[MDEV-4542] Log Warning when there is a missing GTID Transaction Created: 2013-05-17  Updated: 2013-05-17

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Trivial
Reporter: Chris Calender (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

It would be a nice feature if a warning would be logged to the error log when a gap is detected in gtid transactions.

For instance, it is possible to have a missing transaction, which can be seen here:

SELECT @@global.gtid_executed

495026d5-81c4-11e2-8bb6-0296f9c14830:1-2,
98cba6c2-81d2-11e2-8c14-0296f9d510ce:1-69398730:69398732-165311869,
9dac41db-81c8-11e2-8bd2-065e7ea1bc7d:1-25627850,
ddc9b988-9811-11e2-9d25-065e7ead6b68:1,
e3f234a5-9810-11e2-9d1f-065e7e937932:1

SELECT @@global.gtid_purged

495026d5-81c4-11e2-8bb6-0296f9c14830:1-2,
98cba6c2-81d2-11e2-8c14-0296f9d510ce:1-69398730:69398732-130357223,
9dac41db-81c8-11e2-8bd2-065e7ea1bc7d:1-25627850,
ddc9b988-9811-11e2-9d25-065e7ead6b68:1,
e3f234a5-9810-11e2-9d1f-065e7e937932:1

So the missing transaction is: 98cba6c2-81d2-11e2-8c14-0296f9d510ce:69398731

Note the master did not exhibit the gap, so it was introduced on the slave (though I'm not sure how that was caused).

At any rate, once the slave is stopped, and then restarted, an error will occur if the gap is in a binlog that has already been purged (which in this case it is, because we see it in gtid_purged).

Thus, it would be nice to be aware of this beforehand, if at all possible. At least if it were logged, one would be more likely to notice the problem.


Generated at Thu Feb 08 06:57:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.