THIS SERVER IS NOT CURRENTLY OPERATIONAL AND IS IN DEVELOPMENT!!!!
Against my better judgement, I am here to provide you the current work being done at Redemption / xSanadu and other Development Crews as a unified force. The work is going smooth, but we still must sniff out changes that the new Game Server expects to be present in the databases.
First we'll start off with the important information:
Debug of Current Crash
Code:
============================================================================== ------------------------------------------------------------------------------ Thread Information ------------------------------------------------------------------------------ 00 Thread name : IOCP 03 00 job info : 00 job id : 0 00 counter : 0 00 execute time : 0 01 Thread name : IOCP 02 01 job info : 01 job id : 0 01 counter : 0 01 execute time : 0 02 Thread name : IOCP 01 02 job info : 02 job id : 0 02 counter : 0 02 execute time : 0 03 Thread name : IOCP 00 03 job info : 03 job id : 0 03 counter : 0 03 execute time : 0 04 Thread name : Scheduler 00 04 job info : ItemCollector(0x40519510) 04 job id : 0 04 counter : 0 04 execute time : 64 05 Thread name : Scheduler 01 05 job info : _ServerStatusReport(0x40512050) 05 job id : 0 05 counter : 0 05 execute time : 64 06 Thread name : Scheduler 02 06 job info : 06 job id : 0 06 counter : 0 06 execute time : 0 07 Thread name : Scheduler 03 07 job info : 07 job id : 0 07 counter : 0 07 execute time : 0 ------------------------------------------------------------------------------ Basic Information ------------------------------------------------------------------------------ Program Name : Arcadia EXE : C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe User : Administrator Computer : Program : Exception : C0000094 (INT_DIVIDE_BY_ZERO) Fault Address: 00000001401A6F74 01:001A5F74 Mem Usage : 1543824KB / 1500020KB ------------------------------------------------------------------------------ Allocation Count Info(by _MEM_USAGE_DEBUG) ------------------------------------------------------------------------------ Type: StructSummon Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1] Type: StructQuestManager Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1] Type: StructPlayer Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1] ------------------------------------------------------------------------------ x86 Registers ------------------------------------------------------------------------------ RAX=000030D457FEB3F0 RBX=000000005E79FA10 RCX=0000000000000000 RDX=0000000000000000 ESI=0000000000000000 EDI=0000000000000000 EBP=00000001401A6EE0 DS =002B ES=002B FS=0053 GS:002B CS:RIP=0033:00000001401A6F74 SS:RSP=002B:000000005E79F8E0 Flags=00010246 ------------------------------------------------------------------------------ Environment dump ------------------------------------------------------------------------------ app.checksum : 00E3664E app.cmdline : "C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe" app.filesize : 5690368 app.filetime : 2012/03/09-14:59:36 db.c._password : db.c.account : sa db.c.name : Arcadia db.c.server : 127.0.0.1 db.user._password : db.user.account : sa db.user.name : Telecaster db.user.server : 127.0.0.1 db.user.thread_active : 0 db.user.thread_total : 0 db.user.work_active : 0 db.user.work_pending : 0 db.user.work_total : 1 engine.ar_time : 1106 engine.count_client : 0 engine.count_movable : 0 engine.count_static : 0 engine.lock : 0 engine.region_size : 180 engine.scheduler.0.instruction : 24 engine.scheduler.0.object : 1 engine.scheduler.1.instruction : 14 engine.scheduler.1.object : 1 engine.scheduler.2.instruction : 24 engine.scheduler.2.object : 0 engine.scheduler.3.instruction : 24 engine.scheduler.3.object : 0 engine.scheduler.destroy_cnt : 0 engine.scheduler.destroy_loop : 23 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.base_ethereal_durability_consumption_on_damage : 98 game.base_ethereal_durability_consumption_on_normal_attack : 31 game.base_ethereal_durability_consumption_on_skill_attack : 51 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_buy_booth : 0 game.disable_dungeon_raid_siege : 0 game.disable_huntaholic : 0 game.disable_pk_on : 0 game.exp_rate : 1.000000 game.farm_growth_summon_exp : 347264 game.farm_normal_summon_exp : 137700 game.force_unregister_account_on_kick_fail : 0 game.gold_drop_rate : 1.000000 game.ignore_random_damage : 0 game.item_count : 0 game.item_drop_rate : 1.000000 game.item_hold_time : 180000 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.local_flag : 1 game.log_required_item_list : game.log_required_state_list : game.logout_timer : 1000 game.map_height : 1000000 game.map_width : 700000 game.max_characters_per_account : 6 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 : 0 game.monster_respawn_object_cnt : 0 game.monster_respawn_try_cnt : 0 game.monster_wandering : 1 game.no_collision_check : 0 game.no_skill_cooltime : 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.050000 game.pvp_damage_rate_for_summon : 0.050000 game.restrict_banword_for_booth : 0 game.restrict_special_char : 1 game.security_solution_exceptional_ip : game.security_solution_response_timeout : 3000 game.security_solution_type : 0 game.skip_loading_attribute : 0 game.speed_unit : 30 game.stamina_bonus_rate : 1.000000 game.super_save_bonus_rate : 2.000000 game.super_save_level_limit : 130 game.use_auto_jail : 1 game.use_auto_trap : 1 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 : 0 io.connection : 0 io.recv_byte : 0 io.recv_count : 0 io.send_byte : 0 io.send_count : 0 io.use_message_statistics : 0 iocp.active : 0 iocp.dis_count : 0 iocp.instruction : 0 iocp.total : 4 log.chat.working : 0 log.connect_Main : 0 log.connect_Scheduler 01 : 0 log.server_name : CA Game Server log.working : 1 memory.item_heap_size : 246272 memory.monster_heap_size : 299880 memory.player_heap_size : 22752 memory.summon_heap_size : 86560 process.id : 5412 process.load : 338 process.load_kernel : 94 process.load_user : 5 process.memory : 1544672 process.memory_peak : 1545580 process.paged_memory : 1500888 process.paged_memory_peak : 1500888 process.start : 2012/03/11-09:21:28 process.uptime : 11 Second thread.db.0.proc : DB_OnStartUp thread.scheduler.0.proc : ItemCollector thread.scheduler.1.proc : _ServerStatusReport ------------------------------------------------------------------------------ Application-specific log ------------------------------------------------------------------------------ PlayerHeapSize : 22752 kb MonsterHeapSize : 299880 kb ItemHeapSize : 246272 kb SummonHeapSize : 86560 kb PetHeapSize : 8440 kb SkillHeapSize : 51840 kb QuestHeapSize : 5760 kb DBHeapSize : 13218 kb ------------------------------------------------------------------------------ Call Stack (Short) ------------------------------------------------------------------------------ Address Frame Function SourceFile 00000001401A6F74 000000005E79F900 0001:001A5F74 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487) 00000001401A7D59 000000005E79FC00 0001:001A6D59 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487) 00000001401A8F77 000000005E79FD30 0001:001A7F77 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487) 0000000140037B77 000000005E79FEF0 0001:00036B77 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487) 00000001403827D7 000000005E79FF20 0001:003817D7 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487) 00000001403828AF 000000005E79FF50 0001:003818AF C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487) 000000007702652D 000000005E79FF80 BaseThreadInitThunk+D 000000007725C521 000000005E79FFD0 RtlUserThreadStart+21 ------------------------------------------------------------------------------ Memory Dump ------------------------------------------------------------------------------ Code: 16 bytes starting at (RIP = 00000000401A6F74) 401A6F74: 48 F7 F9 B9 01 00 00 00 49 89 01 41 0F B6 40 40 H.......I..A..@@ Stack: 1024 bytes starting at (RSP = 000000005E79F8E0) 5E79F8E0: 28 AF E8 5D 00 00 00 00 00 00 00 00 00 00 00 00 (..]............ 5E79F8F0: 78 2C A3 5D 00 00 00 00 00 00 00 00 00 00 00 00 x,.]............ 5E79F900: 10 AF E8 5D 00 00 00 00 59 7D 1A 40 01 00 00 00 ...]....Y}.@.... 5E79F910: 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79F920: 00 00 00 00 00 00 00 00 10 AF E8 5D 00 00 00 00 ...........].... 5E79F930: 01 00 00 00 00 00 00 00 02 00 00 00 00 00 00 00 ................ 5E79F940: 10 AF E8 5D 00 00 00 00 00 00 00 00 00 00 00 00 ...]............ 5E79F950: 38 B0 E8 5D 00 00 00 00 F4 FB F6 02 00 00 00 00 8..]............ 5E79F960: 0F 7E 3F 4B A3 FD 00 00 03 00 00 00 00 00 00 00 .~?K............ 5E79F970: B0 76 C3 01 00 00 00 00 F0 EF 42 00 00 00 00 00 .v........B..... 5E79F980: F8 9C 3E 40 01 00 00 00 4C 3E 02 40 01 00 00 00 ..>@....L>.@.... 5E79F990: B0 F9 79 5E 00 00 00 00 00 00 42 00 00 00 00 00 ..y^......B..... 5E79F9A0: 28 A2 E7 5D 00 00 00 00 20 F0 42 00 00 00 00 00 (..].... .B..... 5E79F9B0: 00 00 00 00 00 00 00 00 08 F8 20 00 00 00 00 00 .......... ..... 5E79F9C0: 02 00 00 01 02 00 08 01 FE FF FF FF FF FF FF FF ................ 5E79F9D0: 08 00 00 00 00 00 00 00 08 F8 20 00 00 00 00 00 .......... ..... 5E79F9E0: 02 00 00 01 02 00 08 01 00 02 04 01 00 02 0C 01 ................ 5E79F9F0: 09 00 42 00 00 00 00 00 28 A2 E7 5D 00 00 00 00 ..B.....(..].... 5E79FA00: 20 F0 42 00 00 00 00 00 0F 00 00 00 00 00 00 00 .B............. 5E79FA10: 28 F1 40 40 01 00 00 00 00 00 00 00 00 00 00 00 (.@@............ 5E79FA20: 00 00 00 00 60 59 3F ED 38 59 BF B4 00 00 00 00 ....`Y?.8Y...... 5E79FA30: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FA40: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FA50: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FA60: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FA70: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FA80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FA90: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FAA0: 00 00 00 00 00 00 00 00 00 00 00 00 02 12 08 01 ................ 5E79FAB0: 00 00 00 00 00 00 00 00 02 12 00 21 02 12 08 21 ...........!...! 5E79FAC0: 0A 10 00 01 0A 10 08 01 0A 12 00 01 0A 12 08 01 ................ 5E79FAD0: C8 FB 79 5E 00 00 00 00 7A 9B 00 40 01 00 00 00 ..y^....z..@.... 5E79FAE0: D0 FB 79 5E 00 00 00 00 09 00 00 00 00 00 00 00 ..y^............ 5E79FAF0: 00 00 00 00 00 00 00 00 C0 F1 43 40 01 00 00 00 ..........C@.... 5E79FB00: CA F1 43 40 01 00 00 00 AF 40 02 40 01 00 00 00 ..C@.....@.@.... 5E79FB10: C8 FB 79 5E 00 00 00 00 F0 CC 4E 40 01 00 00 00 ..y^......N@.... 5E79FB20: C0 F1 43 40 01 00 00 00 C8 FB 79 5E 00 00 00 00 [email protected]^.... 5E79FB30: C0 81 42 00 00 00 00 00 6D 44 02 40 01 00 00 00 ..B.....mD.@.... 5E79FB40: FF 68 3F 4B A3 FD 00 00 C8 FB 79 5E 00 00 00 00 .h?K......y^.... 5E79FB50: E8 FB F6 02 00 00 00 00 F4 FB F6 02 00 00 00 00 ................ 5E79FB60: 00 FD F6 02 00 00 00 00 20 FC 79 5E 00 00 00 00 ........ .y^.... 5E79FB70: 03 00 00 00 00 00 00 00 00 FC F6 02 00 00 00 00 ................ 5E79FB80: 50 A4 C4 01 00 00 00 00 2E F7 36 40 01 00 00 00 P.........6@.... 5E79FB90: 01 00 00 00 00 1B 06 28 C8 FB 79 5E 00 00 00 00 .......(..y^.... 5E79FBA0: 50 A4 C4 01 00 00 00 00 00 FC F6 02 00 00 00 00 P............... 5E79FBB0: 20 FC 79 5E 00 00 00 00 50 00 90 16 24 18 08 72 .y^....P...$..r 5E79FBC0: FE FF FF FF FF FF FF FF 00 A3 6C 5F 00 00 00 00 ..........l_.... 5E79FBD0: 0F 7F 3F 4B A3 FD 00 00 72 00 00 00 00 00 00 00 ..?K....r....... 5E79FBE0: F4 FB F6 02 00 00 00 00 00 FD F6 02 00 00 00 00 ................ 5E79FBF0: 00 00 00 00 00 00 00 00 03 00 00 00 00 00 00 00 ................ 5E79FC00: 00 FC F6 02 00 00 00 00 77 8F 1A 40 01 00 00 00 ........w..@.... 5E79FC10: 48 FC F6 02 00 00 00 00 48 FC F6 02 00 00 00 00 H.......H....... 5E79FC20: 00 00 00 00 00 00 00 00 00 01 01 01 01 01 01 81 ................ 5E79FC30: 28 A2 E7 5D 00 00 00 00 00 00 00 00 00 00 00 00 (..]............ 5E79FC40: 00 00 00 00 00 00 00 00 85 3D 69 FD FE 07 00 00 .........=i..... 5E79FC50: CC 00 00 00 00 00 00 00 D0 00 00 00 00 00 00 00 ................ 5E79FC60: E0 5C 23 00 00 00 00 00 02 00 00 00 00 00 00 00 .\#............. 5E79FC70: FE FF FF FF FF FF FF FF FC 61 69 FD FE 07 00 00 .........ai..... 5E79FC80: 50 FD 79 5E 00 00 00 00 00 00 00 00 00 00 00 00 P.y^............ 5E79FC90: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 5E79FCA0: F8 FB F6 02 00 00 00 00 E8 FB F6 02 00 00 00 00 ................ 5E79FCB0: F4 FB F6 02 00 00 00 00 00 FD F6 02 00 00 00 00 ................ 5E79FCC0: E0 72 70 5F 00 00 00 00 03 00 00 00 00 00 00 00 .rp_............ 5E79FCD0: 00 FC F6 02 00 00 00 00 7A 30 03 77 00 00 00 00 ........z0.w.... ==============================================================================
You can download the full dump details:
Current SQL Trace
This is the current SQL trace from Startup of Game Server til Crash:
Code:
exec [Telecaster]..sp_procedure_params_rowset N'on_server_startup',1,NULL,NULL go declare @p1 int set @p1=NULL exec on_server_startup @p1 output select @p1 go declare @p1 int set @p1=1 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Item with (nolock) where sid < 0x3FFFFFFFFFFFFFFF' select @p1 go exec sp_unprepare 1 go declare @p1 int set @p1=2 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Skill with (nolock) where sid < 0x3FFFFFFF' select @p1 go exec sp_unprepare 2 go declare @p1 int set @p1=3 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Summon with (nolock)' select @p1 go exec sp_unprepare 3 go declare @p1 int set @p1=4 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Pet with (nolock)' select @p1 go exec sp_unprepare 4 go declare @p1 int set @p1=5 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Farm with (nolock)' select @p1 go exec sp_unprepare 5 go declare @p1 int set @p1=6 exec sp_prepexec @p1 output,NULL,N'UPDATE Character SET name = ''@'' + name WHERE delete_time <= GETDATE() and name not like ''@%''' select @p1 go select * from StringResource go select * from StringLocalResource go exec sp_reset_connection go select * from EventAreaResource go SELECT * FROM dbo.MonsterSkillResource ORDER BY id, sub_id go SELECT * FROM dbo.ItemEffectResource ORDER BY id, ordinal_id go SELECT * FROM dbo.MonsterDropTableResource ORDER BY id, sub_id go SELECT * FROM AuctionCategoryResource ORDER BY category_id, sub_category_id go select * from SetItemEffectResource go select * from MonsterResource go exec sp_reset_connection go select * from SummonResource go exec sp_reset_connection go select * from CreatureLevelBonus go exec sp_reset_connection go select * from DropGroupResource go select * from DropGroupLocalResource go exec sp_reset_connection go select * from SummonDefaultNameResource go select * from SummonUniqueNameResource go
Game Server Startup Log:
This is as far as we've got the Game Server to load at this point:
*Any Load with a 1 or a 0 during load was a table reconfigured or added in by us.
Code:
2012-03-11 09:28:19 Network initialize... ok 2012-03-11 09:28:19 IOCP initialize... ok 2012-03-11 09:28:19 Starting IOCP thread pool... ok 2012-03-11 09:28:19 LUA initialize... ok 2012-03-11 09:28:19 Launching ARCADIA... ok 2012-03-11 09:28:19 Start loading... 2012-03-11 09:28:19 Loading max Item index... (1) ok [B]<-- ALREADY WORKED[/B] 2012-03-11 09:28:19 Loading Complete. 2012-03-11 09:28:20 Total 106738 String loaded... 2012-03-11 09:28:20 Total 119 String(local) info loaded... 2012-03-11 09:28:20 Total 38/38 AuctionCategoryResource loaded. 2012-03-11 09:28:20 Total 0 ItemEffect loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:20 Total 0 Monster skill/trigger info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:20 Total 0 Event Area info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:20 Total 0 Monster item drop info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:25 Total 6640 Monster info loaded... 2012-03-11 09:28:25 Total 138 Summon info loaded... 2012-03-11 09:28:25 Total 87 Summon Level Bonus info loaded... 2012-03-11 09:28:25 Total 4265 DropGroup info loaded... 2012-03-11 09:28:25 Total 0 DropGroup(local) info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:25 Total 119 Summon Default Name loaded... 2012-03-11 09:28:25 Total 1 Summon Unique Name loaded... [B]<-- This one already worked[/B]
You can get the current databases from:
Information Being Updated
You can get the gameserver from:
!!! WARNING !!!
This game server DOES NOT load from gameserver.eop (Any changes to connection info MUST BE HEX'D) The above gameserver is set to use 127.0.0.1 for all connections to the databases, it uses Arcadia and Telecaster as names and an SA with no password for the login.
-Disclaimer:
You all should know better than I, this is one of our last chances to become a community again, so lets keep the trolling, flaming out and the busting our asses in. Only a community makes marvelous things, individuals make great things. Which one do you want, Marvelous or Great?
-MENTION:
I have done all of the work on the databases with Microsoft SQL Server 2012 RC0, there is known issues when trying to restore database backup from 2012 with Microsoft SQL Server 2008 R2. I can only suggest that you use the Microsoft SQL Server 2012 RC0 available from Microsoft