Recreating Deadlocks

08/02/2011 01:22 RoflcopterGoesSoiSoiSoi#1
Hi,

I'm working on fixing the deadlock issue right now. I've received numerous requests for help from...pretty much every private server owner. Today I have some free time and felt like working on it.

1) How can you easily, quickly and 100% accurately reproduce the deadlock every time?
2) What kind of activities/queries cause the deadlock?
3) How much RAM do you have? What's your processor speed?

Please paste some DBCOM deadlock errors in
Code:
code
format.


Thanks!
08/02/2011 01:42 Strean#2
1. If to much player trade at the same time...
2. the smp_update_item_owner and smp_update_item
3. 8GB and Intel Core i7 950 @ 3,06 GHz 3,06 GHz

Code:
2011/08/02 00:34:41 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 251284, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Die Transaktion (Prozess-ID 58) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
2011/08/02 00:46:14 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 255750) : Die Transaktion (Prozess-ID 58) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
I hope its useful for you.

Regards. [DEV]Strean
08/02/2011 20:55 kaderebak#3
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]


1. If to much player trade at the same time...
2. the dbo.item sumon ıd.
3. 4GB and Intel Core i5

HTML Code:
==============================================================================

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

00 Thread name     : IOCP 00
00 job info        : 503
00 job id          : 0
00 counter         : 0
00 execute time    : 59162
01 Thread name     : IOCP 01
01 job info        : 20
01 job id          : 0
01 counter         : 0
01 execute time    : 59162
02 Thread name     : IOCP 03
02 job info        : 503
02 job id          : 0
02 counter         : 0
02 execute time    : 59162
03 Thread name     : IOCP 02
03 job info        : 503
03 job id          : 0
03 counter         : 0
03 execute time    : 59162
04 Thread name     : Scheduler 00
04 job info        : StructMonster
04 job id          : 0
04 counter         : 0
04 execute time    : 59162
05 Thread name     : Scheduler 01
05 job info        : StructNPC
05 job id          : 0
05 counter         : 0
05 execute time    : 59163
06 Thread name     : Scheduler 02
06 job info        : StructMonster
06 job id          : 0
06 counter         : 0
06 execute time    : 59162
07 Thread name     : Scheduler 03
07 job info        : StructMonster
07 job id          : 0
07 counter         : 0
07 execute time    : 59162


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

Program Name : Arcadia
EXE          : C:\Documents and Settings\Administrator\Desktop\game_bin _6.1\CaptainHerlockServer.exe
User         : Administrator
Computer     : FREKANS-M

Program      : 
Exception    : C000000D (Bir hizmet veya işleve geçersiz bir parametre geçildi.
)
Fault Address: 100534EB4 133EB4:77F5405D
Mem Usage    :    1460336KB /    1433416KB

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

Type: StructSummon                               Allocated: [Current:      42]/[Peek Concurrent:      42]/[Total:      44]
Type: StructQuestManager                         Allocated: [Current:      18]/[Peek Concurrent:      18]/[Total:      20]
Type: StructPlayer                               Allocated: [Current:      18]/[Peek Concurrent:      18]/[Total:      20]
Type: GuildInfo                                  Allocated: [Current:       6]/[Peek Concurrent:       6]/[Total:       6]
Type: StructItem                                 Allocated: [Current:    4121]/[Peek Concurrent:    4170]/[Total:    5253]
Type: ItemKeepingInfo                            Allocated: [Current:      47]/[Peek Concurrent:      47]/[Total:      47]
Type: PartyInfo                                  Allocated: [Current:      15]/[Peek Concurrent:      15]/[Total:      15]
Type: StructNPC                                  Allocated: [Current:    3958]/[Peek Concurrent:    3958]/[Total:    3958]
Type: ArRegion                                   Allocated: [Current:  120882]/[Peek Concurrent:  120882]/[Total:  120882]
Type: StructSkill                                Allocated: [Current:    4667]/[Peek Concurrent:    4667]/[Total:    4814]
Type: StructFieldProp                            Allocated: [Current:   44197]/[Peek Concurrent:   44197]/[Total:   44197]
Type: StructPet                                  Allocated: [Current:      14]/[Peek Concurrent:      14]/[Total:      14]
Type: StructQuest                                Allocated: [Current:       4]/[Peek Concurrent:       5]/[Total:      83]
Type: StructSkillProp                            Allocated: [Current:       0]/[Peek Concurrent:       1]/[Total:       1]


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

EAX=3EE7332C  EBX=3AD6FAEC  ECX=55874808  EDX=7C9285EC
ESI=38C50580  EDI=00000041  EBP=3AD6FBE0
DS =3AD60023      ES=39EC0023       FS=003B       GS:0000
CS:EIP=3AD6001B:00534EB4
SS:ESP=7C920023:3AD6F4E4
Flags=00000202


------------------------------------------------------------------------------
    Environment dump
------------------------------------------------------------------------------
app.checksum                        : 00A17223
app.cmdline                         : "C:\Documents and Settings\Administrator\Desktop\game_bin _6.1\CaptainHerlockServer.exe" 
app.filesize                        : 2560000
app.filetime                        : 2011/07/04-02:16:34
app.name                            : game001
auth.connect                        : complete
auth.server_idx                     : 1
auth.server_name                    : Barbaros[PK]
db.c._password                      : 
db.c.account                        : sa
db.c.name                           : Arcadia
db.c.server                         : 83.66.25.86
db.game.ip                          : 83.66.25.86
db.user._password                   : 
db.user.account                     : sa
db.user.name                        : Telecaster
db.user.server                      : 83.66.25.86
db.user.thread_active               : 4
db.user.thread_total                : 4
db.user.work_active                 : 4
db.user.work_pending                : 174
db.user.work_total                  : 8123
engine.ar_time                      : 59167
engine.count_client                 : 13
engine.count_movable                : 95853
engine.count_static                 : 44337
engine.lock                         : 0
engine.region_size                  : 180
engine.scheduler.0.instruction      : 4736
engine.scheduler.0.object           : 111
engine.scheduler.1.instruction      : 4729
engine.scheduler.1.object           : 110
engine.scheduler.2.instruction      : 4725
engine.scheduler.2.object           : 98
engine.scheduler.3.instruction      : 4730
engine.scheduler.3.object           : 112
engine.scheduler.destroy_cnt        : 244
engine.scheduler.destroy_loop       : 4816
engine.scheduler.destroy_pend       : 0
engine.use_region_debug             : 0
engine.wait                         : 0
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                : 1.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                       : 40.000000
game.force_unregister_account_on_kick_fail : 0
game.gold_drop_rate                 : 220.000000
game.ignore_random_damage           : 0
game.item_count                     : 4121
game.item_drop_rate                 : 0.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                   : 1000
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                      : 170
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            : 92024
game.monster_respawn_object_cnt     : 90273
game.monster_respawn_try_cnt        : 91868
game.monster_wandering              : 1
game.no_collision_check             : 1
game.no_skill_cooltime              : 0
game.party_drop_rate                : 0
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.2024.time               : 42884
game.script.2024.trigger            : Run_JobChange_Tutorial( '@10301' , 301 )
game.script.2916.time               : 42807
game.script.2916.trigger            : open_market( 'Creature_card' )
game.script.4104.time               : 48833
game.script.4104.trigger            : open_market( 'crushop_etc' )
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         : 0
game.use_play_point                 : 0
game.use_security                   : 0
game.use_storage_security           : 0
game.user_count                     : 18
io.connection                       : 19
io.ip_address                       : 83.66.25.86
io.port                             : 4514
io.recv_byte                        : 702929
io.recv_count                       : 31839
io.send_byte                        : 4137968
io.send_count                       : 65668
io.use_message_statistics           : 0
iocp.active                         : 2
iocp.bufsize                        : 8192
iocp.dis_count                      : 7
iocp.instruction                    : 59281
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                          : 1240
process.load                        : 6
process.load_kernel                 : 0
process.load_user                   : 100
process.memory                      : 53028
process.memory_peak                 : 492076
process.paged_memory                : 1433400
process.paged_memory_peak           : 1433400
process.start                       : 2011/08/02-21:35:52
process.uptime                      : 9 Minute  51 Second
thread.db.0.proc                    : DB_UpdateItem
thread.db.1.proc                    : DB_UpdateStorageGold
thread.db.2.proc                    : DB_UpdateItem
thread.db.3.proc                    : DB_UpdateItem
thread.iocp.0.proc                  : 5
thread.iocp.1.proc                  : 503
thread.iocp.2.proc                  : 503
thread.iocp.3.proc                  : 503
thread.scheduler.0.proc             : StructMonster
thread.scheduler.1.proc             : StructMonster
thread.scheduler.2.proc             : RespawnObject
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
00534EB4  3AD6FE2C  GameDBManager::DBProc::onProcess+208  d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_gameserver\game\db\gamedbmanager.cpp line 228
0041D3CA  3AD6FF78  XBossWorker::_threadFunc+118    d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_gameserver\xmodule\xbossworker.h line 276
0056AC6C  3AD6FFB0  _callthreadstartex+1B           f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 348
0056AD11  3AD6FFB8  _threadstartex+7F               f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 326
7C824829  3AD6FFEC  GetModuleHandleA+DF           


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

Address   Frame     Function                        SourceFile
00534EB4  3AD6FE2C  GameDBManager::DBProc::onProcess+208  d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_gameserver\game\db\gamedbmanager.cpp line 228
punting on symbol nThreadNum

0041D3CA  3AD6FF78  XBossWorker::_threadFunc+118    d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_gameserver\xmodule\xbossworker.h line 276

0056AC6C  3AD6FFB0  _callthreadstartex+1B           f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 348

0056AD11  3AD6FFB8  _threadstartex+7F               f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 326

7C824829  3AD6FFEC  GetModuleHandleA+DF           



------------------------------------------------------------------------------
    Global Variables
------------------------------------------------------------------------------



------------------------------------------------------------------------------
    Memory Dump
------------------------------------------------------------------------------

Code: 16 bytes starting at (EIP = 00534EB4)
00534EB4: 59 6A 00 6A 01 8D 4D 1C  E8 EB 22 ED FF B8 69 4F  Yj.j..M..."...iO

Stack: 1024 bytes starting at (ESP = 3AD6F4E4)
3AD6F4E0: E0 FB D6 3A B4 4E 53 00  0D 00 00 C0 77 89 57 00  ...:.NS.....w.W.
3AD6F4F0: D4 FB D6 3A 54 FA D6 3A  08 F5 D6 3A D4 FB D6 3A  ...:T..:...:...:
3AD6F500: 53 4D 53 00 E0 FB D6 3A  34 F5 D6 3A 2C A4 56 00  SMS....:4..:,.V.
3AD6F510: 53 4D 53 00 D4 FB D6 3A  00 01 00 00 8C F5 D6 3A  SMS....:.......:
3AD6F520: 33 A1 56 00 08 34 E7 3E  74 73 61 00 D4 FB D6 3A  3.V..4.>tsa....:
3AD6F530: 01 00 00 00 9C F5 D6 3A  7E 79 57 00 D4 FB D6 3A  .......:~yW....:
3AD6F540: 74 73 61 00 53 4D 53 00  00 00 00 00 00 01 00 00  tsa.SMS.........
3AD6F550: 88 34 E7 3E 60 73 61 00  D4 FB D6 3A C0 73 61 00  .4.>`sa....:.sa.
3AD6F560: EC FA D6 3A 00 00 00 00  00 00 00 00 00 00 00 00  ...:............
3AD6F570: 00 00 00 00 60 F5 D6 3A  B4 FB D6 3A 72 77 57 00  ....`..:...:rwW.
3AD6F580: 53 4D 53 00 50 F5 D6 3A  60 73 61 00 B0 F6 D6 3A  SMS.P..:`sa....:
3AD6F590: 10 03 57 00 6C 58 50 04  01 00 00 00 CC F5 D6 3A  ..W.lXP........:
3AD6F5A0: 02 7D 57 00 54 FA D6 3A  D4 FB D6 3A 01 00 00 00  .}W.T..:...:....
3AD6F5B0: 74 73 61 00 00 00 00 00  00 01 00 00 D4 FB D6 3A  tsa............:
3AD6F5C0: 58 F7 D6 3A 74 73 61 00  00 00 00 00 28 F6 D6 3A  X..:tsa.....(..:
3AD6F5D0: 66 80 57 00 54 FA D6 3A  74 F7 D6 3A 58 F7 D6 3A  f.W.T..:t..:X..:
3AD6F5E0: 74 73 61 00 54 94 61 00  00 00 00 00 00 00 00 00  tsa.T.a.........
3AD6F5F0: 63 73 6D E0 FF FF FF 1F  22 05 93 19 28 D9 30 3B  csm....."...(.0;
3AD6F600: 68 16 C0 4B 00 6A 30 3B  54 94 61 00 01 00 00 00  h..K.j0;T.a.....
3AD6F610: 03 00 00 00 01 00 00 00  00 00 00 00 C0 73 61 00  .............sa.
3AD6F620: 00 00 00 00 5C F6 D6 01  5C F6 D6 3A 4B 82 57 00  ....\...\..:K.W.
3AD6F630: 54 FA D6 3A D4 FB D6 3A  74 F7 D6 3A 58 F7 D6 3A  T..:...:t..:X..:
3AD6F640: 74 73 61 00 00 00 00 00  00 00 00 00 00 00 00 00  tsa.............
3AD6F650: 00 00 00 00 00 00 00 00  00 00 00 00 98 F6 D6 3A  ...............:
3AD6F660: 23 A1 56 00 54 FA D6 3A  D4 FB D6 3A 74 F7 D6 3A  #.V.T..:...:t..:
3AD6F670: 58 F7 D6 3A 74 73 61 00  00 00 00 00 00 00 00 00  X..:tsa.........
3AD6F680: 00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00  ................
3AD6F690: 0E 00 00 00 74 73 61 00  BC F6 D6 3A 52 87 92 7C  ....tsa....:R..|
3AD6F6A0: 54 FA D6 3A D4 FB D6 3A  74 F7 D6 3A 58 F7 D6 3A  T..:...:t..:X..:
3AD6F6B0: D4 FB D6 3A 66 87 92 7C  D4 FB D6 3A 64 F7 D6 3A  ...:f..|...:d..:
3AD6F6C0: 23 87 92 7C 54 FA D6 3A  D4 FB D6 3A 74 F7 D6 3A  #..|T..:...:t..:
3AD6F6D0: 58 F7 D6 3A 5D 48 5A 00  00 00 00 00 54 FA D6 3A  X..:]HZ.....T..:
3AD6F6E0: D4 FB D6 3A C2 15 93 7C  54 FA D6 3A D4 FB D6 3A  ...:...|T..:...:
3AD6F6F0: 74 F7 D6 3A 58 F7 D6 3A  5D 48 5A 00 68 2A DC 39  t..:X..:]HZ.h*.9
3AD6F700: 80 05 C5 38 DC FA D6 3A  58 D8 D1 39 60 06 D0 39  ...8...:X..9`..9
3AD6F710: 00 00 00 00 40 CA D1 39  24 F2 22 00 60 D8 D1 39  ....@..9$.".`..9
3AD6F720: 25 F2 23 00 08 08 D0 39  28 30 1B 01 40 F7 D6 3A  %.#....9(0..@..:
3AD6F730: F5 3F 66 77 05 00 00 00  05 00 00 00 50 F7 D6 3A  .?fw........P..:
3AD6F740: A1 40 66 77 44 66 AB 45  01 00 00 00 14 DC D3 39  .@fwDf.E.......9
3AD6F750: 68 F7 D6 3A 40 67 C0 4B  44 66 AB 45 00 00 D7 3A  h..:@g.KDf.E...:
3AD6F760: 98 F5 31 00 44 FA D6 3A  3C 86 92 7C 00 80 D6 3A  ..1.D..:<..|...:
3AD6F770: 74 F7 D6 3A 07 00 01 00  50 06 D0 39 60 D8 D1 39  t..:....P..9`..9
3AD6F780: 90 F5 31 3B 60 06 D0 39  B4 82 D0 39 A8 F7 31 3B  ..1;`..9...9..1;
3AD6F790: F5 61 1D 00 98 F5 31 3B  F6 61 1E 00 00 08 D0 39  .a....1;.a.....9
3AD6F7A0: C0 F7 D6 01 C8 F7 D6 3A  AB 84 98 74 38 22 AB 45  .......:...t8".E
3AD6F7B0: B0 6D 1A 00 B8 82 D0 39  CC F7 D6 3A 00 D0 56 77  .m.....9...:..Vw
3AD6F7C0: 00 00 15 00 00 00 00 00  38 22 AB 45 EC F7 D6 3A  ........8".E...:
3AD6F7D0: 34 41 66 77 84 67 64 77  38 22 AB 45 B8 82 D0 39  4Afw.gdw8".E...9
3AD6F7E0: B4 82 D0 39 38 22 AB 45  20 00 00 00 4F 1E 87 4C  ...98".E ...O..L
3AD6F7F0: 5C B6 D1 39 F2 2B C0 4B  18 81 D0 39 08 81 D0 39  \..9.+.K...9...9
3AD6F800: 00 00 D0 39 3B 00 82 7C  23 00 D0 39 23 00 D6 3A  ...9;..|#..9#..:
3AD6F810: 68 2A DC 39 DC FA D6 3A  80 05 C5 38 EC FA D6 3A  h*.9...:...8...:
3AD6F820: 00 00 00 00 54 FA D6 3A  A4 FA D6 3A E7 BE 80 7C  ....T..:...:...|
3AD6F830: 1B 00 00 00 06 02 00 00  50 FA D6 3A 23 00 D0 39  ........P..:#..9
3AD6F840: 48 F8 D6 3A A1 53 C0 4B  A4 F9 D6 3A 8F 47 C3 4B  H..:.S.K...:.G.K
3AD6F850: 5D 52 C0 4B 28 D9 30 3B  57 0E 04 80 00 00 00 00  ]R.K(.0;W.......
3AD6F860: BC FA D6 3A C0 86 30 3B  57 0E 04 80 00 00 00 00  ...:..0;W.......
3AD6F870: A8 FA D6 3A 00 00 00 00  08 81 D0 39 00 16 C0 4B  ...:.......9...K
3AD6F880: 28 D9 30 3B 28 D9 30 00  00 00 01 00 57 0E 04 80  (.0;(.0.....W...
3AD6F890: 00 00 00 01 8C F9 D6 3A  05 A6 C1 4B 0A 00 D6 3A  .......:...K...:
3AD6F8A0: 00 00 00 00 60 FA D6 3A  71 A6 C1 4B 28 D9 30 3B  ....`..:q..K(.0;
3AD6F8B0: 34 81 D0 39 3C F9 D6 3A  00 00 00 00 58 11 31 3B  4..9<..:....X.1;
3AD6F8C0: BC F9 D6 3A 9A 1D 32 4E  68 16 C0 4B 40 F9 D6 3A  ...:..2Nh..K@..:
3AD6F8D0: 00 F9 D6 3A 66 13 C0 4B  0D 00 00 00 00 00 00 00  ...:f..K........


==============================================================================
08/02/2011 23:58 Uebari#4
There are mostly dead lock issues on SMP_UPDATE_CHARACTER, SMP_UPDATE_ITEM, SMP_UPDATE_ITEM_OWNER, SMP_UPDATE_PET and SMP_UPDATE_SUMMON.

These are the main ones for any server. As I've fixed mine with a few minor tweaks with the procedures themselves, I thought I'd throw in the procedures causing the main issues.
08/03/2011 08:50 N0obsteR#5
Quote:
Originally Posted by Strean View Post
1. If to much player trade at the same time...
2. the smp_update_item_owner and smp_update_item
3. 8GB and Intel Core i7 950 @ 3,06 GHz 3,06 GHz

Code:
2011/08/02 00:34:41 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItemOwner(dbo.smp_update_item_owner: @IN_SID: 251284, @IN_OWNER_ID: 0, @IN_ACCOUNT_ID: 0) : Die Transaktion (Prozess-ID 58) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
2011/08/02 00:46:14 DB COM ERROR(Thread:3, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateItem(dbo.smp_update_item: @IN_SID: 255750) : Die Transaktion (Prozess-ID 58) befand sich auf Sperre Ressourcen aufgrund eines anderen Prozesses in einer Deadlocksituation und wurde als Deadlockopfer ausgewählt. Führen Sie die Transaktion erneut aus.
I hope its useful for you.

Regards. [DEV]Strean
EAh!!!!!!!! and @IN_SID is different
1)dbo.smp_update_item this when you playing
2)and this ...gold whrn you put gold in chest 2kkk +
The problems almost identical
08/03/2011 10:27 RoflcopterGoesSoiSoiSoi#6
@IN_SID is the unique item ID. The issue with warehouse rupees has been fixed for weeks.
08/04/2011 19:05 N0obsteR#7
1) DB COM ERROR (db.smp_update_item)
bag detected, need fix!!!!!!!!!!!1
1)playing, playin and this
2)no specifical action
3)4gb i7, this problem is not in computer