Re: [Semediawiki-user] help with SMW & lock contention

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Semediawiki-user] help with SMW & lock contention

kghbln
Heiya Mark,

there was one issue in the past relating to db locks [0] which brought
$smwgEnabledDeferredUpdate [1] setting. Perhaps setting this to "false"
is a way out. However, my suggestion here may also be totally out of
scope of your issue in the end.

Also forwarding to the developer list. In the end there is also the
option to create an issue at GitHub.

Cheers Karsten

[0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/214
[1] https://github.com/SemanticMediaWiki/SemanticMediaWiki/pull/1435


Am 01.12.2016 um 18:03 schrieb Mark A. Hershberger:

>
> I'm working with some people on a Windows-hosted wiki that is
> experiencing problems with database lock contention. These problems
> look like they have a basis in SMW.
>
> Essential info:
>
> MW 1.26.2
> SMW 2.3.1
> MySQL 5.6.16
>
> Stack trace from one of these errors is below, but I should note that
> runJobs.php isn't set up to run outside of Web requests. That is going
> to be addressed, but it doesn't seem like this problem would just go
> away once we have a propper queue runner.
>
> Any ideas?
>
> Query:
> UPDATE `smw_object_ids` SET smw_proptable_hash = 'a:4:{s:12:\"smw_fpt_inst\";s:32:\"7d64be00f71203050c0d0c59a1fb8e46\";s:12:\"smw_fpt_mdat\";s:32:\"4e7269fa53d4731baf4a114805230244\";s:12:\"smw_fpt_cdat\";s:32:\"d56a3ead28b78ca64c1833f7ef3cfdef\";s:12:\"smw_fpt_newp\";s:32:\"ff8259d43dfc5a27a4cefdaabbf38760\";}' WHERE smw_id = '3809'
> Function: SMWSql3SmwIds::setPropertyTableHashes
> Error: 1205 Lock wait timeout exceeded; try restarting transaction (CHISD91228)
> Backtrace:
>
> #0 ...\includes\db\Database.php(1076): DatabaseBase->reportQueryError('Lock wait timeo...', 1205, 'UPDATE `smw_ob...', 'SMWSql3SmwIds::...', false)
> #1 ...\includes\db\Database.php(2027): DatabaseBase->query('UPDATE `smw_ob...', 'SMWSql3SmwIds::...')
> #2 ...\extensions\SemanticMediaWiki\src\MediaWiki\Database.php(334): DatabaseBase->update('smw_object_ids', Array, Array, 'SMWSql3SmwIds::...', Array)
> #3 ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_Sql3SmwIds.php(1112): SMW\MediaWiki\Database->update('smw_object_ids', Array, Array, 'SMWSql3SmwIds::...')
> #4 ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3_Writers.php(381): SMWSql3SmwIds->setPropertyTableHashes(3809, Array)
> #5 ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3_Writers.php(256): SMWSQLStore3Writers->writePropertyTableUpdates(3809, Array, Array, Array)
> #6 ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3_Writers.php(149): SMWSQLStore3Writers->doFlatDataUpdate(Object(SMW\SemanticData))
> #7 ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3.php(338): SMWSQLStore3Writers->doDataUpdate(Object(SMW\SemanticData))
> #8 ...\extensions\SemanticMediaWiki\includes\storage\SMW_Store.php(229): SMWSQLStore3->doDataUpdate(Object(SMW\SemanticData))
> #9 ...\extensions\SemanticMediaWiki\includes\StoreUpdater.php(183): SMW\Store->updateData(Object(SMW\SemanticData))
> #10 ...\extensions\SemanticMediaWiki\includes\StoreUpdater.php(125): SMW\StoreUpdater->doRealUpdate(NULL)
> #11 ...\extensions\SemanticMediaWiki\includes\StoreUpdater.php(92): SMW\StoreUpdater->performUpdate()
> #12 ...\extensions\SemanticMediaWiki\includes\ParserData.php(261): SMW\StoreUpdater->doUpdate()
> #13 ...\extensions\SemanticMediaWiki\src\MediaWiki\Hooks\LinksUpdateConstructed.php(62): SMW\ParserData->updateStore()
> #14 ...\extensions\SemanticMediaWiki\src\MediaWiki\Hooks\HookRegistry.php(287): SMW\MediaWiki\Hooks\LinksUpdateConstructed->process()
> #15 [internal function]: SMW\MediaWiki\Hooks\HookRegistry->SMW\MediaWiki\Hooks\{closure}(Object(LinksUpdate))
> #16 ...\includes\Hooks.php(201): call_user_func_array(Object(Closure), Array)
> #17 ...\includes\deferred\LinksUpdate.php(137): Hooks::run('LinksUpdateCons...', Array)
> #18 ...\includes\content\AbstractContent.php(234): LinksUpdate->__construct(Object(Title), Object(ParserOutput), false)
> #19 ...\includes\page\WikiPage.php(2183): AbstractContent->getSecondaryDataUpdates(Object(Title), NULL, false, Object(ParserOutput))
> #20 ...\includes\page\WikiPage.php(1861): WikiPage->doEditUpdates(Object(Revision), Object(User), Array)
> #21 [internal function]: WikiPage->doEditContent(Object(WikitextContent), '', 114, false, Object(User), 'text/x-wiki')
> #22 ...\includes\page\Article.php(2049): call_user_func_array(Array, Array)
> #23 ...\includes\EditPage.php(1957): Article->__call('doEditContent', Array)
> #24 ...\includes\EditPage.php(1957): Article->doEditContent(Object(WikitextContent), '', 114, false, Object(User), 'text/x-wiki')
> #25 ...\includes\EditPage.php(1331): EditPage->internalAttemptSave(Array, true)
> #26 ...\includes\EditPage.php(560): EditPage->attemptSave(Array)
> #27 ...\includes\actions\EditAction.php(58): EditPage->edit()
> #28 ...\includes\actions\SubmitAction.php(40): EditAction->show()
> #29 ...\includes\MediaWiki.php(490): SubmitAction->show()
> #30 ...\includes\MediaWiki.php(287): MediaWiki->performAction(Object(Article), Object(Title))
> #31 ...\includes\MediaWiki.php(714): MediaWiki->performRequest()
> #32 ...\includes\MediaWiki.php(508): MediaWiki->main()
> #33 ...\index.php(41): MediaWiki->run()
> #34 {main}
>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Semediawiki-user] help with SMW & lock contention

James HK
Hi,

> $smwgEnabledDeferredUpdate [1] setting. Perhaps setting this to "false"

The setting should remain true (unless there is a clear reason not do
to so). #214 was an issue long before [0] was introduced.

[0] https://www.semantic-mediawiki.org/wiki/Deferred_updates

Cheers

On 12/2/16, kghbln <[hidden email]> wrote:

> Heiya Mark,
>
> there was one issue in the past relating to db locks [0] which brought
> $smwgEnabledDeferredUpdate [1] setting. Perhaps setting this to "false"
> is a way out. However, my suggestion here may also be totally out of
> scope of your issue in the end.
>
> Also forwarding to the developer list. In the end there is also the
> option to create an issue at GitHub.
>
> Cheers Karsten
>
> [0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/214
> [1] https://github.com/SemanticMediaWiki/SemanticMediaWiki/pull/1435
>
>
> Am 01.12.2016 um 18:03 schrieb Mark A. Hershberger:
>>
>> I'm working with some people on a Windows-hosted wiki that is
>> experiencing problems with database lock contention. These problems
>> look like they have a basis in SMW.
>>
>> Essential info:
>>
>> MW 1.26.2
>> SMW 2.3.1
>> MySQL 5.6.16
>>
>> Stack trace from one of these errors is below, but I should note that
>> runJobs.php isn't set up to run outside of Web requests. That is going
>> to be addressed, but it doesn't seem like this problem would just go
>> away once we have a propper queue runner.
>>
>> Any ideas?
>>
>> Query:
>> UPDATE `smw_object_ids` SET smw_proptable_hash =
>> 'a:4:{s:12:\"smw_fpt_inst\";s:32:\"7d64be00f71203050c0d0c59a1fb8e46\";s:12:\"smw_fpt_mdat\";s:32:\"4e7269fa53d4731baf4a114805230244\";s:12:\"smw_fpt_cdat\";s:32:\"d56a3ead28b78ca64c1833f7ef3cfdef\";s:12:\"smw_fpt_newp\";s:32:\"ff8259d43dfc5a27a4cefdaabbf38760\";}'
>> WHERE smw_id = '3809'
>> Function: SMWSql3SmwIds::setPropertyTableHashes
>> Error: 1205 Lock wait timeout exceeded; try restarting transaction
>> (CHISD91228)
>> Backtrace:
>>
>> #0 ...\includes\db\Database.php(1076):
>> DatabaseBase->reportQueryError('Lock wait timeo...', 1205, 'UPDATE
>> `smw_ob...', 'SMWSql3SmwIds::...', false)
>> #1 ...\includes\db\Database.php(2027): DatabaseBase->query('UPDATE
>> `smw_ob...', 'SMWSql3SmwIds::...')
>> #2 ...\extensions\SemanticMediaWiki\src\MediaWiki\Database.php(334):
>> DatabaseBase->update('smw_object_ids', Array, Array, 'SMWSql3SmwIds::...',
>> Array)
>> #3
>> ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_Sql3SmwIds.php(1112):
>> SMW\MediaWiki\Database->update('smw_object_ids', Array, Array,
>> 'SMWSql3SmwIds::...')
>> #4
>> ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3_Writers.php(381):
>> SMWSql3SmwIds->setPropertyTableHashes(3809, Array)
>> #5
>> ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3_Writers.php(256):
>> SMWSQLStore3Writers->writePropertyTableUpdates(3809, Array, Array, Array)
>>
>> #6
>> ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3_Writers.php(149):
>> SMWSQLStore3Writers->doFlatDataUpdate(Object(SMW\SemanticData))
>> #7
>> ...\extensions\SemanticMediaWiki\includes\storage\SQLStore\SMW_SQLStore3.php(338):
>> SMWSQLStore3Writers->doDataUpdate(Object(SMW\SemanticData))
>> #8 ...\extensions\SemanticMediaWiki\includes\storage\SMW_Store.php(229):
>> SMWSQLStore3->doDataUpdate(Object(SMW\SemanticData))
>> #9 ...\extensions\SemanticMediaWiki\includes\StoreUpdater.php(183):
>> SMW\Store->updateData(Object(SMW\SemanticData))
>> #10 ...\extensions\SemanticMediaWiki\includes\StoreUpdater.php(125):
>> SMW\StoreUpdater->doRealUpdate(NULL)
>> #11 ...\extensions\SemanticMediaWiki\includes\StoreUpdater.php(92):
>> SMW\StoreUpdater->performUpdate()
>> #12 ...\extensions\SemanticMediaWiki\includes\ParserData.php(261):
>> SMW\StoreUpdater->doUpdate()
>> #13
>> ...\extensions\SemanticMediaWiki\src\MediaWiki\Hooks\LinksUpdateConstructed.php(62):
>> SMW\ParserData->updateStore()
>> #14
>> ...\extensions\SemanticMediaWiki\src\MediaWiki\Hooks\HookRegistry.php(287):
>> SMW\MediaWiki\Hooks\LinksUpdateConstructed->process()
>> #15 [internal function]:
>> SMW\MediaWiki\Hooks\HookRegistry->SMW\MediaWiki\Hooks\{closure}(Object(LinksUpdate))
>>
>> #16 ...\includes\Hooks.php(201): call_user_func_array(Object(Closure),
>> Array)
>> #17 ...\includes\deferred\LinksUpdate.php(137):
>> Hooks::run('LinksUpdateCons...', Array)
>> #18 ...\includes\content\AbstractContent.php(234):
>> LinksUpdate->__construct(Object(Title), Object(ParserOutput), false)
>> #19 ...\includes\page\WikiPage.php(2183):
>> AbstractContent->getSecondaryDataUpdates(Object(Title), NULL, false,
>> Object(ParserOutput))
>> #20 ...\includes\page\WikiPage.php(1861):
>> WikiPage->doEditUpdates(Object(Revision), Object(User), Array)
>> #21 [internal function]: WikiPage->doEditContent(Object(WikitextContent),
>> '', 114, false, Object(User), 'text/x-wiki')
>> #22 ...\includes\page\Article.php(2049): call_user_func_array(Array,
>> Array)
>> #23 ...\includes\EditPage.php(1957): Article->__call('doEditContent',
>> Array)
>> #24 ...\includes\EditPage.php(1957):
>> Article->doEditContent(Object(WikitextContent), '', 114, false,
>> Object(User), 'text/x-wiki')
>> #25 ...\includes\EditPage.php(1331): EditPage->internalAttemptSave(Array,
>> true)
>> #26 ...\includes\EditPage.php(560): EditPage->attemptSave(Array)
>> #27 ...\includes\actions\EditAction.php(58): EditPage->edit()
>> #28 ...\includes\actions\SubmitAction.php(40): EditAction->show()
>> #29 ...\includes\MediaWiki.php(490): SubmitAction->show()
>> #30 ...\includes\MediaWiki.php(287):
>> MediaWiki->performAction(Object(Article), Object(Title))
>> #31 ...\includes\MediaWiki.php(714): MediaWiki->performRequest()
>> #32 ...\includes\MediaWiki.php(508): MediaWiki->main()
>> #33 ...\index.php(41): MediaWiki->run()
>> #34 {main}
>>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Semediawiki-devel mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Semediawiki-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Loading...