On 12/04/13 10:12, Marlen Caemmerer wrote: > Hello, > > On Tue, 9 Apr 2013, Горан Обрадовић wrote: > >> Date: Tue, 9 Apr 2013 23:55:28 >> >> Around 2000 (~0.01%) revisions from replicated srwiki_p database seem >> to be missing on Toolserver. >> >> For example, revision 5242120 exists in database[1], but doesn't exist >> on Toolserver. >> >> Does anybody know the reason for this anomaly? > > This reminds me of a big bug I was not able to track down. > It seems we have database inconsistencies quite soon after we setup > fresh data from WMF db servers.
What kind of inconsistencies? Is it always on the same fields? > This problem occurs even if we only use the replication integrated into > MySQL. > > I wrote to the database gurus at WMF about that some weeks ago but I got > no mail back and I dont know how to resolve this issue. Barring a mysql bug (hopefully unlikely), and given that WMF slaves are -supposedly- unaffected I can only think in a configuration difference which is affecting in the interpretation of the replicated statements. Is toolserver ignoring some tables? I remember a mysql bug where actions on ignored tables corrupted replication (but I thought it was fixed!). _______________________________________________ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette