Comment 14 for bug 1729536

Revision history for this message
Olaf van der Spek (olafvdspek) wrote : Re: [Bug 1729536] Re: InnoDB: Failing assertion: sym_node->table != NULL

2017-12-01 10:32 GMT+01:00 Eric Fjøsne <email address hidden>:
> I reactivated one set of optimize queries for this night and it crashed
> with the exact same backtrace. So I can confirm this is indeed related
> to this specific set. However, there is nothing fancy about them at all.

Nice!
It might also be good to know if just the truncates works fine or
crashes as well.

> It is a simple SQL script with 9 OPTIMIZE statements being run from the mysql client (CLI) on a single database.
> OPTIMIZE TABLE Table1;
> OPTIMIZE TABLE Table2;
> OPTIMIZE TABLE Table3;

An idea here would be to first test the first half of the queries,
next day try the second half, to further isolate the culprit.

Gr,

--
Olaf