HUNgarocel1 196 Posted March 6, 2021 Share Posted March 6, 2021 Hi Dev's! I have a little interesting problem and i dont have any idea what is it.. Problem: (database syslog) Spoiler Mar 6 22:53:28 :: [ 94250] return 0/0/0 async 0/0/0 Mar 6 22:53:33 :: [ 94300] return 0/0/0 async 0/0/0 Mar 6 22:53:38 :: [ 94350] return 0/0/0 async 0/0/0 Mar 6 22:53:43 :: [ 94400] return 0/0/0 async 0/0/0 Mar 6 22:53:48 :: [ 94450] return 0/0/0 async 0/0/0 Mar 6 22:53:53 :: [ 94500] return 0/0/0 async 0/0/0 Mar 6 22:53:58 :: [ 94550] return 0/0/0 async 0/0/0 Mar 6 22:54:03 :: [ 94600] return 0/0/0 async 0/0/0 Mar 6 22:54:08 :: [ 94650] return 0/0/0 async 0/0/0 Mar 6 22:54:13 :: [ 94700] return 0/0/0 async 0/0/0 Mar 6 22:54:18 :: [ 94750] return 0/0/0 async 0/0/0 Mar 6 22:54:23 :: [ 94800] return 0/0/0 async 0/0/0 Mar 6 22:54:23 :: Current Peer host names... 127.0.0.1 14099 channel : 99 127.0.0.1 14900 channel : 1 127.0.0.1 0 channel : 0 Mar 6 22:54:28 :: [ 94850] return 0/0/0 async 0/0/0 Mar 6 22:54:33 :: [ 94900] return 0/0/0 async 0/0/0 Mar 6 22:54:38 :: [ 94950] return 0/0/0 async 0/0/0 Mar 6 22:54:43 :: [ 95000] return 0/0/0 async 0/0/0 Mar 6 22:54:48 :: [ 95050] return 0/0/0 async 0/0/0 Mar 6 22:54:53 :: [ 95100] return 0/0/0 async 0/0/0 Mar 6 22:54:58 :: [ 95150] return 0/0/0 async 0/0/0 Mar 6 22:55:03 :: [ 95200] return 0/0/0 async 0/0/0 Mar 6 22:55:08 :: [ 95250] return 0/0/0 async 0/0/0 Mar 6 22:55:13 :: [ 95300] return 0/0/0 async 0/0/0 Mar 6 22:55:18 :: [ 95350] return 0/0/0 async 0/0/0 Mar 6 22:55:23 :: [ 95400] return 0/0/0 async 0/0/0 Mar 6 22:55:23 :: Current Peer host names... 127.0.0.1 14099 channel : 99 127.0.0.1 14900 channel : 1 127.0.0.1 0 channel : 0 What is the solution for this? Thank you in advance for your help! Best Regards 1 5 Link to comment Share on other sites More sharing options...
Developer PACI 921 Posted March 7, 2021 Developer Share Posted March 7, 2021 (edited) Sorry what are you asking? Not sure if you are for real or trolling. Edited March 7, 2021 by PACI when you return 0 and server doesn't boot: Link to comment Share on other sites More sharing options...
Contributor TMP4 10995 Posted March 7, 2021 Contributor Share Posted March 7, 2021 4 minutes ago, PACI said: Sorry what are you asking? Not sure if you are for real or trolling. I think he is asking that what this syslog means. Maybe his db not starting or something, but it would be better to check the syserr instead. Link to comment Share on other sites More sharing options...
HUNgarocel1 196 Posted March 7, 2021 Author Share Posted March 7, 2021 12 minutes ago, PACI said: Sorry what are you asking? Not sure if you are for real or trolling. No, i'm not a troll.. Yes @TMP4 this just a simple question. Its normal? Check my syslog: SYSLOG I worried, because its too many i think... Link to comment Share on other sites More sharing options...
Contributor TMP4 10995 Posted March 7, 2021 Contributor Share Posted March 7, 2021 (edited) If your server runnng fine then you can pretty much just ignore it. I'm not a MySQL expert but i remember my syslogs was full with such logs. Edited March 7, 2021 by TMP4 Link to comment Share on other sites More sharing options...
HUNgarocel1 196 Posted March 7, 2021 Author Share Posted March 7, 2021 Okey, i ignore it. Thanks for the answer Link to comment Share on other sites More sharing options...
Solution Defacer35 21 Posted March 8, 2021 Solution Share Posted March 8, 2021 Hi, this syslog is the basicly heart beat of the db.I think this syslog useless, if you dont want to see this ; Open db/src/ClientManager.cpp Find ; else { pt_log ("[%9d] return %d/%d/%d/%d async %d/%d/%d%/%d", thecore_heart->pulse, CDBManager::instance().CountReturnQuery (SQL_PLAYER), CDBManager::instance().CountReturnResult (SQL_PLAYER), CDBManager::instance().CountReturnQueryFinished (SQL_PLAYER), CDBManager::instance().CountReturnCopiedQuery (SQL_PLAYER), CDBManager::instance().CountAsyncQuery (SQL_PLAYER), CDBManager::instance().CountAsyncResult (SQL_PLAYER), CDBManager::instance().CountAsyncQueryFinished (SQL_PLAYER), CDBManager::instance().CountAsyncCopiedQuery (SQL_PLAYER)); if ((thecore_heart->pulse % 50) == 0) sys_log (0, "[%9d] return %d/%d/%d async %d/%d/%d", thecore_heart->pulse, CDBManager::instance().CountReturnQuery (SQL_PLAYER), CDBManager::instance().CountReturnResult (SQL_PLAYER), CDBManager::instance().CountReturnQueryFinished (SQL_PLAYER), CDBManager::instance().CountAsyncQuery (SQL_PLAYER), CDBManager::instance().CountAsyncResult (SQL_PLAYER), CDBManager::instance().CountAsyncQueryFinished (SQL_PLAYER)); } Change like this ; else { //pt_log ("[%9d] return %d/%d/%d/%d async %d/%d/%d%/%d", //thecore_heart->pulse, CDBManager::instance().CountReturnQuery (SQL_PLAYER), CDBManager::instance().CountReturnResult (SQL_PLAYER), CDBManager::instance().CountReturnQueryFinished (SQL_PLAYER), CDBManager::instance().CountReturnCopiedQuery (SQL_PLAYER), CDBManager::instance().CountAsyncQuery (SQL_PLAYER), CDBManager::instance().CountAsyncResult (SQL_PLAYER), CDBManager::instance().CountAsyncQueryFinished (SQL_PLAYER), CDBManager::instance().CountAsyncCopiedQuery (SQL_PLAYER)/*)*/; if ((thecore_heart->pulse % 50) == 0) //sys_log (0, "[%9d] return %d/%d/%d async %d/%d/%d", //thecore_heart->pulse, CDBManager::instance().CountReturnQuery (SQL_PLAYER), CDBManager::instance().CountReturnResult (SQL_PLAYER), CDBManager::instance().CountReturnQueryFinished (SQL_PLAYER), CDBManager::instance().CountAsyncQuery (SQL_PLAYER), CDBManager::instance().CountAsyncResult (SQL_PLAYER), CDBManager::instance().CountAsyncQueryFinished (SQL_PLAYER)/*)*/; } Best Regards. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now