ERROR: unexpected chunk number 2 (expected 0) for toast value 1080046 in pg_t oast_37713

ERROR: unexpected chunk number 2 (expected 0) for toast value 1080046 in pg_t oast_37713

Hi Support Team,

Build: 9000
DB: posgresql


I am getting the Following Error while taking the Backup.


Please wait ! backup in Progress...................
0-----------------------50------------------------100(%)
================================================org.postgresql.util.PSQLExceptio
n: ERROR: unexpected chunk number 2 (expected 0) for toast value 1080046 in pg_t
oast_37713
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:273)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1169)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:905)

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35
3)
        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)
        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1977)
java.io.IOException: Write error
        at java.io.FileOutputStream.writeBytes(Native Method)
        at java.io.FileOutputStream.write(Unknown Source)
        at sun.nio.cs.StreamEncoder.writeBytes(Unknown Source)
        at sun.nio.cs.StreamEncoder.implClose(Unknown Source)
        at sun.nio.cs.StreamEncoder.close(Unknown Source)
        at java.io.OutputStreamWriter.close(Unknown Source)
        at java.io.BufferedWriter.close(Unknown Source)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1225)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:905)

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35
3)
        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)
        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1977)
org.postgresql.util.PSQLException: ERROR: unexpected chunk number 2 (expected 0)
 for toast value 1080046 in pg_toast_37713
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:273)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1169)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:905)

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35
3)
        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)
        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1977)


stopping DB Server >>>>> true
Dec 2, 2014 11:59:49 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer stopDBServer
INFO: Stopping PgSQL Server ...
Dec 2, 2014 11:59:49 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer stopDBServer
INFO: Going to stop DB server using pg_ctl utility.
Dec 2, 2014 11:59:49 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer 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]
Dec 2, 2014 11:59:50 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer executeCommand
INFO: Command to be executed [C:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe,
status, -D, C:\ManageEngine\ServiceDesk\pgsql\data]
Dec 2, 2014 11:59:50 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer checkServerStatus
INFO: Server status :: pg_ctl: no server running
Dec 2, 2014 11:59:51 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer isServerStopped
INFO: isServerStopped :: going to return :: true
Dec 2, 2014 11:59:51 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer isServerStopped
INFO: is DB registered as a service ::: false
Dec 2, 2014 11:59:51 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer isServerStopped
INFO: Check PID status default timeout
Dec 2, 2014 11:59:51 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer isServerStopped
INFO: postmaster.pid file doesn't exist.
Dec 2, 2014 11:59:51 PM com.adventnet.db.adapter.postgres.DefaultPostgresDBIniti
alizer isServerStopped
INFO: isServerStopped method returning status ::: true
org.postgresql.util.PSQLException: ERROR: unexpected chunk number 2 (expected 0)
 for toast value 1080046 in pg_toast_37713
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:273)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1169)
        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:905)

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35
3)
        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)
        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1977)
C:\ManageEngine\ServiceDesk\bin>
                                             

                  New to ADSelfService Plus?