[W6FDpJPeJIBry9XygC2qvAAAAAA] /iss/index.php/Special:BrowseData/MSS_Database?_single&requestDebug=true Wikimedia\Rdbms\DBUnexpectedError from line 3769 of /opt/htdocs/mediawiki/includes/libs/rdbms/database/Database.php: TemporaryTableManager::queryWithAutoCommit: Expected mass commit of all peer transactions (DBO_TRX set).

Backtrace:

#0 /opt/htdocs/mediawiki/extensions/SemanticDrilldown/includes/TemporaryTableManager.php(31): Wikimedia\Rdbms\Database->commit(string)
#1 /opt/htdocs/mediawiki/extensions/SemanticDrilldown/specials/SD_BrowseData.php(230): TemporaryTableManager->queryWithAutoCommit(string, string)
#2 /opt/htdocs/mediawiki/extensions/SemanticDrilldown/specials/SD_BrowseData.php(1150): SDBrowseDataPage->createTempTable(string, NULL, array, array)
#3 /opt/htdocs/mediawiki/includes/specialpage/QueryPage.php(642): SDBrowseDataPage->getPageHeader()
#4 /opt/htdocs/mediawiki/extensions/SemanticDrilldown/specials/SD_BrowseData.php(129): QueryPage->execute(string)
#5 /opt/htdocs/mediawiki/includes/specialpage/SpecialPage.php(522): SDBrowseData->execute(string)
#6 /opt/htdocs/mediawiki/includes/specialpage/SpecialPageFactory.php(568): SpecialPage->run(string)
#7 /opt/htdocs/mediawiki/includes/MediaWiki.php(288): SpecialPageFactory::executePath(Title, RequestContext)
#8 /opt/htdocs/mediawiki/includes/MediaWiki.php(861): MediaWiki->performRequest()
#9 /opt/htdocs/mediawiki/includes/MediaWiki.php(524): MediaWiki->main()
#10 /opt/htdocs/mediawiki/index.php(42): MediaWiki->run()
#11 {main}

Environment:

MediaWiki 1.31.0 (5cfc9ac)
PHP 7.0.31
MariaDB 5.5.60
SMW 2.5.6 (same error in SMW 3.0.0-alpha (e4b81fd))
SemanticDrilldown REL1_31 branch (2252e92)

Related Objects

Mentioned In: T211819: Special:Drilldown not showing the articles when going in a category
Mentioned Here: T174908: Special:BrowseData causes error on MySQL 5.7 slave
rESDDb4d8b42bf10b: Use DB_MASTER for creating temporary database tables
rESDD2252e92d0e1e: build: Updating mediawiki/mediawiki-codesniffer to 18.0.0
rMW5cfc9accca2c: Bump to 1.31.0 for final release

Event Timeline

Jamesmontalvo3 created this task.Sep 18 2018, 6:52 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 18 2018, 6:52 PM

I think this might be a result of https://gerrit.wikimedia.org/r/#/c/mediawiki/core/+/417477/ updating some transaction related warnings to exceptions. Need to take a look at what's going on there.

In this situation it should be safe to set explicitly the IDatabase::FLUSHING_ALL_PEERS flag since we want to commit any open implicit transaction.

Carchaias subscribed.Oct 19 2018, 10:06 AM

Kghbln merged a task: T205421: Database error.Dec 15 2018, 8:09 PM

Kghbln added subscribers: DSwissK, Morlins.

DSwissK mentioned this in T211819: Special:Drilldown not showing the articles when going in a category.Dec 19 2018, 3:23 PM

DSwissK added a subscriber: Yaron_Koren.

This is linked to T174908 and it probably fixed with recent versions of SemanticDrilldown with b4d8b42 included (current master, future 2.2), isn’t it @TK-999 @Yaron_Koren ?

I assume the problem is fixed, but I haven't tested it...

Closing per last two comments. Please reopen if this is still an issue in recent supported versions - thanks!

Expected mass commit of all peer transactions in TemporaryTableManager::queryWithAutoCommit: Closed, ResolvedPublicActions

Description

Related Objects

Event Timeline

Expected mass commit of all peer transactions in TemporaryTableManager::queryWithAutoCommit:
Closed, ResolvedPublic
Actions