Database warning

General discussion about Life is Feudal MMO and Life is Feudal: Your Own, The main section and backbone of the forums.

TiTANSTORM
 
Posts: 13
Joined: 29 Sep 2014, 02:42

Database warning

Post by TiTANSTORM » 28 Nov 2015, 08:24

I have noticed some slight server lag now and then with rows of "outdated RecordSet" warning in the console window. For example:
Code: Select all
WARN 2015-11-27 02:40:47.813 {00} <NOSCOPE> # Warning: found an outdated RecordSet (1562) inside DBI (1188 dbi). Time elapsed: 2400 sec / Warn counter: 4


Any idea what is causing this?
Image

User avatar
Custodian
Mod Developer
 
Posts: 655
Joined: 08 Jun 2015, 14:58
Location: Lisbon

Re: Database warning

Post by Custodian » 28 Nov 2015, 08:30

TiTANSTORM wrote:Any idea what is causing this?

You are using one of mods which executes sql queries to the database.
Most likely, thats LiFDS-CP (Control panel), since its does not work correctly with record sets. I made a pull request fix those issues.


TiTANSTORM
 
Posts: 13
Joined: 29 Sep 2014, 02:42

Re: Database warning

Post by TiTANSTORM » 28 Nov 2015, 19:38

Thanks for the reply. The lifds-cp should only be reading information and the tree removal scripts do not work from what I have read. I also used the LiFAdmin tool to view stats, inventory, etc. and have written things to the database. I have tried not running any mods/admin tools and these warnings still come up. Is there any way to fix this or is a wipe the best solution? The error message I pasted above will scroll across the screen for hundreds of rows which typically causes server lag when that happens.
Image

User avatar
Custodian
Mod Developer
 
Posts: 655
Joined: 08 Jun 2015, 14:58
Location: Lisbon

Re: Database warning

Post by Custodian » 28 Nov 2015, 21:53

TiTANSTORM wrote:I have tried not running any mods/admin tools and these warnings still come up.

If it was related to lifds-cp, it was caused by 'online players' check and update.
Disable lifds-cp (dont execute file lifdscp_stats.cs) for a while and restart server. There should be no such messages.


TiTANSTORM
 
Posts: 13
Joined: 29 Sep 2014, 02:42

Re: Database warning

Post by TiTANSTORM » 29 Nov 2015, 22:45

This is still happening even without lifds-cp running. Also, the "RecordSet (xxxx)" is always varying but "inside DBI (1188 dbi)" is always the same.
Image

User avatar
Custodian
Mod Developer
 
Posts: 655
Joined: 08 Jun 2015, 14:58
Location: Lisbon

Re: Database warning

Post by Custodian » 30 Nov 2015, 00:31

TiTANSTORM wrote:This is still happening even without lifds-cp running. Also, the "RecordSet (xxxx)" is always varying but "inside DBI (1188 dbi)" is always the same.

Share your server log.

User avatar
KhaimovMR
 
Posts: 77
Joined: 10 Oct 2015, 01:39

Re: Database warning

Post by KhaimovMR » 30 Nov 2015, 03:05

Custodian wrote:
TiTANSTORM wrote:This is still happening even without lifds-cp running. Also, the "RecordSet (xxxx)" is always varying but "inside DBI (1188 dbi)" is always the same.

Share your server log.

Yep. I've merged your pull request and tested it on my server.
The problem is still there.
I've restarted my server now after complete excluding lifdscp_stats.cs from main.cs. Will see if this problem is still there.

Could you review the latest version of lifdscp_stats.cs with your pull-request merged?

https://github.com/KhaimovMR/lifds-cp/b ... p_stats.cs

Thanks for your help )

PS: By the way - here is the log with lifdscp_stats.cs included in main.cs - S_KHAIMOVMR-PC_2015-11-30-04-28-33_p6092.log

User avatar
Custodian
Mod Developer
 
Posts: 655
Joined: 08 Jun 2015, 14:58
Location: Lisbon

Re: Database warning

Post by Custodian » 30 Nov 2015, 07:47

KhaimovMR wrote:By the way - here is the log with lifdscp_stats.cs included in main.cs - S_KHAIMOVMR-PC_2015-11-30-04-28-33_p6092.log

When you got message about outdated recordset, you can:
1) dbi.listObjects();
to check if there are any attached child recordsets
2) (from your log):
# Warning: found an outdated RecordSet (13508) inside DBI (1188 dbi). Time elapsed: 600 sec / Warn counter: 1
Call "13508.dump();" and try to call "echo(13508.getSQL());" to get source of the troubles.
:pardon:

User avatar
KhaimovMR
 
Posts: 77
Joined: 10 Oct 2015, 01:39

Re: Database warning

Post by KhaimovMR » 30 Nov 2015, 10:45

Custodian wrote:
KhaimovMR wrote:By the way - here is the log with lifdscp_stats.cs included in main.cs - S_KHAIMOVMR-PC_2015-11-30-04-28-33_p6092.log

When you got message about outdated recordset, you can:
1) dbi.listObjects();
to check if there are any attached child recordsets
2) (from your log):
# Warning: found an outdated RecordSet (13508) inside DBI (1188 dbi). Time elapsed: 600 sec / Warn counter: 1
Call "13508.dump();" and try to call "echo(13508.getSQL());" to get source of the troubles.
:pardon:

Thanks, Cust!
I'll try it today at evening.
I've excluded lifdscp_stats.cs from main.cs - and there is no problem right now in logs.

Today/tomorrow i'll release a new version of lifds-cp with fixed script.

User avatar
KhaimovMR
 
Posts: 77
Joined: 10 Oct 2015, 01:39

Re: Database warning

Post by KhaimovMR » 01 Dec 2015, 03:59

I've fixed this problem in version 0.9.8

LiFDS-CP thread

PS: Big thanks to Custodian for intro into the lif script debugging. :)

User avatar
KhaimovMR
 
Posts: 77
Joined: 10 Oct 2015, 01:39

Re: Database warning

Post by KhaimovMR » 01 Dec 2015, 09:43

By a mistake new lifdscp_stats.cs file wasn't included in v0.9.8.
That's why i've released a hotfix version 0.9.8.1 right now.
This version at last fixed that bug.

Return to General Discussion