主从复制重启后不同步。。

damoa

主服务器日志
100330 05:00:14  mysqld ended

100330 05:03:36  mysqld started
100330 05:03:36  mysqld started
^G/opt/lampp/sbin/mysqld: Error on delete of

'/opt/lampp/var/mysql/localhost.lower-test' (Errcode: 2)
100330  5:03:37 [ERROR] Can't start server: Bind on TCP/IP port:

Address already in use
100330  5:03:37 [ERROR] Do you already have another mysqld server

running on port: 3306 ?
100330  5:03:37 [ERROR] Aborting



从服务器日志
100330  5:00:11 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

100330  5:00:11 [Note] Slave I/O thread killed while reading event
100330  5:00:11 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000004', position 941562
100330  5:00:11 [Note] Error reading relay log event: slave SQL thread

was killed
100330  5:00:11 [Note] Slave I/O thread killed while reading event
100330  5:00:11 [Note] Slave I/O thread exiting, read up to log 'mysql

-bin.000004', position 941562
100330  5:00:11 [Note] Error reading relay log event: slave SQL thread

was killed
100330  5:00:11 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

100330  5:02:35 [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 hostname changed!! Please use '--relay-

log=/opt/lampp/var/mysql/localhost-relay-bin' to avoid this problem.
100330  5:02:35 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.45'  socket: '/opt/lampp/var/mysql/mysql.sock'  port:

3306  Source distribution
100330  5:02:35 [Note] Slave SQL thread initialized, starting

replication in log 'mysql-bin.000004' at position 941562, relay log

'/opt/lampp/var/mysql/localhost-relay-bin.000002' position: 930622
100330  5:02:38 [ERROR] Slave I/O thread: error connecting to master

'slave@192.168.19.101:3306': Error: 'Lost connection to MySQL server at

'reading initial communication packet', system error: 113'  errno: 2013

retry-time: 60  retries: 86400
100330  5:03:38 [Note] Slave I/O thread: connected to master

'slave@192.168.19.101:3306',  replication started in log 'mysql-

bin.000004' at position 941562
100330  5:05:36 [ERROR] Error reading packet from server: binlog

truncated in the middle of event ( server_errno=1236)

现在io和sql都没有同步。。。binlog是相同的。pos节点主从不同。。查看从服务器状态，显示未同步
重启主从mysql后，又同步了

ruochen

日志中有很多异常

感觉给的不是完整连续的日志