ACSLS - ACSLS Terminated and Postgres Database Server is Not Starting Up (Doc ID 1358359.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

ACSLS terminated with these errors (in the acsss_event.log):

The most current Postgres transaction log in $PGDATA/pg_log shows these start up error messages:
"could not locate a valid checkpoint record"
"could not open relation 1663/16384/16569: No such file or directory"
LOG: startup process (PID 4550) was terminated by signal 6
LOG: aborting startup due to startup process failure

Also, if an attempt is made to restore the ACSLS database with rdb.acsss, it may fail with the following:

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5436"

Changes

The /export/home filesystem filled up to 90% usage level.   To mitigate a disk full situation, the system administrator deleted some log files.
He inadvertently deleted the Postgres transaction logs in $PGDATA/pg_log directory.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.