Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4413

UPDATE with user variable breaks replication

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 2.5, 6.4, 22.08
    • 6.4.4, 22.08.3
    • qc_sqlite
    • None

    Description

      I have maxscale (version 22.08.2) and 4 mariadb nodes (master and slaves).
      The problem has appeared in one of mariadb replicas:

      An attempt was made to binlog GTID 1-2-75990 which would create an out-of-order sequence number with existing GTID 1-1-75990, and gtid strict mode is enabled
      

      I found a problem query:

       UPDATE objects o,
                          (
                              SELECT newIndex, o_id FROM (SELECT @n := IF(@n = '2' - 1,@n + 2,@n + 1) AS newIndex, o_id
                              FROM objects,
                              (SELECT @n := -1) variable
                              WHERE o_id != '2142' AND o_parentId = '343' AND o_type IN ('object','variant','folder')
                                  ORDER BY o_index, o_id='2142'
                              ) tmp
                          ) order_table
                          SET o.o_index = order_table.newIndex
                          WHERE o.o_id=order_table.o_id
      

      So, as I understood, the problem is in using user-defined variable.
      I found a bug https://jira.mariadb.org/browse/MXS-4269, but there are no comments and it is closed. How can I fix my problem?
      What interesting, I had this error only on one of three replicas.
      On one of them version 10.5.13, and on the other version 10.5.17. Could this be the reason?

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            magzhanova Asel Magzhanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.