Last modified: 2013-05-22 17:29:21 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T46247, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 44247 - Special:Notifications displays SQL error when database is read-only
Special:Notifications displays SQL error when database is read-only
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
Echo (Other open bugs)
master
All All
: Low normal (vote)
: ---
Assigned To: bsitu
https://www.mediawiki.org/wiki/Specia...
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-01-22 17:52 UTC by Siebrand Mazeland
Modified: 2013-05-22 17:29 UTC (History)
5 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Siebrand Mazeland 2013-01-22 17:52:26 UTC
URL displayed this just now:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "EchoNotificationController::markRead". Database returned error "1290: The MySQL server is running with the --read-only option so it cannot execute this statement (10.64.16.8)".

The edit page[1] was apparently up to speed with the database being read-only. It displays:

Warning: The database has been locked for maintenance, so you will not be able to save your edits right now. You may wish to cut-n-paste the text into a text file and save it for later. 

[1] https://www.mediawiki.org/wiki/User:Siebrand?action=edit&uselang=en

Expected behaviour:
* No write actions should be allowed while database is in read-only mode.
Comment 1 Alex Monk 2013-01-22 17:58:36 UTC
What are we supposed to do in this situation? Just silently not mark notifications as read?
Comment 2 Siebrand Mazeland 2013-01-22 18:03:59 UTC
(In reply to comment #1)
> What are we supposed to do in this situation? Just silently not mark
> notifications as read?

That seems to be the only possible course of action. Displaying and not marking as read is much better than not displaying and throwing a SQL error :).
Comment 3 bsitu 2013-01-22 21:14:01 UTC
It sounds to me this is something that should be handled in core.  Errors resulting from read-only mode should receive special treatment and there should be a system-wide notice about database being locked for maintenance
Comment 4 Gerrit Notification Bot 2013-05-08 21:26:35 UTC
Related URL: https://gerrit.wikimedia.org/r/62922 (Gerrit Change I2e41cef0b5952c43cbba3374ac4da431b81c18ba)
Comment 5 Gerrit Notification Bot 2013-05-14 21:16:34 UTC
https://gerrit.wikimedia.org/r/62922 (Gerrit Change I2e41cef0b5952c43cbba3374ac4da431b81c18ba) | change APPROVED and MERGED [by jenkins-bot]

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links