Re: tuplesort error from create index (?) - Mailing list pgsql-general

From Darren Ferguson
Subject Re: tuplesort error from create index (?)
Date
Msg-id Pine.LNX.4.10.10201021433520.9585-100000@thread.crystalballinc.com
Whole thread Raw
In response to Re: tuplesort error from create index (?)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Stay away from 2.4.15. It had file system problems which were severe
Apart from that the 2.4.17 is reliable.

Never used the 2.4.16

Darren

Darren Ferguson

On Wed, 2 Jan 2002, Tom Lane wrote:

> "Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> > I am running Postgres 7.1 on Mandrake Linux 8.0,
> > kernel version 2.4.16.
>
> Could you upgrade to PG 7.1.3 and see if the problem is still there?
>
> > I am trying to create an index on a table:
> > database=> create index key_i on class (contract, memberid, date)
> > and I get the following error:
> > ERROR:  tuplesort: unexpected end of data
>
> Weird.  Is it possible you are running out of disk space?  (The sort to
> create the index is probably using temporary disk files.)  I should
> think that you'd get an error saying that, though, not this error.
>
> If you have lots of disk space, it'd be worth trying to pg_dump the
> table, load it into a newly created database, and see if the error can
> be reproduced on that fresh copy.  Knowing whether the error can be
> reproduced outside your existing database would be helpful.
>
>             regards, tom lane
>
> PS: does anyone know if there are any serious bugs in Linux 2.4.16?
> I recall hearing about some hasty updates of recent kernels, but am
> not up-to-date on which versions to avoid.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>


pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re:
Next
From: "Jeffrey W. Baker"
Date:
Subject: Re: PostgreSQL GUI