[MDEV-5648] some reason slave stopped replication due error Created: 2014-02-11  Updated: 2014-08-14  Resolved: 2014-02-11

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.7
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Joni-Pekka Kurronen Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Ubuntu 12.04 LTS


 Description    

mysql> show slave status \G;
 
*************************** 1. row ***************************
 
               Slave_IO_State: Waiting for master to send event
 
                  Master_Host: 192.168.0.40
 
                  Master_User: slave_user
 
                  Master_Port: 3306
 
                Connect_Retry: 60
 
              Master_Log_File: mysql-bin.000221
 
          Read_Master_Log_Pos: 242775
 
               Relay_Log_File: mysql-relay.000010
 
                Relay_Log_Pos: 168849715
 
        Relay_Master_Log_File: mysql-bin.000204
 
             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: 1032
 
                   Last_Error: Could not execute Update_rows_v1 event on table bacula.Media; Can't find record in 'Media', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000204, end_log_pos 168850009
 
                 Skip_Counter: 0
 
          Exec_Master_Log_Pos: 385542863
 
              Relay_Log_Space: 288242036
 
              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: 1032
 
               Last_SQL_Error: Could not execute Update_rows_v1 event on table bacula.Media; Can't find record in 'Media', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000204, end_log_pos 168850009
 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 2
 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
                   Using_Gtid: No
 
                  Gtid_IO_Pos: 
1 row in set (0.01 sec)
 
 
 
ERROR: 
No query specified
 
 
 
mysql>



 Comments   
Comment by Sergei Golubchik [ 2014-02-11 ]

This usually happens when master and slave tables go out of sync. There can be many reasons for this to happen. For example, you might have used statement-based replication and executed an "unsafe" (for statement-based) command. Or you might have manually edited tables on the slave. Of course, this could also happen as a result of a bug.

If it is, indeed, a bug and you have a test case that shows how to repeat this error, please, don't hesitate to reopen this bug report.

Comment by james wang [ 2014-08-14 ]

Hi Sergei,

I have the same error.

Replication stopped. I wonder if I can just ignore/skip this sort of error?

Relay bin log (extraction):

  1. at 394
    #140813 15:20:53 server id 1 end_log_pos 858286845 Query thread_id=2375878105 exec_time=0 error_code=0
    SET TIMESTAMP=1407939653/!/;
    SET @@session.pseudo_thread_id=2375878105/!/;
    SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/!/;
    SET @@session.sql_mode=0/!/;
    SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/!/;
    /Unable to render embedded object: File (\C latin1 *//*) not found./;
    SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/!/;
    SET @@session.time_zone='SYSTEM'/!/;
    SET @@session.lc_time_names=0/!/;
    SET @@session.collation_database=DEFAULT/!/;
    BEGIN
    /!/;
  2. at 474
  3. at 560
  4. at 703
  5. at 773
  6. at 836
    #140813 15:20:53 server id 1 end_log_pos 858286931 Table_map: `Easycall`.`calls` mapped to number 7589
    #140813 15:20:53 server id 1 end_log_pos 858287074 Table_map: `Easycall`.`agents` mapped to number 678383
    #140813 15:20:53 server id 1 end_log_pos 858287144 Table_map: `Easycall`.`calls_extra` mapped to number 381731
    #140813 15:20:53 server id 1 end_log_pos 858287207 Table_map: `Easycall`.`status_log` mapped to number 7604
    #140813 15:20:53 server id 1 end_log_pos 858287471 Update_rows: table id 7589 flags: STMT_END_F
  7. at 1100

Thanks a lot in advance
James

Comment by james wang [ 2014-08-14 ]

can i comment on closed ticket?

Generated at Thu Feb 08 07:05:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.