|
You last visited: Today at 10:10
Advertisement
Recreating Deadlocks
Discussion on Recreating Deadlocks within the Rappelz forum part of the MMORPGs category.
08/02/2011, 01:22
|
#1
|
elite*gold: 0 
Join Date: Dec 2010
Posts: 663
Received Thanks: 191
|
Recreating Deadlocks
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
format.
Thanks!
|
|
|
|
08/02/2011, 01:42
|
#2
|
elite*gold: 141
Join Date: Dec 2009
Posts: 554
Received Thanks: 3,920
|
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
|
#3
|
elite*gold: 0
Join Date: Feb 2010
Posts: 210
Received Thanks: 117
|
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 [email protected]$.".`..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 [email protected]
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
|
#4
|
elite*gold: 0
Join Date: Jul 2011
Posts: 81
Received Thanks: 17
|
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
|
#5
|
elite*gold: 0
Join Date: Jul 2011
Posts: 13
Received Thanks: 0
|
Quote:
Originally Posted by Strean
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
|
#6
|
elite*gold: 0
Join Date: Dec 2010
Posts: 663
Received Thanks: 191
|
@IN_SID is the unique item ID. The issue with warehouse rupees has been fixed for weeks.
|
|
|
|
|
08/04/2011, 19:05
|
#7
|
elite*gold: 0
Join Date: Jul 2011
Posts: 13
Received Thanks: 0
|
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
|
|
|
|
Similar Threads
|
Steed walking... and deadlocks.
02/05/2011 - CO2 Private Server - 10 Replies
Has anyone found out how steed walking works?
If so please let me know. I simply can't find out.
For those who have C# sources and have thread/memory usage problems...
Use profilers to see what's your problem...
For big amounts of threads, if you are not using a thread for a player, your problem might be deadlocks. Lately I had about 600 threads at the same time and with dotTrace profiler, I found out that most of them were in a deadlock state as there were no function called on...
|
All times are GMT +1. The time now is 10:12.
|
|
