Re: Still trouble reindexing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Still trouble reindexing
Date: 2003-07-02 06:57:32
Message-ID: 25320.1057129052@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Henrik Steffen" <steffen(at)city-map(dot)de> writes:
> this night I got the following error message while
> reindexing the same table that hat non-unique values
> the last days:

> DBD::Pg::st execute failed:
> ERROR: index_formtuple: data takes 536870936 bytes, max is 8191 [for
> statement ``REINDEX TABLE kundenstatistik''])

> Any hint what that could mean?

Ugh :-( ... looks like corrupt data to me, specifically a bad length
word in a variable-length field. Have you checked your disk hardware
lately?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-02 07:01:24 Re: Performance question
Previous Message Jean-Christian Imbeault 2003-07-02 06:56:52 Re: Performance question