bug

"Damjan Hajsek" <[email protected]> Tue, 15 Nov 2005 14:39:59 +0100
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <009901c5e9ea$131eeca0$8ab2f9c2@plastikfantasti>
My mysql database frezze up, this happend really often, sometimes I use
phpmyadmin, sometimes with egroupware.

I notice after I setup extensions for extension=php_gettext.dll , server
freeze up always when startup, I try some other extensions but all frezze
up, I check extensions path, and it is ok.

It laways frezze up, IIS and I cannot restart it, I must restart server.

 

I use

Windows 2003 server

IIS 6.0

Mysql 4.1

Php 4.3

 

 

Here is log

 

InnoDB: The first specified data file C:\MySQL Datafiles\ibdata1 did not
exist:

InnoDB: a new database to be created!

051110 14:12:36  InnoDB: Setting file C:\MySQL Datafiles\ibdata1 size to 10
MB

InnoDB: Database physically writes the file full: wait...

051110 14:12:38  InnoDB: Log file .\ib_logfile0 did not exist: new to be
created

InnoDB: Setting log file .\ib_logfile0 size to 10 MB

InnoDB: Database physically writes the file full: wait...

051110 14:12:40  InnoDB: Log file .\ib_logfile1 did not exist: new to be
created

InnoDB: Setting log file .\ib_logfile1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

051110 14:12:44  InnoDB: Started; log sequence number 0 0

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for
connections.

Version: '4.1.15-nt'  socket: ''  port: 3306  Official MySQL binary

051110 14:27:11 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Normal shutdown

 

051110 14:27:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Forcing close of thread 42  user: 'root'

 

051110 14:27:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Forcing close of thread 41  user: 'root'

 

051110 14:27:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Forcing close of thread 40  user: 'root'

 

051110 14:59:11  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...

051110 14:59:13  InnoDB: Starting log scan based on checkpoint at

InnoDB: log sequence number 0 447571.

InnoDB: Doing recovery: scanned up to log sequence number 0 447571

051110 14:59:14  InnoDB: Flushing modified pages from the buffer pool...

051110 14:59:14  InnoDB: Started; log sequence number 0 447571

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for
connections.

Version: '4.1.15-nt'  socket: ''  port: 3306  Official MySQL binary

051114  8:20:26 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Normal shutdown

 

051114  8:20:28 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Forcing close of thread 14  user: 'root'

 

051114  8:20:28  InnoDB: Starting shutdown...

051114  8:20:33  InnoDB: Shutdown completed; log sequence number 0 2099013

051114  8:20:33 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Shutdown complete

 

051114  8:20:34  InnoDB: Started; log sequence number 0 2099013

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for
connections.

Version: '4.1.15-nt'  socket: ''  port: 3306  Official MySQL binary

051114  8:50:49 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Normal shutdown

 

051114  8:50:49  InnoDB: Starting shutdown...

051114  8:50:52  InnoDB: Shutdown completed; log sequence number 0 2385433

051114  8:50:52 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-nt: Shutdown complete

 

051114  8:50:57  InnoDB: Started; log sequence number 0 2385433

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051114 11:08:33 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051114 11:08:34  InnoDB: Starting shutdown...

051114 11:08:37  InnoDB: Shutdown completed; log sequence number 0 2388182

051114 11:08:37 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051114 11:13:31  InnoDB: Started; log sequence number 0 2388182

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051114 13:29:11 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051114 13:29:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 11  user: 'root'

 

051114 13:29:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 8  user: 'root'

 

051114 13:29:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 6  user: 'root'

 

051114 13:29:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 5  user: 'root'

 

051114 13:29:13 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 3  user: 'root'

 

051114 13:37:42  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...

051114 13:37:47  InnoDB: Starting log scan based on checkpoint at

InnoDB: log sequence number 0 3050220.

InnoDB: Doing recovery: scanned up to log sequence number 0 3050220

051114 13:37:48  InnoDB: Flushing modified pages from the buffer pool...

051114 13:37:48  InnoDB: Started; log sequence number 0 3050220

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051114 13:58:14 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051114 13:58:16 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 16  user: 'root'

 

051114 13:58:16 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 15  user: 'root'

 

051114 13:58:16 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 14  user: 'root'

 

051114 13:58:16 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 2  user: 'root'

 

051114 13:58:17  InnoDB: Starting shutdown...

051114 13:58:20  InnoDB: Shutdown completed; log sequence number 0 3138822

051114 13:58:20 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051114 13:58:27  InnoDB: Started; log sequence number 0 3138822

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051114 15:37:52 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051114 15:37:54 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 74  user: 'root'

 

051114 15:37:54 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 67  user: 'root'

 

051114 15:37:54 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 5  user: 'root'

 

051114 15:37:54 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 4  user: 'root'

 

051114 15:37:54 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 3  user: 'root'

 

051114 15:37:54  InnoDB: Starting shutdown...

051114 15:37:57  InnoDB: Shutdown completed; log sequence number 0 7515269

051114 15:37:57 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051114 15:38:02  InnoDB: Started; log sequence number 0 7515269

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051114 15:39:01 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051114 15:39:03  InnoDB: Starting shutdown...

051114 15:39:06  InnoDB: Shutdown completed; log sequence number 0 8206907

051114 15:39:06 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051114 15:43:55  InnoDB: Started; log sequence number 0 8206907

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 10:02:17 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 158  user: 'root'

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 157  user: 'root'

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 156  user: 'root'

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 149  user: 'root'

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 148  user: 'root'

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 147  user: 'root'

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 146  user: 'root'

 

051115 10:02:20 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 145  user: 'root'

 

051115 10:07:05  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...

051115 10:07:10  InnoDB: Starting log scan based on checkpoint at

InnoDB: log sequence number 0 20551805.

InnoDB: Doing recovery: scanned up to log sequence number 0 20551805

051115 10:07:11  InnoDB: Flushing modified pages from the buffer pool...

051115 10:07:12  InnoDB: Started; log sequence number 0 20551805

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 10:42:40 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 10:42:42 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 8  user: 'root'

 

051115 10:42:42 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 7  user: 'root'

 

051115 10:42:42 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 6  user: 'root'

 

051115 10:42:42 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 5  user: 'root'

 

051115 10:42:42  InnoDB: Starting shutdown...

051115 10:42:44  InnoDB: Shutdown completed; log sequence number 0 20565242

051115 10:42:44 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 10:42:45  InnoDB: Started; log sequence number 0 20565242

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 11:57:15 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 11:57:17 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 7  user: 'root'

 

051115 11:57:17 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 6  user: 'root'

 

051115 11:57:17 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 5  user: 'root'

 

051115 11:57:17  InnoDB: Starting shutdown...

051115 11:57:22  InnoDB: Shutdown completed; log sequence number 0 20993409

051115 11:57:22 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 11:57:26  InnoDB: Started; log sequence number 0 20993409

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 12:27:48 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 10  user: 'root'

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 9  user: 'root'

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 8  user: 'root'

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 7  user: 'root'

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 6  user: 'root'

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 5  user: 'root'

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 4  user: 'root'

 

051115 12:27:53 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 3  user: 'root'

 

051115 12:27:53  InnoDB: Starting shutdown...

051115 12:27:56  InnoDB: Shutdown completed; log sequence number 0 21084283

051115 12:27:56 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 12:32:38  InnoDB: Started; log sequence number 0 21084283

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 12:57:03 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 12:57:08 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 7  user: 'root'

 

051115 12:57:08 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 6  user: 'root'

 

051115 12:57:08 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 5  user: 'root'

 

051115 12:57:08  InnoDB: Starting shutdown...

051115 12:57:12  InnoDB: Shutdown completed; log sequence number 0 21123502

051115 12:57:12 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 13:01:59  InnoDB: Started; log sequence number 0 21123502

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 13:06:59 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 13:07:00  InnoDB: Starting shutdown...

051115 13:07:03  InnoDB: Shutdown completed; log sequence number 0 21123596

051115 13:07:03 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 13:11:50  InnoDB: Started; log sequence number 0 21123596

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 13:16:08 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 13:16:13  InnoDB: Starting shutdown...

051115 13:16:17  InnoDB: Shutdown completed; log sequence number 0 21125651

051115 13:16:17 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 13:21:04  InnoDB: Started; log sequence number 0 21125651

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 13:36:06 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 13:36:11  InnoDB: Starting shutdown...

051115 13:36:15  InnoDB: Shutdown completed; log sequence number 0 21126898

051115 13:36:15 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 13:41:02  InnoDB: Started; log sequence number 0 21126898

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 13:51:59 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 13:52:04  InnoDB: Starting shutdown...

051115 13:52:06  InnoDB: Shutdown completed; log sequence number 0 21128145

051115 13:52:06 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 13:56:46  InnoDB: Started; log sequence number 0 21128145

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 14:00:58 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 14:01:00 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 2  user: 'root'

 

051115 14:01:00 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 1  user: 'root'

 

051115 14:01:00  InnoDB: Starting shutdown...

051115 14:01:02  InnoDB: Shutdown completed; log sequence number 0 21130645

051115 14:01:02 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 14:05:54  InnoDB: Started; log sequence number 0 21130645

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 14:13:16 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 14:13:20  InnoDB: Starting shutdown...

051115 14:13:24  InnoDB: Shutdown completed; log sequence number 0 21132700

051115 14:13:24 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 14:18:01  InnoDB: Started; log sequence number 0 21132700

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

051115 14:25:24 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Normal shutdown

 

051115 14:25:29 [Warning] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Forcing close of thread 1  user: 'root'

 

051115 14:25:29  InnoDB: Starting shutdown...

051115 14:25:31  InnoDB: Shutdown completed; log sequence number 0 21133518

051115 14:25:31 [Note] C:\Program Files\MySQL\MySQL Server
4.1\bin\mysqld-max-nt: Shutdown complete

 

051115 14:30:21  InnoDB: Started; log sequence number 0 21133518

C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-max-nt: ready for
connections.

Version: '4.1.15-nt-max'  socket: ''  port: 3306  Official MySQL binary