MySQL Forums
Forum List  »  Replication

Deletes to replicated new table fail
Posted by: Chris Adams
Date: September 25, 2006 01:11PM

Hi all,
I have a MySQL server running 4.1.20 on Red Hat AS 4 that is replicated to 2 other RHEL AS 4 servers running the same MySQL version. Here is my issue… I have recently created a table that contains a few fields that are frequently inserted and then deleted/updated. The table is the same on all 3 servers. For some reason the updates/deletes are not replicated to the table only. All other tables in the database (as well as 2 other replicated DB's) are properly replicated. I am seeing the delete statement in the binary logs on the master as well as the relay log on the slave so I know the command is being replicated, it is just not being executed for some reason. Here is an example of what I am seeing in the replication log:

SET INSERT_ID=206411;
# at 311738
#060925 14:44:23 server id 1 log_pos 111197 Query thread_id=44156413 exec_time=0 error_code=0
SET TIMESTAMP=1159209863;
insert into queue (pid, frt, nmbr) values (17851840, 4135680005, 861168);
# at 319952
#060925 14:44:30 server id 1 log_pos 119411 Query thread_id=0 exec_time=0 error_code=0
SET TIMESTAMP=1159209870;
DELETE FROM queue WHERE id=206411;

Yet, I still see the record on the slave after the DELETE is run:

mysql> select * from queue;
+--------+----------+---------+------------+----------+
| id | pid | proc_id | frt | nmbr |
+--------+----------+---------+------------+----------+
| 206411 | 17851840 | NULL | 4135680005 | 861168 |
+--------+----------+---------+------------+----------+

I can manually run the DELETE and it works fine. The records are the same before the DELETE is run on the master. I am not sure what could be causing the problem. There is nothing in the MySQL logs and the slave services show no issues.

Thanks,

Chris

Options: ReplyQuote


Subject
Views
Written By
Posted
Deletes to replicated new table fail
2513
September 25, 2006 01:11PM


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.