Re: [GENERAL] missing chunk number 0 for toast value 25693266 in pg_toast_25497233

2010-05-07 Thread Bryan Murphy
On Fri, May 7, 2010 at 9:02 AM, Magnus Hagander wrote: > Try doing a binary search with LIMIT. E.g., if you have 20M reecords, > do a SELECT * FROM ... LIMIT 10M. (throw away the results) If that > broke, check the upper half, if not, check the lower one (with > OFFSET). > > If you have a serial p

Re: [GENERAL] missing chunk number 0 for toast value 25693266 in pg_toast_25497233

2010-05-07 Thread Magnus Hagander
On Fri, May 7, 2010 at 01:24, Bryan Murphy wrote: > I'm running into this issue again: > > psql --version > psql (PostgreSQL) 8.3.7 > > COPY items_extended TO '/dev/null'; > ERROR:  missing chunk number 0 for toast value 25693266 in pg_toast_25497233 > > Unfortunately, I do not know where these ar

[GENERAL] missing chunk number 0 for toast value 25693266 in pg_toast_25497233

2010-05-06 Thread Bryan Murphy
I'm running into this issue again: psql --version psql (PostgreSQL) 8.3.7 COPY items_extended TO '/dev/null'; ERROR: missing chunk number 0 for toast value 25693266 in pg_toast_25497233 Unfortunately, I do not know where these are coming from and I cannot replicate the data in at least one of m

[GENERAL] missing chunk number 0 for toast value when pg_dump??

2008-08-03 Thread Yi Zhao
hi, all: I use pg_dump command to dump a specified table: pg_dump mydb -p -Uyahoo -t mytable -D -a > /export/dump.sql but, I got this: --- pg_dump: SQL command failed pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 14319826 pg_dump: The

Re: [GENERAL] missing chunk number 0 for toast value xxxxx

2006-08-05 Thread Robby Russell
On Aug 5, 2006, at 4:29 PM, Robby Russell wrote: I'm seeing this weird issue pop up on one a database. This seems to work... robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE title ~* 'postgresql' LIMIT 20; count --- 19 (1 row) ...but these two seem to be causing an err

[GENERAL] missing chunk number 0 for toast value xxxxx

2006-08-05 Thread Robby Russell
I'm seeing this weird issue pop up on one a database. This seems to work... robbyonrails_typo_dev=# SELECT count(id) FROM contents WHERE title ~* 'postgresql' LIMIT 20; count --- 19 (1 row) ...but these two seem to be causing an error now. robbyonrails_typo_dev=# SELECT count(id) FR

[GENERAL] missing chunk number 0 for toast value ...

2005-07-19 Thread Hubert Fröhlich
Hi list, I am working with postgres 8.0.3 on a HP Pro Liant Xeon box under SuSE Linux 9.1 When dumping a database, I got the error pg_dump: SQL command to dump the contents of table "bearbeitungsschritt" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: missing chunk nu

Re: [GENERAL] missing chunk number 0 for toast value

2005-04-27 Thread Ed L.
On Wednesday April 27 2005 6:11 pm, Tom Lane wrote: > "Ed L." <[EMAIL PROTECTED]> writes: > > Does this shed any light? pg_toast_6221538 is the relevant > > toast table... > > > > $ psql -c "set enable_indexscan=off; select chunk_seq, > > length(chunk_data) from pg_toast.pg_toast_6221538 where > >

Re: [GENERAL] missing chunk number 0 for toast value

2005-04-27 Thread Tom Lane
"Ed L." <[EMAIL PROTECTED]> writes: > Does this shed any light? pg_toast_6221538 is the relevant toast > table... > $ psql -c "set enable_indexscan=off; select chunk_seq, > length(chunk_data) from pg_toast.pg_toast_6221538 where chunk_id > = 19319495 order by chunk_seq;" > chunk_seq | length

Re: [GENERAL] missing chunk number 0 for toast value

2005-04-27 Thread Ed L.
On Wednesday April 27 2005 4:40 pm, Tom Lane wrote: > "Ed L." <[EMAIL PROTECTED]> writes: > > On Wednesday April 27 2005 3:55 pm, Tom Lane wrote: > >> Have you tried REINDEXing the toast table in question? > > > > Not yet. Any way to repair it without blocking concurrent > > access? > > Unlikely.

Re: [GENERAL] missing chunk number 0 for toast value

2005-04-27 Thread Tom Lane
"Ed L." <[EMAIL PROTECTED]> writes: > On Wednesday April 27 2005 3:55 pm, Tom Lane wrote: >> Have you tried REINDEXing the toast table in question? > Not yet. Any way to repair it without blocking concurrent > access? Unlikely. But the lock will only affect operations that need to touch toaste

Re: [GENERAL] missing chunk number 0 for toast value

2005-04-27 Thread Ed L.
On Wednesday April 27 2005 3:55 pm, Tom Lane wrote: > > ERROR: Âmissing chunk number 0 for toast value 19319495 > > ERROR: Âunexpected chunk number 4 (expected 0) for toast > > value 19319495 > > Have you tried REINDEXing the toast table in question? Not yet. Any way to repair it without blocking

Re: [GENERAL] missing chunk number 0 for toast value

2005-04-27 Thread Tom Lane
"Ed L." <[EMAIL PROTECTED]> writes: > This is for PostgreSQL 7.4.6 on hppa2.0w-hp-hpux11.00, compiled > by GCC 3.2.2. I'm seeing the following 2 errors: > ERROR: missing chunk number 0 for toast value 19319495 > ERROR: unexpected chunk number 4 (expected 0) for toast value > 19319495 Have yo

[GENERAL] missing chunk number 0 for toast value

2005-04-27 Thread Ed L.
This is for PostgreSQL 7.4.6 on hppa2.0w-hp-hpux11.00, compiled by GCC 3.2.2. I'm seeing the following 2 errors: ERROR: missing chunk number 0 for toast value 19319495 ERROR: unexpected chunk number 4 (expected 0) for toast value 19319495 It is always the same toast value. The table has 1.