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; } } }

ArcGIS Data store's folder pg_xlog size increase 16MB every 5min

ImtiyazPasha

After further investigation we found E:\arcgis\arcgisdatastore\pgdata\pg_xlog folder size keeps on increasing and at this moment consuming 322 GB.

For every 5 minutes, it creates one file of size 16MB. Is this any log file? but the portal log is at E:\arcgis\arcgisportal\logs folder.

Is there any relation between E:\arcgis\arcgisdatastore\pgdata\pg_xlog and E:\arcgis\arcgisportal\logs\database\pg_log?

Please view the attached files.

Below are Operating system details.

Operating System: Windows server R2 standard (64 bit)

RAM: 16 GB

Processor: Intel(R) Xion® CPU E5-2683 v3 @ 2.00Ghz 2.00Ghz

ArcGIS Tool: ArcGIS Enterprise Builder(10.5.1) including patches.

Thanks in advance.

data_store_pg_xlog2.jpg

data_store_pg_xlog1.jpg

DeonLengton_0-1632375819448.png

AnnMJ_0-1632369605591.png

Find more posts tagged with

Accepted answers

ImtiyazPasha

We got it.

Culprit is ArcGIS DataStore:

ArcGIS Data Store’s E:\arcgis\arcgisdatastore\pgdata\postgresql.config file contains “archive_command”.

archive_command = 'C:/Program^ Files/ArcGIS/DataStore/framework/etc/scripts/dbcli put-transaction-log "E:/arcgis/arcgisdatastore/pgdata/%p" "%f" "C:/Program^ Files/ArcGIS/DataStore/"'

We didn’t install the ArcGIS Data Store at 'C:/Program^ Files/ArcGIS/DataStore and

we installed at 'E:/DataStore.

Why ArcGIS Data Store is considering 'C:/Program^ Files/ArcGIS/DataStore’ as our ArcGIS Data Store installation folder?

We changed the “archive_command” as below and restarted the ArcGIS Datsore service.

archive_command = 'E:/DataStore/framework/etc/scripts/dbcli put-transaction-log "E:/arcgis/arcgisdatastore/pgdata/%p" "%f" "E:/DataStore/"'

ArcGIS Datastore started deleting or truncating old log files E:\arcgis\arcgisdatastore\pgdata\pg_xlog files.

At last, problem solved.

All comments

RandallWilliams

This sounds like a permissions issue on the PG_DATA directory. Those logs should be truncating. Under the 'tools' directory, run configureserviceaccount.bat. Here's the syntax:

configureserviceaccount [--username username] [--password password] [--readconfig user-configure-file] [--writeconfig user-configure-file\

http://enterprise.arcgis.com/en/portal/latest/administer/windows/data-store-utility-reference.htm

You also might want to look into your backup creation and retention schedule.

ImtiyazPasha

Hi Randall,

No folder named E:\Datastore\logs or E:\Datastore\nosqldata but we have

E:\arcgis\arcgisdatastore\logs and E:\arcgis\arcgisdatastore\nosqldata.

Best regards,

Imtiyaz

ImtiyazPasha

We got it.

Culprit is ArcGIS DataStore:

ArcGIS Data Store’s E:\arcgis\arcgisdatastore\pgdata\postgresql.config file contains “archive_command”.

archive_command = 'C:/Program^ Files/ArcGIS/DataStore/framework/etc/scripts/dbcli put-transaction-log "E:/arcgis/arcgisdatastore/pgdata/%p" "%f" "C:/Program^ Files/ArcGIS/DataStore/"'

We didn’t install the ArcGIS Data Store at 'C:/Program^ Files/ArcGIS/DataStore and

we installed at 'E:/DataStore.

Why ArcGIS Data Store is considering 'C:/Program^ Files/ArcGIS/DataStore’ as our ArcGIS Data Store installation folder?

We changed the “archive_command” as below and restarted the ArcGIS Datsore service.

archive_command = 'E:/DataStore/framework/etc/scripts/dbcli put-transaction-log "E:/arcgis/arcgisdatastore/pgdata/%p" "%f" "E:/DataStore/"'

ArcGIS Datastore started deleting or truncating old log files E:\arcgis\arcgisdatastore\pgdata\pg_xlog files.

At last, problem solved.

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.