nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Does the ArcGIS Monitor SQLite DB for logs get compacted?

TristanMcHardie

I noticed our logs database at AppData\Local\ESRI\ArcGISMonitor\config-store-server\logs\agm-logs.sqlite is getting up to 1 GB. This isn't necessarily a problem in our case but I was curious about how this database's size is managed.

The default retention period is 90 days but I shortened this to 60 days. However, the database file size didn't reduce, even after restarting the ArcGIS Monitor service.

I'm wondering, does this DB get VACUUMed?

Find more posts tagged with

Accepted answers

GeoJosh

Tristan,

Thank you for bringing this issue to our attention. Starting in Monitor 2023.3, the SQLite database will be auto-VACUUM'ed and this issue should be resolved.

Josh

All comments

GeoJosh

Hey Tristan,

The logs table should automatically get truncated when you change the log retention period in Administration > Logs > Log Settings.

If this not the case for you, there's a chance that a majority of the logs that make up the 1GB were created less than 60 days ago. If you sort the existing logs by date (oldest to newest), do you see entries that are greater than 60 days old?

Josh

TristanMcHardie

Hi @GeoJosh, thanks for your response.

When I reduced the retention time from 90 to 60 days I saw a one third reduction in the number of log records, and there is nothing older than 60 days. I'm confident that it's consistent across time, and that the records have indeed been deleted.

It's just that the database file size itself hasn't reduced at all. My guess is that it's fragmented and VACUUM needs to be run.

Cheers,
Tristan

GeoJosh

Tristan,

Thank you for bringing this issue to our attention. Starting in Monitor 2023.3, the SQLite database will be auto-VACUUM'ed and this issue should be resolved.

Josh

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.