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

Galera duplicate error on autoincrement field primary key

Details

    Description

      The Galera cluster consists of 2 data nodes and one Galera Arbitrator.
      After the second node failure, the cluster consists of one alive node and garbd instance and Duplicate error started to be received by the application:

      MySql.Data.MySqlClient.MySqlException Duplicate entry '300347006487' for key 'PRIMARY

      Attachments

        Issue Links

          Activity

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1366997

            Can you also share the table structure (SHOW CREATE TABLE ... ) ?

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - Can you also share the table structure (SHOW CREATE TABLE ... ) ?

            two files attached with the create table where Primary key error was reported:
            CreateTable_transaction.txt
            CreateTable_vbintegrationlogmerchant.txt

            BR,

            ivan.stoykov@skysql.com Stoykov (Inactive) added a comment - two files attached with the create table where Primary key error was reported: CreateTable_transaction.txt CreateTable_vbintegrationlogmerchant.txt BR,
            seppo Seppo Jaakola added a comment -

            This bug is being worked in upstream bug tracker: https://github.com/codership/mysql-wsrep/issues/18

            seppo Seppo Jaakola added a comment - This bug is being worked in upstream bug tracker: https://github.com/codership/mysql-wsrep/issues/18
            seppo Seppo Jaakola added a comment -

            For autocommit inserts, there is a potential workaround by configuring:
            wsrep_drupal_282555_workaround = ON
            wsrep_retry_autocommit= < reasonably large value, in my test 10 is enough to prevent dupkey errors >

            With this configuration, mysql server will silently retry an autocommit insert that would fail for duplicate key error. Max retry count can be controlled with wsrep_retry_autocommit limit.

            seppo Seppo Jaakola added a comment - For autocommit inserts, there is a potential workaround by configuring: wsrep_drupal_282555_workaround = ON wsrep_retry_autocommit= < reasonably large value, in my test 10 is enough to prevent dupkey errors > With this configuration, mysql server will silently retry an autocommit insert that would fail for duplicate key error. Max retry count can be controlled with wsrep_retry_autocommit limit.
            nirbhay_c Nirbhay Choubey (Inactive) added a comment - http://bazaar.launchpad.net/~maria-captains/maria/maria-10.0-galera/revision/3911
            nirbhay_c Nirbhay Choubey (Inactive) added a comment - http://bazaar.launchpad.net/~maria-captains/maria/maria-5.5-galera/revision/3552
            claudio.nanni Claudio Nanni added a comment -

            Hi,
            Still happening on 10.0.20, especially on fresh startup.

            claudio.nanni Claudio Nanni added a comment - Hi, Still happening on 10.0.20, especially on fresh startup.

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              ivan.stoykov@skysql.com Stoykov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.