[MCOL-2144] query_stats replication issue - binlog is not ignoring Created: 2019-02-07  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Critical
Reporter: David Hill (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: 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


Generated at Thu Feb 08 02:34:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.