|
You last visited: Today at 08:36
Advertisement
What is meaning of this LOGS?
Discussion on What is meaning of this LOGS? within the Shaiya PServer Development forum part of the Shaiya Private Server category.
05/21/2019, 16:40
|
#1
|
elite*gold: 0 
Join Date: Aug 2016
Posts: 84
Received Thanks: 15
|
What is meaning of this LOGS?
PS_DBAGENT__system log
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
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
|
![[PH]KEO(DEV) is offline](images/elitepvpers/statusicon/user_offline.gif)
|
|
|
05/22/2019, 00:47
|
#2
|
elite*gold: 0
Join Date: Aug 2016
Posts: 84
Received Thanks: 15
|
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?
2019-05-21 16:46:52 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 16:47:00 ### Connect[1296] : Game[?][0x009E8C10], Addr=127.0.0.1, DBJobEnd=1
2019-05-21 16:47:00 ### DB_SYSTEM_CONNECT[1420] :Game[1][0x009E8C10], Name=Game01, Addr=127.0.0.1
2019-05-21 18:53:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]TCP Provider: Timeout error [258]. , SQL STATE: 42000, NATIVE ERROR: 258 (0x102)
2019-05-21 18:53:36 SaveBuyPointItem 327 TestChar qerr=-1, {?=call usp_Save_User_BuyPointItems2(223,327,0,'brr1','201 9-05-21 18:53:02')}
2019-05-21 18:56:20 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2019-05-21 18:56:20 ::LoadBillingItem 48 qerr=-1, EXEC usp_Read_Char_Product_Item_E 48
2019-05-21 18:57:21 ::LoadCharacter 153 qerr=0, EXEC usp_Read_Chars_Detail2_R 153
2019-05-21 18:57:21 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
what causes and fixed?
|
|
|
|
|
05/22/2019, 19:30
|
#3
|
elite*gold: 0
Join Date: Mar 2013
Posts: 850
Received Thanks: 408
|
Quote:
Originally Posted by [PH]KEO(DEV)
PS_DBAGENT__system log
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
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
|
|
|
|
 |
Similar Threads
|
WTB SBOT ACCOUNT- MEANING CAN BUY ON IT!
10/08/2009 - Trading - 3 Replies
I want a SBOT account i can buy Sbot on. Will require to be able to log on and see that i can buy then i will pay. Post your price here
|
What's the meaning of this ?
06/13/2009 - Conquer Online 2 - 3 Replies
Hey guys
i got jailed for no reason
i send message complaining to TQ
they answered me and send me this
Here is the record:
Cheater found. Account, User:, cheat type:, subtype: -- Wed Jun 10 20:28:44 2009
cheater player_id account id GotoJail -- Wed Jun 10 20:33:44 2009
|
The Meaning of life
04/16/2007 - Off Topic - 15 Replies
you can callme crazy but im pretty sure the meaning of life is the number 4 and ill explain why i think that. lets say a random number of 52=fiftytwo <---52 is spelt with 8 letters 8=eight <---8 is spelt with 5 letters 5=five <---five is spelt with 4 letter and well
you cant go any futher then 4 and thnk about it 4 seasons....4 classes in conqueronline 24<--- hours in a day theres 4 weeks in a month. but yea try this with any number or word and it will end up to be 4...and so many ppl ask me...
|
All times are GMT +1. The time now is 08:36.
|
|
![[PH]KEO(DEV)'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar6902319_4.gif){kind=avatar}
