Add IF EXISTS to create table and databases queries in pt-table-checksum
Bug #950290 reported by
Alfie John
This bug report is a duplicate of:
Bug #950294: pt-table-checksum should always create schema and tables with IF NOT EXISTS.
Edit
Remove
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
Invalid
|
Medium
|
Unassigned | ||
Bug Description
pt-table-checksum does the following if the schema isn't on the master:
- CREATE DATABASE percona
- CREATE TABLE dsns
- CREATE TABLE checksums
However if a slave already has the schema, replication breaks with database/table "already exists".
Revision history for this message
| Daniel Nichter (daniel-nichter) wrote | #1 |
| tags: | added: breaks-replication pt-table-checksum |
| Changed in percona-toolkit: | |
| status: | New → Confirmed |
| importance: | Undecided → Medium |
Revision history for this message
| Daniel Nichter (daniel-nichter) wrote | #2 |
| Changed in percona-toolkit: | |
| status: | Confirmed → Invalid |
To post a comment you must log in.
Confirmed. In create_repl_table() for example:
$sql =~ s/CREATE TABLE checksums/CREATE TABLE $repl_table/;