Re: [GENERAL] Getting TOAST errors

2011-09-19 Thread Tim Uckun
> > A self-contained test case (code and data) that triggers the error. > If it only does so probabilistically, once in every-so-many runs, > that's fine. I'll see what I can do. Give me a few days. Cheers. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Getting TOAST errors

2011-09-19 Thread Tom Lane
Tim Uckun writes: >> Well, I'm not asking for perfect reproducibility --- a test case that >> fails even 1% of the time would be great. > What exactly do you need? A self-contained test case (code and data) that triggers the error. If it only does so probabilistically, once in every-so-many runs

Re: [GENERAL] Getting TOAST errors

2011-09-19 Thread Tim Uckun
> >> Not really. I have a nightly process which downloads data and sticks >> it into a text field. Afterwards another process reads that text data >> and processes it creating rows in another table. The problem occurs in >> the last step and at seemingly random intervals. For example one time >> it

Re: [GENERAL] Getting TOAST errors

2011-09-19 Thread Tom Lane
Tim Uckun writes: >> Hard to tell. We've seen enough reports like that to make it seem like >> there may be some bug buried there, but no one has provided anything to >> do any debugging work with. Can you create a reproducible test case? > Not really. I have a nightly process which downloads dat

Re: [GENERAL] Getting TOAST errors

2011-09-19 Thread Tim Uckun
> > Hard to tell.  We've seen enough reports like that to make it seem like > there may be some bug buried there, but no one has provided anything to > do any debugging work with.  Can you create a reproducible test case? Not really. I have a nightly process which downloads data and sticks it into

Re: [GENERAL] Getting TOAST errors

2011-09-19 Thread Tom Lane
Tim Uckun writes: > I am occasionally getting this kind of error when attempting a SELECT > statement. > PGError: ERROR: missing chunk number 0 for toast value 27143 in > pg_toast_2619 > What does this mean? Is some sort of corruption creeping into the database? Hard to tell. We've seen enou

[GENERAL] Getting TOAST errors

2011-09-19 Thread Tim Uckun
I am occasionally getting this kind of error when attempting a SELECT statement. PGError: ERROR: missing chunk number 0 for toast value 27143 in pg_toast_2619 What does this mean? Is some sort of corruption creeping into the database? Postgres 9.0 linux. -- Sent via pgsql-general mailing lis