Public bug reported:
MySQL Router 8.0.x has a race in its connection/quarantine code (upstream
BUG#39215253, fixed in commit `3be5cd509d34` on the 8.4 branch and in 9.7.4;
not in any 8.0 or 8.4 release yet). After a failover, a client connection that
observed the primary as quarantined blocks ~10s in `wait_primary_failover()`.
Meanwhile the quarantine prober un-quarantines the primary and reopens the
listener. When the stale connection finally errors, it calls
`stop_socket_acceptors()` based on its stale `all_quarantined_` flag. The
quarantine is now empty and the topology does not change, so nothing ever
reopens the listener. Port 6446 (classic RW) stays closed until the router is
restarted or the topology changes again. Port 6448 (X RW) shares the code path.
Oracle has changed maintenance strategy for router, meaning that only one
version
is maintained at a time, currently v26.10
** Affects: mysql-8.0 (Ubuntu)
Importance: Undecided
Status: New
** Patch added: "0001-fix-backport-for-MySQL-Bug-39215253.patch"
https://bugs.launchpad.net/bugs/2174047/+attachment/6017225/+files/0001-fix-backport-for-MySQL-Bug-39215253.patch
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2174047
Title:
MySQL Router BUG#39215253
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/2174047/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs