Search Postgresql Archives

Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



It seems to be very hit and miss...

The below is from the machine described in this thread running PostgreSQL 9.4.10:

update 100000

update 120000

update 140000

update 160000

update 180000

Update all

Vacuum

org.postgresql.util.PSQLException: ERROR: unexpected chunk number 2285 (expected 0) for toast value 187504167 in pg_toast_187504156

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)

        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)

        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)

        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)

        at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:78)

        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:157)

        at Start.execute(Start.java:118)

        at Start.main(Start.java:20)

=========================================

New attempt - number 2

Inserting the rows

Executing  0

Executing  40000

Executing  80000

Executing  120000

Executing  160000

Executing  200000


Thank you for trying :)

Best wishes,
Harry

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux