| hoo updated the task description. (Show Details) |
CHANGES TO TASK DESCRIPTION
Getting errors like:
```
Nov 28 19:11:39 mw1191: [Mon Nov 28 19:11:39 2016] [hphp] [4640:7f5bfd3ff700:132019:000001] [] \n```Apr 8 09:02:17 mw1342: #012Warning: [data-update-failed]: A data update callback triggered an exception (A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? \n#012Query: DELETE FROM `wb_terms` WHERE term_language = 'zh-hans''en' AND term_type = 'label' AND term_text = '\xe6\xa8\xa1\xe6\x9d\xbf:Country data Saxony' AND term_entity_id = '25722070' AND term_entity_type = 'item'\nFunction: Wikibase\\TermSqlIndex::deleteTerms\nAnalyzing Cancer Disparities: A New Policy Landscape Calls for New Approaches to Research.' AND term_full_entity_id = 'Q35898854'#012Function: Wikibase\Lib\Store\Sql\TermSqlIndex::deleteTerms#012Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.16.144)\n48.26)#012) [Called from Wikibase\\Updates\Repo\Content\DataUpdateAdapter::doUpdate in /srv/mediawiki/php-1.2931.0-wmf.3/extensions/Wikidata28/extensions/Wikibase/repo/includes/updatesContent/DataUpdateAdapter.php at line 7367] in /srv/mediawiki/php-1.2931.0-wmf.328/includes/debug/MWDebug.php on line 31109
```
```
Nov 28 19:11:39 mw1191: [Mon Nov 28 19:11:39 2016] [hphp] [4640:7f5bfd3ff700:132019:000001] [] \n```Apr 8 09:02:17 mw1342: #012Warning: [data-update-failed]: A data update callback triggered an exception (A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? \n#012Query: DELETE FROM `wb_terms` WHERE term_language = 'zh-hans''en' AND term_type = 'label' AND term_text = '\xe6\xa8\xa1\xe6\x9d\xbf:Country data Saxony' AND term_entity_id = '25722070' AND term_entity_type = 'item'\nFunction: Wikibase\\TermSqlIndex::deleteTerms\nAnalyzing Cancer Disparities: A New Policy Landscape Calls for New Approaches to Research.' AND term_full_entity_id = 'Q35898854'#012Function: Wikibase\Lib\Store\Sql\TermSqlIndex::deleteTerms#012Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.16.144)\n48.26)#012) [Called from Wikibase\\Updates\Repo\Content\DataUpdateAdapter::doUpdate in /srv/mediawiki/php-1.2931.0-wmf.3/extensions/Wikidata28/extensions/Wikibase/repo/includes/updatesContent/DataUpdateAdapter.php at line 7367] in /srv/mediawiki/php-1.2931.0-wmf.328/includes/debug/MWDebug.php on line 31109
```
...
This could probably be solved or at least severely eased by collecting primary keys first (maybe even from a replica) and later on deleting by PK (in `TermSqlIndex::deleteTerms` and `TermSqlIndex::deleteTermsOfEntity`)TASK DETAIL
EMAIL PREFERENCES
To: hoo
Cc: Aklapper, hoo, Lahi, Gq86, GoranSMilovanovic, Soteriaspace, Jayprakash12345, JakeTheDeveloper, QZanden, LawExplorer, Wikidata-bugs, aude, TheDJ, Mbch331, Jay8g, Krenair
Cc: Aklapper, hoo, Lahi, Gq86, GoranSMilovanovic, Soteriaspace, Jayprakash12345, JakeTheDeveloper, QZanden, LawExplorer, Wikidata-bugs, aude, TheDJ, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
