Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5.29, 11.4.10
-
RockyLinux 8.10
Description
We running a federatedX connection between a Galera cluster with 4 nodes and a mariadb server 10.5.29. In the middle we have a loadbalancer for adjusting the load between the Galera nodes and mariadb server.
When the loadbalancher switch the Galera node, we got a new session/connection on the mariadb server. For this new connection, the "set time_zone='+00:00'" is missing. Due to this the timestamp is not valid any more.
For solving this issue, I have created a patch. It tracks the mysql.net.bio. When it changed, means we got a new connection, we set the time_zone to +00:00.
I have added the patch.
I assume, that the issue is also present in all versions after 10.5.29
After updating one server to 11.4.10, I can confirm that the issue is still present.