Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2144

query_stats replication issue - binlog is not ignoring

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Do
    • None
    • Icebox
    • N/A
    • None

    Description

      Reported by a customer that there was an error on the slave node with replication on the query_stats table. On CS, this table shouldnt be replicated because it keeps stats based on the UM its keep on.

      So bin logging needs to ignore this table in the replication processing.

      from master

      Last_SQL_Error: Could not execute Write_rows_v1 event on table infinidb_querystats.querystats; Duplicate entry '817843' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000266, end_log_pos 4934

      from one of the slave mysql error file:

      2019-02-07 10:31:27 11 [ERROR] Slave SQL: Could not execute Write_rows_v1 event on table infinidb_querystats.querystats; Duplicate entry '817843' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000266, end_log_pos 4934, Gtid 0-1-5655754, Internal MariaDB error code: 1062

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.