• All submissions to this site are governed by Second Life Project Contribution Agreement. By submitting patches and other information using this site, you acknowledge that you have read, understood, and agreed to those terms.
Issue Details (XML | Word | Printable)

Key: WEB-1194
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: WorkingOnIt Linden
Reporter: Zai Lynch
Votes: 3
Watchers: 5
Operations

If you were logged in you would be able to see more operations.
3. Second Life Website - WEB

Wiki database error

Created: 29/Jun/09 07:13 AM   Updated: 30/Jun/09 08:06 AM
Return to search
Component/s: wiki.secondlife.com
Affects Version/s: None
Fix Version/s: None

File Attachments: None
Image Attachments:

1. recent_changes.png
(79 kB)
2. WEB-1194.png
(21 kB)

Last Triaged: 29/Jun/09 02:28 PM
Linden Lab Issue ID: DEV-34668


 Description  « Hide
The Wiki is throwing database errors, all edits from yesterday night till today seem to be lost in some kind of rollback (see edit history...), new edits are not saving. Marking this as showstopper until it got some attention. Can downgrade to critical then.

 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 07:54 AM
seems to be fixed. edits restored. whew... thx!

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 08:49 AM
Restored edits are gone again, bug occurs like described... seemed to be only temporarily fixed. reopening

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 08:52 AM
hrm... and fixed again... I will refrain from toggling this between reopened and closed every couple of minutes... will close it in case the wiki stays fixed for at least one day from now on.

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 11:06 AM
One more remark:

I just found out that - for me - the Special:RecentChanges differs, depending on if I'm logged in or not.
Not just the recent changes. Any page differs. When I'm logged in and look at the MediaWiki:Sitenotice, it's gone. When I log out and look at the page, it's there again (keep in mind that you might need to clear cache to see that).

Are there different servers to balance the load? One for people who are logged in and one for people who aren't?
If so, these two seem to be out of sync...


[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 11:57 AM
The problem seemed to be mirror dependent. Should be fixed as of 5 min ago. Could folks check?

[ Permlink | « Hide ]
Gordon Wendt added a comment - 29/Jun/09 12:15 PM
Problem still occuring. I tested this on https://wiki.secondlife.com/wiki/Bug_triage/2009-06-29. The old version of the page only has two triage issues listed and a comment in the log section, the new version has many more (you can't miss the difference) issues listed.

I tried the following after Blue gave the all clear at approximately 12:00pm.

  • Doing a force reload of the page while logged in
  • Doing a force reload of the page after logging out
  • Clearing cache and restarting browser and then attempting to load while logged out
  • Logging in and attempting to load the page.

I did this in Both the Secondlife browser using secondlife Snowglobe 1.0.2 (2451) and Firefox 3.0.11


[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 12:18 PM
One other thing to try when you're having wiki problems: tack "?action=purge" to the end of the URL.

I did this on https://wiki.secondlife.com/wiki/Bug_triage/2009-06-29 , and that seems to have changed things


[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 12:23 PM
ok...we did the equivalent of "?action=purge" for the whole site, since we suspect that while the original problem was fixed, the residual cache corruption may have left the artifacts that like the problem on today's bug triage agenda.

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 12:28 PM
Looks as it were fixed...

[ Permlink | « Hide ]
Gordon Wendt added a comment - 29/Jun/09 01:05 PM
Still doing weird things for me when logged out but that may very well be just residual cache issues that will flush themselves out and everything appears fine when logged in.

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 01:17 PM
How many mirrors are there and does it ensure that I am still on the same mirror after a ?action=purge ?
I'm asking, since it's still occassionally happening when I'm logged off. (I always test the Special:RecentChanges, since it's most obvious there if it works or not). One time, an ?action=purge fixed it. I just tried it again and it didn't... means, it's still not displaying the all changes that happened today. Just 10 of them

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 02:21 PM
definatly still something wrong... (see pic)

[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 02:27 PM
hrm, ok, thanks for the reports Zai and Gordon. Back to the drawing board....

[ Permlink | « Hide ]
Strife Onizuka added a comment - 29/Jun/09 02:31 PM
Yeah, at the very least a dozen changes were lost but for a while a couple hours of changes had gone missing.

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 03:05 PM
guess it's one of the mirrors beeing still out of sync. this is a screen from 5 minutes ago while I was logged off. occasionally checking the recent changes shows either this or the (what I expect to be) full list of updates.

[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 03:21 PM
Strife: what page has changes that are missing? Can you let us know the timing of those problems?

Zai, thanks for the second screenshot. I witnessed that myself but wasn't able to repro.


[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 03:21 PM
Strife: also...a URL for an article where the possible dataloss would be most obvious.

[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 04:12 PM
We tried kicking a few more things which might have had stored cruft. Did that help?

[ Permlink | « Hide ]
Yoz Linden added a comment - 29/Jun/09 04:12 PM
We've restarted all the usual suspects, with the aim of clearing out any leftover caches that may be causing this problem. If you still see any bugs, please yell!

[ Permlink | « Hide ]
Rob Linden added a comment - 29/Jun/09 04:52 PM
Marking as fixed. Please reopen if this is still a problem.

[ Permlink | « Hide ]
Zai Lynch added a comment - 29/Jun/09 04:55 PM
looks good to me so far *closing*

[ Permlink | « Hide ]
Gordon Wendt added a comment - 30/Jun/09 08:02 AM - edited
For the most part seems to be fine now at least as far as I can tell.

Not sure if this is more things goofing up or if this should be a new issue but got this when I got a wrong message error logging in today. When I tried again (with the right password this time) I was able to login fine though so not sure how serious this is.

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Space required after the Public Identifier in Entity, line: 1 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/SLAuth.php on line 107

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: SystemLiteral " or ' expected in Entity, line: 1 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/SLAuth.php on line 107

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: SYSTEM or PUBLIC, the URI is missing in Entity, line: 1 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/SLAuth.php on line 107

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Entity 'nbsp' not defined in Entity, line: 8 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/SLAuth.php on line 107

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: hr line 10 and body in Entity, line: 12 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/SLAuth.php on line 107

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: body line 4 and html in Entity, line: 12 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/SLAuth.php on line 107

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Premature end of data in tag html line 2 in Entity, line: 13 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/SLAuth.php on line 107

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Space required after the Public Identifier in Entity, line: 1 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/llsd-dom.php on line 10

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: SystemLiteral " or ' expected in Entity, line: 1 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/llsd-dom.php on line 10

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: SYSTEM or PUBLIC, the URI is missing in Entity, line: 1 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/llsd-dom.php on line 10

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Entity 'nbsp' not defined in Entity, line: 8 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/llsd-dom.php on line 10

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: hr line 10 and body in Entity, line: 12 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/llsd-dom.php on line 10

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: body line 4 and html in Entity, line: 12 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/llsd-dom.php on line 10

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Premature end of data in tag html line 2 in Entity, line: 13 in /shared/mediawiki_prod/wiki.secondlife.com/w/extensions/llsd-dom.php on line 10
Powered by Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators