Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..
328 views

nmsdbmgr 48644 RUNNING Data Warehouse unaccessible.

Hi Team,

 

After installing the QA in HA lcuster nnmi is  not working, I am getting the below message from ovstatus -c 

nmsdbmgr             48644  RUNNING        Data Warehouse unaccessible.

from Pg_log 

 

nnm:17268:1330ERROR: duplicate key value violates unique constraint "nms_author_value_key"
2018-10-23 07:07:06.841 GMT: nnm:17268:1330DETAIL: Key (value)=(com.hp.nms.author.qaspi) already exists.
2018-10-23 07:07:06.841 GMT: nnm:17268:1330STATEMENT: insert into NMS_AUTHOR (VALUE, LABEL, VERSION, id) values ($1, $2, $3, $4)
2018-10-23 07:09:02.682 GMT: :24664:0LOG: received fast shutdown request
2018-10-23 07:09:02.683 GMT: :24664:0LOG: aborting any active transactions
2018-10-23 07:09:02.683 GMT: nnm:35768:0FATAL: terminating connection due to administrator command
2018-10-23 07:09:02.684 GMT: nnm:19284:0FATAL: terminating connection due to administrator command
2018-10-23 07:09:02.684 GMT: nnm:27240:0FATAL: terminating connection due to administrator command
2018-10-23 07:09:02.685 GMT: nnm:45088:0FATAL: terminating connection due to administrator command
2018-10-23 07:09:02.686 GMT: nnm:17268:0FATAL: terminating connection due to administrator command
2018-10-23 07:09:02.686 GMT: nnm:23360:0FATAL: terminating connection due to administrator command
2018-10-23 07:09:02.687 GMT: nnm:30156:0FATAL: terminating connection due to administrator command
2018-10-23 07:09:02.688 GMT: :46792:0LOG: autovacuum launcher shutting down
2018-10-23 07:09:02.789 GMT: :28720:0LOG: shutting down
2018-10-23 07:09:04.357 GMT: template1:41304:0FATAL: the database system is shutting down
2018-10-23 07:09:05.002 GMT: :28720:0LOG: database system is shut down

 

:32620:0LOG: could not open file "postmaster.pid": No such file or directory
2018-10-23 06:55:02.997 GMT: :32620:0LOG: performing immediate shutdown because data directory lock file is invalid
2018-10-23 06:55:02.998 GMT: :32620:0LOG: received immediate shutdown request
2018-10-23 06:55:03.013 GMT: :30200:0WARNING: terminating connection because of crash of another server process
2018-10-23 06:55:03.013 GMT: :30200:0DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2018-10-23 06:55:03.013 GMT: :30200:0HINT: In a moment you should b

Raised a support case well but still not getting any resolution, please help.

Thanks

 

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.