Last modified: 2008-09-08 08:37:24 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 T17267, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 15267 - internal_api_error_DBQueryError when API action login
internal_api_error_DBQueryError when API action login
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
API (Other open bugs)
1.14.x
PC Windows Server 2003
: Normal normal (vote)
: ---
Assigned To: Roan Kattouw
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-08-22 13:44 UTC by Damien
Modified: 2008-09-08 08:37 UTC (History)
2 users (show)

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


Attachments

Description Damien 2008-08-22 13:44:42 UTC
When I ty to use the MediaWiki Api (simple login action) I get the following error.
I tried to change MySQL parameters.
The same login action works well on Wikipedia.

Tested with :
OS : Windows Server 2003
MediaWiki 1.13 & 1.14svn
Apache 2.2.6 & 2.2.8
PHP 5.2.5 & 5.2.6
MySQL 4.1 & 5.0 (Windows & Linux)
MediaWiki is configured with InnoDB tables
Also tested with a fresh install of MediaWiki

Thanks in advance,

Damien


Array
(
    [error] => Array
        (
            [code] => internal_api_error_DBQueryError
            [info] => Exception Caught: A database error has occurred
Query: DELETE FROM `objectcache` WHERE keyname='mwwiki:messages:en:status'
Function: MediaWikiBagOStuff::_doquery
Error: 1205 Lock wait timeout exceeded; try restarting transaction (localhost)

            [*] => 

#0 D:\MW\includes\db\Database.php(561): Database->reportQueryError('Lock wait timeo...', 1205, 'DELETE FROM `ob...', 'MediaWikiBagOSt...', false)
#1 D:\MW\includes\BagOStuff.php(433): Database->query('DELETE FROM `ob...', 'MediaWikiBagOSt...')
#2 D:\MW\includes\BagOStuff.php(319): MediaWikiBagOStuff->_doquery('DELETE FROM `ob...')
#3 D:\MW\includes\BagOStuff.php(288): SqlBagOStuff->_query('DELETE FROM $0 ...', 'mwwiki:...')
#4 D:\MW\includes\BagOStuff.php(274): SqlBagOStuff->delete('mwwiki:...')
#5 D:\MW\includes\BagOStuff.php(100): SqlBagOStuff->set('mwwiki:...', 'loading', 60)
#6 D:\MW\includes\MessageCache.php(419): BagOStuff->add('mwwiki:...', 'loading', 60)
#7 D:\MW\includes\MessageCache.php(250): MessageCache->saveToCaches(Array, false, 'en')
#8 D:\MW\includes\MessageCache.php(606): MessageCache->load('en')
#9 D:\MW\includes\MessageCache.php(543): MessageCache->getMsgFromNamespace('Double-redirect...', 'en')
#10 [internal function]: MessageCache->get('double-redirect...', true, true)
#11 D:\MW\includes\StubObject.php(58): call_user_func_array(Array, Array)
#12 D:\MW\includes\StubObject.php(76): StubObject->_call('get', Array)
#13 [internal function]: StubObject->__call('get', Array)
#14 D:\MW\includes\GlobalFunctions.php(467): StubObject->get('double-redirect...', true, true)
#15 D:\MW\includes\GlobalFunctions.php(432): wfMsgGetKey('double-redirect...', true, true, true)
#16 D:\MW\includes\GlobalFunctions.php(380): wfMsgReal('double-redirect...', Array, true, true)
#17 D:\MW\includes\User.php(508): wfMsgForContent('double-redirect...')
#18 D:\MW\includes\specials\SpecialUserlogin.php(386): User::isUsableName('ApiBot')
#19 D:\MW\includes\api\ApiLogin.php(100): LoginForm->authenticateUserData()
#20 D:\MW\includes\api\ApiMain.php(386): ApiLogin->execute()
#21 D:\MW\includes\api\ApiMain.php(236): ApiMain->executeAction()
#22 D:\MW\includes\api\ApiMain.php(220): ApiMain->executeActionWithErrorHandling()
#23 D:\MW\api.php(77): ApiMain->execute()
#24 {main}
        )
)
Comment 1 Max Semenik 2008-08-23 04:59:13 UTC
Related to bug 1274 or a dupe of it
Comment 2 Roan Kattouw 2008-08-24 18:43:10 UTC
(In reply to comment #0)
> Error: 1205 Lock wait timeout exceeded; try restarting transaction (localhost)
That error is your database's fault, not MediaWiki's. Try restarting your database server or your web server or retrying the request.
Comment 3 Damien 2008-08-24 19:06:38 UTC
I have tested with MySQL 4.1 and 5 on Linux and Windows servers in a test environment. How can we have locks with only one connexion (used for MediaWiki)?
Comment 4 Roan Kattouw 2008-08-25 19:50:13 UTC
When reopening the bug, please provide a (good) reason. I'll re-close the bug as INVALID since it's not a bug in MediaWiki, but a problem with your environment. The fact that the bug is closed doesn't mean you can't comment on it, so you can still ask for help here, although there are probably better places to get it.
Comment 5 Damien 2008-09-08 08:37:24 UTC
This bug is linked to bug 15460 and is now fixed in MediaWiki 1.13.1.

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


Navigation
Links