error restore db opmanager
[01-09-2018]|[17:32:14:895]|[FINE] : ************** Restore operation started **********************
[01-09-2018]|[17:32:14:895]|[FINE] : Restore started on 01-09-2018 at 17:32:14:895
[01-09-2018]|[17:32:14:911]|[INFO] :
Extracting property file please wait .....
[01-09-2018]|[17:32:14:911]|[FINE] : Extracting zip file :c:\ManageEngine\OpManager\backup\Backup_Pgsql_dic29_095808_11300.zip
[01-09-2018]|[17:32:15:051]|[INFO] :
Extraction completed.
[01-09-2018]|[17:32:15:192]|[FINE] : no_of_threads = 10
[01-09-2018]|[17:32:15:192]|[FINE] : BACKUP_FORMAT : PGSQLOUTFILE
[01-09-2018]|[17:32:15:192]|[FINE] : Backup taken in POSTGRESQL
[01-09-2018]|[17:32:15:192]|[FINE] : Backup Mode : ALL
[01-09-2018]|[17:32:15:379]|[INFO] :
Extracting zip file please wait .....
[01-09-2018]|[17:32:50:229]|[INFO] : Extraction completed.
[01-09-2018]|[17:32:50:229]|[INFO] :
Please wait ! Reading tables from configuration .....
[01-09-2018]|[17:32:50:853]|[INFO] : Exception reading dynamic tables :
org.postgresql.util.PSQLException: ERROR: relation "metatable" does not exist
Position: 46
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at jdbc.RestoreDBUtil.getDynamicTablesFromMetaTable(RestoreDBUtil.java:95)
at jdbc.AbstractRestoreDB.getAllTableNames(AbstractRestoreDB.java:311)
at jdbc.AbstractRestoreDB.restoreDB(AbstractRestoreDB.java:91)
at jdbc.AbstractRestoreDB.doRestore(AbstractRestoreDB.java:423)
at jdbc.RestoreBackup.restoreDB(RestoreBackup.java:81)
at jdbc.RestoreBackup.main(RestoreBackup.java:203)
[01-09-2018]|[17:32:50:885]|[INFO] :
Restore DB started ....
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_15_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_19_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_18_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_17_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_16_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table CentralDetails
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_23_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_22_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_21_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_20_2017
[01-09-2018]|[17:33:05:268]|[SEVERE] :
jdbc.RestoreException: Error occurred while Restoring Data.
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:151)
at jdbc.AbstractRestoreDB.restoreDB(AbstractRestoreDB.java:99)
at jdbc.AbstractRestoreDB.doRestore(AbstractRestoreDB.java:423)
at jdbc.RestoreBackup.restoreDB(RestoreBackup.java:81)
at jdbc.RestoreBackup.main(RestoreBackup.java:203)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Restore failed for table 'statsdata12_15_2017' :
Restore failed for table 'statsdata12_15_2017' :
SET
SET
SET
SET
SET
SET
SET
SET
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:26: ERROR: index "pg_attribute_relid_attnam_index" contains unexpected zero page at block 215
HINT: Please REINDEX it.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:29: ERROR: relation "public.statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:35: ERROR: relation "statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889459: invalid command \.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889466: ERROR: syntax error at or near "1654"
LINE 1: 1654 CPU3 1513306755093 0
^..
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:142)
... 4 more
Caused by: java.lang.Exception: Restore failed for table 'statsdata12_15_2017' :
Restore failed for table 'statsdata12_15_2017' :
SET
SET
SET
SET
SET
SET
SET
SET
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:26: ERROR: index "pg_attribute_relid_attnam_index" contains unexpected zero page at block 215
HINT: Please REINDEX it.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:29: ERROR: relation "public.statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:35: ERROR: relation "statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889459: invalid command \.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889466: ERROR: syntax error at or near "1654"
LINE 1: 1654 CPU3 1513306755093 0
^..
at jdbc.RestoreDB$RestoreData.restoreUsingPgSqlCommand(RestoreDB.java:297)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:204)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:161)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[01-09-2018]|[17:33:05:268]|[FINE] : Deleting temporary files if exists ...
[01-09-2018]|[17:33:10:525]|[FINE] : temp files deleted successfully.
[01-09-2018]|[17:33:10:525]|[FINE] : Restore finished at : 01-09-2018 at 17:33:10:525
[01-09-2018]|[17:33:10:525]|[FINE] : ******************* Restore DB Completed ***********************
[01-09-2018]|[17:32:14:895]|[FINE] : Restore started on 01-09-2018 at 17:32:14:895
[01-09-2018]|[17:32:14:911]|[INFO] :
Extracting property file please wait .....
[01-09-2018]|[17:32:14:911]|[FINE] : Extracting zip file :c:\ManageEngine\OpManager\backup\Backup_Pgsql_dic29_095808_11300.zip
[01-09-2018]|[17:32:15:051]|[INFO] :
Extraction completed.
[01-09-2018]|[17:32:15:192]|[FINE] : no_of_threads = 10
[01-09-2018]|[17:32:15:192]|[FINE] : BACKUP_FORMAT : PGSQLOUTFILE
[01-09-2018]|[17:32:15:192]|[FINE] : Backup taken in POSTGRESQL
[01-09-2018]|[17:32:15:192]|[FINE] : Backup Mode : ALL
[01-09-2018]|[17:32:15:379]|[INFO] :
Extracting zip file please wait .....
[01-09-2018]|[17:32:50:229]|[INFO] : Extraction completed.
[01-09-2018]|[17:32:50:229]|[INFO] :
Please wait ! Reading tables from configuration .....
[01-09-2018]|[17:32:50:853]|[INFO] : Exception reading dynamic tables :
org.postgresql.util.PSQLException: ERROR: relation "metatable" does not exist
Position: 46
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at jdbc.RestoreDBUtil.getDynamicTablesFromMetaTable(RestoreDBUtil.java:95)
at jdbc.AbstractRestoreDB.getAllTableNames(AbstractRestoreDB.java:311)
at jdbc.AbstractRestoreDB.restoreDB(AbstractRestoreDB.java:91)
at jdbc.AbstractRestoreDB.doRestore(AbstractRestoreDB.java:423)
at jdbc.RestoreBackup.restoreDB(RestoreBackup.java:81)
at jdbc.RestoreBackup.main(RestoreBackup.java:203)
[01-09-2018]|[17:32:50:885]|[INFO] :
Restore DB started ....
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_15_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_19_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_18_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_17_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_16_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table CentralDetails
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_23_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_22_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_21_2017
[01-09-2018]|[17:32:50:931]|[FINE] : Restoring table statsdata12_20_2017
[01-09-2018]|[17:33:05:268]|[SEVERE] :
jdbc.RestoreException: Error occurred while Restoring Data.
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:151)
at jdbc.AbstractRestoreDB.restoreDB(AbstractRestoreDB.java:99)
at jdbc.AbstractRestoreDB.doRestore(AbstractRestoreDB.java:423)
at jdbc.RestoreBackup.restoreDB(RestoreBackup.java:81)
at jdbc.RestoreBackup.main(RestoreBackup.java:203)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Restore failed for table 'statsdata12_15_2017' :
Restore failed for table 'statsdata12_15_2017' :
SET
SET
SET
SET
SET
SET
SET
SET
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:26: ERROR: index "pg_attribute_relid_attnam_index" contains unexpected zero page at block 215
HINT: Please REINDEX it.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:29: ERROR: relation "public.statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:35: ERROR: relation "statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889459: invalid command \.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889466: ERROR: syntax error at or near "1654"
LINE 1: 1654 CPU3 1513306755093 0
^..
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:142)
... 4 more
Caused by: java.lang.Exception: Restore failed for table 'statsdata12_15_2017' :
Restore failed for table 'statsdata12_15_2017' :
SET
SET
SET
SET
SET
SET
SET
SET
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:26: ERROR: index "pg_attribute_relid_attnam_index" contains unexpected zero page at block 215
HINT: Please REINDEX it.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:29: ERROR: relation "public.statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:35: ERROR: relation "statsdata12_15_2017" does not exist
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889459: invalid command \.
psql:c:/ManageEngine/OpManager/backup/temp1/backup/opmanager/statsdata12_15_2017.bkp:1889466: ERROR: syntax error at or near "1654"
LINE 1: 1654 CPU3 1513306755093 0
^..
at jdbc.RestoreDB$RestoreData.restoreUsingPgSqlCommand(RestoreDB.java:297)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:204)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:161)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[01-09-2018]|[17:33:05:268]|[FINE] : Deleting temporary files if exists ...
[01-09-2018]|[17:33:10:525]|[FINE] : temp files deleted successfully.
[01-09-2018]|[17:33:10:525]|[FINE] : Restore finished at : 01-09-2018 at 17:33:10:525
[01-09-2018]|[17:33:10:525]|[FINE] : ******************* Restore DB Completed ***********************