Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6583

Replication error

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • N/A
    • None
    • None

    Description

      Please refer to: https://mariadb.atlassian.net/browse/MDEV-5648

      I have the same error and wonder if I can ignore/skip this sort of replication errors (Could not execute Update_rows_v1 event on table tableName; Can't find record in 'tableName', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.***, end_log_pos ***).

      Relay bin log extractions:

      # 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/*!*/;
      /*!\C latin1 *//*!*/;
      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
      /*!*/;
      # at 474
      # at 560
      # at 703
      # at 773
      # 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
      # at 1100
      #140813 15:20:53 server id 1  end_log_pos 858287498     Xid = 251749261622

      Attachments

        Activity

          People

            Unassigned Unassigned
            jwang james wang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.