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

LP:713561 - "Duplicate entry" error and time datatype cause slave provisioning to fail

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Incomplete
    • None
    • None
    • None

    Description

      When executing a RQG test that does non-concurrent INSERT into various tables and then uses mysqldump to clone a new slave, the new slave diverges from the master. The slave starts properly and does apply all binlog events from the master, however when the master and the slave are dumped and diffed, they are no longer identical.

      Some observations:

      • It appears that the situation only happens when duplicate key errors are seen on the master due to the randomness of the workload.
      • The duplicate key error is reported against the table that has a non-auto-increment PK, however the diff reports that the table that contains no PK at all is the one that has diverged
      • In some instances, the test reports that the slave thread has failed with an error "Slave SQL: Error 'Table 'test.table1_innodb_int_autoinc' doesn't exist' on opening tables, Error_code: 1146", however the table does exist on the slave
      • Maybe the issue is related to the different rules regarding InnoDB rollback depending on the type of error – statement v.s. transaction rollback

      Attachments

        Activity

          People

            Unassigned Unassigned
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.