Last modified: 2011-10-07 01:44:34 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T30598, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 28598 - Deadlock INSERT IGNORE INTO `flaggedtemplates`
Deadlock INSERT IGNORE INTO `flaggedtemplates`
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
FlaggedRevs (Other open bugs)
unspecified
All All
: Low normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
: 26224 (view as bug list)
Depends on:
Blocks: 28599
  Show dependency tree / graph
 
Reported: 2011-04-18 19:59 UTC by Sam Reed (reedy)
Modified: 2011-10-07 01:44 UTC (History)
6 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Sam Reed (reedy) 2011-04-18 19:59:14 UTC 
Deadlock found when trying to get lock; Try restarting transaction (10.0.6.39)  INSERT IGNORE INTO `flaggedtemplates` (ft_rev_id,ft_namespace,ft_title,ft_tmp_rev_id)
Comment 1 Aaron Schulz 2011-04-18 20:13:30 UTC 
(In reply to comment #0)
> Deadlock found when trying to get lock; Try restarting transaction (10.0.6.39) 
> INSERT IGNORE INTO `flaggedtemplates`
> (ft_rev_id,ft_namespace,ft_title,ft_tmp_rev_id)

When?
Comment 2 Aaron Schulz 2011-04-18 20:13:51 UTC 
And how often?
Comment 3 Sam Reed (reedy) 2011-04-18 20:14:07 UTC 
Last 10 or 15 minutes on ruwiki seen on fenari
Comment 4 Aaron Schulz 2011-04-18 20:19:23 UTC 
How often? Is it failing three times in the MW database.php deadlock loop (which actually causes the user to see an error)?
Comment 5 Sam Reed (reedy) 2011-04-18 20:21:29 UTC 
Was reported on the dberror logs on fenari

It seemed a rather large insert....
Comment 6 Aaron Schulz 2011-05-07 10:25:49 UTC 
(In reply to comment #4)
> How often? Is it failing three times in the MW database.php deadlock loop
> (which actually causes the user to see an error)?

Note: these are logged by MW itself, so all errors are user visible.
Comment 7 Aaron Schulz 2011-05-08 22:41:35 UTC 
*** Bug 26224 has been marked as a duplicate of this bug. ***
Comment 8 Aaron Schulz 2011-05-08 22:42:43 UTC 
Tweaks in r87700.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links