bug #202

"Deadlock found when trying to get lock; try restarting transaction)" (InnoDB)

Added by Samuel Verschelde over 1 year ago. Updated over 1 year ago.

Status:New Start date:11/04/2011
Priority:Medium Due date:
Assignee:- % Done:

0%
Category:-
Target version:0.3

Description

I got a 500 error while browsing madb:

[Fri Nov 04 11:12:18 2011] [error] [client 82.235.47.188] temporary table not created : "Criteria:\nSQL (may not be complete): SELECT DISTINCT package.ID FROM `package`\nParams: " (SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction), referer: http://demo.madb.org/index.php/rpm/list/distrelease/2/application/0/arch/1/source/0/listtype/updates/page/1

History

#1
Updated by Samuel Verschelde over 1 year ago

We get it sometimes during synchronization with sophie :

--- cooker : x86_64 : non-free-testing (0 RPMs , 0 new) ---
--- cooker : x86_64 : non-free-testing-src (0 RPMs , 0 new) ---
--- cooker : x86_64 : non-free-updates (0 RPMs , 0 new) ---
--- cooker : x86_64 : non-free-updates-src (0 RPMs , 0 new) ---
--- cooker : x86_64 : plf-free-release (0 RPMs , 0 new) ---
--- cooker : x86_64 : plf-free-release-src (184 RPMs , 0 new) ---
--- cooker : x86_64 : plf-non-free-release (0 RPMs , 0 new) ---
--- cooker : x86_64 : plf-non-free-release-src (85 RPMs , 0 new) ---
Total number of retrieved RPMs : 0
Total number of failed RPMs retrievals : 0
Total number of removed RPMs : 0

  Error executing query : "UPDATE package AS package, tmpapplications                                                                                                                       
  SET package.is_application=TRUE                                                                                                                                                           
  WHERE package.name = tmpapplications.name AND package.is_source=FALSE" (SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction)

#2
Updated by Samuel Verschelde over 1 year ago

  • Description updated (diff)

Also available in: Atom PDF