invalid secondary checkpoint record0PANIC: could not locate a valid checkpoint record.

  • Document ID:KM00864347
  • Creation Date:18-Apr-2014
  • Modified Date:03-Jun-2021
    • Micro Focus Products:
      network node manager

Summary

invalid secondary checkpoint record0PANIC: could not locate a valid checkpoint record. invalid secondary checkpoint record0PANIC: could not locate a valid checkpoint record.

Error

This error LOG: invalid secondary checkpoint record0PANIC: could not locate a valid checkpoint record  can be found under the pg_log file .

 

Windows:

 drive:\ProgramData\HP\HP BTO Software\shared\nnm\databases\Postgres\pg_log

Unix:

/var/opt/OV/shared/nnm/databases/Postgres/pg_log

Cause

This error may occur if the database  was  not started correctly.

Fix

The solution for this issue  is executing the following steps:

1-ovstop -v

2-Run 

Windows:

"\Program Files (x86)\HP\HP BTO Software\nonOV\Postgres\bin\pg_resetxlog" -f "\ProgramData\HP\HP BTO Software\shared\nnm\databases\Postgres"

Unix:

 /var/opt/nonov/Postgres/bin/pg_resetxlog -f /var/opt/OV/shared/nnm/databases/Postgres

3-ovstart -v