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

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Bug - A problem which impairs or prevents the functions of the product. MDEV-7123 MariaDB 10.0.14 Galera node shutdown with signal 11

                • Major - Major loss of function.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  nirbhay_c Nirbhay Choubey added a comment -

                  https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1366997

                  Show
                  nirbhay_c Nirbhay Choubey added a comment - https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1366997
                  Hide
                  Permalink
                  nirbhay_c Nirbhay Choubey added a comment -

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

                  Show
                  nirbhay_c Nirbhay Choubey added a comment - Can you also share the table structure (SHOW CREATE TABLE ... ) ?
                  Hide
                  Permalink
                  ivan.stoykov@skysql.com Stoykov added a comment -

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

                  BR,

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

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

                  Show
                  seppo Seppo Jaakola added a comment - This bug is being worked in upstream bug tracker: https://github.com/codership/mysql-wsrep/issues/18
                  Hide
                  Permalink
                  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.

                  Show
                  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.
                  Hide
                  Permalink
                  nirbhay_c Nirbhay Choubey added a comment -

                  http://bazaar.launchpad.net/~maria-captains/maria/maria-10.0-galera/revision/3911

                  Show
                  nirbhay_c Nirbhay Choubey added a comment - http://bazaar.launchpad.net/~maria-captains/maria/maria-10.0-galera/revision/3911
                  Hide
                  Permalink
                  nirbhay_c Nirbhay Choubey added a comment -

                  http://bazaar.launchpad.net/~maria-captains/maria/maria-5.5-galera/revision/3552

                  Show
                  nirbhay_c Nirbhay Choubey added a comment - http://bazaar.launchpad.net/~maria-captains/maria/maria-5.5-galera/revision/3552

                    People

                    • Assignee:
                      nirbhay_c Nirbhay Choubey
                      Reporter:
                      ivan.stoykov@skysql.com Stoykov
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: