Page MenuHomePhabricator

Deadlock INSERT IGNORE INTO `flaggedtemplates`
Closed, ResolvedPublic

Description

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)


Version: unspecified
Severity: normal

Details

Reference
bz28598

Related Objects

StatusSubtypeAssignedTask
OpenNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Low.Nov 21 2014, 11:31 PM
bzimport set Reference to bz28598.
bzimport added a subscriber: Unknown Object (MLST).

(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?

Last 10 or 15 minutes on ruwiki seen on fenari

How often? Is it failing three times in the MW database.php deadlock loop (which actually causes the user to see an error)?

Was reported on the dberror logs on fenari

It seemed a rather large insert....

(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.

*** Bug 26224 has been marked as a duplicate of this bug. ***