Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-39008

FederatedX broke Timestamps when Connection change

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            gkodinov Georgi Kodinov
            PeterSecu Peter
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.