Last modified: 2014-06-05 23:03:58 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 28498 - "LinksUpdate::incrTableUpdate". Database returned error "1205: Lock wait timeout exceeded; try restarting transaction" on Commons
"LinksUpdate::incrTableUpdate". Database returned error "1205: Lock wait time...
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
1.17.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: 28499
  Show dependency treegraph
 
Reported: 2011-04-11 18:37 UTC by Sam Reed (reedy)
Modified: 2014-06-05 23:03 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Sam Reed (reedy) 2011-04-11 18:37:44 UTC
"LinksUpdate::incrTableUpdate". Database returned error "1205: Lock wait timeout exceeded; try restarting transaction

Did try and fix this in 485799, but it seemed to cause others issues. Reverted in r85812
Comment 1 Krinkle 2011-04-11 22:19:12 UTC
what "other issues" ?

Both r85799 's CR and r85812 commit message don't say a lot ;-)
Comment 2 Sam Reed (reedy) 2011-04-11 22:38:52 UTC
(In reply to comment #1)
> what "other issues" ?
> 
> Both r85799 's CR and r85812 commit message don't say a lot ;-)

It made the errors occur more frequently for some people
Comment 3 Nemo 2013-02-03 15:58:07 UTC
With <http://wiki.openstreetmap.org/w/index.php?title=Category%3AEn&diff=863065&oldid=863024> I got Database error: 
[...] richiamata dalla funzione "LinksUpdate::incrTableUpdate". Il database ha restituito il seguente errore "1213: Deadlock found when trying to get lock; try restarting transaction (localhost)".
Comment 4 Andre Klapper 2013-02-04 17:26:52 UTC
(In reply to comment #3)
> With
> <http://wiki.openstreetmap.org/w/index.
> php?title=Category%3AEn&diff=863065&oldid=863024>
> I got Database error: 
> [...] richiamata dalla funzione "LinksUpdate::incrTableUpdate". Il database
> ha
> restituito il seguente errore "1213: Deadlock found when trying to get lock;
> try restarting transaction (localhost)".

I only get:
"2 revisions of this difference (863024 and 863065) were not found.
This is usually caused by following an outdated diff link to a page that has been deleted. Details can be found in the deletion log."
Comment 5 Nemo 2013-02-04 17:45:45 UTC
Yes, sorry, the error was on saving and not on displaying, the diff just for the records. Only sysops can see it now.
Comment 6 Aaron Schulz 2014-06-05 22:31:21 UTC
Does this still occur?
Comment 7 Aaron Schulz 2014-06-05 23:03:58 UTC
Seems rare now:

aaron@fluorine:~/mw-log$ zgrep --no-filename Deadlock archive/dberror.log-201405* | grep -P '(?<=\s)[a-zA-Z\\:]+::[\w:]+(\s+\([^)]+\))?(?=\s)' -o | sort | uniq -c | sort -rn -k 1
   1602 RecentChange::save
    762 MessageGroupStats::forItemInternal
    553 LocalFile::recordUpload2
    359 User::saveOptions
    143 MessageGroupStats::clear
     33 Title::invalidateCache
     31 WikiPage::updateCategoryCounts
     31 LocalFileRestoreBatch::execute
     19 SqlDataUpdate::invalidatePages
     11 FRDependencyUpdate::doUpdate
      8 LocalFileMoveBatch::doDBUpdates
      8 LocalFile::lock
      6 WikiPage::pageData
      6 Block::insert
      5 WikiPage::doDeleteArticleReal
      5 GlobalUsage::insertLinks
      5 GlobalUsage::copyLocalImagelinks
      5 Category::refreshCounts
      3 HTMLCacheUpdateJob::invalidateTitles
      3 FRPageConfig::setStabilitySettings
      2 WatchedItem::addWatch
      2 Title::moveToInternal
      2 LinksUpdate::incrTableUpdate
      2 LinksDeletionUpdate::doUpdate
      2 DatabaseMessageIndex::store
      2 Block::updateTimestamp
      1 WikiPage::updateRevisionOn
      1 WikiPage::insertRedirectEntry
      1 WikiPage::commitRollback
      1 WatchedItem::removeWatch
      1 MWDbEchoBackend::createNotification
      1 LinksUpdate::updateLinksTimestamp
      1 FRUserCounters::saveUserParams
      1 FlaggableWikiPage::updateStableVersion
      1 FlaggableWikiPage::updatePendingList
      1 ChangeTags::addTags

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links