pt-heartbeat breaks replication if started on slave with an empty table

Description

If you start pt-heartbeat on slave before you have any entry on the table, the tool will insert a row in the table even if you have set --monitor argument. Once you start the tool on master, it will insert the first row in the table and it will break replication.

How to repeat:

Note:
If you have your slave as read_only and/or super_read_only step 2 will fail on below error:

Environment

None

Smart Checklist

Activity

Show:

Details

Assignee

Reporter

Priority

Affects versions

Reviewer

Smart Checklist

Created June 21, 2017 at 11:34 AM
Updated March 4, 2024 at 5:31 PM