Replication breaks - slave differs from master

[Andreas Stallmann]

Hi!

One single table out of many differs after a while between mysql master and slave. The statement altering the table is:

UPDATE SEQ_GEN SET SEQUENCE_VALUE = SEQUENCE_VALUE + 10 WHERE SEQUENCE_NAME = 'Client_Object_SEQ'

We already checked, that no other process but the replication is altering the slave.

The logs show, that some transactions are completed in a different order on the master and the slave. Still, it’s in no way the obvious reason for the difference between the two hosts.

Any ideas? Any (kind) RTFMs? :-)

Cheers,

Andreas

--
CONET Solutions GmbH
Andreas Stallmann,
Theodor-Heuss-Allee 19, 53773 Hennef
Tel.: [phone], Fax: [phone]
Mobil: [phone]
Internet: http://www.conet.de, mailto: AStallmann@stripped<mailto:[e-mail]>



----------------------------
CONET Solutions GmbH, Theodor-Heuss-Allee 19, 53773 Hennef.
Registergericht/Registration Court: Amtsgericht Siegburg (HRB Nr. 9136)
Geschäftsführer/Managing Director: Anke Höfer

 ----------------------------