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 Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
