服务器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)
static void close_connections(void)
{
...#ifndef __bsdi__ // Bug in BSDI kernel
if (tmp->vio_ok())
{
if (global_system_variables.log_warnings)
sql_print_warning(ER(ER_FORCING_CLOSE),my_progname, //Forcing close of thread
tmp->thread_id,
(tmp->main_security_ctx.user ?
tmp->main_security_ctx.user : ""));
close_connection(tmp,0,0);
}
#endif
}这个错误是关闭连接报出的,因为你配置了global_system_variables.log_warnings相关字段。所以给出该报错。
你给的log根本不能查出问题的所在。你把mysl单独独立出来会出错吗?
mysql服务意外终止,这发生了1次。代码:7034.
不过好像这提示也没啥用。
这是5.0.10以前版本的bug...
http://bugs.mysql.com/bug.php?id=7403
打开360安全卫士-》高级-》系统服务状态中启动Mysql服务后就OK了