Bug #13813 Optimize table causes server to restart

• Submitted: 6 Oct 2005 17:48
• Modified: 25 Oct 2005 8:26
• Reporter: Ben Janos
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.7
• OS: Sun-solaris2.9
• CPU Architecture: Any

[6 Oct 2005 17:48] Ben Janos

Description:
After running an optimize table on an innodb table for about 2 hours it said it completed successfully but after that it restarts the server.

How to repeat:
run "Optimize table <tablename>" on an innodb table

[6 Oct 2005 19:16] Hartmut Holzgraefe

Anything in the error log that may give a hint why this happened?

You're also using a rather old 4.1 version, the problem might already have been fixed,
e.g. by http://bugs.mysql.com/bug.php?id=7658 ...

[7 Oct 2005 18:15] Ben Janos

THis could have occured due to a corrupt table...the log said nothing though

[7 Oct 2005 18:29] Hartmut Holzgraefe

If the server really was restarted due to a crash/bug then this should have been logged in the error log ...

[7 Oct 2005 19:36] Ben Janos

Yes it was in the log that the server restarted but you asked if there was anything in the log that would give us a hint as to what happened and the answer is no...