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