Erreur Transaction (Process ID) was deadlocked on lock resources with another process





04-12-2017, 03:14 PM
Message : #1

Erreur Transaction (Process ID) was deadlocked on lock resources with another process


Sous SQL Server 2008, deux requêtes qui lisent et mettent à jour des tables en même temps provoquent cette erreur :

Msg 1205, Level 13, State 51, Line 123
Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Trouver tous les messages de cet utilisateur
Citer ce message dans une réponse


Articles ou discussions similaires
Erreur SQL Server Common table expression defined but not used
SQL Server 2012 Erreur Lock request time out period exceeded en supprimant des bases
SQL Server 2012 - Erreur Lock request time out period exceeded
Erreur SQL Server The operation Import failed Microsoft.SqlServer.Management.Reg
SQL Server 2012 Erreur Transaction Process ID was deadlocked on lock resources
SQL Server - Current transaction cannot be committed
SQL Server Erreur - The ORDER BY clause is invalid in views inline functions
SQL Server 2008 Erreur SHRINKDATABASE the transaction log for database is full
SQL Server 2012 - Erreur de copie de base Login timeout expired