Last_SQL_Error: Error 'Can't drop database 'just'; database doesn't exist' on query. Default database: 'just'. Query: 'drop database just'
Relay_Master_Log_File: master-bin.000001
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 'just'; database doesn't exist' on query. Default database: 'just'. Query: 'drop database just'
Skip_Counter: 0
Exec_Master_Log_Pos: 681
Relay_Log_Space: 1728
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 'just'; database doesn't exist' on query. Default database: 'just'. Query: 'drop database just'
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: 22915959-e5e3-11e5-a894-000c29c0d786
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
开发把数据库删除了,跑过来说,糟了,找我这个救火队员,当时就有点.....
幸好我备份了的。
环境:
centos 6.5 64
mysql 5.6.12
主从环境 gtid开启
教训,如果主从环境删除要先在主库删除,不要在从库做删除,不然SQL线程永远识别不了。
永远报1008
解决:
stop slave;
create database jishibang;
start slave;
show slave status;
IO
SQL 均为yes
说明:关于5.6的gtid特性请尽快熟悉,不然新手会出很多错。