Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5.19
-
None
Description
on on Galera4 (master) node
1. do the full backup with maria-backup
on standalone (slave) node:
2. maria-backup prepare backup
3. create table, discard tablespace, import tablespace from backup
4. set global replicate_do_db='ctac';
5. SET GLOBAL replicate_do_table='ctac.writetest';
6. CHANGE MASTER 'ppes' TO MASTER_HOST='ppes2', master_user='root', master_password='password', MASTER_PORT=3406, master_log_file='pes2-logbin.003137', master_log_pos=5789;
7. check the error.log:
2025-03-09 13:00:55 2743 [Note] Master 'ppes': Slave I/O thread: connected to master 'root@ppes2:3406',replication started in log 'pes2-logbin.003137' at position 5789
2025-03-09 13:00:55 2744 [ERROR] Master 'ppes': Slave SQL: Could not execute Update_rows_v1 event on table heartbeat.heartbeat; Can't find record in 'heartbeat', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log pes2-logbin.003137, end_log_pos 6171, Gtid 144-85-7041435, Internal MariaDB error code: 1032
2025-03-09 13:00:55 2744 [ERROR] Master 'ppes': Slave SQL: Node has dropped from cluster, Gtid 144-85-7041435, Internal MariaDB error code: 1047
2025-03-09 13:00:55 2744 [Note] Master 'ppes': Slave SQL thread exiting, replication stopped in log 'pes2-logbin.003137' at position 5789
=================
where ctac.writetest - table to be replicated, heartbeat.heartbeat - local to galera4 cluster (master) with pt-heartbeat manual emulation, which we don't want to replicate
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
on on Galera4 (master) node
1. do the full backup with maria-backup on standalone (slave) node: 2. maria-backup prepare backup 3. create table, discard tablespace, import tablespace from backup 4. set global replicate_do_db='ctac'; 5. SET GLOBAL replicate_do_table='ctac.writetest'; 6. CHANGE MASTER 'ppes' TO MASTER_HOST='ppes2', master_user='root', master_password='password', MASTER_PORT=3406, master_log_file='pes2-logbin.003137', master_log_pos=5789; 7. check the error.log: 2025-03-09 13:00:55 2743 [Note] Master 'ppes': Slave I/O thread: connected to master 'root@ppes2:3406',replication started in log 'pes2-logbin.003137' at position 5789 2025-03-09 13:00:55 2744 [ERROR] Master 'ppes': Slave SQL: Could not execute Update_rows_v1 event on table heartbeat.heartbeat; Can't find record in 'heartbeat', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log pes2-logbin.003137, end_log_pos 6171, Gtid 144-85-7041435, Internal MariaDB error code: 1032 2025-03-09 13:00:55 2744 [ERROR] Master 'ppes': Slave SQL: Node has dropped from cluster, Gtid 144-85-7041435, Internal MariaDB error code: 1047 2025-03-09 13:00:55 2744 [Note] Master 'ppes': Slave SQL thread exiting, replication stopped in log 'pes2-logbin.003137' at position 5789 ================= where ctac.writetest - table to be replicated, heartbeat.heartbeat - local to galera4 cluster (master) with pt-heartbeat manual emulation, which we don't want to replicate |
Fix Version/s | N/A [ 14700 ] | |
Resolution | Not a Bug [ 6 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |