Re: [HACKERS] tuplesort: unexpected end of data

NunoACHenriques <[EMAIL PROTECTED]> writes: > A different error today: > [MemoryContextAlloc: invalid request size 4294967295] This could be a variant of the same problem: instead of getting a zero tuple length from the sort temp file, we're reading a -1 tuple length. Still no way to tell i

Re: [HACKERS] tuplesort: unexpected end of data

Hi! A different error today: [MemoryContextAlloc: invalid request size 4294967295] This is a more often (twice a week) error and I don't understand why?... I'm verifying the machine: fsck (with bad blocks chk), ... but no hardware problems untill now. -

Re: [HACKERS] tuplesort: unexpected end of data

NunoACHenriques <[EMAIL PROTECTED]> 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 ex

Re: [HACKERS] tuplesort: unexpected end of data

On Sun, 9 Jun 2002, Tom Lane wrote: >Can't you set up a situation where the failure is reproducible, then? >On a day where you get the failure, dump the database and see if >you can load the data into a fresh database and reproduce the problem. > Ok, I will do that... >I don't necessaril

Re: [HACKERS] tuplesort: unexpected end of data

NunoACHenriques <[EMAIL PROTECTED]> writes: > On Sun, 9 Jun 2002, Tom Lane wrote: >> Is the data in the tables changing constantly? > Not constantly, once a day. Can't you set up a situation where the failure is reproducible, then? On a day where you get the failure, dump the database and

Re: [HACKERS] tuplesort: unexpected end of data

Hi! On Sun, 9 Jun 2002, Tom Lane wrote: >Is the data in the tables changing constantly? If you can repeat the >same query on the same data and get varying results, then we're >dealing with something odder than I suspected. > > regards, tom lane > Not const

Re: [HACKERS] tuplesort: unexpected end of data

NunoACHenriques <[EMAIL PROTECTED]> writes: > I should say that this error is a non-deterministic one. It happened > once/twenty... Is the data in the tables changing constantly? If you can repeat the same query on the same data and get varying results, then we're dealing with something o

Re: [HACKERS] tuplesort: unexpected end of data

Hi! I should say that this error is a non-deterministic one. It happened once/twenty... ---explain info- spid=> explain insert into warehouse_tmp (uri, expression, n, relevance, spid_measure, size, title, sample) spid-

Re: [HACKERS] tuplesort: unexpected end of data

NunoACHenriques <[EMAIL PROTECTED]> writes: > Jun 2 06:29:37 srv31 postgres[2986]: [57279] ERROR: tuplesort: unexpected end of >data Hmm. This is an internal consistency check in the sort code. Perhaps you've found a bug, but there's not enough info here to do much. Can you provide the EXPL

[HACKERS] tuplesort: unexpected end of data

Hi all! First of all, thanks for your fine job and the answers to a problem (which I thought it was a PG bug) I posted some days ago. I've solved it! Now I've got another strange issue to post... Briefing: the program runs daily and this (please see below) error