appgini_query_log

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
rpierce
Veteran Member
Posts: 255
Joined: 2018-11-26 13:55
Location: Washington State

appgini_query_log

Post by rpierce » 2023-01-12 00:43

My database is filling up with appgini_query_log entries. It is generating a new record every 20 seconds or so. Is this a normal thing? At this time there are 168,135 records in this table. Should I delete them periodically or just ignore them?
Capture.JPG
appgini_query_log entries
Capture.JPG (25.2 KiB) Viewed 1078 times

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: appgini_query_log

Post by jsetzer » 2023-01-12 04:56

Are you using latest version 22.14?
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

rpierce
Veteran Member
Posts: 255
Joined: 2018-11-26 13:55
Location: Washington State

Re: appgini_query_log

Post by rpierce » 2023-01-13 04:39

Hi Jan,

I'm using 22.11

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: appgini_query_log

Post by jsetzer » 2023-01-13 08:54

From changelog:

AppGini 22.12, Feb 24, 2022
...
Query logs page: show hint that logs older than x days are automatically cleaned up, with a button to clean up slow queries, and another for error queries.
...

And I remember in the first days of query logging feature, certain SQL commands related to database setup were logged regularly/repeatedly, although unnecessary. There was a change in a later version which drastically reduced the amount of errors being logged. But I don't remember the exact AG version nor can I find a changelog entry.

Hope this helps!
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

rpierce
Veteran Member
Posts: 255
Joined: 2018-11-26 13:55
Location: Washington State

Re: appgini_query_log

Post by rpierce » 2023-01-13 17:33

Thank you Jan,

I'll get the newer version and see what happens.

Ray

Post Reply