Re: Regard to PANIC: unexpected hash relation size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vlastimil Krejcir <krejcir(at)ics(dot)muni(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Regard to PANIC: unexpected hash relation size
Date: 2007-04-13 15:08:54
Message-ID: 19309.1176476934@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vlastimil Krejcir <krejcir(at)ics(dot)muni(dot)cz> writes:
> I have PostgreSQL running for one and half year without any issues until
> yesterday. I get this:

> PANIC: unexpected hash relation size: 122, should be 4
> server closed the connection unexpectedly

> I have PostgreSQL 8.1.5 on SunOS (5.10 Generic_118833-36 sun4u sparc
> SUNW,Sun-Fire-V445).

Mmm ... I don't think so, since AFAICT that message string is not
present in 8.1.5. Please recheck the server version.

If you can put together a reproducible test case for this, we should
be able to fix it, but right now there's not enough info available to
guess what's going wrong. FWIW, I imagine that a test case would
involve a specific sequence of data inserted into a hash index.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nitin Verma 2007-04-13 15:10:10 Re: ERROR: XLogFlush: request
Previous Message Martin Gainty 2007-04-13 14:52:49 Re: Is there a shortage of postgresql skilled ops people