MySQL Forums
Forum List  »  Replication

cluster replication slave -[ERROR] Slave: Error 'Table 'db' already exists' on query.
Posted by: richard horan
Date: April 19, 2006 05:23AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
cluster replication slave -[ERROR] Slave: Error 'Table 'db' already exists' on query.
3513
April 19, 2006 05:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.