© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
It's hard to say which specific query caused the crash. It appears that the queries we observed running on the server did not make it to the log.
From our memory there were two queries:
1. INSERT SELECT from a table a -- in a 'sending data' state
2. RENAME TABLE a to a_2, a_old to a, a_2 to a_old - waiting for the first query to finish
It appeared that as soon as the first query finished, the 2nd query did not run. When the system came back online the tables had not appeared to rotate through