unable to restore data from fullbackup
I try to restore data to fresh SDP 9019 from fullbackup.
I have a 3 backup files
backup_postgres_9019_fullbackup_09_25_2014_15_00_part_1
backup_postgres_9019_fullbackup_09_25_2014_15_00_part_2
backup_postgres_9019_fullbackup_09_25_2014_15_00_part_3
When I run restoreData.bat there is possible to select only one filename, therefor I select first one.
During restoring data I have a next errors, and the process is stoped and in ServiceDesk directory a lot of ***.sql files.
====
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
====================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
=QUERY = INSERT INTO ConfigurationRecord (crid,crtype,scope,segmentationtype,av
ilable) VALUESnull
java.sql.BatchUpdateException: Batch entry 46 INSERT INTO ConfigurationRecord (
rid,crtype,scope,segmentationtype,available) VALUES(13694, 'Schedule', 'GLOBAL'
NULL, '1') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handl
Error(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutor
mpl.java:459)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecuto
Impl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.j
va:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdb
2Statement.java:2737)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Res
oreSDBackup.java:754)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Rest
reSDBackup.java:324)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup
java:133)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.ja
a:186)
at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Batch entry 46 INSERT INTO ConfigurationRecord (
rid,crtype,scope,segmentationtype,available) VALUES(13694, 'Schedule', 'GLOBAL'
NULL, '1') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handl
Error(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutor
mpl.java:459)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecuto
Impl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.j
va:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdb
2Statement.java:2737)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Res
oreSDBackup.java:754)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Rest
reSDBackup.java:324)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup
java:133)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.ja
a:186)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Batch entry 46 INSERT INTO ConfigurationRecord (cr
d,crtype,scope,segmentationtype,available) VALUES(13694, 'Schedule', 'GLOBAL',
ULL, '1') was aborted. Call getNextException to see the cause.
Batch entry 46 INSERT INTO ConfigurationRecord (crid,crtype,scope,segmentationt
pe,available) VALUES(13694, 'Schedule', 'GLOBAL', NULL, '1') was aborted. Call
getNextException to see the cause.
25.09.2014 16
:20:32 com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.postgres.PostgresDBAdapter@1f42731
, startDBServer :: [true], dbProp :: {ManagedConnectionFactoryProperties=
, TrackConnectionByTx=true, Password=postgres, MaxSize=20, UserName=postgres, C
nnectionURL=jdbc:postgresql://localhost:65432/servicedesk, BlockingTimeoutMilli
=30000, Criteria=ByNothing, DriverClass=org.postgresql.Driver, JndiName=Postgre
DS, LocalTransactions=true, IdleTimeoutMinutes=15, TransactionIsolation=TRANSAC
ION_READ_COMMITTED, MinSize=0}
25.09.2014 16
:20:32 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er stopDBServer
INFO: Stopping PgSQL Server ...
25.09.2014 16
:20:32 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er stopDBServer
INFO: Going to stop DB server using pg_ctl utility.
25.09.2014 16
:20:32 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er executeCommand
INFO: Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe,
-D, C:\ManageEngine\ServiceDesk\pgsql\data, -o, "-p65432", stop, -s, -m, fast]
25.09.2014 16
:20:33 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er executeCommand
INFO: Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe,
status, -D, C:\ManageEngine\ServiceDesk\pgsql\data]
25.09.2014 16
:20:33 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er checkServerStatus
INFO: Server status :: pg_ctl: server is running (pid: 3064)
25.09.2014 16
:20:33 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er getServerStatus
INFO: isServerRunning :: false
25.09.2014 16
:20:34 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er executeCommand
INFO: Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe,
status, -D, C:\ManageEngine\ServiceDesk\pgsql\data]
25.09.2014 16
:20:34 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er checkServerStatus
INFO: Server status :: pg_ctl: server is running (pid: 3064)
25.09.2014 16
:20:34 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er getServerStatus
INFO: isServerRunning :: false
25.09.2014 16
:20:35 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er executeCommand
INFO: Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe,
status, -D, C:\ManageEngine\ServiceDesk\pgsql\data]
25.09.2014 16
:20:35 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er checkServerStatus
INFO: Server status :: pg_ctl: server is running (pid: 3064)
25.09.2014 16
:20:35 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er getServerStatus
INFO: isServerRunning :: false
25.09.2014 16
:20:36 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er executeCommand
INFO: Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe,
status, -D, C:\ManageEngine\ServiceDesk\pgsql\data]
25.09.2014 16
:20:36 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er checkServerStatus
INFO: Server status :: pg_ctl: no server running
25.09.2014 16
:20:37 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er isServerStopped
INFO: isServerStopped :: going to return :: true
25.09.2014 16
:20:37 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er isServerStopped
INFO: is DB registered as a service ::: false
25.09.2014 16
:20:37 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er isServerStopped
INFO: Check PID status default timeout
25.09.2014 16
:20:37 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er isServerStopped
INFO: postmaster.pid file doesn't exist.
25.09.2014 16
:20:37 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitiali
er isServerStopped
INFO: isServerStopped method returning status ::: true
25.09.2014 16
:20:37 com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
25.09.2014 16
:20:37 com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
25.09.2014 16
:20:42 com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB
====