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

Spider is not maintaining SQL_MODE across nodes

Details

    Description

      When session level SQL_MODE is set in the spider node, this is not replicated to the data nodes in Spider, causing issues with data that is correct in the spider node SQL_MODE setting but is not in data nodes unless SQL_MODE is set there also to align with the spider node setting.

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-16508 spider: sql_mode not maintained between spider node and data nodes

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sjmudd Simon Mudd added a comment -

            This may not be noticed unless the spider node (or datanodes) have a stricter sql_mode setting than expected. e.g. during replication the upstream master could be configured differently. I saw this break replication. The issue was due to a configuration mistake but it's clear that sql_mode settings need to be applied on the data nodes to be the same as the session. Whether that comes through via a normal query or via replication won't matter.

            sjmudd Simon Mudd added a comment - This may not be noticed unless the spider node (or datanodes) have a stricter sql_mode setting than expected. e.g. during replication the upstream master could be configured differently. I saw this break replication. The issue was due to a configuration mistake but it's clear that sql_mode settings need to be applied on the data nodes to be the same as the session. Whether that comes through via a normal query or via replication won't matter.
            dthompson David Thompson (Inactive) added a comment -

            This should obviously be configurable since there is no strict requirement that the spider node is the same exact version or distribution as the data nodes so it's possible that sql_mode valid value support may differ.

            dthompson David Thompson (Inactive) added a comment - This should obviously be configurable since there is no strict requirement that the spider node is the same exact version or distribution as the data nodes so it's possible that sql_mode valid value support may differ.
            jacob-mathew Jacob Mathew (Inactive) added a comment -

            Downgraded priority since the customer has a workaround.

            jacob-mathew Jacob Mathew (Inactive) added a comment - Downgraded priority since the customer has a workaround.

            People

              Kentoku Kentoku Shiba (Inactive)
              karlsson Anders Karlsson
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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