| From: | Harry Ambrose <harry(dot)ambrose(at)gmail(dot)com> |
|---|---|
| To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |
| Date: | 2017-06-12 13:01:10 |
| Message-ID: | CAK4Knu8QBqvNfgGKz8_atGceis=KYzSHo0G4mG96pKnkmyzm+A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Olav Gjerde | 2017-06-12 13:11:47 | Re: Timezone locale consistency for functional indexes |
| Previous Message | Harry Ambrose | 2017-06-12 12:57:05 | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |