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
|
Deletes to replicated new table fail |
821 | Chris Adams |
09/25/2006 01:11PM |
Sorry, you can't reply to this topic. It has been closed.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.