MDEV-35570 parallel slave ALTER-SEQUNCE attemted to binlog out-of-order

[andrelkin]

trafficstars

The description is copied from the commit message of the initial branch's commit

Since MDEV-31503 fixes ALTER-SEQUENCE might be able to complete its work including binlogging before a preceding in binlog-order transaction. There may not be data dependency between the two transactions, but there would be "an attempt was made to binlog GTID D-S-XYZ which would create an out-of-order sequence number" error in the gtid_strict_mode = ON.

After the preceding transaction started committing, and does is very slow, ALTER-SEQUNCE was able to find a time window to complete because it temporarily releases its link with the waitee parent transaction. And while having released it it also erroneously executed binlogging part.

Fixed with restoring the commit dependency on the parent before ALTER-SEQUNCE takes on binlogging.

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}