In pt-table-checksum's check_repl_table():
if ( !$tbl_exists ) {
if( $o->get('create-replicate-table') ) {
create_repl_table(%args)
}
else {
die "--replicate table $repl_table does not exist..."
}
}
So what will happen here is that the following will be run:
CREATE TABLE checksum (
...
)
However all my slaves already have the percona schema... it was only
the cold master which had it missing. So now replication fails since
we have:
"Table 'checksums' already exists"
To play it safe should the query be changed to:
CREATE TABLE IF NOT EXISTS checksum (
...
)
Alfie