Bug #69930 Not able to Disable Replication
Submitted: 5 Aug 2013 23:53 Modified: 3 Oct 2013 17:57
Reporter: Siva Prasad Padidam Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.6.12 OS:Linux (Trying to Disable the replication and enable the replication again on the same master and Slave. )
Assigned to: CPU Architecture:Any

[5 Aug 2013 23:53] Siva Prasad Padidam
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.
[3 Oct 2013 17:57] Umesh Shastry
Hello Siva,

Thank you for the report.
I cannot repeat described behavior. Could you please try with the latest GA(5.6.14) version and let us know if you still have this issue?

Also, see http://dev.mysql.com/doc/refman/5.6/en/reset-slave.html

Thanks,
Umesh