Tag Info

New answers tagged

1

Uh oh - bad news. There's a known deadlocks by-design issue with MERGE: https://connect.microsoft.com/SQLServer/feedback/details/723696/basic-merge-upsert-causing-deadlocks And just generally, I'd avoid MERGE in general due to the problems documented by Aaron Bertrand: ...


1

the deadlock message sometimes will not show the full picture. It could be some other query is holding the lock which is not any of those two showed in the log. As you said, you have delete query in the beginning, that properly would be the case. Here is a way I normally use to troubleshoot the deadlocks when you can not get all the info from the log. ...


0

[Solved] How to fix: 'inventoryitems', 'CREATE TABLE `inventoryitems` ( `inventoryitemid` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(3) unsigned NOT NULL, `characterid` int(11) DEFAULT NULL, `accountid` int(11) DEFAULT NULL, `itemid` int(11) NOT NULL DEFAULT '0', `inventorytype` int(11) NOT NULL DEFAULT '0', `position` int(11) ...


1

The system is starting to complain about the number of comments. I'd be interested in seeing the statements as they are sent to the server - i.e. the fully generated SQL statements, i.e. with real values, not ? parameter place holders. The statement that appears to be causing the issue is this one. INSERT INTO `inventoryitems` VALUES (DEFAULT, 4, '595', ...



Top 50 recent answers are included