Kloxo面板mysql自动停止，求救！急

251300333

本人安装了一个kloxo面板，mysql总是自动停止，日志记录如下，麻烦朋友们出出招：
------------------------
100716 04:25:57  mysqld started
100716  4:25:57 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  4:25:57 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100716  4:25:57  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100716  4:25:57  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100716  4:25:57  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 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
100716  4:25:58  InnoDB: Started; log sequence number 0 0
100716  4:25:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100716  4:25:59 [Note] /usr/libexec/mysqld: Normal shutdown

100716  4:25:59  InnoDB: Starting shutdown...
100716  4:25:59  InnoDB: Shutdown completed; log sequence number 0 43655
100716  4:25:59 [Note] /usr/libexec/mysqld: Shutdown complete

100716 04:25:59  mysqld ended

100716 04:26:00  mysqld started
100716  4:26:00 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  4:26:00 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  4:26:00  InnoDB: Started; log sequence number 0 43655
100716  4:26:00 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100716  4:31:15 [Note] /usr/libexec/mysqld: Normal shutdown

100716  4:31:17  InnoDB: Starting shutdown...
100716  4:31:19  InnoDB: Shutdown completed; log sequence number 0 71442
100716  4:31:19 [Note] /usr/libexec/mysqld: Shutdown complete

100716 04:31:19  mysqld ended

100716 04:31:30  mysqld started
100716  4:31:30 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  4:31:30 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  4:31:30  InnoDB: Started; log sequence number 0 71442
100716  4:31:30 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100716  5:55:46 [Note] /usr/libexec/mysqld: Normal shutdown

100716  5:55:46  InnoDB: Starting shutdown...
100716  5:55:46  InnoDB: Shutdown completed; log sequence number 0 71442
100716  5:55:46 [Note] /usr/libexec/mysqld: Shutdown complete

100716 05:55:47  mysqld ended

100716 05:57:49  mysqld started
100716  5:57:50 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  5:57:50 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  5:57:50  InnoDB: Started; log sequence number 0 71442
100716  5:57:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100716  5:59:13 [Note] /usr/libexec/mysqld: Normal shutdown

100716  5:59:13  InnoDB: Starting shutdown...
100716  5:59:14  InnoDB: Shutdown completed; log sequence number 0 71442
100716  5:59:14 [Note] /usr/libexec/mysqld: Shutdown complete

100716 05:59:14  mysqld ended

100716 06:01:17  mysqld started
100716  6:01:17 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  6:01:17 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  6:01:18  InnoDB: Started; log sequence number 0 71442
100716  6:01:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100716  6:03:12 [Note] /usr/libexec/mysqld: Normal shutdown

100716  6:03:14  InnoDB: Starting shutdown...
100716  6:03:15  InnoDB: Shutdown completed; log sequence number 0 71442
100716  6:03:15 [Note] /usr/libexec/mysqld: Shutdown complete

100716 06:03:15  mysqld ended

100716 06:05:17  mysqld started
100716  6:05:18 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  6:05:18 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716  6:05:18  InnoDB: Started; log sequence number 0 71442
100716  6:05:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100716  6:45:58 [Note] /usr/libexec/mysqld: Normal shutdown

100716  6:46:00  InnoDB: Starting shutdown...
100716  6:46:01  InnoDB: Shutdown completed; log sequence number 0 71442
100716  6:46:01 [Note] /usr/libexec/mysqld: Shutdown complete

100716 06:46:01  mysqld ended

100716 21:54:01  mysqld started
100716 21:54:02 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716 21:54:02 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100716 21:54:02  InnoDB: Started; log sequence number 0 71442
100716 21:54:03 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100717  2:39:53 [Note] /usr/libexec/mysqld: Normal shutdown

100717  2:39:53  InnoDB: Starting shutdown...
100717  2:39:54  InnoDB: Shutdown completed; log sequence number 0 71442
100717  2:39:54 [Note] /usr/libexec/mysqld: Shutdown complete

100717 02:39:54  mysqld ended

100717 03:20:34  mysqld started
100717  3:20:35 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717  3:20:35 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717  3:20:35  InnoDB: Started; log sequence number 0 71442
100717  3:20:35 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100717  3:21:02 [Note] /usr/libexec/mysqld: Normal shutdown

100717  3:21:04  InnoDB: Starting shutdown...
100717  3:21:05  InnoDB: Shutdown completed; log sequence number 0 71442
100717  3:21:05 [Note] /usr/libexec/mysqld: Shutdown complete

100717 03:21:05  mysqld ended

100717 03:21:27  mysqld started
100717  3:21:27 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717  3:21:27 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717  3:21:27  InnoDB: Started; log sequence number 0 71442
100717  3:21:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100717  3:21:48 [Note] /usr/libexec/mysqld: Normal shutdown

100717  3:21:48  InnoDB: Starting shutdown...
100717  3:21:48  InnoDB: Shutdown completed; log sequence number 0 71442
100717  3:21:48 [Note] /usr/libexec/mysqld: Shutdown complete

100717 03:21:48  mysqld ended

100717 03:21:49  mysqld started
100717  3:21:49 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717  3:21:49 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717  3:21:49  InnoDB: Started; log sequence number 0 71442
100717  3:21:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100717 23:03:33 [Note] /usr/libexec/mysqld: Normal shutdown

100717 23:03:33  InnoDB: Starting shutdown...
100717 23:03:35  InnoDB: Shutdown completed; log sequence number 0 71442
100717 23:03:35 [Note] /usr/libexec/mysqld: Shutdown complete

100717 23:03:35  mysqld ended

100717 23:03:56  mysqld started
100717 23:03:56 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717 23:03:56 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717 23:03:56  InnoDB: Started; log sequence number 0 71442
100717 23:03:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100717 23:04:17 [Note] /usr/libexec/mysqld: Normal shutdown

100717 23:04:17  InnoDB: Starting shutdown...
100717 23:04:18  InnoDB: Shutdown completed; log sequence number 0 71442
100717 23:04:18 [Note] /usr/libexec/mysqld: Shutdown complete

100717 23:04:18  mysqld ended

100717 23:04:19  mysqld started
100717 23:04:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717 23:04:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100717 23:04:19  InnoDB: Started; log sequence number 0 71442
100717 23:04:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100718 13:04:35 [Note] /usr/libexec/mysqld: Normal shutdown

100718 13:04:35  InnoDB: Starting shutdown...
100718 13:04:37  InnoDB: Shutdown completed; log sequence number 0 200416
100718 13:04:37 [Note] /usr/libexec/mysqld: Shutdown complete

100718 13:04:37  mysqld ended

100718 13:06:52  mysqld started
100718 13:06:53 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 13:06:53 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 13:06:53  InnoDB: Started; log sequence number 0 200416
100718 13:06:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100718 14:02:37 [Note] /usr/libexec/mysqld: Normal shutdown

100718 14:02:39  InnoDB: Starting shutdown...
100718 14:02:40  InnoDB: Shutdown completed; log sequence number 0 200416
100718 14:02:40 [Note] /usr/libexec/mysqld: Shutdown complete

100718 14:02:40  mysqld ended

100718 20:00:32  mysqld started
100718 20:00:32 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 20:00:32 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 20:00:33  InnoDB: Started; log sequence number 0 200416
100718 20:00:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100718 20:16:13 [Note] /usr/libexec/mysqld: Normal shutdown

100718 20:16:15  InnoDB: Starting shutdown...
100718 20:16:16  InnoDB: Shutdown completed; log sequence number 0 200416
100718 20:16:16 [Note] /usr/libexec/mysqld: Shutdown complete

100718 20:16:16  mysqld ended

100718 20:23:01  mysqld started
100718 20:23:01 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 20:23:01 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 20:23:01  InnoDB: Started; log sequence number 0 200416
100718 20:23:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100718 20:48:42 [Note] /usr/libexec/mysqld: Normal shutdown

100718 20:48:44  InnoDB: Starting shutdown...
100718 20:48:44  InnoDB: Shutdown completed; log sequence number 0 200416
100718 20:48:44 [Note] /usr/libexec/mysqld: Shutdown complete

100718 20:48:44  mysqld ended

100718 20:54:32  mysqld started
100718 20:54:32 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 20:54:32 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 20:54:33  InnoDB: Started; log sequence number 0 200416
100718 20:54:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100718 21:10:13 [Note] /usr/libexec/mysqld: Normal shutdown

100718 21:10:15  InnoDB: Starting shutdown...
100718 21:10:16  InnoDB: Shutdown completed; log sequence number 0 200416
100718 21:10:16 [Note] /usr/libexec/mysqld: Shutdown complete

100718 21:10:16  mysqld ended

100718 21:26:17  mysqld started
100718 21:26:18 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 21:26:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 21:26:22  InnoDB: Started; log sequence number 0 200416
100718 21:26:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100718 21:38:51 [Note] /usr/libexec/mysqld: Normal shutdown

100718 21:38:53  InnoDB: Starting shutdown...
100718 21:38:54  InnoDB: Shutdown completed; log sequence number 0 200416
100718 21:38:54 [Note] /usr/libexec/mysqld: Shutdown complete

100718 21:38:54  mysqld ended

100718 21:39:15  mysqld started
100718 21:39:15 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 21:39:15 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100718 21:39:16  InnoDB: Started; log sequence number 0 200416
100718 21:39:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100721  6:03:50 [Note] /usr/libexec/mysqld: Normal shutdown

100721  6:03:51  InnoDB: Starting shutdown...
100721  6:03:52  InnoDB: Shutdown completed; log sequence number 0 200416
100721  6:03:52 [Note] /usr/libexec/mysqld: Shutdown complete

100721 06:03:52  mysqld ended

100721 06:06:22  mysqld started
100721  6:06:23 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721  6:06:23 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721  6:06:24  InnoDB: Started; log sequence number 0 200416
100721  6:06:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100721  7:52:11 [Note] /usr/libexec/mysqld: Normal shutdown

100721  7:52:11  InnoDB: Starting shutdown...
100721  7:52:13  InnoDB: Shutdown completed; log sequence number 0 200416
100721  7:52:13 [Note] /usr/libexec/mysqld: Shutdown complete

100721 07:52:13  mysqld ended

100721 08:51:09  mysqld started
100721  8:51:10 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721  8:51:10 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721  8:51:10  InnoDB: Started; log sequence number 0 200416
100721  8:51:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100721  9:51:55 [Note] /usr/libexec/mysqld: Normal shutdown

100721  9:51:55  InnoDB: Starting shutdown...
100721  9:51:56  InnoDB: Shutdown completed; log sequence number 0 200416
100721  9:51:56 [Note] /usr/libexec/mysqld: Shutdown complete

100721 09:51:56  mysqld ended

100721 11:14:37  mysqld started
100721 11:14:37 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721 11:14:37 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721 11:14:38  InnoDB: Started; log sequence number 0 200416
100721 11:14:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100721 12:00:22 [Note] /usr/libexec/mysqld: Normal shutdown

100721 12:00:24  InnoDB: Starting shutdown...
100721 12:00:25  InnoDB: Shutdown completed; log sequence number 0 200416
100721 12:00:25 [Note] /usr/libexec/mysqld: Shutdown complete

100721 12:00:25  mysqld ended

100721 12:46:12  mysqld started
100721 12:46:13 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721 12:46:13 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721 12:46:14  InnoDB: Started; log sequence number 0 200416
100721 12:46:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
100721 12:48:30 [Note] /usr/libexec/mysqld: Normal shutdown

100721 12:48:30  InnoDB: Starting shutdown...
100721 12:48:31  InnoDB: Shutdown completed; log sequence number 0 200416
100721 12:48:31 [Note] /usr/libexec/mysqld: Shutdown complete

100721 12:48:31  mysqld ended

100721 12:48:52  mysqld started
100721 12:48:52 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721 12:48:52 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100721 12:48:52  InnoDB: Started; log sequence number 0 200416
100721 12:48:52 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
----------------
QQ：200513538，定有重谢，可以送你一个美国VPS一个月。

renxiao2003

条件很好。可惜我不太会。看样子是'max_join_size'参数没有设置吧。

cenalulu

从日志来看是Normal shutdown
应该是mysql启动2分钟以后有什么人为的操作或者触发，导致关闭了。
max_join_size 只是warning，可以忽略

ruochen

从日志来看是Normal shutdown
应该是mysql启动2分钟以后有什么人为的操作或者触发，导致关闭了。
max_joi ...
cenalulu 发表于 2010-07-22 11:56

    最好还是将warning给干掉，然后继续监控

Coolriver

这种问题只能上去进去GDB调试，跟一下这个进程在干啥，为什么刚启动后就退出了。

有兴趣了，给我发Mail，我帮你看看。

251300333

今天排查了一天，还是没有找到原因，不过又没有前面那么频繁了。今天就自动断开了一次

251300333

找到原因了，NND，原来是我创建VM虚拟机的时候是用的快照进行创建的，创建后配置了IP信息和主机名信息，没有修改hosts文件，还得修改hosts文件中的主机名，
127.0.0.1               VML1195 localhost.localdomain localhost
就是上面标红色的部份了，所有用快照创建的虚拟机这里全是一样的，所以导致mysql出问题