MySQLcrashonSHOWTABLESTATUSFROM

Windows 2003 Enterprise, IIS 6.0, PHP 5.0.2, MySQL
4.1.7-nt

I'm getting sporadic crashes of mysql when I use
phpmyadmin. I believe the key to the bug is that the
crash only occurs when I launch phpmyadmin for the
first time -- once I'm in, I never get the crash later.

This only happens with phpmyadmin. It does not
happen with any of several other php/mysql packages I
use on the same server.

IIS and PHP remain up and running, it is only mysql
that crashes.

Restarting mysql and refreshing the browser with
phpmyadmin fixes the problem, though sometimes I
have to restart mysql more than once.

It doesn't happen every time, but I'd say it happens
about 70% of the time. Can't reliably reproduce it, but it
happens over and over.

From the event log --
The MySQL service terminated unexpectedly. It has
done this 38 time(s).

From the mysql log--
050928 14:52:40 InnoDB: Database was not shut down
normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd
files...
InnoDB: Restoring possible half-written data pages from
the doublewrite
InnoDB: buffer...
050928 14:52:40 InnoDB: Starting log scan based on
checkpoint at
InnoDB: log sequence number 0 274608.
InnoDB: Doing recovery: scanned up to log sequence
number 0 274608
050928 14:52:41 InnoDB: Flushing modified pages from
the buffer pool...
050928 14:52:41 InnoDB: Started; log sequence
number 0 274608

• Original URL: "https://sourceforge.net/p/phpmyadmin/support-requests/784/":https://sourceforge.net/p/phpmyadmin/support-requests/784/


• Original author: mchargue


• Found in version: 2.6.4-pl1

该提问来源于开源项目：phpmyadmin/phpmyadmin