Page MenuHomePhabricator
Create Task
Maniphest T30499

[DO NOT USE] 1205: Lock wait timeout exceeded; try restarting transaction (tracking)
Closed, InvalidPublic
Actions

Description

Note that this tracking task has not been used for years and does not solve any purpose these days apart from categorizing for the sake of categorizing. Thus it is closed as INVALID.

Details

Reference
bz28499

Related Objects
Search...

StatusSubtypeAssignedTask
 InvalidNoneT30499 [DO NOT USE] 1205: Lock wait timeout exceeded; try restarting transaction (tracking)
 ResolvedNoneT22468 User::invalidateCache throws 1205: Lock wait timeout exceeded
 ResolvedNoneT15921 deadlocks mass-deleting media files in categories
 ResolvedKrinkleT29639 Transaction timeout when trying to OldLocalFile::upgradeRow()
 ResolvedPRODUCTION ERRORKrinkleT31979 Lock wait timeout exceeded in LinkCache::addLinkObj()
 DeclinedNoneT30485 Block::purgeExpired giving "Lock wait timeout exceeded;"/"Deadlock"
 DeclinedNoneT30498 "LinksUpdate::incrTableUpdate". Database returned error "1205: Lock wait timeout exceeded; try restarting transaction" on Commons
 ResolvedPRODUCTION ERRORKrinkleT30600 Lock wait timeout exceeded in GlobalUsage::insertLinks
 ResolvedaaronT42589 Database "Error: 1213 Deadlock" while running rebuildLocalisationCache.php
 ResolvedNoneT32931 1205: Lock wait timeout exceeded from User::updateNewtalk
 DeclinedNoneT42843 Function: LocalFile::lock: Lock wait timeout exceeded
 DeclinedNoneT33077 "efUpdateCheckUserData". Database returned error "1205: Lock wait timeout exceeded; try restarting transaction".
 ResolvedNoneT42927 Moving files results in broken descriptions and deleted images
 ResolvedNoneT45331 Do not refresh file metadata for huge files on purge, and especially do not do it well holding database locks
 ResolvedNoneT44021 Function: GlobalUsage::insertLinks Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.0.6.41)
 DeclinedPRODUCTION ERRORNoneT54712 WikiPage::updateCategoryCounts causing Lock wait timeout exceeded
 ResolvedNoneT62600 "1205 Lock wait timeout exceeded" in AbuseFilter::checkEmergencyDisable
 DuplicateNoneT74636 "ChangeTags::addTags" Database returned error "1205 Lock wait timeout exceeded; try restarting transaction"
 ResolvedPRODUCTION ERRORaaronT100577 "Lock wait timeout exceeded"
 ResolvedKrinkleT110034 Lock wait timeout exceeded; try restarting transaction in User::addToDatabase()
 ResolvedKrinkleT131191 User::addGroups() gives lock timeouts and deadlocks
 ResolvedPRODUCTION ERRORaaronT199762 WikiPage::updateCategoryCounts causing Lock wait timeout exceeded
 ResolvedPRODUCTION ERRORLadsgroupT185847 Fatal exception DBQueryError "Lock wait timeout exceeded" on Special:Tags
 ResolvedUmherirrenderT120140 Lock wait timeout exceeded (WikiPage::insertRedirectEntry) when renaming pages or otherwise editing/creating redirects
 ResolvedPRODUCTION ERRORaaronT201240 Transaction timeout for LinksUpdate::updateLinksTimestamp (SET page_links_updated)
ResolvedPRODUCTION ERRORaaronT202715 "Lock wait timeout exceeded" when a user edits fast (from User::incEditCountImmediate)
 DuplicatePRODUCTION ERRORNoneT163597 Fatal error "Lock wait timeout exceeded" from WikiPage::insertRedirectEntry when moving a page
 DeclinedPRODUCTION ERRORNoneT130561 FlaggedRevsHooks::autoMarkPatrolled hook from RecentChange::save sometimes failed with "Lock wait timeout exceeded"
 DuplicatePRODUCTION ERRORNoneT204476 Lock wait timeout exceeded from WikiPage::insertOn (Unable to import "Template:IPA_Symbol")
 DuplicatePRODUCTION ERRORNoneT205557 Database "Lock wait timeout exceeded" from HTMLCacheUpdateJob::invalidateTitles
 ResolvedPRODUCTION ERRORNoneT206098 Fatal on Preferences and ApiOptions with "Lock wait timeout exceeded" from User::getInstanceForUpdate
 ResolvedLadsgroupT211849 A particular edit not showing on watchlist
 ResolvedPRODUCTION ERRORNikerabbitT134252 Avoid "Lock wait timeout exceeded" from MessageGroupStats::clear
 ResolvedmatmarexT214963 Database contention due to concurrent requests to ApiOptions

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 21 2014, 11:25 PM
• bzimport added projects: MediaWiki-libs-Rdbms, Tracking-Neverending.
• bzimport set Reference to bz28499.
• bzimport added a subscriber: Unknown Object (MLST).
Reedy created this task.Apr 11 2011, 6:39 PM
Reedy added a comment.Apr 11 2011, 6:47 PM

Domas, making these changes seems to make them happen more frequently elsewhere... :/

• RobLa-WMF added a comment.Apr 25 2011, 11:14 PM

Sam is going to investigate a few days worth of logs and get a better characterization of the problem.

• RobLa-WMF added a comment.May 3 2011, 8:18 PM

Per yesterday's bug triage, we're bumping the tracking issue down to low priority. Only bug 20468 seems to happen with enough frequency to rise to normal priority.

Reedy added a parent task: T100577: "Lock wait timeout exceeded".May 27 2015, 11:25 PM
Reedy removed a parent task: T100577: "Lock wait timeout exceeded".
Reedy added a subtask: T100577: "Lock wait timeout exceeded".
Jdforrester-WMF closed subtask T100577: "Lock wait timeout exceeded" as Resolved.Jun 10 2015, 2:10 AM
Southparkfan added a subtask: T110034: Lock wait timeout exceeded; try restarting transaction in User::addToDatabase().Aug 24 2015, 1:54 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 24 2015, 1:54 PM
Reception123 closed subtask T110034: Lock wait timeout exceeded; try restarting transaction in User::addToDatabase() as Resolved.Aug 26 2015, 3:10 PM
Reception123 reopened subtask T110034: Lock wait timeout exceeded; try restarting transaction in User::addToDatabase() as Open.Aug 26 2015, 3:15 PM
Southparkfan closed subtask T110034: Lock wait timeout exceeded; try restarting transaction in User::addToDatabase() as Resolved.Aug 26 2015, 3:17 PM
Southparkfan reopened subtask T110034: Lock wait timeout exceeded; try restarting transaction in User::addToDatabase() as Open.Mar 14 2016, 2:18 PM
Southparkfan added a subtask: T131191: User::addGroups() gives lock timeouts and deadlocks.Mar 29 2016, 7:45 PM
• RobLa-WMF added a project: Technical-Debt.Mar 29 2016, 9:53 PM
• Phabricator_maintenance removed a parent task: T4007: [DO NOT USE] Tracking bug [superseded by #Tracking].Jul 28 2016, 2:33 AM
Krinkle closed subtask T30600: Lock wait timeout exceeded in GlobalUsage::insertLinks as Resolved.Jul 14 2018, 4:57 AM
Krinkle closed subtask T31979: Lock wait timeout exceeded in LinkCache::addLinkObj() as Resolved.Jul 14 2018, 5:00 AM
Krinkle closed subtask T110034: Lock wait timeout exceeded; try restarting transaction in User::addToDatabase() as Resolved.
Krinkle closed subtask T29639: Transaction timeout when trying to OldLocalFile::upgradeRow() as Resolved.
Krinkle closed subtask T131191: User::addGroups() gives lock timeouts and deadlocks as Resolved.Jul 14 2018, 5:10 AM
Anomie closed subtask T54712: WikiPage::updateCategoryCounts causing Lock wait timeout exceeded as Declined.Jul 17 2018, 1:47 AM
Krinkle added a subtask: T199762: WikiPage::updateCategoryCounts causing Lock wait timeout exceeded.Jul 17 2018, 2:08 AM
Krinkle added a subtask: T185847: Fatal exception DBQueryError "Lock wait timeout exceeded" on Special:Tags.Jul 18 2018, 11:41 PM
Krinkle moved this task from Untriaged to Usage problem on the MediaWiki-libs-Rdbms board.Jul 28 2018, 10:17 PM
aaron closed subtask T199762: WikiPage::updateCategoryCounts causing Lock wait timeout exceeded as Resolved.Jul 30 2018, 3:50 AM
Krinkle added a subtask: T197464: Fatal error when submitting edit and deletion/undeletion on Commons from "Error: 1205 Lock wait timeout exceeded" (WikiPage::lockAndGetLatest).Aug 4 2018, 4:54 PM
Krinkle added a subtask: T120140: Lock wait timeout exceeded (WikiPage::insertRedirectEntry) when renaming pages or otherwise editing/creating redirects.
Krinkle added a subtask: T201240: Transaction timeout for LinksUpdate::updateLinksTimestamp (SET page_links_updated) .
Krinkle closed subtask T201240: Transaction timeout for LinksUpdate::updateLinksTimestamp (SET page_links_updated) as Resolved.Aug 28 2018, 1:43 AM
Krinkle added a subtask: T163597: Fatal error "Lock wait timeout exceeded" from WikiPage::insertRedirectEntry when moving a page.Sep 5 2018, 2:35 AM
Krinkle added a subtask: T130561: FlaggedRevsHooks::autoMarkPatrolled hook from RecentChange::save sometimes failed with "Lock wait timeout exceeded".Sep 6 2018, 1:02 AM
Krinkle closed subtask T130561: FlaggedRevsHooks::autoMarkPatrolled hook from RecentChange::save sometimes failed with "Lock wait timeout exceeded" as Declined.Sep 6 2018, 1:10 AM
jcrespo added a subtask: T204476: Lock wait timeout exceeded from WikiPage::insertOn (Unable to import "Template:IPA_Symbol").Sep 17 2018, 8:46 AM
• Marostegui subscribed.Sep 17 2018, 8:47 AM
Krinkle added a subtask: T206098: Fatal on Preferences and ApiOptions with "Lock wait timeout exceeded" from User::getInstanceForUpdate.Oct 3 2018, 5:22 AM
Ladsgroup closed subtask T185847: Fatal exception DBQueryError "Lock wait timeout exceeded" on Special:Tags as Resolved.Nov 14 2018, 7:17 PM
Tgr added a subtask: T211849: A particular edit not showing on watchlist.Jan 2 2019, 7:27 PM
Tgr closed subtask T211849: A particular edit not showing on watchlist as Resolved.Jan 2 2019, 7:48 PM
jcrespo added a subtask: T134252: Avoid "Lock wait timeout exceeded" from MessageGroupStats::clear.Jan 7 2019, 10:44 AM
Krinkle edited projects, added MediaWiki-General; removed MediaWiki-libs-Rdbms.Feb 9 2019, 11:40 PM
Krinkle updated the task description. (Show Details)
Krinkle removed a subscriber: • wikibugs-l-list.
matmarex closed subtask T214963: Database contention due to concurrent requests to ApiOptions as Resolved.Feb 18 2019, 8:43 PM
matmarex reopened subtask T214963: Database contention due to concurrent requests to ApiOptions as Open.
Jdforrester-WMF closed subtask T214963: Database contention due to concurrent requests to ApiOptions as Resolved.Feb 19 2019, 7:59 AM
aaron closed subtask T42589: Database "Error: 1213 Deadlock" while running rebuildLocalisationCache.php as Resolved.Mar 27 2019, 9:48 PM
Krinkle closed subtask T202715: "Lock wait timeout exceeded" when a user edits fast (from User::incEditCountImmediate) as Resolved.May 20 2020, 5:44 PM
Umherirrender closed subtask T45331: Do not refresh file metadata for huge files on purge, and especially do not do it well holding database locks as Resolved.Nov 27 2021, 5:27 PM
Umherirrender closed subtask T206098: Fatal on Preferences and ApiOptions with "Lock wait timeout exceeded" from User::getInstanceForUpdate as Resolved.Jan 2 2022, 8:01 PM
Umherirrender closed subtask T120140: Lock wait timeout exceeded (WikiPage::insertRedirectEntry) when renaming pages or otherwise editing/creating redirects as Resolved.Apr 20 2022, 6:17 PM
Aklapper closed this task as Invalid.Tue, Apr 2, 3:26 AM

This tracking task has not been used for years and does not solve any purpose these days apart from categorizing for the sake of categorizing.
See https://phabricator.wikimedia.org/maniphest/query/uTjsENgt_nj3/#R for a list of "1205 DB" tasks instead.

Aklapper renamed this task from 1205: Lock wait timeout exceeded; try restarting transaction (tracking) to [DO NOT USE] 1205: Lock wait timeout exceeded; try restarting transaction (tracking).Tue, Apr 2, 3:27 AM
Aklapper updated the task description. (Show Details)
Aklapper removed a subscriber: • RobLa-WMF.
Izno removed a subtask: T197464: Fatal error when submitting edit and deletion/undeletion on Commons from "Error: 1205 Lock wait timeout exceeded" (WikiPage::lockAndGetLatest).Tue, Apr 2, 5:18 AM
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