DCA V1/V2/V3: How to decode DCA_CHECK_ERROR Error: Database state Uncertain. master data directory=

DCA V1/V2/V3: How to decode DCA_CHECK_ERROR Error: Database state Uncertain. master data directory=

Environment:

Data Computing Appliance V3

Data Computing Appliance V2

Data Computing Appliance V1

 

Description:

 

How to decode dca_check error which points to wrong data directory.

Example output below from dca_check:

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(smdw): Error: Database state Uncertain. master data directory=/data/master/gpseg-1, gpdb port=5432

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(smdw): Error: Database state Uncertain: DB postmaster pid exists=0, DB tmpfile exists=1, DB lockfile exists=1, gpdb port active=1, DB postmaster pid value=0

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(smdw): Error: Database state Uncertain. DB active=0 and DB gpsyncmaster processes running=1

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(smdw): Error: Database state Uncertain. Found postgres process gpadmin 10129 10126 0 Aug24 ? 00:00:00 postgres: port 5432, logger process

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(smdw): Error: Database state Uncertain. Found postgres process gpadmin 10133 10126 0 Aug24 ? 00:03:26 postgres: port 5432, WAL Redo Server process

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(smdw): Error: Database state Uncertain. Found postgres process gpadmin 10221 10126 0 Aug24 ? 00:02:44 postgres: port 5432, gpsyncagent process con45 idle

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(mdw): Error: Database state Uncertain. master data directory=/data/master/gpseg-1, gpdb port=5432

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(mdw): Error: Database state Uncertain: DB postmaster pid exists=0, DB tmpfile exists=1, DB lockfile exists=1, gpdb port active=1, DB postmaster pid value=0

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(mdw): Error: Database state Uncertain. DB active=1 and DB gpsyncmaster processes running=0

 

20160829:11:55:57:027174 dcacheck_main.py:mdw:root-[ERROR]:-DCA_CHECK_ERROR host(mdw): Error: Database state Uncertain. Found postgres process gpadmin 2791 21330 0 11:28 ? 00:00:00 postgres: port 5432, r45s postgres 93.183.29

 

 

 

Resolution:

For a detailed step by step resolution please refer to EMC Support Solution 488549  https://support.emc.com/kb/488549