My Matchserver is running fine, after 3 days of running, I can't see the server on my client. When I checked my server it says "[CRITICAL ERROR] Can't connect to DBMS."
It is the second time I experienced it. Below here is some preview of my logs.
Code:COMMAND LOG END ============================================================ UpdateServerLog() [Gap : 220187], [ 9/ 24 21:13:29] UpdateServerStatusDB() [Gap : 1531], [ 9/ 24 21:17: 9] GetKillTracker().Update() [Gap : 16], [ 9/ 24 21:17:11] LOOP LOG END ======= [Loop End Time : 9/ 24 21:17:11] =================== [09/24/11 21:17:11] GARBAGE SESSION CLEANING : ClientCount=8, SessionCount=11, AgentCount=0, CommandPool=2693, objHistoryCount=48 DB Query(OnAsyncGetCharInfo > GetCharInfoByAID) Failed [09/24/11 21:17:33] Start agent Register (CommUID 0:35106) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 [09/24/11 21:17:34] Agent Added (UID:035106) [09/24/11 21:17:34] Agent Registered (CommUID 0:35106) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 [09/24/11 21:17:34] Agent Removed (UID:035106) [09/24/11 21:17:35] Start agent Register (CommUID 0:35109) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 [09/24/11 21:17:35] Agent Added (UID:035109) [09/24/11 21:17:35] Agent Registered (CommUID 0:35109) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 MMatchDBMgr::UpdateAccountLastLoginTime - Timeout expired MMatchDBMgr::UpdateAccountLastLoginTime - Timeout expired MMatchDBMgr::UpdateCharPlayTime - Timeout expired MMatchDBMgr::UpdateAccountLastLoginTime - Timeout expired MMatchDBMgr::UpdateCharInfoData - Timeout expired MMatchDBMgr::UpdateServerStatus - Timeout expired [09/24/11 21:27:21] [CRITICAL ERROR] DB Connection Lost. MMatchDBMgr::UpdateCharPlayTime - Timeout expired MMatchDBMgr::InsertPlayerLog - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateCharInfoData - Timeout expired MMatchDBMgr::UpdateAccountLastLoginTime - Timeout expMMatchDBMgr::InsertPlayerLog - Timeout expired MMatchDBMgr::InsertPlayerLog - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MDatabase::Connect - Timeout expired [09/24/11 21:39:10] Can't Connect To DBMS LOOP LOG START ===== [Loop Start Time : 9/ 24 21:18: 7] =================== LoopTimeGap = 1262922 [MAX : 1262922] COMMAND LOG START ========================================================== Command Count = 158 [MAX : 1569240] Command ID = 1543 [Gap : 109] Command ID = 1314 [Gap : 22313] Command ID = 5001 [Gap : 1031] Command ID = 1222 [Gap : 281] Command ID = 1222 [Gap : 485] Command ID = 5001 [Gap : 15] COMMAND LOG END ============================================================ UpdateServerStatusDB() [Gap : 1262907], [ 9/ 24 21:18: 7] GetKillTracker().Update() [Gap : 15], [ 9/ 24 21:39:10] LOOP LOG END ======= [Loop End Time : 9/ 24 21:39:10] =================== MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure [09/24/11 21:39:10] Agent Removed (UID:035109) MMatchDBMgr::UpdateCharPlayTime - Communication link failure MMatchDBMgr::InsertPlayerLog - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateCharPlayTime - Communication link failure MMatchDBMgr::InsertPlayerLog - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateCharPlayTime - Communication link failure MMatchDBMgr::InsertPlayerLog - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateCharInfoData - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateCharPlayTime - Communication link failure MMatchDBMgr::InsertPlayerLog - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateCharPlayTime - Communication link failure MMatchDBMgr::InsertPlayerLog - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure [09/24/11 21:39:10] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=20, AgentCount=0, CommandPool=2693, objHistoryCount=50 [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncUpdateCharInfoData) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncUpdateCharInfoData) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncUpdateCharInfoData) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed [21:39:10] Async DB Query(OnAsyncCharFinalize) Failed MDatabase::CheckOpen - Reconnet database [09/24/11 21:39:10] Start agent Register (CommUID 0:35111) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 [09/24/11 21:39:11] Agent Added (UID:035111) [09/24/11 21:39:11] Agent Registered (CommUID 0:35111) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 [09/24/11 21:39:11] Agent Removed (UID:035111) MMatchDBMgr::GetCustomIPList - Communication link failure success to update CustomIP [09/24/11 21:39:19] Start agent Register (CommUID 0:35128) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 [09/24/11 21:39:20] Agent Added (UID:035128) [09/24/11 21:39:20] Agent Registered (CommUID 0:35128) IP:184.22.45.204, TCPPort:7777, UDPPort:5100 MMatchDBMgr::GetAccountCharInfo - Communication link failure . AID(789), CharNum(0). [21:39:57] Async DB Query(ResponseAccountCharInfo) Failed MMatchDBMgr::InsertConnLog - Communication link failure MMatchDBMgr::GetAccountCharList - Communication link failure [21:40:30] Async DB Query(ResponseAccountCharList) Failed MMatchDBMgr::InsertConnLog - Communication link failure MMatchDBMgr::GetAccountCharList - Communication link failure [21:40:38] Async DB Query(ResponseAccountCharList) Failed MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::InsertConnLog - Communication link failure MMatchDBMgr::GetAccountCharInfo - Communication link failure . AID(818), CharNum(0). [21:40:46] Async DB Query(ResponseAccountCharInfo) Failed MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::InsertConnLog - Communication link failure MMatchDBMgr::GetAccountCharList - Communication link failure [21:40:49] Async DB Query(ResponseAccountCharList) Failed MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure MMatchDBMgr::GetAccountCharList - Communication link failure [21:41:00] Async DB Query(ResponseAccountCharList) Failed MMatchDBMgr::UpdateAccountLastLoginTime - Communication link failure
It can't connect to the DBMS for around 15 mins, then after such time, it becomes stable.
Any ideas regarding this issue? I need a hand over here. Thanks!
Reply With Quote
