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

Duplicate key may be generated during cluster configuration change

Details

    Description

      The fix for MENT-1023 needs to be migrated to the CS version:
      -------------
      Incorrect processing of an auto-incrementing field during applying transactions results in a duplicate key being created. This is due to the fact that at the beginning of the write_row() and update_row() functions, the values ​​of the auto-increment parameters are used, which are read from the parameters of the current thread, but further along the code other values are used, which are read from global variables (when applying a transaction). This can happen when the cluster configuration has changed while applying a transaction (in high_priority_service mode for Galera 4). Further during IST processing duplicating key is detected, and processing of the DB_DUPLICATE_KEY return code (inside innodb, in the write_row() handler) results in a call to wsrep_thd_self_abort().

      Attachments

        Activity

          sysprg Julius Goryavsky created issue -
          sysprg Julius Goryavsky made changes -
          Field Original Value New Value
          sysprg Julius Goryavsky made changes -
          Fix Version/s 10.2 [ 14601 ]
          sysprg Julius Goryavsky made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          sysprg Julius Goryavsky made changes -
          Fix Version/s 10.2.37 [ 25112 ]
          Fix Version/s 10.2 [ 14601 ]
          sysprg Julius Goryavsky made changes -
          Assignee Julius Goryavsky [ sysprg ] Marko Mäkelä [ marko ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.2.37 [ 25112 ]
          marko Marko Mäkelä made changes -
          Assignee Marko Mäkelä [ marko ] Julius Goryavsky [ sysprg ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          marko Marko Mäkelä made changes -
          marko Marko Mäkelä made changes -
          sysprg Julius Goryavsky made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          sysprg Julius Goryavsky made changes -
          Assignee Julius Goryavsky [ sysprg ] Marko Mäkelä [ marko ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          marko Marko Mäkelä made changes -
          Assignee Marko Mäkelä [ marko ] Julius Goryavsky [ sysprg ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          marko Marko Mäkelä made changes -
          Component/s Storage Engine - InnoDB [ 10129 ]
          Component/s Server [ 13907 ]
          sysprg Julius Goryavsky made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          sysprg Julius Goryavsky made changes -
          issue.field.resolutiondate 2021-03-08 13:29:20.0 2021-03-08 13:29:20.357
          sysprg Julius Goryavsky made changes -
          Fix Version/s 10.2.38 [ 25207 ]
          Fix Version/s 10.3.29 [ 25206 ]
          Fix Version/s 10.4.19 [ 25205 ]
          Fix Version/s 10.5.10 [ 25204 ]
          Fix Version/s 10.6.0 [ 24431 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 119125 ] MariaDB v4 [ 158890 ]

          People

            sysprg Julius Goryavsky
            sysprg Julius Goryavsky
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.