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

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




      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.


        1. oqgraph.base_config.mysql
          1 kB
          Brian LaVallee
        2. sp.current_path.mysql
          0.6 kB
          Brian LaVallee
        3. syslog.messages.txt
          11 kB
          Brian LaVallee

        Issue Links



              andymc73 Andrew McDonnell
              b.lavallee@globaltank.jp Brian LaVallee
              0 Vote for this issue
              6 Start watching this issue



                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.