mysql主从同步slave报错，slave sql线程中断
151224 16:47:10 Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)151224 16:47:10 Slave I/O thread killed while reading event
151224 16:47:10 Slave I/O thread exiting, read up to log 'cpmysql01-bin.000123', position 335505511
151224 16:47:21 Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
151224 16:47:21 Slave SQL thread initialized, starting replication in log 'cpmysql01-bin.000123' at position 335505511,> 151224 16:47:21 Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
151224 16:47:21 Slave I/O thread: connected to master 'mopgaming@103.56.195.8:3306',replication started in log 'cpmysql01-bin.000123' at position 335505511
151224 17:03:15 IP address '103.56.195.14' could not be resolved: Name or service not known
2015-12-24 17:36:51 7f3cce0a4700 InnoDB: Recalculation of persistent statistics requested for table "lottery"."mop_bet_order" index "bet_order_created_at_index" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
报错信息：
slave去mysql主服务器的请求丢失，导致断开主从同步SQL线程中断，slave I/0线程被杀死。
尝试解决：
show slave stutus\G;
start slave io_thread; 如果io线程没有运行，尝试重启该线程，接收mysqlbin日志
不行的话，直接关闭，启动slave
stop slave;
start slave;
参考文档：MySQL数据库错误server_errno=2013的解决
http://blog.itpub.net/7607759/viewspace-683607/
页:
[1]