Bug #109413 Allow ignoring replication key errors for MEMORY engine tables only
Submitted: 16 Dec 2022 13:51 Modified: 16 Dec 2022 14:23
Reporter: Yoni Sade Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Dec 2022 13:51] Yoni Sade 
Description:
Add a dynamic system-wide Boolean parameter called "replica_ignore_memory_tables_key_errors" (0 or 1, default 0)
so that DUP KEY / KEY NOT FOUND errors are ignored for MEMORY engine tables only so that replica can be restarted without the need to empty all MEMORY engine tables on the source (which interrupts with production activity)

How to repeat:
--
[16 Dec 2022 14:14] MySQL Verification Team 
Hi Mr. Sade,

Thank you for your bug report.

However, it is a duplicate report for the following entry:

https://bugs.mysql.com/bug.php?id=109411

Duplicate.
[16 Dec 2022 14:23] Yoni Sade 
This is not a duplicate of the other bug I've opened since the first one is about changing the doc by mentioning another workaround with an existing system variable.

Please change the status of this bug/feature request to Open.