| 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: | Whole Thread | Raw Message | 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
| 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 |