Postgres Pro
Downloads
Home   >   mailing lists

Re: PANIC: unexpected hash relation size - Mailing list pgsql-general

From Tom Lane
Subject Re: PANIC: unexpected hash relation size
Date
Msg-id 20045.1175270545@sss.pgh.pa.us
Whole thread Raw
In response to PANIC: unexpected hash relation size  (Csaba Kalman <csaba818@freemail.hu>)
Responses Re: unexpected data beyond EOF and character encoding  (Jaime Silvela <JSilvela@Bear.com>)
Re: PANIC: unexpected hash relation size  (csaba <csaba818@freemail.hu>)
List pgsql-general
Tree view 
Csaba Kalman <csaba818@freemail.hu> writes:
> I frequently get this error message:
> PANIC: unexpected hash relation size: X, should be Y
> There is no specific point where I get this error, it can occur anytime
> after a SELECT/INSERT/UPDATE. I've never got it after DELETE so far.

AFAICS this should only happen in INSERT/UPDATE, since it must be coming
from an attempt to insert an entry in a hash index.  What's the exact
schema of this table including indexes?

> Is it a bug, or I'm doing something wrong?

It's a bug, but you've not provided enough information to let anyone
reproduce or fix it.

            regards, tom lane

pgsql-general by date:

Previous
From: Max.Kaufmann@lazard.com
Date:
Subject: job opportunity with Hedge Fund - NYC
Next
From: Listmail
Date:
Subject: Re: Tsearch2 crashes my backend, ouch !