MatchServer Kor_Publish build problems

[Ronny786]

can anyone tell, why server loses ts connection from DB in KOR_Publish ?

[MentaL]

[OldSchoolGZ]

whats the log say?

[Ronny786]

whats the log say?

oops i deleted those logs.. but still there was exception handle adding dbo.InsertConnlog and gamelog ... something like that.. nothing critical or weird log.

[OldSchoolGZ]

those are important I don't get those errors with BRZ_PUBLISH and KOREA uses different tables and procs then the db that was released

[Ronny786]

Check this out, i got logs !

Spoiler:

gameguard not running
Load XML from memory : strings.xml(0x0052) - SUCCESS
Load XML from memory : cserror.xml(0x0052) - SUCCESS

== Nomsg item count : 0 ==

[03/07/13 09:15:29] DBMS connected

Query({CALL spUpdateServerInfo (1000, 'North-West Server', 1)}).[03/07/13 09:15:29] Command registeration completed


10
MBMatchServer::AddClanServerSwitchDownSchedule - make close clan mode schedule success. next close clan mode time is 13-3-31 23:50

10
Inited client file list (1)
Start GambleItem Init.
GIID : 1000001
GRIID : M(502003), F(502003), RentHourPeriod(360), ItemCnt(0).
GRIID : M(500003), F(500003), RentHourPeriod(360), ItemCnt(0).
GRIID : M(502001), F(502001), RentHourPeriod(360), ItemCnt(0).
GRIID : M(506002), F(506002), RentHourPeriod(360), ItemCnt(0).
GRIID : M(509003), F(509003), RentHourPeriod(360), ItemCnt(0).
GRIID : M(505002), F(505002), RentHourPeriod(360), ItemCnt(0).
GRIID : M(520032), F(520532), RentHourPeriod(360), ItemCnt(0).
GRIID : M(520030), F(520530), RentHourPeriod(360), ItemCnt(0).
GRIID : M(521014), F(521514), RentHourPeriod(360), ItemCnt(0).
GRIID : M(521024), F(521524), RentHourPeriod(360), ItemCnt(0).
GRIID : M(522009), F(522509), RentHourPeriod(360), ItemCnt(0).
GRIID : M(522013), F(522513), RentHourPeriod(360), ItemCnt(0).
GRIID : M(523027), F(523527), RentHourPeriod(360), ItemCnt(0).
GRIID : M(523012), F(523512), RentHourPeriod(360), ItemCnt(0).
GRIID : M(524016), F(524516), RentHourPeriod(360), ItemCnt(0).
GRIID : M(524025), F(524525), RentHourPeriod(360), ItemCnt(0).
GRIID : M(528002), F(528002), RentHourPeriod(360), ItemCnt(0).
GRIID : M(520033), F(520533), RentHourPeriod(360), ItemCnt(0).
GRIID : M(502004), F(502004), RentHourPeriod(360), ItemCnt(0).
GRIID : M(527001), F(527001), RentHourPeriod(360), ItemCnt(0).
GIID : 1000002
GRIID : M(502002), F(502002), RentHourPeriod(168), ItemCnt(0).
GRIID : M(500004), F(500004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(500001), F(500001), RentHourPeriod(168), ItemCnt(0).
GRIID : M(506004), F(506004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(507003), F(507003), RentHourPeriod(168), ItemCnt(0).
GRIID : M(504501), F(504501), RentHourPeriod(168), ItemCnt(0).
GRIID : M(520014), F(520514), RentHourPeriod(168), ItemCnt(0).
GRIID : M(520029), F(520529), RentHourPeriod(168), ItemCnt(0).
GRIID : M(521017), F(521517), RentHourPeriod(168), ItemCnt(0).
GRIID : M(521027), F(521527), RentHourPeriod(168), ItemCnt(0).
GRIID : M(522020), F(522520), RentHourPeriod(168), ItemCnt(0).
GRIID : M(522004), F(522504), RentHourPeriod(168), ItemCnt(0).
GRIID : M(523024), F(523524), RentHourPeriod(168), ItemCnt(0).
GRIID : M(523005), F(523505), RentHourPeriod(168), ItemCnt(0).
GRIID : M(524027), F(524527), RentHourPeriod(168), ItemCnt(0).
GRIID : M(524012), F(524512), RentHourPeriod(168), ItemCnt(0).
GRIID : M(527002), F(527002), RentHourPeriod(168), ItemCnt(0).
GRIID : M(520034), F(520534), RentHourPeriod(168), ItemCnt(0).
GRIID : M(502005), F(502005), RentHourPeriod(168), ItemCnt(0).
GRIID : M(528001), F(528001), RentHourPeriod(168), ItemCnt(0).
GIID : 1000003
GRIID : M(4), F(4), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6), F(6), RentHourPeriod(168), ItemCnt(0).
GRIID : M(14), F(14), RentHourPeriod(168), ItemCnt(0).
GRIID : M(16), F(16), RentHourPeriod(168), ItemCnt(0).
GRIID : M(31), F(31), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4023), F(4023), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4514), F(4514), RentHourPeriod(168), ItemCnt(0).
GRIID : M(5016), F(5016), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6009), F(6009), RentHourPeriod(168), ItemCnt(0).
GRIID : M(7004), F(7004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(8001), F(8001), RentHourPeriod(168), ItemCnt(0).
GRIID : M(9001), F(9001), RentHourPeriod(168), ItemCnt(0).
GRIID : M(21009), F(21509), RentHourPeriod(168), ItemCnt(0).
GRIID : M(22006), F(22506), RentHourPeriod(168), ItemCnt(0).
GRIID : M(23008), F(23511), RentHourPeriod(168), ItemCnt(0).
GRIID : M(24007), F(24507), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30403), F(30403), RentHourPeriod(168), ItemCnt(0).
GRIID : M(25005), F(25005), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30002), F(30002), RentHourPeriod(168), ItemCnt(0).
GRIID : M(400007), F(400007), RentHourPeriod(168), ItemCnt(0).
GIID : 1000004
GRIID : M(7), F(7), RentHourPeriod(168), ItemCnt(0).
GRIID : M(8), F(8), RentHourPeriod(168), ItemCnt(0).
GRIID : M(17), F(17), RentHourPeriod(168), ItemCnt(0).
GRIID : M(18), F(18), RentHourPeriod(168), ItemCnt(0).
GRIID : M(35), F(35), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4022), F(4022), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4516), F(4516), RentHourPeriod(168), ItemCnt(0).
GRIID : M(5020), F(5020), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6010), F(6010), RentHourPeriod(168), ItemCnt(0).
GRIID : M(7009), F(7009), RentHourPeriod(168), ItemCnt(0).
GRIID : M(8004), F(8004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(9007), F(9007), RentHourPeriod(168), ItemCnt(0).
GRIID : M(21010), F(21510), RentHourPeriod(168), ItemCnt(0).
GRIID : M(22007), F(22507), RentHourPeriod(168), ItemCnt(0).
GRIID : M(23009), F(23512), RentHourPeriod(168), ItemCnt(0).
GRIID : M(24008), F(24508), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30003), F(30003), RentHourPeriod(168), ItemCnt(0).
GRIID : M(25006), F(25006), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30103), F(30103), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30305), F(30305), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6008), F(6008), RentHourPeriod(168), ItemCnt(0).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 2.
Shop GItem : 1000003
Shop GItem : 1000004
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Blue Box), IsTimeover(0).
Gamble item. ID(1000002), Name(Pink Box), IsTimeover(0).
Gamble item. ID(1000003), Name(Green Box), IsTimeover(0).
Gamble item. ID(1000004), Name(Gold Box), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 2
Shop gamble item. ID(1000003), Name(Green Box).
Shop gamble item. ID(1000004), Name(Gold Box).
=== Completed Dump GambleItem Info. ===

init GameOn success.
success init security.
FILE PATH : E:\Kryptonite Gaming Network 1.5\KGN Official New Server\MatchServer\MD5HashValue.txt
MD5 Hash Value => 5d 09 8c 2f 99 37 cc 2c 20 82 ba ad 28 e2 c1 7e

================================== Server configure info ==================================
[03/07/13 09:15:29] Release Date : Mar 7 2013
[03/07/13 09:15:29] X-Trap Off
[03/07/13 09:15:29] MD5 Check Off
[03/07/13 09:15:29] Loop Log Save Off
[03/07/13 09:15:29] Server Country : KOREA
[03/07/13 09:15:29] Command version : (58)
[03/07/13 09:15:29] Event usable state : (false)
[03/07/13 09:15:29] Load event size : (0)
[03/07/13 09:15:29] FileCRCCheckSum usable state : (false)
[03/07/13 09:15:29] FileCRC size : (1)
[03/07/13 09:15:29] Country Code Filter usalbe state : (false)
[03/07/13 09:15:29] Accept Invalied IP state : (true)
[03/07/13 09:15:29] Keeper IP : (127.0.0.1)
[03/07/13 09:15:29] Monitor IP : (127.0.0.1)
[03/07/13 09:15:29] Ticket use : 0

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

[03/07/13 09:15:29] Match Server Created (Port:6000)

Dueltournament Service Open(2013-3-7 Hour9, Min15)
Daily Survival Ranking Request [month3 day7 hour9 min15]
success to update CustomIP
[03/07/13 09:15:36] Start agent Register (CommUID 0:10) IP:127.0.0.1, TCPPort:7777, UDPPort:5100

[03/07/13 09:15:36] Agent Added (UID:010)
[03/07/13 09:15:36] Agent Registered (CommUID 0:10) IP:127.0.0.1, TCPPort:7777, UDPPort:5100

Query({CALL spUpdateServerStatus_Netmarble (0, 0, 1)}).
[03/07/13 09:15:59] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerStatus_Netmarble (0, 0, 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerStatus_Netmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[03/07/13 09:15:59] [CRITICAL ERROR] DB Connection Lost.

[03/07/13 09:15:59] DBMS connected

Query({CALL spInsertServerLog (1, 0, 0, 0, 0)}).Query({CALL spUpdateServerStatus_Netmarble (0, 0, 1)}).
[03/07/13 09:16:29] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerStatus_Netmarble (0, 0, 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerStatus_Netmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[03/07/13 09:16:29] [CRITICAL ERROR] DB Connection Lost.

[03/07/13 09:16:29] DBMS connected

Query({CALL spUpdateServerStatus_Netmarble (0, 0, 1)}).
[03/07/13 09:16:59] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerStatus_Netmarble (0, 0, 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerStatus_Netmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[03/07/13 09:16:59] [CRITICAL ERROR] DB Connection Lost.

[03/07/13 09:16:59] DBMS connected

Query({CALL spInsertServerLog (1, 0, 0, 0, 0)}).Query({CALL spUpdateServerStatus_Netmarble (0, 0, 1)}).
[03/07/13 09:17:29] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerStatus_Netmarble (0, 0, 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerStatus_Netmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[03/07/13 09:17:29] [CRITICAL ERROR] DB Connection Lost.

[03/07/13 09:17:29] DBMS connected

Query({CALL spUpdateServerStatus_Netmarble (0, 0, 1)}).
[03/07/13 09:17:59] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerStatus_Netmarble (0, 0, 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerStatus_Netmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[03/07/13 09:17:59] [CRITICAL ERROR] DB Connection Lost.

[03/07/13 09:17:59] DBMS connected

[03/07/13 09:18:29] GARBAGE SESSION CLEANING : m_This(02), ClientCount=0, SessionCount=1, AgentCount=1, CommandPool=4, objHistoryCount=1

Query({CALL spInsertServerLog (1, 0, 0, 0, 0)}).Query({CALL spUpdateServerStatus_Netmarble (0, 0, 1)}).
[03/07/13 09:18:29] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerStatus_Netmarble (0, 0, 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerStatus_Netmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[03/07/13 09:18:29] MMatchDBMgr::ExceptionHandler - Disconnect
[03/07/13 09:18:29] MMatchDBMgr::ExceptionHandler - Reconnect
[03/07/13 09:18:29] MMatchDBMgr::ExceptionHandler - This(28290352)
[03/07/13 09:18:29] [CRITICAL ERROR] DB Connection Lost.

[03/07/13 09:18:29] DBMS connected

[03/07/13 09:18:29] [CRITICAL ERROR] UpdateServerStatusDB - Shutdown

[03/07/13 09:18:29] MatchServer Shutting down...

[DelPa]

http://forum.ragezone.com/f311/serve...online-877442/
...How?

[Ronny786]

http://forum.ragezone.com/f311/serve...online-877442/
...How?

that post really not fixing my problem.....

edited :

Fixed !

[milagrogunz]

wow decompile KOR_REALASE_PUBLISH

[OldSchoolGZ]

CALL spUpdateServerStatus_Netmarble (0, 0, 1)

The released database is not using this so it causes it to crash change it in source to use only spUpdateServerStatus(0, 0)