pt-online-schema-change fails with "Duplicate entry" on MariaDB
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Brian Fraser |
Bug Description
Tool version: pt-online-
Command: pt-online-
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`.
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.
Related branches
- Daniel Nichter: Approve
-
Diff: 73 lines (+18/-2)3 files modifiedbin/pt-online-schema-change (+6/-1)
lib/TableParser.pm (+1/-1)
sandbox/start-sandbox (+11/-0)
Changed in percona-toolkit: | |
assignee: | nobody → Brian Fraser (fraserbn) |
Changed in percona-toolkit: | |
status: | Triaged → In Progress |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Is this a known MariaDB bug with SHOW WARNINGS or does the query really only produce a warning on MariaDB? Does this happen consistently? for any table and data?