MySQL Forums
Forum List  »  Replication

Replicate_Ignore_DB error WHY?
Posted by: yvonne kire
Date: March 08, 2019 02:12PM

I setup a slave to ignore a bounch of DBs
Slave mysql starts up w/o problem
then when I start slave I get an error
It try to replicate a statement from one of the db I told to ignore
what's going on here?
WHY?

Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB: (all_landing, astro_landing, bc_landing)
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1032
Last_Error: Could not execute Update_rows event on table all_landing.alpo_stat; Can't find record in 'alpo_stat', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log box213-37-bin.000089, end_log_pos 833866264

Options: ReplyQuote


Subject
Views
Written By
Posted
Replicate_Ignore_DB error WHY?
693
March 08, 2019 02:12PM


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.