SMgrRelation hashtable corrupted

Started by Postgresqlover 21 years ago3 messagesgeneral
Jump to latest
#1Postgresql
postgresql@troygeek.com

Hello,

I'm building a small web app (written in JSP) and using PostgreSQL 8.0 Beta
2 as the backend running on Windows XP (installed with pgInstaller).
Ocassionally, I get this SQLException message in my web page:

"SMgrRelation hashtable corrupted"

If I refresh the web page it error goes away. I searched the lists and it
looked like someone got this with beta 1. Just wondering if anyone found a
solution.

Thanks!

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Postgresql (#1)
Re: SMgrRelation hashtable corrupted

"TroyGeek" <postgresql@troygeek.com> writes:

I'm building a small web app (written in JSP) and using PostgreSQL 8.0 Beta
2 as the backend running on Windows XP (installed with pgInstaller).
Ocassionally, I get this SQLException message in my web page:
"SMgrRelation hashtable corrupted"

I suspect this is a dangling-reference problem, but I don't see where it
could be coming from. Can you provide a test case?

regards, tom lane

#3Chris Ochs
chris@paymentonline.com
In reply to: Postgresql (#1)
Re: SMgrRelation hashtable corrupted

Just an FYI, I got this before while doing a bunch of alter table statements, and I got it again just a few minutes ago doing the same thing, only this time I was doing the the alter table while vacuum was running, and it was vacuum that gave me the error "SMgrRelation hashtable corrupted".

This is on beta1/Freebsd 5.2.1.

Chris
----- Original Message -----
From: TroyGeek
To: Pgsql-General
Sent: Saturday, September 25, 2004 2:26 PM
Subject: [GENERAL] SMgrRelation hashtable corrupted

Hello,

I'm building a small web app (written in JSP) and using PostgreSQL 8.0 Beta 2 as the backend running on Windows XP (installed with pgInstaller). Ocassionally, I get this SQLException message in my web page:

"SMgrRelation hashtable corrupted"

If I refresh the web page it error goes away. I searched the lists and it looked like someone got this with beta 1. Just wondering if anyone found a solution.

Thanks!