Description:
Hi,
I am trying to disable and enable replication on the same Slave server. So the steps followed are
1) Stop Slave;
2) Reset Slave All;
3) Stop and Start the Slave
4) CHANGE MASTER TO MASTER_HOST='X.X.X.X', MASTER_USER='replication_user', MASTER_PASSWORD='xxxx', MASTER_PORT=xxxx;
5) Start Slave.
Whats happening is the Slave is still picking up the old replication information. We are in the testing phase of replication. Below is the info from slave site.
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: System lock
Master_Host: 16.216.152.155
Master_User: replication_user
Master_Port: 1531
Connect_Retry: 60
Master_Log_File: binlogs.000012
Read_Master_Log_Pos: 122687509
Relay_Log_File: d9t0645g-relay-bin.000002
Relay_Log_Pos: 357
Relay_Master_Log_File: binlogs.000007
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: 1051
Last_Error: Error 'Unknown table 'SIVA.simples'' on query. Default database: 'SIVA'. Query: 'DROP TABLE `simples` /* generated by server */'
Skip_Counter: 0
Exec_Master_Log_Pos: 191
Relay_Log_Space: 1947863562
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: 1051
Last_SQL_Error: Error 'Unknown table 'SIVA.simples'' on query. Default database: 'SIVA'. Query: 'DROP TABLE `simples` /* generated by server */'
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: 8df6665c-f4f5-11e2-badc-00505600209f
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp: 130805 23:26:50
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set: 8df6665c-f4f5-11e2-badc-00505600209f:45-74
Executed_Gtid_Set: c5709bf9-f50a-11e2-bb67-005056002232:1-7
Auto_Position: 0
1 row in set (0.01 sec)
ERROR:
No query specified
Master Info.
mysql> show master status;
+----------------+----------+--------------+------------------+--------------------------------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+----------------+----------+--------------+------------------+--------------------------------------------+
| binlogs.000025 | 695 | | | 8df6665c-f4f5-11e2-badc-00505600209f:1-113 |
+----------------+----------+--------------+------------------+--------------------------------------------+
1 row in set (0.00 sec)
How to repeat:
Following the steps Given in Description.
Description: Hi, I am trying to disable and enable replication on the same Slave server. So the steps followed are 1) Stop Slave; 2) Reset Slave All; 3) Stop and Start the Slave 4) CHANGE MASTER TO MASTER_HOST='X.X.X.X', MASTER_USER='replication_user', MASTER_PASSWORD='xxxx', MASTER_PORT=xxxx; 5) Start Slave. Whats happening is the Slave is still picking up the old replication information. We are in the testing phase of replication. Below is the info from slave site. mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: System lock Master_Host: 16.216.152.155 Master_User: replication_user Master_Port: 1531 Connect_Retry: 60 Master_Log_File: binlogs.000012 Read_Master_Log_Pos: 122687509 Relay_Log_File: d9t0645g-relay-bin.000002 Relay_Log_Pos: 357 Relay_Master_Log_File: binlogs.000007 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: 1051 Last_Error: Error 'Unknown table 'SIVA.simples'' on query. Default database: 'SIVA'. Query: 'DROP TABLE `simples` /* generated by server */' Skip_Counter: 0 Exec_Master_Log_Pos: 191 Relay_Log_Space: 1947863562 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: 1051 Last_SQL_Error: Error 'Unknown table 'SIVA.simples'' on query. Default database: 'SIVA'. Query: 'DROP TABLE `simples` /* generated by server */' Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: 8df6665c-f4f5-11e2-badc-00505600209f Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 130805 23:26:50 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 8df6665c-f4f5-11e2-badc-00505600209f:45-74 Executed_Gtid_Set: c5709bf9-f50a-11e2-bb67-005056002232:1-7 Auto_Position: 0 1 row in set (0.01 sec) ERROR: No query specified Master Info. mysql> show master status; +----------------+----------+--------------+------------------+--------------------------------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +----------------+----------+--------------+------------------+--------------------------------------------+ | binlogs.000025 | 695 | | | 8df6665c-f4f5-11e2-badc-00505600209f:1-113 | +----------------+----------+--------------+------------------+--------------------------------------------+ 1 row in set (0.00 sec) How to repeat: Following the steps Given in Description.