an UPDATE eating all disk space

Asked by Steven De Coeyer on 2012-07-10

Hello

I was wondering if MariaDB is also affected by this MySQL bug:
http://bugs.mysql.com/bug.php?id=65745

The bug in a nutshell: "An UPDATE that should only modify a single row runs forever and blows up table / tablespace size until there is no more disk space available"

Kind regards,
Steven

Question information

Language:
English Edit question
Status:
Solved
For:
MariaDB Edit question
Assignee:
No assignee Edit question
Solved by:
Sergei Golubchik
Solved:
2012-07-10
Last query:
2012-07-10
Last reply:
2012-07-10
Best Sergei Golubchik (sergii) said : #1

No it's not.

With XtraDB - most certainly not, because that bug was caused by another bug fix, and that latter bug fix is not in the XtraDB yet.

With InnoDB (if you run MariaDB with InnoDB plugin) - I was not able to repeat the bug, because optimizer uses a slightly different execution plan, so the query from the bug report does not trigger the bug. But perhaps a different specially crafted query can still trigger that bug.

Steven De Coeyer (zhann) said : #2

Thanks Sergei, that solved my question.