need help with sql error

~~KeithUrban~~ · 07/22/2011, 19:53

i keep geting
and its crashing our server
Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction

2011/07/22 00:53:06 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 187987, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 01:47:34 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 189706, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 02:29:08 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 189712) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 02:51:33 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 193290, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 03:25:24 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 175672, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 245) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 03:29:02 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 175646, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 245) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 03:33:05 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 195039, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 04:52:23 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 196091, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 245) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:29:53 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 86557, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:38:42 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 197585, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:47:10 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 202200) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:50:26 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 22433) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 15:25:48 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 18086, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 17:00:49 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 20173, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 17:19:43 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 7137) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 17:47:59 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 25117) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 18:43:30 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 36806) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 18:57:14 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 9494) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 19:59:22 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 9996) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 21:33:24 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 32848) : Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 22:21:11 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 39989) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 02:43:50 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 54762) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 03:24:14 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 56746, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:05:53 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 57604, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 30) : Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:09:41 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 58404, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 108) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:24:20 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 33985, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:46:36 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 54664) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 05:00:25 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 29215) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 05:07:38 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 61314) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 05:27:17 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 63192, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 08:06:05 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 36042, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 08:14:49 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 57665) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 08:45:04 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 61321) : Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 12:45:31 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 36816) : Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 13:05:20 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 57147) : Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 13:32:43 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 67279, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

~~KeithUrban~~ · 07/22/2011, 20:16

bump

~~KeithUrban~~ · 07/22/2011, 20:19

2011/07/22 00:53:06 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 187987, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 01:47:34 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 189706, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 02:29:08 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 189712) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 02:51:33 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 193290, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 03:25:24 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 175672, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 245) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 03:29:02 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 175646, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 245) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 03:33:05 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 195039, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 04:52:23 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 196091, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 245) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:29:53 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 86557, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:38:42 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 197585, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:47:10 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 202200) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 11:50:26 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 22433) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 15:25:48 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 18086, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 17:00:49 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 20173, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 17:19:43 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 7137) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 17:47:59 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 25117) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 18:43:30 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 36806) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 18:57:14 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 9494) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 19:59:22 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 9996) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 21:33:24 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 32848) : Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/22 22:21:11 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 39989) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 02:43:50 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 54762) : Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 03:24:14 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 56746, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:05:53 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 57604, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 30) : Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:09:41 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 58404, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 108) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:24:20 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 33985, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 04:46:36 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 54664) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 05:00:25 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 29215) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 05:07:38 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 61314) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 05:27:17 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 63192, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 08:06:05 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 36042, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 08:14:49 DB COM ERROR(Thread:2, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 57665) : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 08:45:04 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 61321) : Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 12:45:31 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 36816) : Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 13:05:20 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 57147) : Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 13:32:43 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 67279, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2011/07/23 14:07:22 DB COM ERROR(Thread:1, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 70654, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 326) : Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

~~KeithUrban~~ · 07/22/2011, 20:19

thats what crashes the server it happens between 5-30 minutes

~~KeithUrban~~ · 07/22/2011, 20:47

i looked up info on the error, and i understand it, but i still have no ideal what is causing it

~~KeithUrban~~ · 07/22/2011, 21:07

anyone help please?

~~KeithUrban~~ · 07/23/2011, 02:40

wow, thanks for wasting my time..

~~KeithUrban~~ · 07/23/2011, 02:48

------------------------------------------------------------------------------
Thread Information
------------------------------------------------------------------------------

00 Thread name : IOCP 01
00 job info : 20
00 job id : 0
00 counter : 0
00 execute time : 67130
01 Thread name : IOCP 00
01 job info : 20
01 job id : 0
01 counter : 0
01 execute time : 67130
02 Thread name : IOCP 03
02 job info : 503
02 job id : 0
02 counter : 0
02 execute time : 67130
03 Thread name : IOCP 02
03 job info : 503
03 job id : 0
03 counter : 0
03 execute time : 67130
04 Thread name : Scheduler 00
04 job info : StructMonster
04 job id : 0
04 counter : 0
04 execute time : 67130
05 Thread name : Scheduler 02
05 job info : StructMonster
05 job id : 0
05 counter : 0
05 execute time : 65880
06 Thread name : Scheduler 01
06 job info : StructMonster
06 job id : 0
06 counter : 0
06 execute time : 67132
07 Thread name : Scheduler 03
07 job info : StructMonster
07 job id : 0
07 counter : 0
07 execute time : 67132

------------------------------------------------------------------------------
Basic Information
------------------------------------------------------------------------------

Program Name : Arcadia
EXE : C:\Users\Rappelz server\Desktop\Everything\Game server\Rappelz-Server\CaptainHerlockServer.exe
User : Rappelz server
Computer : RAPPELZSERVER

Program :
Exception : C000000D (An invalid parameter was passed to a service or function.
)
Fault Address: 10044F424 4E424:760EAE5F
Mem Usage : 1487212KB / 1445576KB

------------------------------------------------------------------------------
Allocation Count Info(by _MEM_USAGE_DEBUG)
------------------------------------------------------------------------------

Type: StructSummon Allocated: [Current: 67]/[Peek Concurrent: 67]/[Total: 68]
Type: StructQuestManager Allocated: [Current: 12]/[Peek Concurrent: 12]/[Total: 13]
Type: StructPlayer Allocated: [Current: 12]/[Peek Concurrent: 12]/[Total: 13]
Type: GuildInfo Allocated: [Current: 14]/[Peek Concurrent: 14]/[Total: 14]
Type: StructItem Allocated: [Current: 1484]/[Peek Concurrent: 1490]/[Total: 1866]
Type: ItemKeepingInfo Allocated: [Current: 4]/[Peek Concurrent: 4]/[Total: 4]
Type: PartyInfo Allocated: [Current: 48]/[Peek Concurrent: 48]/[Total: 48]
Type: StructNPC Allocated: [Current: 3939]/[Peek Concurrent: 3939]/[Total: 3939]
Type: ArRegion Allocated: [Current: 121046]/[Peek Concurrent: 121046]/[Total: 121046]
Type: StructSkill Allocated: [Current: 3860]/[Peek Concurrent: 3861]/[Total: 3888]
Type: StructFieldProp Allocated: [Current: 44197]/[Peek Concurrent: 44197]/[Total: 44197]
Type: StructQuest Allocated: [Current: 1]/[Peek Concurrent: 2]/[Total: 92]
Type: StructPet Allocated: [Current: 7]/[Peek Concurrent: 7]/[Total: 7]

------------------------------------------------------------------------------
x86 Registers
------------------------------------------------------------------------------

EAX=3791113C EBX=0064E4D8 ECX=59AA98E4 EDX=00000000
ESI=00010163 EDI=0064E270 EBP=3B35FAA4
DS =002B ES=002B FS=0053 GS:002B
CS:EIP=5B0023:0044F424
SS:ESP=40002B:3B35FA6C
Flags=00000206

------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
app.checksum : 00A17223
app.cmdline : "C:\Users\Rappelz server\Desktop\Everything\Game server\Rappelz-Server\CaptainHerlockServer.exe"
app.filesize : 2560000
app.filetime : 2011/07/04-02:16:32
app.name : game001
auth.connect : complete
auth.server_idx : 1
auth.server_name : Crimson Tears
db.c._password : 6713865f7823805079e8c6728bc3f8f8
db.c.account : sa
db.c.name : Arcadia
db.c.server : 192.168.2.6
db.game.ip : 192.168.2.6
db.user._password : 6713865f7823805079e8c6728bc3f8f8
db.user.account : sa
db.user.name : Telecaster
db.user.server : 192.168.2.6
db.user.thread_active : 4
db.user.thread_total : 4
db.user.work_active : 4
db.user.work_pending : 396
db.user.work_total : 1273
engine.ar_time : 68018
engine.count_client : 11
engine.count_movable : 95819
engine.count_static : 44250
engine.lock : 2
engine.region_size : 180
engine.scheduler.0.instruction : 6003
engine.scheduler.0.object : 103
engine.scheduler.1.instruction : 6003
engine.scheduler.1.object : 99
engine.scheduler.2.instruction : 6002
engine.scheduler.2.object : 104
engine.scheduler.3.instruction : 5981
engine.scheduler.3.object : 107
engine.scheduler.destroy_cnt : 155
engine.scheduler.destroy_loop : 6082
engine.scheduler.destroy_pend : 1
engine.use_region_debug : 0
engine.wait : 3
game.AdultServer : 0
game.AutoOpenOnly : 0
game.PKServer : 0
game.allowed_special_char :
game.ally_pcbang_bonus_rate : 0.100000
game.ally_pcbang_chaos_bonus_rate : 0.100000
game.apply_stamina_bonus_in_premium_pcbang : 0
game.auction_process_request_min_interval : 100
game.auction_search_request_min_interval : 300
game.bUseLockDelayLogging : 0
game.broadcast_event_item_pickup : 0
game.cash_item_dropable : 0
game.cash_usable_server : 0
game.chaos_drop_rate : 60.000000
game.check_storage_security_always : 1
game.disable_dungeon_raid_siege : 0
game.disable_huntaholic : 0
game.disable_pk_on : 0
game.exp_rate : 50.000000
game.force_unregister_account_on_kick_fail : 0
game.gold_drop_rate : 60.000000
game.ignore_random_damage : 0
game.item_count : 1484
game.item_drop_rate : 30.000000
game.item_hold_time : 180000
game.item_loading : complete
game.limit_adv_chat_count : 1
game.limit_booth_openable_layer_to_zero : 0
game.limit_dungeon_enterable_level : 0
game.limit_field_logout : 0
game.limit_game_time : 0
game.loading : complete
game.local_flag : 1
game.logout_timer : 0
game.map_height : 1000000
game.map_width : 700000
game.max_game_time_limited_age : 17
game.max_healthy_game_time : 1080000
game.max_layer : 256
game.max_level : 300
game.max_storage_item_count : 1000
game.max_tired_game_time : 1800000
game.min_booth_startable_level : 0
game.min_global_chat_usable_level : 0
game.mod : 0.000000
game.monster_drop_respawn : 0
game.monster_pathfinding : 0
game.monster_respawn_cnt : 91914
game.monster_respawn_object_cnt : 90287
game.monster_respawn_try_cnt : 91381
game.monster_wandering : 1
game.no_collision_check : 1
game.no_skill_cooltime : 0
game.party_drop_rate : 30
game.party_exp_rate : 1.000000
game.period_of_security_solution_check : 30000
game.play_point_accumulate_amount : 1
game.play_point_accumulate_term : 60
game.premium_pcbang_bonus_rate : 1.200000
game.premium_pcbang_chaos_bonus_drop_rate : 1.000000
game.premium_pcbang_chaos_bonus_rate : 0.100000
game.premium_pcbang_gold_bonus_drop_rate : 1.000000
game.premium_pcbang_item_bonus_drop_rate : 1.000000
game.premium_pcbang_play_point_bonus_rate : 2.000000
game.pvp_damage_rate_for_player : 0.200000
game.pvp_damage_rate_for_summon : 0.130000
game.restrict_banword_for_booth : 0
game.restrict_special_char : 1
game.script.1336.time : 45132
game.script.1336.trigger : start_quest( 1006, 90301115 )
game.script.2588.time : 62881
game.script.2588.trigger : quest_info( 1007, 3 )
game.script.4532.time : 63458
game.script.4532.trigger : start_quest( 1007, 90301118 )
game.script.4548.time : 35318
game.script.4548.trigger : end_quest( 1005, 2 )
game.security_solution_exceptional_ip :
game.security_solution_response_timeout : 3000
game.security_solution_type : 0
game.server_screenshot_url :

game.skip_loading_attribute : 0
game.speed_unit : 30
game.stamina_bonus_rate : 1.000000
game.tile_size : 42.000000
game.use_auto_jail : 1
game.use_auto_trap : 0
game.use_delete_security : 0
game.use_guild_donation_point : 0
game.use_login_logout_debug : 1
game.use_play_point : 0
game.use_security : 0
game.use_storage_security : 0
game.user_count : 12
io.connection : 18
io.ip_address : 67.255.53.99
io.port : 4514
io.recv_byte : 499781
io.recv_count : 27628
io.send_byte : 2376489
io.send_count : 44649
io.use_message_statistics : 0
iocp.4548.script : Quest_Link_1_1()
iocp.active : 4
iocp.bufsize : 8192
iocp.dis_count : 128
iocp.instruction : 42863
iocp.total : 4
log.chat.working : 0
log.server_name : game001
log.working : 0
memory.item_heap_size : 189696
memory.monster_heap_size : 385200
memory.player_heap_size : 11952
memory.summon_heap_size : 43600
process.id : 4524
process.load : 0
process.load_kernel : 100
process.load_user : 0
process.memory : 1487212
process.memory_peak : 1489672
process.paged_memory : 1445576
process.paged_memory_peak : 1446032
process.start : 2011/07/23-20:18:21
process.uptime : 11 Minute 28 Second
thread.db.0.proc : DB_UpdateItem
thread.db.1.proc : DB_UpdateItem
thread.db.2.proc : DB_UpdateItem
thread.db.3.proc : DB_UpdateItem
thread.iocp.0.proc : 20
thread.iocp.1.proc : 20
thread.iocp.2.proc : 503
thread.iocp.3.proc : 503
thread.scheduler.0.proc : StructMonster
thread.scheduler.1.proc : StructMonster
thread.scheduler.2.proc : StructSummon
thread.scheduler.3.proc : StructMonster

------------------------------------------------------------------------------
Application-specific log
------------------------------------------------------------------------------

PlayerHeapSize : 11952 kb
MonsterHeapSize : 385200 kb
ItemHeapSize : 189696 kb
SummonHeapSize : 43600 kb
PetHeapSize : 4200 kb
SkillHeapSize : 38400 kb
QuestHeapSize : 4800 kb
DBHeapSize : 13042 kb

------------------------------------------------------------------------------
Call Stack (Short)
------------------------------------------------------------------------------

Address Frame Function SourceFile
0044F424 3B35FAA4 0001:0004E424 C:\Users\Rappelz server\Desktop\Everything\Game server\Rappelz-Server\CaptainHerlockServer.exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\struct\structplayer.cpp line 146
0040A0F0 3B35FF48 0001:000090F0 C:\Users\Rappelz server\Desktop\Everything\Game server\Rappelz-Server\CaptainHerlockServer.exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\arcadia\arscheduler.cpp line 388
0056AC6C 3B35FF80 0001:00169C6C C:\Users\Rappelz server\Desktop\Everything\Game server\Rappelz-Server\CaptainHerlockServer.exe f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 348
0056AD11 3B35FF88 0001:00169D11 C:\Users\Rappelz server\Desktop\Everything\Game server\Rappelz-Server\CaptainHerlockServer.exe f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 326
76B433CA 3B35FF94 0001:000033CA C:\Windows\syswow64\kernel32.dll
771E9ED2 3B35FFD4 0001:00029ED2 C:\Windows\SysWOW64\ntdll.dll
771E9EA5 3B35FFEC 0001:00029EA5 C:\Windows\SysWOW64\ntdll.dll

------------------------------------------------------------------------------
Call Stack (Detail)
------------------------------------------------------------------------------

Address Frame Function SourceFile
0044F424 3B35FAA4 0001:0004E424 C:\Users\Rappelz server\Desktop\Everything\Game server\Rappelz-Server\CaptainHerlockServer.exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\struct\structplayer.cpp line 146

~~KeithUrban~~ · 07/23/2011, 08:11

so nobody ha a ideal... jw? speedy? wisp? ncarbon?

ironhammer500 · 07/23/2011, 10:14

Quote:

Originally Posted by RoflcopterGoesSoiSoiSoi

1) this is the result of being cocky and full of yourself
Not like you arnt cocky and full of yourself to eh?
2) lol
3) if you can't fix this yourself, you have any success running a server

Copter if u can fix it just tell him whats wrong and stop being a ****, and hurry up and gtfo! Thought u left.

The deadlock is coz the querys arnt processing quick enough so sql is having to terminate them when they dont respond, which casues the game to crash.

solutions mabe : query cache

or find whay to make them run faster.

~~KeithUrban~~ · 07/23/2011, 15:09

iron, this is for darkness within server,
and rofl, i never once have been cocky and full of my self, go **** your self dicktard

~~ismokedrow~~ · 07/23/2011, 20:38

Keith check your visitor messages Brah. And Iron get off Kales **** dude, why is his actions any of your concern. Quit taking every chance you get to flame Kale and maybe let other big boys (You know the ones who can pull up their huggies) defend themselves.

ironhammer500 · 07/23/2011, 20:44

Quote:

Originally Posted by ismokedrow

Keith check your visitor messages Brah. And Iron get off Kales **** dude, why is his actions any of your concern. Quit taking every chance you get to flame Kale and maybe let other big boys (You know the ones who can pull up their huggies) defend themselves.

Then why are you defending kale and he isnt here defending him self?

@keith ah i see i was helping to work on it to lol but i thought that u was on about a diff server.

~~ismokedrow~~ · 07/23/2011, 20:45

I just figure as long as you wanna bash him on another's behalf, i'm going to make sport off of bashing you in his defense.

ironhammer500 · 07/23/2011, 20:48

Quote:

Originally Posted by ismokedrow

I just figure as long as you wanna bash him on another's behalf, i'm going to make sport off of bashing you in his defense.

But then that contradicts what u just said....and tbh for trolling others he deserves to be flamed.

AND OFF TOPIC! i know i was offtopic so let quit hijacking and get back on topic.

The deadlocks have sorted now anyways keith.