Page MenuHomePhabricator
Create Task
Maniphest T3274

deadlock error on edit save
Closed, DeclinedPublic
Actions

Description

Author: dkesh

Description:
I was editing List of US Supreme Court Cases on en when I got this error:

A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:

SELECT cur_id,cur_namespace,cur_title FROM `cur`,`links` WHERE cur_id=l_to

AND l_from=102337 FOR UPDATE

from within function "LinkCache::preFill". MySQL returned error "1213: Deadlock
found when trying to get lock; Try restarting transaction (10.0.0.1)".

Version: unspecified
Severity: major

Details

Reference
bz1274
TitleReferenceAuthorSource BranchDest Branch
gitlab: Rely on gitlab-runner concurrency for scalingrepos/releng/gitlab-cloud-runner!197dduvallreview/simplify-gitlab-runner-scalingmain
gitlab-runner: Fix poll_timeout configurationrepos/releng/gitlab-cloud-runner!149dduvallreview/fix-poll-timeoutmain
Specify --wait-for-ready global buildctl flagrepos/releng/kokkuri!58dduvallreview/wait-for-ready-part-deuxmain
Update image with a buildctl version that supports --wait-for-readyrepos/releng/kokkuri!57dduvallreview/update-imagemain
buildkitd: Enable CNI for network namespace isolationrepos/releng/gitlab-cloud-runner!128dduvallreview/use-cni-for-network-isolationmain
Specify --wait-for-ready global buildctl flagrepos/releng/kokkuri!55dduvallreview/wait-for-readymain
buildkitd: Adjust resource requests/limits and scaling behaviorrepos/releng/gitlab-cloud-runner!122dduvallreview/adjust-buildkitd-hpa-and-resourcesmain
buildkitd: Fix HPA label selectors by splitting envoy cluster_namerepos/releng/gitlab-cloud-runner!121dduvallreview/fix-buildkit-hpamain
Revert "helm: Change port name to grpc for compat with Istio"repos/releng/buildkit!18dduvallreview/app-protocolwmf/v0.10
buildkitd: Scale based on active incoming TCP connectionsrepos/releng/gitlab-cloud-runner!120dduvallreview/buildkitd-connection-saturation-metricmain
buildkitd: Disable autoscaling until we have a reliable metricrepos/releng/gitlab-cloud-runner!119dduvallreview/disable-buildkitd-autoscalingmain
istio: Install stats monitor and DestinationRule for buildkitdrepos/releng/gitlab-cloud-runner!117dduvallreview/foo-27630main
helm: Change port name to grpc for compat with Istiorepos/releng/buildkit!16dduvallreview/use-grpc-port-namewmf/v0.10
buildkitd: Enable metrics for Istio/Envoy circuit breakersrepos/releng/gitlab-cloud-runner!115dduvallreview/fix-create-load-jobmain
istio: Enable sidecar injection in the gitlab-runner namespacerepos/releng/gitlab-cloud-runner!114dduvallreview/use-istio-sidecar-injectionmain
istio: Install istio service meshrepos/releng/gitlab-cloud-runner!111dduvallreview/istio-service-meshmain
Show related patches Customize query in GitLab

Revisions and Commits

Unknown Object (Diffusion Commit)
Unknown Object (Diffusion Commit)

Event Timeline

• bzimport raised the priority of this task from to High.Nov 21 2014, 8:09 PM
• bzimport added a project: WMF-General-or-Unknown.
• bzimport set Reference to bz1274.
• bzimport added a subscriber: Unknown Object (MLST).
• bzimport created this task.Jan 6 2005, 10:05 PM
• brion added a comment.Jan 29 2005, 7:17 AM
  • Bug 1296 has been marked as a duplicate of this bug. ***
tstarling added a comment.Mar 9 2005, 4:44 AM

This can be fixed at any time by setting $wgDumbLinkUpdates = true. This
elimates any chance of a deadlock on the heavily-updated link table.
Unfortunately (according to JamesDay) that causes the slaves to choke and die. A
strategy of reducing lock time may be a better approach, and a few such tweaks
have been made. Deadlocks should be much less frequent than they once were.

As far as I'm concerned, a friendlier error message allowing the user to
resubmit their edit easily would close this bug.

• brion added a comment.Mar 9 2005, 6:55 AM

Couldn't we restart the transaction automatically in this case, by at some level re-callling a function?

• brion added a comment.Jan 22 2006, 4:21 AM

Restored from flood attack.

• brion added a comment.May 4 2006, 8:12 AM
  • Bug 5824 has been marked as a duplicate of this bug. ***
• brion added a comment.May 9 2006, 12:12 AM
  • Bug 5166 has been marked as a duplicate of this bug. ***
• brion added a comment.May 9 2006, 12:13 AM
  • Bug 5876 has been marked as a duplicate of this bug. ***
• bzimport added a comment.Nov 14 2007, 11:29 AM

a.steffan wrote:

The same error appeared on your mediawiki today.
Mediawiki 1.11.0
Mysql 5.0.22
PHP 5.1.2 (cgi-fcgi)

The error message:

In the function "MediaWikiBagOStuff::_doinsert"
MySQL returned the error "1213: Deadlock found when trying to get lock; try restarting transaction (localhost)"

maiden_taiwan added a comment.Aug 21 2008, 2:05 PM

I got this error today on 1.13.0 on Windows 2003 Server when trying to view a page, not edit it. --~~~~

aaron added a comment.Sep 11 2008, 9:31 PM

(In reply to comment #9)

I got this error today on 1.13.0 on Windows 2003 Server when trying to view a
page, not edit it. --~~~~

These tables don't exist anymore, like the query

• demon added a comment.Dec 16 2008, 2:06 AM

Closing as WORKSFORME. As Aaron said, 'cur' doesn't exist anymore. Nor does this query, or even the method LinkCache::preFill. Any deadlock errors on save would be unrelated to this.

epriestley added a commit: Unknown Object (Diffusion Commit).Mar 4 2015, 8:14 AM
epriestley changed the task status from Declined to Resolved by committing Unknown Object (Diffusion Commit).Mar 4 2015, 8:24 AM
epriestley added a commit: Unknown Object (Diffusion Commit).
• demon changed the task status from Resolved to Declined.Mar 4 2015, 8:39 AM
• demon claimed this task.
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