Matchserver crash

[medotarek]

Hello , please someone help me? iam using Dawson's source

Log :

gameguard not running
Load XML from memory : strings.xml(0x2711) - SUCCESS
Load XML from memory : cserror.xml(0x2711) - SUCCESS
[05/31/14 13:54:43] DBMS connected

[05/31/14 13:54:43] Command registeration completed

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 : H:\International GunZ officiall\Underworld GunZ\Server\1.5 Match Server\MD5HashValue.txt
MD5 Hash Value => 3d 1f dc 59 85 dd ab 05 50 02 8a 9d 7a aa c3 a3 

================================== Server configure info ==================================
[05/31/14 13:54:43] Release Date : May 31 2014
[05/31/14 13:54:43] X-Trap Off
[05/31/14 13:54:43] MD5 Check Off
[05/31/14 13:54:43] Loop Log Save Off
[05/31/14 13:54:43] Server Country : NHNUSA
[05/31/14 13:54:43] Command version : (58)
[05/31/14 13:54:43] Event usable state : (true)
[05/31/14 13:54:43] Load event size : (0)
[05/31/14 13:54:43] FileCRCCheckSum usable state : (false)
[05/31/14 13:54:43] FileCRC size : (0)
[05/31/14 13:54:43] Country Code Filter usalbe state : (false)
[05/31/14 13:54:43] Accept Invalied IP state : (true)
[05/31/14 13:54:43] Keeper IP : (127.0.0.1)
[05/31/14 13:54:43] Monitor IP : (127.0.0.1)
[05/31/14 13:54:43] Ticket use : 0

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

[05/31/14 13:54:43] Match Server Created (Port:6000)

Dueltournament Service Open(2014-5-31 Hour13, Min54) 
Daily Survival Ranking Request [month5 day31 hour13 min54]
success to update CustomIP

[05/31/14 13:55:13]  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]

[05/31/14 13:55:13] [CRITICAL ERROR] DB Connection Lost.

[05/31/14 13:55:14] DBMS connected


[05/31/14 13:56:13]  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]

[05/31/14 13:56:13] [CRITICAL ERROR] DB Connection Lost.

[05/31/14 13:56:14] DBMS connected


[05/31/14 13:56:43]  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]

[05/31/14 13:56:43] [CRITICAL ERROR] DB Connection Lost.

[05/31/14 13:56:44] DBMS connected


[05/31/14 13:57:13]  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]

[05/31/14 13:57:13] [CRITICAL ERROR] DB Connection Lost.

[05/31/14 13:57:14] DBMS connected

[05/31/14 13:57:43] GARBAGE SESSION CLEANING : m_This(02), ClientCount=0, SessionCount=0, AgentCount=0, CommandPool=1, objHistoryCount=0


[05/31/14 13:57:43]  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]

[05/31/14 13:57:43]  MMatchDBMgr::ExceptionHandler - Disconnect
[05/31/14 13:57:43]  MMatchDBMgr::ExceptionHandler - Reconnect
[05/31/14 13:57:43]  MMatchDBMgr::ExceptionHandler - This(18790992)
[05/31/14 13:57:44] [CRITICAL ERROR] DB Connection Lost.

[05/31/14 13:57:45] DBMS connected

[05/31/14 13:57:45] [CRITICAL ERROR] UpdateServerStatusDB - Shutdown

[05/31/14 13:57:45] MatchServer Shutting down...

The Part of shutdowning :

#ifdef LOCALE_KOREA		
		int nNatePlayer = 0;

		for(MMatchObjectList::iterator iter = m_Objects.begin(); iter != m_Objects.end(); iter++) 
		{
			MMatchObject* pObj = (MMatchObject*)iter->second;
			if( pObj->GetAccountInfo()->m_nCCode == 30 ) { nNatePlayer++; }
		}

		bResult = m_MatchDBMgr.UpdateServerStatus_Netmarble(MGetServerConfig()->GetServerID(), nCurPlayer, nNatePlayer);
#else
		bResult = m_MatchDBMgr.UpdateServerStatus(MGetServerConfig()->GetServerID(), nCurPlayer);
#endif

		if (bResult == false) 
		{
			LOG(LOG_PROG, "[CRITICAL ERROR] DB Connection Lost.\n");

			m_MatchDBMgr.Disconnect();

			InitDB();
			st_ErrCounter++;
			if (st_ErrCounter > MAX_DB_QUERY_COUNT_OUT) 
			{
				LOG(LOG_PROG, "[CRITICAL ERROR] UpdateServerStatusDB - Shutdown\n");
				Shutdown();
			}
		}
		else
		{
			st_ErrCounter = 0;
		}
	}

[MentaL]

[Anju]

Maybe try this:

/*#ifdef LOCALE_KOREA        
        int nNatePlayer = 0;

        for(MMatchObjectList::iterator iter = m_Objects.begin(); iter != m_Objects.end(); iter++) 
        {
            MMatchObject* pObj = (MMatchObject*)iter->second;
            if( pObj->GetAccountInfo()->m_nCCode == 30 ) { nNatePlayer++; }
        }

        bResult = m_MatchDBMgr.UpdateServerStatus_Netmarble(MGetServerConfig()->GetServerID(), nCurPlayer, nNatePlayer);
#else*/
        bResult = m_MatchDBMgr.UpdateServerStatus(MGetServerConfig()->GetServerID(), nCurPlayer);
/*#endif*/ 

[medotarek]

Maybe try this:

/*#ifdef LOCALE_KOREA        
        int nNatePlayer = 0;

        for(MMatchObjectList::iterator iter = m_Objects.begin(); iter != m_Objects.end(); iter++) 
        {
            MMatchObject* pObj = (MMatchObject*)iter->second;
            if( pObj->GetAccountInfo()->m_nCCode == 30 ) { nNatePlayer++; }
        }

        bResult = m_MatchDBMgr.UpdateServerStatus_Netmarble(MGetServerConfig()->GetServerID(), nCurPlayer, nNatePlayer);
#else*/
        bResult = m_MatchDBMgr.UpdateServerStatus(MGetServerConfig()->GetServerID(), nCurPlayer);
/*#endif*/ 

i commented the shutdown code its not closing but idk if its working fine

[Anju]

Have you tried to comment it and see if it works? Because, as of right now, I'm still concern if it fixed it or not.

[Gun[Lengend]]

#ifdef LOCALE_KOREA		
		int nNatePlayer = 0;

		for(MMatchObjectList::iterator iter = m_Objects.begin(); iter != m_Objects.end(); iter++) 
		{
			MMatchObject* pObj = (MMatchObject*)iter->second;
			if( pObj->GetAccountInfo()->m_nCCode == 30 ) { nNatePlayer++; }
		}

//		bResult = m_MatchDBMgr.UpdateServerStatus(MGetServerConfig()->GetServerID(), nCurPlayer, nNatePlayer);//Gun edit DB error
//#else
		bResult = m_MatchDBMgr.UpdateServerStatus(MGetServerConfig()->GetServerID(), nCurPlayer);
#endif

And comment out error the logs show above will fix it

[medotarek]

#ifdef LOCALE_KOREA		
		int nNatePlayer = 0;

		for(MMatchObjectList::iterator iter = m_Objects.begin(); iter != m_Objects.end(); iter++) 
		{
			MMatchObject* pObj = (MMatchObject*)iter->second;
			if( pObj->GetAccountInfo()->m_nCCode == 30 ) { nNatePlayer++; }
		}

//		bResult = m_MatchDBMgr.UpdateServerStatus(MGetServerConfig()->GetServerID(), nCurPlayer, nNatePlayer);//Gun edit DB error
//#else
		bResult = m_MatchDBMgr.UpdateServerStatus(MGetServerConfig()->GetServerID(), nCurPlayer);
#endif

And comment out error the logs show above will fix it

iam already fixed it bro
/Close