服务器windows 2003,web服务器用的是jboss4.0.3,mysql用的是5.0.27
最近一段时间mysql总是自己莫名其妙的关闭,查看操作系统的日志提示
forcing close of thread 619 user:'root',快崩溃了,有没有谁知道是什么原因该怎么解决啊
前两天问过一次,可是这两天又出这个问题了,
错误日志:
080525 18:09:50 InnoDB: Started; log sequence number 0 16905095
080525 18:09:52 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 8:45:39 [Note] SuncerWebMYSQL: Normal shutdown080526 8:45:39 InnoDB: Starting shutdown...
080526 8:45:42 InnoDB: Shutdown completed; log sequence number 0 16935177
080526 8:45:42 [Note] SuncerWebMYSQL: Shutdown complete080526 8:45:44 InnoDB: Started; log sequence number 0 16935177
080526 8:45:45 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 9:42:34 [Note] SuncerWebMYSQL: Normal shutdown080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14850 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14800 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14652 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14635 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14453 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14318 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14279 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14268 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14257 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14209 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14147 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 12457 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 11191 user: 'root'080526 9:42:36 InnoDB: Starting shutdown...
080526 9:42:39 InnoDB: Shutdown completed; log sequence number 0 17035358
080526 9:42:39 [Note] SuncerWebMYSQL: Shutdown complete080526 9:42:49 InnoDB: Started; log sequence number 0 17035358
080526 9:42:49 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 10:52:05 InnoDB: Operating system error number 995 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.
080526 10:52:06 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...
080526 10:52:06 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 17204461.
InnoDB: Doing recovery: scanned up to log sequence number 0 17204461
InnoDB: Last MySQL binlog file position 0 519825, file name .\mysql-bin.000015
080526 10:52:06 InnoDB: Started; log sequence number 0 17204461
080526 10:52:06 [Note] Recovering after a crash using mysql-bin
080526 10:52:06 [Note] Starting crash recovery...
080526 10:52:06 [Note] Crash recovery finished.
080526 10:52:06 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 11:06:05 [Note] SuncerWebMYSQL: Normal shutdown080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 1237 user: 'root'080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 1079 user: 'root'080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 869 user: 'root'080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 849 user: 'root'080526 11:06:07 InnoDB: Starting shutdown...
080526 11:06:10 InnoDB: Shutdown completed; log sequence number 0 17212273
080526 11:06:10 [Note] SuncerWebMYSQL: Shutdown complete080526 11:06:13 InnoDB: Started; log sequence number 0 17212273
080526 11:06:13 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
最近一段时间mysql总是自己莫名其妙的关闭,查看操作系统的日志提示
forcing close of thread 619 user:'root',快崩溃了,有没有谁知道是什么原因该怎么解决啊
前两天问过一次,可是这两天又出这个问题了,
错误日志:
080525 18:09:50 InnoDB: Started; log sequence number 0 16905095
080525 18:09:52 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 8:45:39 [Note] SuncerWebMYSQL: Normal shutdown080526 8:45:39 InnoDB: Starting shutdown...
080526 8:45:42 InnoDB: Shutdown completed; log sequence number 0 16935177
080526 8:45:42 [Note] SuncerWebMYSQL: Shutdown complete080526 8:45:44 InnoDB: Started; log sequence number 0 16935177
080526 8:45:45 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 9:42:34 [Note] SuncerWebMYSQL: Normal shutdown080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14850 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14800 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14652 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14635 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14453 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14318 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14279 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14268 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14257 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14209 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 14147 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 12457 user: 'root'080526 9:42:36 [Warning] SuncerWebMYSQL: Forcing close of thread 11191 user: 'root'080526 9:42:36 InnoDB: Starting shutdown...
080526 9:42:39 InnoDB: Shutdown completed; log sequence number 0 17035358
080526 9:42:39 [Note] SuncerWebMYSQL: Shutdown complete080526 9:42:49 InnoDB: Started; log sequence number 0 17035358
080526 9:42:49 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 10:52:05 InnoDB: Operating system error number 995 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.
080526 10:52:06 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...
080526 10:52:06 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 17204461.
InnoDB: Doing recovery: scanned up to log sequence number 0 17204461
InnoDB: Last MySQL binlog file position 0 519825, file name .\mysql-bin.000015
080526 10:52:06 InnoDB: Started; log sequence number 0 17204461
080526 10:52:06 [Note] Recovering after a crash using mysql-bin
080526 10:52:06 [Note] Starting crash recovery...
080526 10:52:06 [Note] Crash recovery finished.
080526 10:52:06 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
080526 11:06:05 [Note] SuncerWebMYSQL: Normal shutdown080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 1237 user: 'root'080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 1079 user: 'root'080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 869 user: 'root'080526 11:06:07 [Warning] SuncerWebMYSQL: Forcing close of thread 849 user: 'root'080526 11:06:07 InnoDB: Starting shutdown...
080526 11:06:10 InnoDB: Shutdown completed; log sequence number 0 17212273
080526 11:06:10 [Note] SuncerWebMYSQL: Shutdown complete080526 11:06:13 InnoDB: Started; log sequence number 0 17212273
080526 11:06:13 [Note] SuncerWebMYSQL: ready for connections.
Version: '5.0.27-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货