Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6784

OQGRAPH: External Connection Crashes MariaDB with "InnoDB: Assertion failure"

    Details

      Description

      I've spent about a week trying to build a stable instance of OQGRAPH for use by a webserver.

      Finding that almost every-other external query results in InnoDB: Assertion failure. But no issues when using the CLI on localhost or a remote_host.

      OK = localhost> SELECT * FROM oss.path;
      OK = remote_host> SELECT * FROM oss.path;
      NG = [localhost ~]# mysql -e 'SELECT * FROM oss.path;'
      NG = [remote_host ~]# mysql -h oqgrah_host -e 'SELECT * FROM oss.path;'

      Note: The first query normally works, and subsequent queries fail. I've been using a stored procedure that normally restarts MariaDB, so every-other-query works.

      OK = localhost> CALL oss.current_path(3);
      OK = remote_host> CALL oss.current_path(3);
      NG = [localhost ~]# mysql -e 'CALL oss.current_path(3);'
      NG = [remote_host ~]# mysql -h oqgrah_host -e 'CALL oss.current_path(3);'

      This is a clean build, minimal CentOS, EPEL, & MariaDB from the repo. I've tried multiple MariaDB (default config) builds, even reverted to CentOS 6.3 to see if that would make a difference. I originally suspected the problem might with PHP, but no difference between mysql ' mysqli. Then I found the issue was reproducible from bash.

      Attached you will find the syslog message, stored procedure, plus the DB schema and quick setup I have been working with. If you have any questions, please let me know.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                andymc73 Andrew McDonnell
                Reporter:
                b.lavallee@globaltank.jp Brian LaVallee
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: