What is meaning of this LOGS?

05/21/2019 16:40 [PH]KEO(DEV)#1

PS_DBAGENT__system log

PS_GAMELOG__system.log

thanks if someone answering

05/22/2019 00:47 [PH]KEO(DEV)#2

Quote:

Originally Posted by failpvper

your PS_Billing database had an error and is in recovery, causing those loadbillingitem errors. some of those stored procedures are coming from PS_GameData but aren't able to read the tables in PS_Billing because it's in recovery. after a while, they will just time out...

something went wrong with your PS_GameDefs database also and put it in recovery.

you should've been able to see this in SSMS... i'd restore the PS_Billing and PS_Gamedefs from backups.

how about this error sir?

Spoiler

what causes and fixed?

05/22/2019 19:30 {Skrillex}#3

Quote:

Originally Posted by [PH]KEO(DEV)

PS_DBAGENT__system log

Spoiler

2019-05-21 09:35:19 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2019-05-21 09:35:23 ### Connect[3988] : Game[?][0x00948C10], Addr=127.0.0.1, DBJobEnd=1

2019-05-21 09:35:23 ### DB_SYSTEM_CONNECT[4388] :Game[1][0x00948C10], Name=Game01, Addr=127.0.0.1

2019-05-21 12:19:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_Billing' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

2019-05-21 12:19:29 ::LoadBillingItem 62 qerr=-1, EXEC usp_Read_Char_Product_Item_E 62

2019-05-21 12:24:30 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2019-05-21 12:24:30 LoadCharacterList failed 23 qerr=-1, EXEC usp_Read_Chars_R 1, 62

2019-05-21 12:24:48 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2019-05-21 12:24:48 ::LoadBillingItem 88 qerr=-1, EXEC usp_Read_Char_Product_Item_E 88

2019-05-21 12:25:53 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2019-05-21 12:25:53 ::LoadBillingItem 88 qerr=-1, EXEC usp_Read_Char_Product_Item_E 88

PS_GAMELOG__system.log

Spoiler

2019-05-21 12:19:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_GameDefs' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

thanks if someone answering

Is enough ram available?

Regards