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

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 :/

Environment

CentOS 6

Assignee

Andrew McDonnell

Reporter

Heinz Wiesinger

Labels

Fix versions

Affects versions

Priority

Major
Configure