Update statement processed only master server.

I hope someone can help me or give me some clues as to what I can try.

We have a process of pushing data into a table (new_thresh_val). The =
process of pushing data is I show below:
1) DELETE FROM new_thresh_val; # empties the table.
2) A series of Insert statements to push data back into the table.
3) A series of Update statements that are exceptions that over-ride the =
precomuted data.

I have the binary log turned on for both the Master and Slave servers. =
I see the DELETE and the series of INSERT statements in both logs. =
However, I do not see any update statements in the Slave's binary log =
from the set that is seen in the master binary log (a sample shown =
below). The UPDATE statements are simply missing in the Slave's binary =
log.

I then went ahead and processed the Master's UPDATE SQL statements =
through the MySQL client on the slave with the root account. No errors =
were detected through the MySQL client and after I manually excecuted =
the UPDATE statements, the data between Master and Slave was once again =
in SYNC. So the question is why does it appear that the UPDATE =
statements not processed through replication? =20

Here is the grant for the Slave's replication account. Other Update =
statements are processed without any issue at least none that I am aware =
of at this time. I do not see any errors in the error log.
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.*...

Server Information:
MySQL Version: MySQL 4.1.9-nt-log via TCP/IP
OS: Windows 2003 Server

Any one got any clues or ideas?

Thanks,

Mark Smith
Staff Consultant
Keynote Systems

From the binary log (Master)
# at 48081723
#050224 13:41:44 server id 10 log_pos 48081723 Query =
thread_id=3D4624557 exec_time=3D0 error_code=3D0
SET TIMESTAMP=3D1109281304;
Delete from pst_customername.new_thresh_val;
# at 48081796
....
#050224 13:41:44 server id 10 log_pos 48081796 Query =
thread_id=3D4624557 exec_time=3D0 error_code=3D0
SET TIMESTAMP=3D1109281304;
Insert into pst_customername.new_thresh_val (Agent_ID, Slot_ID, =
Page_Seq, Hour_Of_Week, Severity, Total, DNS, Redirect, TCP, SSLFix, =
FirstByte, BPage, Content, Avail, Count, ByteCount) values (10080, =
490259, 0, 0, 0, 626, 7, 0, 145, -1, 162, 281, -1, 100, -1, -1), (10080, =
490259, 0, 0, 1, 1878, 20, 10, 436, -1, 485, 843, -1, 90, -1, -1);
# at 48097118
....
# at 134925422
# at 134925676
#050224 13:43:26 server id 10 log_pos 134925676 Query =
thread_id=3D4624625 exec_time=3D5 error_code=3D0
SET TIMESTAMP=3D1109281406;
Update pst_customername.new_thresh_val a, =
pst_customername.customername_slot b, =
pst_customername.customername_agent c set a.BPage =3D '50' where =
a.Severity =3D '1' and a.Agent_ID =3D c.Agent_ID and a.Slot_ID =3D =
b.Slot_ID and b.Slot_Alias =3D 'Foo';
# at 134925920
# at 134926204
....
# at 134941759
# at 134942013
#050224 13:43:31 server id 10 log_pos 134942013 Query =
thread_id=3D4624625 exec_time=3D4 error_code=3D0
SET TIMESTAMP=3D1109281411;
Update pst_customername.new_thresh_val a, =
pst_customername.customername_slot b, =
pst_customername.customername_agent c set a.BPage =3D '100' where =
a.Severity =3D '2' and a.Agent_ID =3D c.Agent_ID and a.Slot_ID =3D =
b.Slot_ID and b.Slot_Alias =3D 'Foo';
# at 134942258

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org