cluster replication slave -[ERROR] Slave: Error 'Table 'db' already exists' on query.
getting the error below. i am not sure how to fix this problem.
any ideas on what i need to do. this was a fresh install.
so i ignored this problem and created a table on the master cluster. the
nodes in the master cluster see the table. the nodes on the slave cluster do not.
i don't know if the problems are related.
version- 5.1.7
060419 6:16:29 [ERROR] Slave: Error 'Table 'db' already exists' on query. Defau
lt database: 'mysql'. Query: ' CREATE TABLE db ( Host char(60) binary DEFAULT
'' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DE
FAULT '' NOT NULL, Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT '
N' NOT NULL, Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT
NULL, Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Cre
ate_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Drop_priv
enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Grant_priv enum('
N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, References_priv enum('N'
,'Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') C
OLLATE utf8_general_ci DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') COLLATE
utf8_general_ci DEFAULT 'N' NOT NULL, Create_tmp_table_priv enum('N','Y') COLL
AT
060419 6:16:29 [Warning] Slave: Table 'db' already exists Error_code: 1050
060419 6:16:29 [Warning] Slave: Unknown error Error_code: 1105
060419 6:16:29 [ERROR] Error running query, slave SQL thread aborted. Fix the p
roblem, and restart the slave SQL thread with "SLAVE START". We stopped at log '
bin-log.000002' position 102