Re: tuplesort: unexpected end of data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: NunoACHenriques <nach(at)fct(dot)unl(dot)pt>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: tuplesort: unexpected end of data
Date: 2002-06-10 14:03:32
Message-ID: 5666.1023717812@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

NunoACHenriques <nach(at)fct(dot)unl(dot)pt> writes:
> Neither I believe it because the machine is well tested (including a
> 24h memtest). But there is something I can't get of my mind: once a day my
> app "forces" PG to "play" with some 3GB of disk data in a ext2 fs. It is
> known that sometimes ext2 corrupts data...

Unless you've got things set up so that the temporary files created for
the sorting step are in the ext2 partition, this doesn't seem like it
could be the source of the problem. A more plausible theory is that a
segment of main RAM is bad, but you happen not to use that part of RAM
except under heavy load (ie, while running this daily batch job).

Or it could just be a bug. If you can get a reproducible test case I'll
be happy to dig into it.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-06-10 14:04:49 Re: Missing types in C header files
Previous Message Tom Lane 2002-06-10 13:56:27 Re: Efficient DELETE Strategies