Backup Error
Hi All,
I am trying to upgrade the SCP to latest Version. when doing the database backup, there is error and causing the backup failed :
ERROR = *ERROR: unexpected chunk size 498 (expected 1472) in final chunk 1 for toast value 99568 in pg_toast_64839*
BACKUP FAILED WITH ERRORS
Error during backup is :
org.postgresql.util.PSQLException: ERROR: unexpected chunk size 498 (expected 1472) in final chunk 1 for toast value 99568 in pg_toast_64839
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBackUp.java:2095)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1652)
at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:677)
at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:155)
at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(ScheduledBackupTask.java:95)
at com.adventnet.taskengine.internal.SchedulerBean.executeTask(SchedulerBean.java:631)
at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:115)
at com.sun.proxy.$Proxy5.executeTask(Unknown Source)
at com.adventnet.taskengine.internal.ScheduleExecutor.executeNextTask(ScheduleExecutor.java:163)
at com.adventnet.taskengine.internal.ScheduleExecutor.run(ScheduleExecutor.java:90)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)