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

OQGraph crashes under load




      I've been updating one of my applications from OQGraphv2 to v3 and while initial tests showed everything working, I'm now getting troublesome crashes when I put some load on the OQGraph table.

      The application is basically a webservice (in PHP) that queries the OQGraph table (schema attached) and returns the result. The query in itself should be fairly simple:

      SELECT db.* FROM db_history AS db INNER JOIN version_history AS v ON db.nodeID = v.linkid WHERE origid = 1 AND destid = 3 AND latch = 'dijkstras';

      When doing single sequential requests in the browser, everything works fine. But once I started to put some load on the webservice (using siege as load testing tool), MariaDB crashes quickly after 1-2 requests (crash dump attached), always with the same crash dump.

      I should note that the database setup is a master-slave replication setup. I'm not sure that has anything to do with the crashes I'm seeing though.

      I can reproduce this fairly easily and reliably in my test environment, on both the slave and the master node, but have not been successful so far in producing a test case that does not involve running siege.


        1. backtrace_2.log
          6 kB
          Heinz Wiesinger
        2. backtrace.log
          8 kB
          Heinz Wiesinger
        3. carbon.log
          3 kB
          Heinz Wiesinger
        4. crash.log
          4 kB
          Heinz Wiesinger
        5. data.sql
          2 kB
          Heinz Wiesinger
        6. debug.log
          410 kB
          Heinz Wiesinger
        7. explain.log
          3 kB
          Heinz Wiesinger
        8. oqgraph_crash_without_latch.log
          863 kB
          Heinz Wiesinger
        9. oqgraph_load.core.tar.xz
          1.12 MB
          Heinz Wiesinger
        10. schema.sql
          0.8 kB
          Heinz Wiesinger
        11. show_variables.log
          385 kB
          Heinz Wiesinger
        12. threaddump_2.log
          61 kB
          Heinz Wiesinger
        13. threaddump.log
          88 kB
          Heinz Wiesinger
        14. valgrind.log
          10 kB
          Heinz Wiesinger
        15. variables
          69 kB
          Heinz Wiesinger

          Issue Links



              serg Sergei Golubchik
              pprkut Heinz Wiesinger
              0 Vote for this issue
              5 Start watching this issue



                  Git Integration

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