MySQL报错:Last_Errno: 1008 | Last_SQL_Errno: 1008
原创HowardSir 2017-05-06 16:48:38 博主文章分类:MySQL ©著作权
文章标签 mysql MySQL 文章分类 MySQL 数据库 阅读数3783
©著作权归作者所有:来自51CTO博客作者HowardSir的原创作品,请联系作者获取转载授权,否则将追究法律责任
MySQL主从复制不能同步,查看slave状态,报错如下:
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.0.134
Master_User: slave
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000006
Read_Master_Log_Pos: 520
Relay_Log_File: relay-log-bin.000028
Relay_Log_Pos: 252
Relay_Master_Log_File: master-bin.000006
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1008
Last_Error: Error 'Can't drop database 'aaa'; database doesn't exist' on query. Default database: ''. Query: 'drop database aaa'
Skip_Counter: 1
Exec_Master_Log_Pos: 356
Relay_Log_Space: 868
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1008
Last_SQL_Error: Error 'Can't drop database 'aaa'; database doesn't exist' on query. Default database: ''. Query: 'drop database aaa'
1 row in set (0.00 sec)
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33.
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
解决办法:
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> set global sql_slave_skip_counter = 1; # 将同步指针向下移动一个,可以重复操作
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.0.134
Master_User: slave
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000006
Read_Master_Log_Pos: 520
Relay_Log_File: relay-log-bin.000030
Relay_Log_Pos: 252
Relay_Master_Log_File: master-bin.000006
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 520
Relay_Log_Space: 551
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33.
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
- 42.
- 43.
- 44.
- 45.
- 46.
- 赞
- 收藏
- 评论
- 举报
上一篇:MySQL 主主复制
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
-
mysql主从报错:Last_Error: Error 'Operation ALTER USER failed for 'root'@'localhost'' on query
报错信息Last_Error:Error'OperationALTERUSERfailedfor'root'@'localhost''onquery.Defaultdatabase:''.Query:'ALTERUSER'root'@'localhost'IDENTIFIEDWITH'caching_sha2_password'AS'A005%&4!DeAf4&(bEnVTRe9BaL8Fj4R
mysql -
MySQL报错:Last_Errno: 1008 | Last_SQL_Errno: 1008
MySQL主从复制不能同步,查看slave状态,报错如下:mysql> show slave status \G*************************** 1. row ***************************
mysql MySQL -
Last_Error: Relay log read failure: Could not parse relay log event entry.
综合网上各种答案,总结一下,还是有帮助的。Relay log corruption example:You can get error info after SHOW SLAVE STATUS;Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: t
数据库 SHOW STATUS SLAVE -
mysql主从报错:Last_Error: Slave failed to initialize relay log info structure from the repository
报错信息showslavestatus\G查看如下Last_Error:Slavefailedtoinitializerelayloginfostructurefromtherepositoryerror.log查看如下20220331T02:54:04.925947Z0ERRORMY011059ReplCouldnotfindtargetlogfilementionedinrelayloginf
mysql -
MySQL报错:Last_Errno: 1008
mysql主从复制排错
mysql 1008 1858 排错 -
The document caused a serious error the last time it was opened
Problem:When you try to open a file that Microsoft Excel or Microsoft Word could not open previously, you receive the following error message: The document 'Filename' caused a serious error the la
职场 休闲 -
mysql报错InnoDB: ERROR: the age of the last checkpoint is
mysql有时会报如下错: 130508 3:40:15 InnoDB: ERROR: the age of the last checkpoint is 13492019,InnoDB: which exceeds the log group capacity 9433498.InnoDB: If you are using big BLOB or
is ERROR -
xtrabackup: error: last checkpoint LSN (3409281307) is larger than last copied LSN (3409274368). #2
1.错误发生场景:使用2.4.1版本的xtrabackup工具进行全备,备份日志中报出此错误2.知识要点:MySQL中,redo 日志写进程会在三种条件下被触发从log buffer中写日志到redo log file中,分别是每隔一秒、日志达到log buffer的1/3、每一次提交的时候。刷新日志的LSN到log file是采用轮询的方式进行的,比如有三组日志当这三组都被写满的时候再重新覆盖第一组的日志,以此类推。同时checkpoints检查点会刷新在log file被覆盖前刷新buffer [p
mysql 配置文件 html linux 错误提示 -
1008
n, i = map(int, input().split())nums = []nums[:] = input().split()nums = nums [ : n]nums.reverse()nums[0 : i] = nums[i-1 : : -1]nums[i : n] = nums[n-1 : i-1 : -1]i = 0while i < len(nums):...
# PTA -
MySQL主备同步last_io_error
# MySQL主备同步last_io_error## 概述MySQL主备同步是MySQL数据库中一项重要的功能,用于保证主数据库和备份数据库之间的数据同步。在主备同步过程中,可能会出现各种错误和异常情况,其中之一就是`last_io_error`。本文将介绍`last_io_error`的含义、可能的原因以及如何解决这些问题。## 什么是last_io_error?`last_io
数据库 服务器 MySQL -
error Newline required at end of file but not found eol-last
error Newline required at end of file but not found eol-last
eslint -
mysql/mariadb很慢,报错:InnoDB: ERROR: the age of the last checkpoint is
问题mysql最新网络吞吐速度慢,到后台查看日志报错:Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server201023 14:19:01 InnoDB: ERROR: the age of the last checkpoint is 9444086,InnoDB: w
mysql 3g 数据目录 -
mysql主从同步错误Last_SQL_Errno: 1133 Last_SQL_Error: Error ‘Can‘t find any matching row in the user table
Last_SQL_Errno: 1133Last_SQL_Error: Error 'Can't find any matching row in the user table' on query. Default database: ''. Query: 'grant all privileges on `zentao`.* to `zentao`@`localhost`'问题MySQL主从同步停止,在从库中查看状态mysql> show slave status\G报如下错..
mysql主从同步出错 mysql主从同步忽略 mysql同步指定表 mysql SSL -
PHP error_get_last() 函数
定义和用法 error_get_last() 函数获得最后发生的错误。 该函数以数组的形式返回最后发生的错误。如果没有错误发生则返回 NULL。 返回的错误数组包含 4 个键名和键值: [type] - 错误类型 [message] - 错误消息 [file] - 发生错误所在的文件 [line]
数组 php 错误类型 键值 PHP -
PHP preg_last_error() 函数
preg_last_error 函数用于返回最后一个 PCRE 正则执行产生的错误代码。语法 int preg_last_error ( void ) 实例 返回数组中指定匹配的元素: <?php preg_match('/(?:\D+|<\d+>)*[!?
正则 错误代码 数组 php PHP -
error mysql 主从last mysql8主从
一、规划 前提:需要准备四台服务器,每台服务器上安装了 mysql8 数据库。规划:从 1 复制 主1 ,从 2 复制 主 2,主 1 复制 主 2,主 2 复制主 1,也就是 主 1 和主 2 互为主从。主1主2互为主从,是为了以下情景,主1挂了,主2自动升级为主数据库,当主1恢复后,主1则变成次主数据库。举个案例:1、在主1创建了一个数据库,从1自动“复制”主1生成数据库, 
error mysql 主从last mysql dba 数据库 主从复制 -
Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary lo
mysql> show slave status\G *************************** 1. row **************
mysql sql javascript -
mysql 1008 mysql1008错误
错误描述 前一天在主库上建立了daxia数据库,然后立马就删除了,导致从库并没有同步完成,然后再去执行binlog中删除的操作时,找不到daxia数据库,所以导致同步中断。# 在从库上查看同步状态,如下MySQL [(none)]> show slave status \G*************************** 1. row **********************
mysql 1008 数据库 MySQL mysql -
HDOJ 1008
ElevatorTime Limit: 2000/1000 MS (Java/Others) Memory Limit: 65
java ios #include sed javascript