Re: SMgrRelation hashtable corrupted - Mailing list pgsql-general

From Tom Lane
Subject Re: SMgrRelation hashtable corrupted
Date
Msg-id 2913.1094850928@sss.pgh.pa.us
Whole thread Raw
In response to SMgrRelation hashtable corrupted  ("Chris Ochs" <chris@paymentonline.com>)
List pgsql-general
"Chris Ochs" <chris@paymentonline.com> writes:
> On 8 beta1 I get 'SMgrRelation hashtable corrupted'  *sometimes* when
> executing the following, but only when there are other clients connecting to
> the same database.

Hmm.  The SMgrRelation hashtable is local in each backend, so I'm not
sure I believe the correlation to other backends being active, but ...

What I'd suggest doing is changing the elog(ERROR) to elog(PANIC)
(in smgrclose in src/backend/storage/smgr/smgr.c), rebuilding with
--enable-debug if you didn't already, and then getting a debugger
stack trace from the core dump next time it happens.

            regards, tom lane

pgsql-general by date:

Previous
From: Dan Sugalski
Date:
Subject: Speeding up LIKE with placeholders?
Next
From: Tom Lane
Date:
Subject: Re: Speeding up LIKE with placeholders?