Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100

Поиск
Список
Период
Сортировка
От Harry Ambrose
Тема Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
Дата
Msg-id CAK4Knu8QBqvNfgGKz8_atGceis=KYzSHo0G4mG96pKnkmyzm+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Harry Ambrose
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
Следующее
От: Olav Gjerde
Дата:
Сообщение: Re: [GENERAL] Timezone locale consistency for functional indexes