mysql master slave "table already exists" but table not exists
- by Korjavin Ivan
I have 1 master mysql process, and 2 slave.
Today on both slaves i see :
Error 'Table 'bgbilling.contract_status_balance_dump' already exists' on query. Default database: 'bgbilling'. Query: 'CREATE TABLE contract_status_balance_dump( UNIQUE(cid) ) SELECT cid, MAX(yy*12+(mm-1))%12 + 1 AS mm,FLOOR(MAX(yy*12+(mm-1)) / 12) AS yy FROM contract_balance GROUP BY cid'
"show tables" does not show this table.
I tryed stop slave , and do "drop table contract_status_balance_dump"
but:
ERROR 1051 (42S02): Unknown table 'contract_status_balance_dump'
How its possible? And how fix that?