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".
To post a comment you must log in.
Confirmed. In create_repl_table() for example:
$sql =~ s/CREATE TABLE checksums/CREATE TABLE $repl_table/;