Last modified: 2008-09-08 08:37:24 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} ) )
Related to bug 1274 or a dupe of it
(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.
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)?
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.
This bug is linked to bug 15460 and is now fixed in MediaWiki 1.13.1.