Bogus data in lock file

  • KM03601383
  • 19-Feb-2020
  • 24-Jun-2020

Summary

The bogus data in lock file is preventing the PostgreSQL service to become available.

Error

There is a FATAL message in the PostgreSQL server log file.

FATAL message:  bogus data in lock file "/opt/arcsight/logger/current/runtime/.s.PGSQL.XXXX.lock"

 

Cause

The bogus data in lock file is preventing the PostgreSQL service to become available.

Fix

1)  Stop all ESM services:

/etc/init.d/arcsight_services stop all

 

2) Confirm that there are no ESM services running:

/etc/init.d/arcsight_services status

 

3) Navigate to the bogus data at /opt/arcsight/logger/current/runtime/ as arcsight user

 

4) Remove the file (s.PGSQL.XXXX.lock) seen in the error. In this scenario it is .s.PGSQL.1976.lock.

 

Note: this is a hidden file indicated by a .(dot) in front of the filename. To view if file exist use ls -al

 

5) Initiate a start on the PostgreSQL service ONLY:

/opt/arcsight/logger/current/arcsight/service/postgresql start

 

6) Verify that the PostgreSQL service launched successfully:

/opt/arcsight/logger/current/arcsight/service/postgresql status

 

7) Then start also the other processes:

/sbin/service arcsight_services start all