Postgres Pro
Downloads
Home   >   mailing lists

Thread: SMgrRelation hashtable corrupted

SMgrRelation hashtable corrupted

From
"TroyGeek"
Date:

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!

Re: SMgrRelation hashtable corrupted

From
Tom Lane
Date:
"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

Re: SMgrRelation hashtable corrupted

From
"Chris"
Date:
 
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
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!