[MXS-1746] The session-specific gtid_domain_id is queried instead of the global one Created: 2018-03-27  Updated: 2018-03-28  Resolved: 2018-03-28

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbmon
Affects Version/s: 2.2
Fix Version/s: 2.2.5

Type: Bug Priority: Major
Reporter: Esa Korhonen Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None


 Description   

gtid_domain_id has both a session value and global value. Generally we are interested in the global value. The query in read_server_variables(), however, only checks the session value (SELECT @@gtid_domain_id). This does not update with the global value as long as the session is alive, meaning the monitor will follow the wrong gtid domain id.

Upon closer inspection, the gtid_domain_id is quite a problematic value, as it seems changing the global version does not change the value for existing sessions. This means that if any old sessions keep doing writes, those writes will go to the old domain. In the worst case, there could be multiple domains being updated simultaneously, making it impossible to say which is the current domain. This has implications for checking if a server is behind another server in gtid:s.


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