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

Running mysqlcheck -A --auto-repair on OQGraph InnoDB backing table causes crashes on subsequent OQGRAPH queries.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.0.10
    • 10.5, 10.6
    • None
    • CentOS 6

    Description

      I have the weird situation that querying dijkstras shortest path on an OQGraph table, which has an InnoDB backing table sometimes results in a crash. Stacktrace attached.

      This is the query I run:

      SELECT * FROM oq_graph WHERE latch='dijkstras' AND origid=0;

      The weird thing is that after the server automatically restarts after the crash, the query works. Then I run mysqlcheck on the entire database and after running it the query causes the crash again. So I somehow ended up in an endless loop here :/

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              pprkut Heinz Wiesinger
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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