https://bugzilla.wikimedia.org/show_bug.cgi?id=65263
Bug ID: 65263
Summary: Exceptions when database connection is lost and
automatically reopened with pending transaction idle
callbacks
Product: MediaWiki
Version: 1.23-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 47375
Web browser: ---
Mobile Platform: ---
While attempting to confirm bug 65251, a user performed rapid file uploads in
an attempt to get two versions uploaded within the same second.
In dberror.log, I see numerous entries along the lines of the following that
seem to be related:
Tue May 13 15:25:30 UTC 2014 mw1190 zhwiki Connection lost and
reconnected after 33.725s, query: BEGIN /* DatabaseBase::query
(Revision::fetchFromConds) Liangent-bot */
Which seems to be behind these exceptions that Ori noticed:
2014-05-13 15:51:25 mw1147 zhwiki: [2328423f] /w/api.php?maxlag=0 Exception
from line 927 of
/usr/local/apache/common-local/php-1.24wmf3/includes/db/Database.php:
Transaction idle callbacks still pending.
#0
/usr/local/apache/common-local/php-1.24wmf3/includes/db/DatabaseMysqlBase.php(66):
DatabaseBase->close()
#1
/usr/local/apache/common-local/php-1.24wmf3/includes/db/DatabaseMysqlBase.php(574):
DatabaseMysqlBase->open('10.64.16.13', [REDACTED], [REDACTED], 'zhwiki')
#2 /usr/local/apache/common-local/php-1.24wmf3/includes/db/Database.php(1108):
DatabaseMysqlBase->ping()
#3 /usr/local/apache/common-local/php-1.24wmf3/includes/db/Database.php(1595):
DatabaseBase->query('SELECT 1 FROM...', 'LocalFile::lock')
#4 /usr/local/apache/common-local/php-1.24wmf3/includes/db/Database.php(1306):
DatabaseBase->select('image', '1', Array, 'LocalFile::lock', Array)
#5
/usr/local/apache/common-local/php-1.24wmf3/includes/filerepo/file/LocalFile.php(1851):
DatabaseBase->selectField('image', '1', Array, 'LocalFile::lock', Array)
#6
/usr/local/apache/common-local/php-1.24wmf3/includes/filerepo/file/LocalFile.php(1168):
LocalFile->lock()
#7
/usr/local/apache/common-local/php-1.24wmf3/includes/upload/UploadBase.php(698):
LocalFile->upload('/tmp/php5wruKn', 'UTFComment: oZV...', 'UTFComment: oZV...',
1, Array, false, Object(User))
#8
/usr/local/apache/common-local/php-1.24wmf3/includes/api/ApiUpload.php(637):
UploadBase->performUpload('UTFComment: oZV...', 'UTFComment: oZV...', false,
Object(User))
#9
/usr/local/apache/common-local/php-1.24wmf3/includes/api/ApiUpload.php(144):
ApiUpload->performUpload(Array)
#10
/usr/local/apache/common-local/php-1.24wmf3/includes/api/ApiUpload.php(111):
ApiUpload->getContextResult()
#11 /usr/local/apache/common-local/php-1.24wmf3/includes/api/ApiMain.php(913):
ApiUpload->execute()
#12 /usr/local/apache/common-local/php-1.24wmf3/includes/api/ApiMain.php(363):
ApiMain->executeAction()
#13 /usr/local/apache/common-local/php-1.24wmf3/includes/api/ApiMain.php(334):
ApiMain->executeActionWithErrorHandling()
#14 /usr/local/apache/common-local/php-1.24wmf3/api.php(85):
ApiMain->execute()
#15 /usr/local/apache/common-local/w/api.php(3): require('/usr/local/apac...')
#16 {main}
DatabaseBase->query() appears to have noticed the disconnection, and calls
->ping() to try to reconnect, which tries to reopen the connection, which tries
to close the dead connection, which throws an exception due to the pending
callbacks. What the correct behavior might be in this situation (if throwing an
exception isn't itself right), I have no idea.
I note this seems to be an instance of the problem bug 47375 is generically
asking to be fixed.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
