Author: damien.flament
Description:
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}
)
)
Version: 1.14.x
Severity: normal
OS: Windows Server 2003
Platform: PC