[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-09-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 Sean Pringle sprin...@wikimedia.org changed: What|Removed |Added Status|ASSIGNED|RESOLVED

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-18 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #23 from Sean Pringle sprin...@wikimedia.org --- Right, sorry, s/page_latest/page_random/. Coffee was wearing off. http://www.percona.com/doc/percona-toolkit/2.2/pt-table-sync.html#cmdoption-pt-table-sync--float-precision -- You

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-18 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #24 from MZMcBride b...@mzmcbride.com --- It seems like the cause of this issue has been identified (comment 11) and the issue has been resolved (no further reports of the issue and the relevant DB has been re-synced and re-pooled).

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #19 from Sean Pringle sprin...@wikimedia.org --- db1009 has been synced with the s2 master and returned to the pool. The specific errors identified here (the missing rev ids, page_latest, etc) have been spot-checked and are intact.

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #20 from Bawolff (Brian Wolff) bawolff...@gmail.com --- (In reply to comment #19) One small observation: At least some of the original page_latest differences I observed were due to a difference in FLOAT/DOUBLE precision which

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #21 from Ariel T. Glenn ar...@wikimedia.org --- page_random was different in some of the rows; I guess that's the floating vs double mentioned above. separately, page_latest was different in some rows as well, although not nearly

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 Platonides platoni...@gmail.com changed: What|Removed |Added CC||platoni...@gmail.com

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #12 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 79178 had a related patch set uploaded by Springle: remove db1009 from action while investigating bug 52853 https://gerrit.wikimedia.org/r/79178 -- You are

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #13 from Gerrit Notification Bot gerritad...@wikimedia.org --- Change 79178 merged by Springle: remove db1009 from action while investigating bug 52853 https://gerrit.wikimedia.org/r/79178 -- You are receiving this mail because:

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 p858snake p858sn...@gmail.com changed: What|Removed |Added Status|PATCH_TO_REVIEW |NEW

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 Sean Pringle sprin...@wikimedia.org changed: What|Removed |Added Status|NEW |ASSIGNED ---

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #16 from Sean Pringle sprin...@wikimedia.org --- db1009 `revisions` is missing rev_id's 38674172 - 38674177. Several other tables checksummed (recentchanges, loging, page) also show small numbers of missing rows and/or missing

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #17 from Bawolff (Brian Wolff) bawolff...@gmail.com --- (In reply to comment #16) db1009 `revisions` is missing rev_id's 38674172 - 38674177. Several other tables checksummed (recentchanges, loging, page) also show small numbers

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-15 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #18 from Sean Pringle sprin...@wikimedia.org --- Can confirm some db1009 `page` records have wrong page_latest. -- You are receiving this mail because: You are on the CC list for the bug.

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 Bawolff (Brian Wolff) bawolff...@gmail.com changed: What|Removed |Added Summary|On a voting page on nl-wiki |nlwiki

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 MZMcBride b...@mzmcbride.com changed: What|Removed |Added Priority|Unprioritized |High -- You are

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 Greg Grossmeier g...@wikimedia.org changed: What|Removed |Added CC|

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 Ariel T. Glenn ar...@wikimedia.org changed: What|Removed |Added CC|

[Bug 52853] nlwiki logged in users shown wrong version of page, possible db corruption

2013-08-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52853 --- Comment #11 from Ariel T. Glenn ar...@wikimedia.org --- Note that according to https://wikitech.wikimedia.org/wiki/Server_Admin_Log we had 13:59 paravoid: powercycling db1009, down for 20h, kernel prints BUG: soft lockup on Aug 11,