Crash server help please

[darckistyle]

Hello, I have a problem, the server crash, I try to find the problem with other DEV, but with no success can you help me?

 Spoiler

================================================== ============================

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

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


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

Program Name : Arcadia
EXE : C:\Shiva server\Database shiva Seraphin\CaptainHerlockServer.exe
User : DefaultAppPool
Computer : SD-34877

Program :
Exception : C000000D (Un paramètre non valide a été passé à un service ou une fonction.
)
Fault Address: 10044F424 4E424:7606AF26
Mem Usage : 1550788KB / 1506672KB

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

Type: StructSummon Allocated: [Current: 275]/[Peek Concurrent: 275]/[Total: 293]
Type: StructQuestManager Allocated: [Current: 43]/[Peek Concurrent: 43]/[Total: 46]
Type: StructPlayer Allocated: [Current: 43]/[Peek Concurrent: 43]/[Total: 46]
Type: GuildInfo Allocated: [Current: 72]/[Peek Concurrent: 72]/[Total: 72]
Type: StructSkill Allocated: [Current: 8538]/[Peek Concurrent: 8538]/[Total: 8828]
Type: StructItem Allocated: [Current: 14005]/[Peek Concurrent: 14005]/[Total: 16206]
Type: AuctionInfo Allocated: [Current: 27]/[Peek Concurrent: 27]/[Total: 27]
Type: ItemKeepingInfo Allocated: [Current: 404]/[Peek Concurrent: 404]/[Total: 404]
Type: PartyInfo Allocated: [Current: 514]/[Peek Concurrent: 514]/[Total: 515]
Type: StructNPC Allocated: [Current: 4819]/[Peek Concurrent: 4819]/[Total: 4819]
Type: ArRegion Allocated: [Current: 124950]/[Peek Concurrent: 124950]/[Total: 124950]
Type: StructFieldProp Allocated: [Current: 44284]/[Peek Concurrent: 44284]/[Total: 44284]
Type: StructPet Allocated: [Current: 35]/[Peek Concurrent: 35]/[Total: 36]
Type: StructQuest Allocated: [Current: 18]/[Peek Concurrent: 18]/[Total: 21]
Type: StructSkillProp Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 2]


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

EAX=88EA7175 EBX=0064E4D8 ECX=55EE2D48 EDX=00000000
ESI=0000F580 EDI=0064E270 EBP=3A02FAA4
DS =002B ES=3A00002B FS=BEC10053 GS:002B
CS:EIP=D40023:0044F424
SS:ESP=002B:3A02FA6C
Flags=00000282


------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
app.checksum : 00A17223
app.cmdline : CaptainHerlockServer.exe
app.filesize : 2560000
app.filetime : 2011/07/04-03:16:34
app.name : game001
auth.connect : complete
auth.server_idx : 1
auth.server_name : Seraphin[FR]
console._password : ***********
console.ip : 127.0.0.1
console.port : 9578
db.c._password :
db.c.account : sa
db.c.name : Arcadia
db.c.server : 127.0.0.1
db.game.ip : 88.XXX.XX.XXX
db.user._password :
db.user.account : sa
db.user.name : Telecaster
db.user.password :
db.user.server : 127.0.0.1
db.user.thread_active : 4
db.user.thread_total : 4
db.user.work_active : 4
db.user.work_pending : 216
db.user.work_total : 11720
engine.ar_time : 67910
engine.count_client : 35
engine.count_movable : 100539
engine.count_static : 44625
engine.lock : 1
engine.region_size : 180
engine.scheduler.0.instruction : 5728
engine.scheduler.0.object : 217
engine.scheduler.1.instruction : 5732
engine.scheduler.1.object : 216
engine.scheduler.2.instruction : 5726
engine.scheduler.2.object : 221
engine.scheduler.3.instruction : 5719
engine.scheduler.3.object : 232
engine.scheduler.destroy_cnt : 375
engine.scheduler.destroy_loop : 5833
engine.scheduler.destroy_pend : 6
engine.use_region_debug : 0
engine.wait : 5
game.AdultServer : 0
game.AutoOpenOnly : 0
game.PKServer : 0
game.UseGameGuard : 0
game.UseHackShield : 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 : 100
game.bUseLockDelayLogging : 0
game.broadcast_event_item_pickup : 0
game.cash_item_dropable : 0
game.cash_usable_server : 1
game.chaos_drop_rate : 250.000000
game.check_storage_security_always : 1
game.disable_dungeon_raid_siege : 0
game.disable_huntaholic : 0
game.disable_huntaholic_timer : 0
game.disable_pk_on : 0
game.exp_rate : 160.000000
game.force_unregister_account_on_kick_fail : 1
game.gold_drop_rate : 20000.000000
game.guild_icon_base_url :
game.huntaholic_timer : 0
game.ignore_random_damage : 0
game.item_count : 14033
game.item_drop_rate : 100.000000
game.item_hold_time : 6000
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 : 1
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 : 190
game.max_storage_item_count : 500
game.max_tired_game_time : 1800000
game.mem_usage_info_save_interval : 60
game.min_booth_startable_level : 0
game.min_global_chat_usable_level : 1
game.mod : 0.000000
game.monster_drop_respawn : 0
game.monster_pathfinding : 0
game.monster_respawn_cnt : 95262
game.monster_respawn_object_cnt : 92810
game.monster_respawn_try_cnt : 95110
game.monster_wandering : 1
game.no_collision_check : 0
game.no_skill_cooltime : 1
game.party_drop_rate : 100
game.party_exp_rate : 2.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.2548.time : 62570
game.script.2548.trigger : open_market( 'deva_equip' )
game.script.3568.time : 59142
game.script.3568.trigger : NPC_TeleportTown_2_Secroute_Sub( 4 )
game.script.4040.time : 62683
game.script.4040.trigger : RunTeleport_Secroute( 0 , 222175 , 17949 )
game.script.5888.time : 62199
game.script.5888.trigger : open_market( 'cashshop_deco' )
game.security_solution_exceptional_ip :
game.security_solution_response_timeout : 3000
game.security_solution_type : 0
game.server_screenshot_url :
game.skip_loading_attribute : 1
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 : 42
io.auth.ip : 88.XXX.XX.XXX
io.connection : 41
io.ip_address : 88.XXX.XX.XXX
io.port : 4514
io.recv_byte : 1390364
io.recv_count : 64881
io.send_byte : 10360906
io.send_count : 165996
io.use_message_statistics : 0
iocp.active : 4
iocp.bufsize : 8192
iocp.dis_count : 504
iocp.instruction : 145038
iocp.total : 4
log.chat.working : 0
log.disable : 1
log.server_name : game001
log.working : 0
memory.item_heap_size : 189696
memory.monster_heap_size : 400180
memory.player_heap_size : 11952
memory.summon_heap_size : 43600
process.id : 1188
process.load : 0
process.load_kernel : 100
process.load_user : 0
process.memory : 1550788
process.memory_peak : 1553124
process.paged_memory : 1506672
process.paged_memory_peak : 1506996
process.start : 2012/03/25-16:23:24
process.uptime : 12 Minute 4 Second
set_user_limit : 350
thread.db.0.proc : DB_Login
thread.db.1.proc : DB_UpdateItem
thread.db.2.proc : DB_UpdateCharacter
thread.db.3.proc : DB_Login
thread.iocp.0.proc : 20
thread.iocp.1.proc : 503
thread.iocp.2.proc : 503
thread.iocp.3.proc : 503
thread.scheduler.0.proc : StructMonster
thread.scheduler.1.proc : StructNPC
thread.scheduler.2.proc : StructMonster
thread.scheduler.3.proc : StructPlayer


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

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


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

Address Frame Function SourceFile
0044F424 3A02FAA4 0001:0004E424 C:\Shiva server\Database shiva Seraphin\CaptainHerlockServer.exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\struct\structplayer.cpp line 146
0040A0F0 3A02FF48 0001:000090F0 C:\Shiva server\Database shiva Seraphin\CaptainHerlockServer.exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\arcadia\arscheduler.cpp line 388
0056AC6C 3A02FF80 0001:00169C6C C:\Shiva server\Database shiva Seraphin\CaptainHerlockServer.exe f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 348
0056AD11 3A02FF88 0001:00169D11 C:\Shiva server\Database shiva Seraphin\CaptainHerlockServer.exe f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 326
77073677 3A02FF94 0001:00003677 C:\Windows\syswow64\kernel32.dll
77AF9F42 3A02FFD4 0001:00029F42 C:\Windows\SysWOW64\ntdll.dll
77AF9F15 3A02FFEC 0001:00029F15 C:\Windows\SysWOW64\ntdll.dll


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

Address Frame Function SourceFile
0044F424 3A02FAA4 0001:0004E424 C:\Ncarbon\Database shiva Seraphin\CaptainHerlockServer.exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\struct\structplayer.cpp line 146

[q8wars]

lol u will not found any one tell u what u do

[q8wars]

!!

[|\| /\ /< `/ ()]

try look in gamelog.txt

[sewn62]

smp_insert_character:

@IN_DEFAULT_WEAPON_SID	BIGINT,
@IN_DEFAULT_WEAPON_CODE	INT,
@IN_DEFAULT_ARMOR_SID	BIGINT,
@IN_DEFAULT_ARMOR_CODE	INT,
@IN_DEFAULT_BAG_SID		BIGINT,
@IN_DEFAULT_BAG_CODE	INT

Game_Log.txt:

2012/04/25 22:51:15 DB COM ERROR(Thread:2, HRESULT:80040E07, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_update_character) : Error converting data type bigint to int.
2012/04/25 22:51:15 DB COM ERROR(Thread:3, HRESULT:80040E07, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_update_character) : Error converting data type bigint to int.
2012/04/25 23:09:14 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_OnStartUp(Hard-coded in DB_OnStartUp::readMaxFarmIndex) : Invalid object name 'Farm'.
2012/04/26 09:26:21 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 17:02:33 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 19:45:19 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 19:51:29 DB COM ERROR(Thread:3, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
2012/04/26 20:05:30 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 20:08:29 DB COM ERROR(Thread:1, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
2012/04/26 20:48:27 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item) : Could not find server 'Billing' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2012/04/26 20:53:38 DB COM ERROR(Thread:1, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.

I does not how include to change the value of BigInt ?

[Audric123]

The problem is the gameguard on the client. Use a client no gameguard and there are not crash.

[Xijezu]

Originally Posted by Audric123

The problem is the gameguard on the client. Use a client no gameguard and there are not crash.

This is the dumbest comment I ever saw...

The client has nothing to do with a servercrash, especially not the Gameguard.

If it would, then I would go to retail and crash this the whole time.

2012/04/26 20:53:38 DB COM ERROR(Thread:1, HRESULT:80040E10, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacter(dbo.smp_insert_state) : Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.

this should be help enough.

[c1ph3r]

Please check if your authserver.opt console._password is set. If somebody connects to your authserver and post a command which isn't supported by the authserver your authserver will crash with the posted error! (Sorry don't know the real parameter name...but you have to set a console pw!)

Set an authserver.opt console._password and nobody can connect to your authserver via console...don't know if this would fix your error but this is one of the security lags in the 7.3 files....

[Audric123]

Xijezu I know what I said -_-

Will take care of your server (If it is not hacked yet -- ')