mysql slave error_Mysql slave error

最新推荐文章于 2021-02-26 23:02:46 发布
最新推荐文章于 2021-02-26 23:02:46 发布
阅读量156 收藏
点赞数
文章标签： mysql slave error
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_29015801/article/details/114329884
版权

140109 15:13:13 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:13 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301029473

140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301029473

140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301031427

140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301035259

140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301037299

140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301038319

140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301038319

140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301050289

140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301053956

140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301053956

140109 15:13:16 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301054211

140109 15:13:16 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301054466

140109 15:13:16 [Note] Slave: received end packet from server, apparent master shutdown:

140109 15:13:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301057629

SLAVE的错误日志里面不停的刷上面的问题，而且show slave status\G的时候Slave_IO_Running一时YES，一时NO。

问题的原因是：和某一台slave的server_id重复了

原文：http://ldhqy.blog.51cto.com/2788106/1620116

红茶漫山
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql slave错误_Mysql slave 同步错误解决
weixin_30873333的博客
01-19 512
分析解决master 数据库提供服务，slave数据库作报表服务器，通过mysqlbin log做主从同步。从报表数据来看，缺少了从10/28到现在(11/18)之前的数据，比对master、slave数据库主要表数据，发现：10/28之后的slave库数据缺失，一致未同步。查看slave mysql同步状态：关注图中黄色字段：Slave_IO_Running: YesSlave_SQL_Runn...
MySQL-Master_Slave_repl.txt
06-29
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs This error generally occur when we clone the master to slaver. Delete auto.cnf of mysql, and then ...
Mysql slave error
weixin_34315665的博客
03-13 105
140109 15:13:13 [Note] Slave: received end packet from server, apparent master shutdown:140109 15:13:13 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-...
mysql slave error_mysql slave error处理
weixin_35810223的博客
01-19 508
0.关键点:1.show slave status\G; 查看挂了的原因2.一般处理完后要tcp校验一下3.如果是宕机或者实例重启，在主库执行start slave前要在备库上看看有没有回滚进程ps aux | grep magiclog ，如果有 magiclog 进程在执行说明在回滚。回滚过程中不能执行start slave，不然会报各种slave err1.报错:文件中位点>文件大小G...
mysql slave error_mysql slave error
weixin_33842051的博客
02-26 104
空间不足，导致同步停止130906 13:25:52 [ERROR] log /data/mysql/var/mysql-relay-bin.000332 listed in the index, but failed to stat130906 13:25:52 [ERROR] Error counting relay log space130906 13:31:50 [ERROR] log /...
MySQL多线程复制遇到Error_code: 1872的解决方案
09-10
在MySQL 5.7.10版本中，如果数据库因为外部因素如IDC机房断电而重启，从机在尝试恢复复制时可能会报告`Error_code: 1872`，提示“Slave failed to initialize relay log info structure from the repository”。...
mysql 数据同步 出现Slave_IO_Running:No问题的解决方法小结
09-11
### MySQL 数据同步中 Slave_IO_Running:No 问题的解决方法 #### 一、MySQL Replication 基础概述 在MySQL的复制机制中，主要包括两部分：**Master（主服务器）** 和 **Slave（从服务器）**。主服务器负责记录所有...
MySQL ERROR 2013 (HY000)错误解决方法
12-15
如果是在linux shell命令行中直接打 mysql 命令，能够顺利连上 MySQL，执行查询语句也比较正常，但如果执行 STOP SLAVE; 命令时就随机出现 ERROR 2013 (HY000): Lost connection to MySQL server during query 问题...
mysql1201_MySQL启动slave报错ERROR1201(HY000)
weixin_35076634的博客
02-02 332
MySQL 启动slave报错 ERROR 1201 (HY000) ,原来是有两个文件要删掉。估计是昨天其他人测试没有成功的时候生成的。配置了MySQL的复制，启动slave的时候报错如下：mysql> start slave;ERROR 1201 (HY000): Could not initialize master info structure; more error message...
mysql slave error处理
zhangjikuan的专栏
11-02 2563
备库挂了：slave io/sql thread error 0.关键点: 1.show slave status\G; 查看挂了的原因 2.一般处理完后要tcp校验一下 3.如果是宕机或者实例重启，在主库执行start slave前要在备库上看看有没有回滚进程ps aux | grep magiclog ，如果有 magiclog 进程在执行说明在回滚。回滚过程中不能执行star
mysql slave不能同步Last_SQL_Error Error Duplicate entry
这么多柠檬c
06-05 473
slave stop; set GLOBAL SQL_SLAVE_SKIP_COUNTER=1; slave start;
slave崩溃后的一个解决办法
pwlazy的专栏
04-11 1893
今天我在查看slave日志发现很多错误，通常情况下，你可以 通过SET GLOBAL SQL_SLAVE_SKIP_COUNTER= n忽略错误或者通过查过日志改正错误然后slave start但这一次都搞不定，烦死了，我决定重设slave. ( master是192.168.100.231)在slave机器上：  slave stop; mysqldump -u root -
Slave Error 'Your password does not satisfy the current policy requirements' on query. Default...
fangang001的专栏
04-01 697
在配置mysql5.7.28主从复制过程中，主库创建的用户不符合既定密码策略导致从库start slave过程中报错： “Error 'Your password does not satisfy the current policy requirements' on query. Default database: 'mysql'. Query: 'GRANT ALL PRIVILEGES O...
mysql error handler_MySql错误处理（二） - Condition & Handle
weixin_34545862的博客
01-21 100
20.2.10.2.DECLARE处理程序DECLARE handler_type HANDLER FOR condition_value[,...] sp_statementhandler_type:CONTINUE| EXIT| UNDOcondition_value:SQLSTATE [VALUE] sqlstate_value| condition_name| SQLWARNING| N...
mysql_slave :Error_code: 1593解决
congruo6877的博客
01-14 521
NO1：在slave库上：SQL>slave stop;SQL>reset master;NO2：在master库上执行：SQL>show master status;记录2个参数值：master_log_fi...
mysql slave 1062_mysql主从同步slave错误1062
weixin_32473663的博客
01-19 556
昨天检查mysql主从同步发现slave错误代码1062插入数据错误。Relay_Master_Log_File: mysql-bin.011280Slave_SQL_Running: NoLast_Errno: 1062原因：1.程序可能在slave上进行了写操作2.也可能是slave机器重起后，事务回滚造成的.有二种解决办法一 1.首先停掉Slave服务：slave stop2.到主服务器上查...
Failed reading log event, reconnecting to retry
ciqxcl15963093886的博客
04-11 220
数据库版本：5.6.16 系统：CentOS 6.5 搭建数据库从库报错： 160411 14:30:39 [Note] Slave I/O thread: Failed reading log event, re...
mysql slave duplicate entry_mysql slave不能同步Last_SQL_Error: Error ‘Duplicate entry ‘
最新发布
05-20
这个错误通常表示主从同步过程中出现了重复的数据，可能是由于数据在主库上进行了重复插入或更新操作导致的。解决此问题的一种方法是手动跳过错误的 SQL 语句，然后重新启动从库同步。 具体的步骤如下： 1. 在从库上执行以下命令，查看出错的 SQL 语句： SHOW SLAVE STATUS\G 2. 找到 "Last_SQL_Error" 字段，看看具体的错误信息是什么。 3. 如果错误信息是 "Duplicate entry"，则可以手动跳过该 SQL 语句。在从库上执行以下命令： STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE; 这里的 "1" 表示跳过一个 SQL 语句，如果错误的 SQL 语句不止一个，需要将 "1" 改为相应的数字。 4. 重新检查从库的状态： SHOW SLAVE STATUS\G 如果 "Slave_IO_Running" 和 "Slave_SQL_Running" 都为 "Yes"，则说明主从同步已经恢复正常。 需要注意的是，手动跳过 SQL 语句可能会导致数据不一致，因此在执行此操作之前，最好先备份从库的数据。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值