Re: ERROR: shared buffer hash table corrupted

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ashish_postgre(at)yahoo(dot)co(dot)in
Cc: pggeneral <pgsql-general(at)postgresql(dot)org>, ashish(dot)karalkar(at)netcore(dot)co(dot)in
Subject: Re: ERROR: shared buffer hash table corrupted
Date: 2008-01-14 15:39:17
Message-ID: 14178.1200325157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in> writes:
> <table cellspacing='0' cellpadding='0' border='0' ><tr><td style="font: inherit;">Hello list members,<br>I hav a table with 140M rows. While I am trying to select the count from the table<br>I am getting following error<br><br>ERROR:&nbsp; shared buffer hash table corrupted<br><br>Can anybody please suggest me wht had gone wrong and how to fix it?<br><br>PostgreSQL 8.2.4<br>OS:Suse 10.3<br><br>With Regards<br>Ashish...<br><br></td></tr></table><br>
> <!--3--><hr size=1></hr> Save all your chat conversations. <a href="http://in.rd.yahoo.com/tagline_webmessenger_3/*http://in.messenger.yahoo.com/webmessengerpromo.php">Find them online.</a>

Please avoid posting in HTML on these lists ... or at least not HTML-only.

As to the problem, can you extract a reproducible test case? It
certainly seems like a bug, but it's not one I can recall hearing
of before.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-01-14 15:44:12 Re: tcp_keepalives_idle ignored
Previous Message Shelby Cain 2008-01-14 15:36:50 Re: ECPG problem with 8.3