![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
异常问题解决
文章平均质量分 52
fzdba
这个作者很懒,什么都没留下…
展开
-
ERROR 1129 (HY000): Host '192.168.153.135' is blocked because of many connection errors; unblock wit
相关IP:db1: 192.168.153.135db2:192.168.153.132 场景说明:在db1上访问db2,使用以下语句:mysql -uadmin -p123456 -h192.168.153.132执行后错如下:ERROR 1129 (HY000): Host '192.168.153.135' is blocked because of ma原创 2014-02-26 11:58:20 · 3542 阅读 · 0 评论 -
5.6主从同步,跳过异常语句
场景说明:主从同步异常,使用“show slave status\G”查看,发现如下错误。Last_Error: Error executing row event: 'Cannot execute statement: impossible to write to binary log since statement is in row format原创 2014-03-17 16:15:33 · 970 阅读 · 0 评论 -
mysql主从同步异常问题整理
主键重复场景说明:在主从数据不一致情况下,slave已经有id为2数据,在master上没有id为2数据,往主库上写入id=2的数据。主库t1数据:mysql> select * from t1;+----+------+| id | name |+----+------+| 1 | 1 |+----+------+从库t1数据:mysql> selec原创 2014-03-21 10:06:07 · 8913 阅读 · 0 评论