Current Peer host names...

[HUNgarocel1 193]

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

[PACI 911]

Sorry what are you asking?

Not sure if you are for real or trolling.

Edited March 7, 2021 by PACI

[TMP4 10555]

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.

[HUNgarocel1 193]

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...

[TMP4 10555]

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

[HUNgarocel1 193]

Okey, i ignore it. Thanks for the answer 

 

[Defacer35 21]

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.