Last modified: 2014-09-22 10:10:17 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 T73058, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 71058 - [Regression] Jenkins: SQLite database is often locked causing queries to fail
[Regression] Jenkins: SQLite database is often locked causing queries to fail
Status: NEW
Product: Wikimedia
Classification: Unclassified
Continuous integration (Other open bugs)
wmf-deployment
All All
: High major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-09-19 18:27 UTC by Krinkle
Modified: 2014-09-22 10:10 UTC (History)
3 users (show)

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


Attachments

Description Krinkle 2014-09-19 18:27:26 UTC
https://integration.wikimedia.org/ci/job/mwext-VisualEditor-qunit/11566/

Artifact: mw-debug-www.log

DatabaseBase::query: Writes done: REPLACE INTO objectcache (keyname,value,exptime) VALUES ('X')
SQL ERROR (ignored): database is locked
..


DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR: database is locked
..


MessageBlobStore::insertMessageBlob failed to update DB: exception 'DBQueryError' with message 'A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('en','jquery.ui.button','{}','20140919182152')
Function: MessageBlobStore::insertMessageBlob/single-row
Error: 5 database is locked


DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: REPLACE INTO objectcache (keyname,value,exptime) VALUES ('X')
SQL ERROR (ignored): database is locked
..

SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
SQL ERROR (ignored): database is locked
DatabaseBase::query: Writes done: INSERT OR IGNORE INTO msg_resource (mr_lang,mr_resource,mr_blob,mr_timestamp) VALUES ('X')
...
Comment 1 Antoine "hashar" Musso (WMF) 2014-09-22 10:10:17 UTC
I don't think MediaWiki manages SQLite lock and concurrency at all.

In this case, it seems two different Apache PHP threads are attempting to update the message cache.   For CI purposes, maybe we want to repopulate the message cache in the DB or skip it entirely to use the good old messages PHP files.

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


Navigation
Links