090719 14:50:08 [ERROR] Slave SQL: Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'update files as a set a.tmp_kit = (select min(kit_eid) from contents as b where b.mp3_id = a.id)', Error_code: 1053
090719 14:50:08 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'log-bin.000035' position 290052
090720 8:39:52 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
090720 8:39:52 [Note] Slave I/O thread killed while reading event请大家帮帮忙,在从服务器上看到上面的错误信息,stop slave,change master to,start slave以后还是不能解决问题
SLAVE_IO_RUNNING始终为NO,错误日志
090720 8:48:50 [Note] Slave I/O thread exiting, read up to log 'log-bin.000036', position 106
090720 8:48:50 [Note] Error reading relay log event: slave SQL thread was killed
090719 14:50:08 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'log-bin.000035' position 290052
090720 8:39:52 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
090720 8:39:52 [Note] Slave I/O thread killed while reading event请大家帮帮忙,在从服务器上看到上面的错误信息,stop slave,change master to,start slave以后还是不能解决问题
SLAVE_IO_RUNNING始终为NO,错误日志
090720 8:48:50 [Note] Slave I/O thread exiting, read up to log 'log-bin.000036', position 106
090720 8:48:50 [Note] Error reading relay log event: slave SQL thread was killed
090720 9:16:13 [ERROR] Slave I/O: error connecting to master '[email protected]:3306' - retry-time: 60 retries: 86400, Error_code: 1045
090720 9:16:13 [Note] Slave SQL thread initialized, starting replication in log 'log-bin.000001' at position 106, relay log '.\INTRA5-relay-bin.000001' position: 4在my.ini中skip_slave_errors=1045还是不行
090720 9:16:13 [ERROR] Slave I/O: error connecting to master '[email protected]:3306' - retry-time: 60 retries: 86400, Error_code: 1045
090720 9:16:13 [Note] Slave SQL thread initialized, starting replication in log 'log-bin.000001' at position 106, relay log '.\INTRA5-relay-bin.000001' position: 4在my.ini中skip_slave_errors=1045还是不行
090720 9:16:13 [Note] Slave SQL thread initialized, starting replication in log 'log-bin.000001' at position 106, relay log '.\INTRA5-relay-bin.000001' position: 4
一直提示连不上主服务器,但是我在从服务器上mysql -uroot -p123456 -h(主机)的时候是可以连上的啊
090719 14:50:08 [ERROR] Slave SQL: Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;
看看你的防火墙,还有就是复制用的用户帐号权限。