Analytics Datastore doesn't start

Document ID : KB000120939
Last Modified Date : 13/11/2018
Show Technical Document Details
Issue:
Attempts to start the Analytics Datastore from the Service Manager Dialog fail.

The log of the Service Manager (SMgr_log_00.txt) only reports start and stop in the same second:
20181113/074203.500 - U00022007 Process 'ANALYTICS-DATASTORE' (ID '23705') successfully started.
20181113/074203.614 - U00022012 Process 'ANALYTICS-DATASTORE' (ID '23705') ended.

There are no other relevant messages generated.

When trying to start the Datastore manually by copying the line the SMD properties, the error below is displayed:

Command:
<Analytics>/datastore/pg_start.sh <Automic>/External.Resources/postgresql <postgresql_port> 

Output:
Starting the automic datastore now. 
FATAL: lock file "postmaster.pid" already exists 
HINT: Is another postmaster (PID <pid>) running in data directory "<Automic>/External.Resources/postgresql/data"?
Cause:
The postgresql Datastore did not stop gracefully and the file <Automic>/External.Resources/postgresql/data/postmaster.pid was not deleted.
Resolution:
Workaround:

Rename the file postmaster.pid to postmaster.pid.old and restart the Analytics Datastore via the Service Manager Dialog