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

1882
3
Jump to solution
01-23-2018 10:09 PM
ImtiyazPasha
New Contributor III

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

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.

 

 

 

1 Solution

Accepted Solutions
ImtiyazPasha
New Contributor III

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.

 

View solution in original post

3 Replies
RandallWilliams
Esri Regular Contributor

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
New Contributor III
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
0 Kudos
ImtiyazPasha
New Contributor III

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.

 

View solution in original post