This is an archived snapshot of W3C's public bugzilla bug tracker, decommissioned in April 2019. Please see the home page for more details.

Bug 19913 - Recurring, hard to diagnose edit consistency problems
Summary: Recurring, hard to diagnose edit consistency problems
Status: NEW
Alias: None
Product: webplatform.org
Classification: Unclassified
Component: infrastructure (show other bugs)
Version: unspecified
Hardware: All All
: P1 normal
Target Milestone: ---
Assignee: Doug Schepers
QA Contact: public-webplatform-bugs list
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-08 22:19 UTC by Alex Komoroske
Modified: 2013-04-27 11:24 UTC (History)
2 users (show)

See Also:


Attachments

Description Alex Komoroske 2012-11-08 22:19:51 UTC
For the past week or two there have been very odd edit consistency problems that are difficult to debug and difficult to reproduce accurately. In sum, though, they make editing templates and forms (and sometimes just normal articles) extremely challenging to do correctly.

I've observed all of the following behavior in the past few weeks:
* Make an edit, it "sticks" (no session loss warning), but the page I'm taken to after editing doesn't show the edit. Refreshing the browser multiple times is sometimes necessary, and sometimes only a hard refresh (Edit > Refresh) will fix it.
* Edits to templates don't show up on pages that use those templates for minutes, even after hard-refreshing the pages that use them
* Changes that have been made, and show up when viewing the page, not appearing in the changelog
* Changes in the changelog being out of order with times that are incorrect, even though the final state of the page is correct. In one case I made an edit, then a few seconds later made a second edit. Minutes later, the changelog was showing that the second edit was made more than four minutes before the first!

This problem happens often. A recent page where oddities were observed: http://docs.webplatform.org/wiki/Template:API_Object_Property

It seems like various backends are seeing an inconsistent picture of the status of the database.
Comment 1 David Kirstein (Frozenice) 2012-11-10 20:55:42 UTC
Another change being out of order:
http://docs.webplatform.org/w/index.php?title=apis/file/MSStream&action=history

The 3 history entries are (timestamps use my timezone):
* 2012-11-10 20:08  "test"            oldid=17138
* 2012-11-10 19:47  "revert of test"  oldid=17139
* 2012-10-05 00:40  "page creation"   oldid= 8871

Very odd. At least the oldid seems be in chronological order. Also the user contribs log [1] shows the same (wrong) order but correctly marks the revert as the top, it might use the oldid to determine that.

I guess it's not a problem of unsynchronized clocks or the db cluster/replication, because MW only uses db1 for writes.


[1] http://docs.webplatform.org/w/index.php?limit=2&title=Special%3AContributions&contribs=user&target=Phistuck&namespace=0&offset=20121110190900
Comment 2 JuleeAtAdobe 2012-12-04 02:50:29 UTC
Reverting this bug's platform to All, as experience happens on all platforms.
Comment 3 David Kirstein (Frozenice) 2013-04-27 11:24:02 UTC
(posting here as this bug hasn't been moved to TBG yet)

Yesterday I noticed that the clocks on the app* servers were indeed out of sync, Ryan fixed this (missing cron).

So although I wrote in my previous comment "I guess it's not a problem of unsynchronized clocks" (I didn't have shell access at that time), this might very well have been the source of the out of order changes.