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