2017-12-01 10:32 GMT+01:00 Eric Fjøsne <1729...@bugs.launchpad.net>:
> 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

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1729536

Title:
  InnoDB: Failing assertion: sym_node->table != NULL

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1729536/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to