Page MenuHomePhabricator
Create Task
Maniphest T30599

Deadlock tracking bug (tracking)
Closed, InvalidPublic
Actions

Description

Deadlocks are baaad

Version: unspecified
Severity: normal

Details

Reference
bz28599

Related Objects
Search...

StatusSubtypeAssignedTask
 InvalidNoneT30599 Deadlock tracking bug (tracking)
 DeclinedNoneT18971 Deadlock detection
 ResolvedNoneT15921 deadlocks mass-deleting media files in categories
 DeclinedNoneT19819 Database deadlock on page table page_counter after import
 DeclinedNoneT30485 Block::purgeExpired giving "Lock wait timeout exceeded;"/"Deadlock"
 DeclinedReedyT30543 Article::updateCategoryCounts 1213 Deadlock found when trying to get lock
 DeclinedNoneT25544 deleteBatch.php causes database deadlock
 ResolvedNoneT30598 Deadlock INSERT IGNORE INTO `flaggedtemplates`
 ResolveddanielT44547 TermSqlCache deadlocks
 DeclinedNoneT44685 Remove the label/description uniqueness constraint for items
 ResolvedNoneT38116 Deadlock on user account creation leaves account in bad state
 ResolvedNoneT44798 Wikibase Repo: Deadlock found when trying to get lock in Wikibase\TermSqlCache::saveTermsOfEntity
 ResolvedNoneT41479 Revision::fetchFromConds: Deadlock found when trying to get lock
 InvalidNoneT47882 Deadlock in SiteLinkTable
 ResolvedhooT111535 Wikibase\Repo\Store\SQL\EntityPerPageTable::{closure} creating high number of deadlocks
 ResolvedLadsgroupT95685 Drop wb_entity_per_page table
 Resolved• adrianheineT134873 Make EntityRevisionLookup not rely on entity_per_page
 ResolveddanielT140758 Investigate where wb_entity_per_page table is used and needed
 ResolvedLadsgroupT140876 In SqlEntityInfoBuilder, replace the usage of wb_entity_per_page with using the page and redirect tables
 ResolvedLadsgroupT140877 In PropertyInfoTableBuilder, replace the usage of wb_entity_per_page with using the page and redirect tables
 ResolvedLadsgroupT140890 Drop EntityPerPage service
 ResolvedhooT140888 Re-implement listEntities() in EntityPerPageIdPager (and rename to SqlEntityIdPager)
 ResolvedhooT140891 Factor EntityPerPage::getEntitiesWithoutTerm out into it's own service
 ResolvedhooT147638 Introduce a setting for entity types supported by Special:EntitiesWithoutLabel/ Special:EntitiesWithoutDescription
 ResolvedhooT140892 Factor EntityPerPage::getEntitiesWithoutSitelinks out into it's own service
 DeclinedNoneT114903 Migrate wb_terms to using prefixed entity IDs instead of numeric IDs
 ResolvedLydia_PintscherT159718 Evaluate how to best add a column for full entity ID to wb_terms without affecting wikidata.org users
 ResolvedNoneT159851 Add a column for full entity ID to wb_terms table
 ResolvedWMDE-leszekT168708 Populating full entity column in wb_terms table when running MW update.php should be fast and run only once
 DeclinedNoneT169720 Remove column storing numeric entity ID in wb_terms once it has become redundant
 DeclinedNoneT169721 Remove term_entity_id during database schema update when term_full_entity_id is used instead
 DeclinedNoneT169722 Remove term_entity_id column from wb_terms table when no longer needed on WMF cluster
 ResolvedLadsgroupT188995 Clean up the code base for term_entity_id
 ResolvedaudeT162533 Script for populating term_full_entity_id column in wb_terms table
 ResolvedMarosteguiT162539 Deploy schema change for adding term_full_entity_id column to wb_terms table
 ResolvedLadsgroupT162673 Adjust code reading from wb_terms table to use full entity ID
 ResolvedAndrewT167114 Open view for term_full_entity_id in wb_terms table in labs
 ResolvedLadsgroupT171460 Populate term_full_entity_id on www.wikidata.org
 ResolvedaudeT171461 Populate term_full_entity_id on test.wikidata.org
 ResolvedLadsgroupT167229 Change configuration of Wikidata in production to write term_full_entity_id
 ResolvedLadsgroupT165197 Change configuration of test Wikidata to write term_full_entity_id
 ResolvedLadsgroupT172776 Property labels missing on some items
 ResolvedMarosteguiT177601 Deploy dropping wb_entity_per_page table
 ResolvedAndrewT178661 Drop wb_entity_per_page views in Wiki Replicas
 ResolvedPRODUCTION ERRORAnomieT195397 {{PAGESINCATEGORY}} returns incorrect value on en-wiki Category:Candidates for speedy deletion
 ResolvedPRODUCTION ERRORAddshoreT151789 Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction
 ResolvedPRODUCTION ERRORLucas_Werkmeister_WMDET147981 Deadlock in SiteLinkTable::insertLinks on Item merges
 ResolvedPRODUCTION ERRORLadsgroupT205045 Exception from LinksUpdate: Deadlock found in database query (from Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages)
 ResolvedLadsgroupT213809 Make EntityUsageTable::addUsages batchSize configurable
 ResolvedLadsgroupT215146 Decrease EntityUsageTable addUsage batch size to 300
 ResolvedMichaelT225500 Decrease EntityUsageTable addUsage batch size to 100
 ResolvedLadsgroupT226818 Diff when updating wbc_entity_usage
 ResolvedPRODUCTION ERRORaaronT206283 Failed deferred updates should be queued as jobs if possible (Deadlock from LinksUpdate in WikiPage::updateCategoryCounts)
 ResolvedLadsgroupT234948 New Wikibase deadlocks on Wikidata wiki since 2019-10-08T00:00:02: Wikibase\Lib\Store\Sql\Terms\{closure} Deadlock found when trying to get lock; try restarting transaction
 ResolvedAddshoreT235265 Slow query on SpecialMostLinked creating lag on wikidata slaves
 ResolvedPRODUCTION ERRORTK-999T214035 DBError "Error: 1213 Deadlock found when trying to get lock" on WikiPage::doUpdateRestrictions
 DuplicatePRODUCTION ERRORNoneT236464 Deadlock found when trying to get lock

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 21 2014, 11:31 PM
• bzimport added projects: MediaWiki-libs-Rdbms, Tracking-Neverending.
• bzimport set Reference to bz28599.
• bzimport added a subscriber: Unknown Object (MLST).
Reedy created this task.Apr 18 2011, 8:00 PM
jcrespo added a subtask: T111535: Wikibase\Repo\Store\SQL\EntityPerPageTable::{closure} creating high number of deadlocks.Sep 9 2015, 8:49 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 9 2015, 8:49 AM
Danny_B moved this task from Tag to Should be workboard column instead on the Tracking-Neverending board.Jul 2 2016, 12:36 PM
Quiddity removed a parent task: T4007: [DO NOT USE] Tracking bug [superseded by #Tracking].Jul 14 2016, 3:11 AM
hoo closed subtask T111535: Wikibase\Repo\Store\SQL\EntityPerPageTable::{closure} creating high number of deadlocks as Resolved.Oct 24 2017, 4:03 PM
jcrespo added a subtask: T195397: {{PAGESINCATEGORY}} returns incorrect value on en-wiki Category:Candidates for speedy deletion.Jun 15 2018, 11:33 AM
Anomie closed subtask T195397: {{PAGESINCATEGORY}} returns incorrect value on en-wiki Category:Candidates for speedy deletion as Resolved.Jun 15 2018, 12:13 PM
• Vvjjkkii reopened subtask T195397: {{PAGESINCATEGORY}} returns incorrect value on en-wiki Category:Candidates for speedy deletion as Open.Jul 1 2018, 1:08 AM
• Community_Tech_bot closed subtask T195397: {{PAGESINCATEGORY}} returns incorrect value on en-wiki Category:Candidates for speedy deletion as Resolved.Jul 1 2018, 6:20 AM
Krinkle moved this task from Untriaged to Usage problem on the MediaWiki-libs-Rdbms board.Jul 28 2018, 10:17 PM
Krinkle added a subtask: T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction.Sep 14 2018, 12:11 AM
Krinkle added a subtask: T147981: Deadlock in SiteLinkTable::insertLinks on Item merges.Sep 14 2018, 1:00 AM
Krinkle added a subtask: T205045: Exception from LinksUpdate: Deadlock found in database query (from Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages).Oct 5 2018, 3:09 AM
Krinkle edited projects, added: MediaWiki-General; removed: MediaWiki-libs-Rdbms.Feb 9 2019, 11:40 PM
Addshore changed the status of subtask T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction from Open to Stalled.Jun 22 2019, 10:19 PM
• alaa_wmde closed subtask T205045: Exception from LinksUpdate: Deadlock found in database query (from Wikibase\Client\Usage\Sql\EntityUsageTable::addUsages) as Resolved.Oct 1 2019, 2:52 PM
jcrespo added a subtask: T234948: New Wikibase deadlocks on Wikidata wiki since 2019-10-08T00:00:02: Wikibase\Lib\Store\Sql\Terms\{closure} Deadlock found when trying to get lock; try restarting transaction.Oct 8 2019, 4:00 PM
jcrespo added a subtask: T214035: DBError "Error: 1213 Deadlock found when trying to get lock" on WikiPage::doUpdateRestrictions.Oct 9 2019, 6:44 AM
• alaa_wmde closed subtask T234948: New Wikibase deadlocks on Wikidata wiki since 2019-10-08T00:00:02: Wikibase\Lib\Store\Sql\Terms\{closure} Deadlock found when trying to get lock; try restarting transaction as Resolved.Oct 9 2019, 5:52 PM
• alaa_wmde reopened subtask T234948: New Wikibase deadlocks on Wikidata wiki since 2019-10-08T00:00:02: Wikibase\Lib\Store\Sql\Terms\{closure} Deadlock found when trying to get lock; try restarting transaction as Open.Oct 9 2019, 6:50 PM
Krinkle changed the status of subtask T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction from Stalled to Open.Oct 12 2019, 5:02 AM
jcrespo added a subtask: T236464: Deadlock found when trying to get lock.Oct 25 2019, 9:54 AM
Addshore closed subtask T234948: New Wikibase deadlocks on Wikidata wiki since 2019-10-08T00:00:02: Wikibase\Lib\Store\Sql\Terms\{closure} Deadlock found when trying to get lock; try restarting transaction as Resolved.Nov 5 2019, 1:38 PM
Addshore closed subtask T151789: Wikibase\\TermSqlIndex::deleteTerms: Deadlock found when trying to get lock; try restarting transaction as Resolved.Mar 23 2020, 9:18 AM
Aklapper removed a subscriber: • wikibugs-l-list.Apr 12 2020, 9:55 AM
aaron closed subtask T206283: Failed deferred updates should be queued as jobs if possible (Deadlock from LinksUpdate in WikiPage::updateCategoryCounts) as Resolved.Apr 17 2020, 10:00 AM
Krinkle closed subtask T214035: DBError "Error: 1213 Deadlock found when trying to get lock" on WikiPage::doUpdateRestrictions as Resolved.Jan 28 2021, 5:42 AM
Lucas_Werkmeister_WMDE closed subtask T147981: Deadlock in SiteLinkTable::insertLinks on Item merges as Resolved.Dec 20 2023, 3:34 PM
BPirkle closed subtask T25544: deleteBatch.php causes database deadlock as Declined.Nov 20 2025, 3:49 PM
Pppery closed this task as Invalid.May 13 2026, 8:59 PM
Pppery subscribed.

This tracking task has not been used for seven years. Boldly closing.

Pppery moved this task from Should be workboard column instead to Transition completed / Archived on the Tracking-Neverending board.May 13 2026, 8:59 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits