Utilisateur:WinfredGeake28
De Semantic MediaWiki - Sandbox
Refs: https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/4926#issuecomment-2117535184
php rebuildData.php:
... updating 40243 [S: Utilisateur:WinfredGeake28] Wikimedia\Rdbms\DBTransactionStateError from line 1515 of /../w/includes/libs/rdbms/database/Database.php: Cannot execute query from SMW\SQLStore\Rebuilder\Rebuilder::getMaxId while transaction status is ERROR #0 /../w/includes/libs/rdbms/database/Database.php(1234): Wikimedia\Rdbms\Database->assertQueryIsCurrentlyAllowed() #1 /../w/includes/libs/rdbms/database/Database.php(1921): Wikimedia\Rdbms\Database->query() #2 /../w/includes/libs/rdbms/database/Database.php(1760): Wikimedia\Rdbms\Database->select() #3 /../w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->selectField() #4 /../w/includes/libs/rdbms/database/DBConnRef.php(300): Wikimedia\Rdbms\DBConnRef->__call() #5 /../w/extensions/SemanticMediaWiki/src/MediaWiki/Connection/Database.php(641): Wikimedia\Rdbms\DBConnRef->selectField() #6 /../w/extensions/SemanticMediaWiki/src/SQLStore/Rebuilder/Rebuilder.php(176): SMW\MediaWiki\Connection\Database->selectField() #7 /../w/extensions/SemanticMediaWiki/src/Maintenance/DataRebuilder.php(390): SMW\SQLStore\Rebuilder\Rebuilder->getMaxId() #8 /../w/extensions/SemanticMediaWiki/src/Maintenance/DataRebuilder.php(224): SMW\Maintenance\DataRebuilder->rebuildAll() #9 /../w/extensions/SemanticMediaWiki/maintenance/rebuildData.php(198): SMW\Maintenance\DataRebuilder->rebuild() #10 /../w/maintenance/doMaintenance.php(107): SMW\Maintenance\rebuildData->execute() #11 /../w/extensions/SemanticMediaWiki/maintenance/rebuildData.php(294): require_once('/var/www/html/s...') #12 {main}
Wikimedia\Rdbms\DBQueryError from line 1713 of /../w/includes/libs/rdbms/database/Database.php: Error 1690: BIGINT UNSIGNED value is out of range in '`DB9910120150926`.`02100_smw_prop_stats`.`usage_count` - 1' (localhost:5252) Function: SMW\SQLStore\PropertyStatisticsStore::addToUsageCount Query: UPDATE `02100_smw_prop_stats` SET usage_count = usage_count - 1,null_count = null_count - 0 WHERE p_id = 24772 #0 /../w/includes/libs/rdbms/database/Database.php(1337): Wikimedia\Rdbms\Database->getQueryException() #1 /../w/includes/libs/rdbms/database/Database.php(1237): Wikimedia\Rdbms\Database->executeQuery() #2 /../w/includes/libs/rdbms/database/Database.php(2471): Wikimedia\Rdbms\Database->query() #3 /../w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->update() #4 /../w/includes/libs/rdbms/database/DBConnRef.php(375): Wikimedia\Rdbms\DBConnRef->__call() #5 /../w/extensions/SemanticMediaWiki/src/MediaWiki/Connection/Database.php(543): Wikimedia\Rdbms\DBConnRef->update() #6 /../w/extensions/SemanticMediaWiki/src/SQLStore/PropertyStatisticsStore.php(112): SMW\MediaWiki\Connection\Database->update() #7 /../w/extensions/SemanticMediaWiki/src/SQLStore/PropertyStatisticsStore.php(164): SMW\SQLStore\PropertyStatisticsStore->addToUsageCount() #8 /../w/extensions/SemanticMediaWiki/src/SQLStore/PropertyTableUpdater.php(97): SMW\SQLStore\PropertyStatisticsStore->addToUsageCounts() #9 /../w/extensions/SemanticMediaWiki/src/SQLStore/SQLStoreUpdater.php(382): SMW\SQLStore\PropertyTableUpdater->update() #10 /../w/extensions/SemanticMediaWiki/src/SQLStore/SQLStoreUpdater.php(231): SMW\SQLStore\SQLStoreUpdater->doFlatDataUpdate() #11 /../w/extensions/SemanticMediaWiki/src/SQLStore/SQLStore.php(318): SMW\SQLStore\SQLStoreUpdater->doDataUpdate() #12 /../w/extensions/SemanticMediaWiki/src/Elastic/ElasticStore.php(242): SMW\SQLStore\SQLStore->doDataUpdate() #13 /../w/extensions/SemanticMediaWiki/src/Store.php(237): SMW\Elastic\ElasticStore->doDataUpdate() #14 /../w/extensions/SemanticMediaWiki/src/Store.php(274): SMW\Store->updateData() #15 /../w/extensions/SemanticMediaWiki/src/MediaWiki/Jobs/UpdateJob.php(98): SMW\Store->clearData() #16 /../w/extensions/SemanticMediaWiki/src/SQLStore/Rebuilder/Rebuilder.php(247): SMW\MediaWiki\Jobs\UpdateJob->run() #17 /../w/extensions/SemanticMediaWiki/src/Maintenance/DataRebuilder.php(472): SMW\SQLStore\Rebuilder\Rebuilder->rebuild() #18 /../w/extensions/SemanticMediaWiki/src/Maintenance/DataRebuilder.php(385): SMW\Maintenance\DataRebuilder->doUpdateById() #19 /../w/extensions/SemanticMediaWiki/src/Maintenance/DataRebuilder.php(224): SMW\Maintenance\DataRebuilder->rebuildAll() #20 /../w/extensions/SemanticMediaWiki/maintenance/rebuildData.php(198): SMW\Maintenance\DataRebuilder->rebuild() #21 /../w/maintenance/doMaintenance.php(107): SMW\Maintenance\rebuildData->execute() #22 /../w/extensions/SemanticMediaWiki/maintenance/rebuildData.php(294): require_once('/var/www/html/s...') #23 {main}
[291080df3e91ac37a4aeb547] [no req] Wikimedia\Rdbms\DBTransactionError from line 1533 of /../w/includes/libs/rdbms/database/Database.php: Explicit transaction still active. A caller may have caught an error. Open transactions: sql/transaction/update Backtrace: #0 /../w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1645): Wikimedia\Rdbms\Database->assertNoOpenTransactions() #1 /../w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(2153): Wikimedia\Rdbms\LoadBalancer->Wikimedia\Rdbms\{closure}() #2 /../w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1664): Wikimedia\Rdbms\LoadBalancer->forEachOpenMasterConnection() #3 /../w/includes/libs/rdbms/lbfactory/LBFactory.php(247): Wikimedia\Rdbms\LoadBalancer->approveMasterChanges() #4 /../w/includes/libs/rdbms/lbfactory/LBFactorySimple.php(133): Wikimedia\Rdbms\LBFactory->Wikimedia\Rdbms\{closure}() #5 /../w/includes/libs/rdbms/lbfactory/LBFactory.php(249): Wikimedia\Rdbms\LBFactorySimple->forEachLB() #6 /../w/includes/libs/rdbms/lbfactory/LBFactory.php(308): Wikimedia\Rdbms\LBFactory->forEachLBCallMethod() #7 /../w/maintenance/doMaintenance.php(135): Wikimedia\Rdbms\LBFactory->commitMasterChanges() #8 /../w/extensions/SemanticMediaWiki/maintenance/rebuildData.php(294): require_once(string) #9 {main}