pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
[pgsql] How bad is this full vacuum error? 2+ messages / 2 participants [nested] [flat]
* [pgsql] How bad is this full vacuum error? @ 2012-08-01 15:43 Gary Webster <webster@lexmark.com> 2012-08-01 20:18 ` Re: [pgsql] How bad is this full vacuum error? Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Gary Webster @ 2012-08-01 15:43 UTC (permalink / raw) To: pgsql-admin Hello. How bad is this? 2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 ERROR: missing chunk number 0 for toast value 1086399 in pg_toast_987417 2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 STATEMENT: VACUUM (FULL); Does this mean I have db corruption, or just that the vacuum quit? Thanks. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [pgsql] How bad is this full vacuum error? 2012-08-01 15:43 [pgsql] How bad is this full vacuum error? Gary Webster <webster@lexmark.com> @ 2012-08-01 20:18 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2012-08-01 20:18 UTC (permalink / raw) To: Gary Webster <webster@lexmark.com>; +Cc: pgsql-admin Gary Webster <webster@lexmark.com> writes: > How bad is this? > 2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 ERROR: missing > chunk number 0 for toast value 1086399 in pg_toast_987417 > 2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 STATEMENT: VACUUM > (FULL); If it's repeatable, it's corrupted data :-(. If it just happened once, and doesn't recur on the next try, it might have been related to a system catalog race condition that we fixed last fall. (What PG version are you running?) I'm unsure about that though, because the toast table name seems to indicate that it's for a user table not a system catalog, and I'm not very sure why VACUUM would be doing toast dereferences into a user table. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-08-01 20:18 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-08-01 15:43 [pgsql] How bad is this full vacuum error? Gary Webster <webster@lexmark.com> 2012-08-01 20:18 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox