MYSQL 奇怪问题。自动停止。

[天地会-爱人]

环境是
FreeBSD系统、nginx环境、php5.2。8、mysql5.0

有时候不知道为什么会出现

Lost connection to MySQL server at 'reading initial communication packet'
错误

我/etc/rc.d/init.d/mysql start 启动下又好了。好多次都出现这样了

求助。。。。大家的帮忙。。

[vinsonshen]

看下data目录下 .err错误日志里面是否有详细信息可以查没有吧

[天地会-爱人]

下面是日志文件。大家帮帮忙是什么错误影响到的呢？
091102 03:47:40 mysqld_safe Starting mysqld daemon with databases from /usr/data0/mysql3306
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
091102 3:47:41 [ERROR] Plugin 'InnoDB' init function returned error.
091102 3:47:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091102 3:47:41 [Note] Event Scheduler: Loaded 0 events
091102 3:47:41 [Note] /usr/local/webserver/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-log' socket: '/tmp/mysql.sock' port: 3267 Source distribution
091102 3:47:48 [Note] /usr/local/webserver/mysql/libexec/mysqld: Normal shutdown

091102 3:47:48 [Note] Event Scheduler: Purging the queue. 0 events
091102 3:47:48 [Note] /usr/local/webserver/mysql/libexec/mysqld: Shutdown complete

091102 03:47:48 mysqld_safe mysqld from pid file /usr/data0/mysql3306/dq5420-1001.local.com.pid ended
091102 16:36:51 [ERROR] Plugin 'InnoDB' init function returned error.
091102 16:36:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091102 16:36:51 [Note] Event Scheduler: Loaded 0 events
091102 16:36:51 [Note] /usr/local/webserver/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-log' socket: '/tmp/mysql.sock' port: 3267 Source distribution
091104 19:15:31 [Note] /usr/local/webserver/mysql/libexec/mysqld: Normal shutdown

091104 19:15:31 [Note] Event Scheduler: Purging the queue. 0 events
091104 19:15:31 [Note] /usr/local/webserver/mysql/libexec/mysqld: Shutdown complete

091104 19:15:31 mysqld_safe mysqld from pid file /usr/data0/mysql3306/dq5420-1001.local.com.pid ended
091104 19:15:32 mysqld_safe Starting mysqld daemon with databases from /usr/data0/mysql3306
091104 19:15:32 [Warning] Changed limits: max_open_files: 11095 max_connections: 768 table_cache: 5158
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
091104 19:15:32 [ERROR] Plugin 'InnoDB' init function returned error.
091104 19:15:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091104 19:15:33 [Note] Event Scheduler: Loaded 0 events
091104 19:15:33 [Note] /usr/local/webserver/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-log' socket: '/tmp/mysql.sock' port: 3267 Source distribution
091107 20:27:52 mysqld_safe Starting mysqld daemon with databases from /usr/data0/mysql3306
091107 20:27:52 [Warning] Changed limits: max_open_files: 11095 max_connections: 768 table_cache: 5158
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
091107 20:27:53 [ERROR] Plugin 'InnoDB' init function returned error.
091107 20:27:53 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091107 20:27:54 [Note] Event Scheduler: Loaded 0 events
091107 20:27:54 [Note] /usr/local/webserver/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-log' socket: '/tmp/mysql.sock' port: 3267 Source distribution

[天地会-爱人]

顶上去，希望高手看见帮帮忙。

[fcoolx]

把ib_logfile文件都删了，再重启试试

[天地会-爱人]

顶上去，希望高手看见帮帮忙

[fcoolx]

[Quote=引用 7 楼 aries_jo 的回复:]
要stop再start才可以了。。

现在做同步有[ERROR] Slave I/O: error connecting to master 'user_bak@125.89.11.111:4546' - retry-time: 60  retries: 86400, Error_code: 1045这个出现。是什么原因呢？
[/Quote]

设置了主从复制， 主又连不上
在/etc/my.cnf中把主从的配置删掉

[天地会-爱人]

我都删除了。还是有。。
091111 17:11:28 mysqld_safe Starting mysqld daemon with databases from /usr/data0/mysql3306
091111 17:11:28 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in MySQL 6.0. Please use 'CHANGE MASTER' instead.
091111 17:11:28 [Warning] Changed limits: max_open_files: 11095 max_connections: 768 table_cache: 5158
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
091111 17:11:28 [ERROR] Plugin 'InnoDB' init function returned error.
091111 17:11:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091111 17:11:28 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his ho
stname changed!! Please use '--relay-log=dq5420-1001-relay-bin' to avoid this problem.
091111 17:11:28 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './dq5420-1001-relay-bin.000001' position:
4

[天地会-爱人]

要stop再start才可以了。。

现在做同步有[ERROR] Slave I/O: error connecting to master 'user_bak@125.89.11.111:4546' - retry-time: 60 retries: 86400, Error_code: 1045这个出现。是什么原因呢？

[天地会-爱人]

配置全部删除？为什么？

[天地会-爱人]

现在主日志中显示错误如下。。希望大家帮忙看看是哪出现错误了。。小弟感谢了

91112 18:49:06 mysqld_safe mysqld from pid file /usr/data0/mysql3306/test.com.pid ended
091112 18:49:07 mysqld_safe Starting mysqld daemon with databases from /usr/data0/mysql3306
091112 18:49:07 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in MySQL 6.0. Please use 'CHANGE MASTER' instead.
091112 18:49:07 [Warning] Changed limits: max_open_files: 11095 max_connections: 768 table_cache: 5158
091112 18:49:07 InnoDB: Started; log sequence number 0 46409
091112 18:49:08 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his ho
stname changed!! Please use '--relay-log=dq5420-1001-relay-bin' to avoid this problem.
091112 18:49:08 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 106, relay log './dq5420-1001-relay-bin.00000
1' position: 4
091112 18:49:08 [Note] Event Scheduler: Loaded 0 events
091112 18:49:08 [Note] /usr/local/webserver/mysql/libexec/mysqld: ready for connections.
Version: '5.1.34-log' socket: '/tmp/mysql.sock' port: 2323 Source distribution
091112 18:49:08 [ERROR] Slave I/O: error connecting to master '[e-mail]:2424' - retry-time: 60 retries: 86400, Error_code: 1045

[fcoolx]

[Quote=引用 9 楼 aries_jo 的回复:]
配置全部删除？为什么？
[/Quote]

因为你配的不对，
删掉起码能让你mysql起来

当然改对了，更好

[fcoolx]

[ERROR] Slave I/O: error connecting to master '[e-mail]:2424' -
这错误信息很明白了
在你my.cnf中找到类似的行，能改对更好，不知道账号密码就先注掉，起码能起来
#master-host = <hostname>
#master-user = <username>
#master-password = <password>
#master-port = <port>

[天地会-爱人]

我看了master.info配置信息是对的啊。

[天地会-爱人]

我删除账号了。设置
grant all on test.* to [e-mail] identified by '123456';

出现这个错误

[ERROR] Error reading packet from server: Access denied; you need the REPLICATION SLAVE privilege for this operation ( server_errno=1227)