BUG #16638: Some tables in the database cannot be opened

Started by PG Bug reporting formover 5 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 16638
Logged by: 雷 赵
Email address: 15103271955@163.com
PostgreSQL version: 9.6.12
Operating system: Ubuntu
Description:

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: BUG #16638: Some tables in the database cannot be opened

PG Bug reporting form <noreply@postgresql.org> writes:

The following bug has been logged on the website:
Bug reference: 16638
Logged by: 雷 赵
Email address: 15103271955@163.com
PostgreSQL version: 9.6.12
Operating system: Ubuntu
Description:

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

This symptom matches an old bug that was fixed in PG 9.6.9. So

(1) Are you quite sure your server is running 9.6.12, and not some
older minor release? Check "SELECT version()" to be certain.

(2) According to the release note about it, any pre-existing
corruption of this sort could be repaired by vacuuming affected
tables. So maybe you just need to do that.

regards, tom lane