Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-345

LP #1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by yetanotherape last update 15-02-2013 17:10:54

      Tool version: pt-online-schema-change 2.1.8
      Command: pt-online-schema-change --alter "DROP COLUMN test_column" --nodrop-old-table --execute u=root,D=test,t=test_table
      MariaDB version: mysql Ver 15.1 Distrib 5.5.28-MariaDB, for Linux (x86_64) using readline 5.1

      Run command on server that is in use.
      Output:
      ...
      `test`.`test_table` was not altered.
      (in cleanup) Error copying rows from `test`.`test_table` to `test`.`_test_table_new`: Copying rows caused a MySQL error 1062:
      Level: Warning
      Code: 1062
      Message: Duplicate entry '622374' for key 'PRIMARY'
      Query: INSERT LOW_PRIORITY IGNORE INTO ...

      It seems that MariaDB return some warnings while executing SHOW WARNINGS after INSERT IGNORE.
      On MySQL (mysql Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (x86_64) using readline 6.2) SHOW WARNINGS return nothing.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: