PostGreSQL Backup fails a restore with FATAL message and connection termination
Applies to
- SnapCenter Plug-in for Creator
- PostGreSQL Plug-in from 6.0, 6.0.1,...
Issue
When running a restore for a PostGreSQL database, the following occurs, ending in FATAL error:
com.netapp.plugincreator.agent.nextgen.executionmanager.OperationExecutorImpl -Trying to call method restorePre with classloader com.netapp.plugincreator.agent.nextgen.pluginfactory.PluginClassLoader$ChildURLClassLoader@1922e6dStarting execution of the command : [su, -, postgres, /bin/sh, -c, /usr/pgsql-17/bin/pg_ctl -D /testvol/postgres/TEST/PGDATA status]Command execution completed with exitCode:0com.netapp.snapcenter.plugin.common.operation.OperationExecutor -org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator commandjava.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at com.netapp.snapcenter.plugin.common.operation.OperationExecutor.waitOnFutureTasks(OperationExecutor.java:119)
at com.netapp.snapcenter.plugin.common.operation.OperationExecutor.executeOperationOnResources(OperationExecutor.java:66)
at com.netapp.snapcenter.plugin.PostgreSQL.PostgreSQL.executeOperation(PostgreSQL.java:123)