Forum OpenACS Q&A: postgresql random errors

Collapse
Posted by Gilbert Wong on
Hi Guys, I get this error that happens randomly. It looks like a problem with postgresql itself and not my script. Have any of you encountered this problem before and if so, what is the fix? Thanks.
[30/Oct/2000:22:18:02][12092.225285][-conn45-] Error: nsd.db: error
(localhost::anime, FATAL 1:  btree: failed to add item to the page 
pqReadData() -- backend closed the channel 
unexpectedly.                        
        This probably means the backend terminated abnormally before 
or while processing the 
request):                                                             
Collapse
Posted by Don Baccus on
Is this happening on one table, or several tables?

A quick fix is to bring the system down, drop the index, and recreate it.  Try it and see if it stops happening for a bit, anyway.

I dimly recall seeing something about changing in index code in 7.0.2 (I think) causing sporadic errors like this but don't recall details.  You might poke around the Postgres site, reading the bugs and hackers  e-mail list archives for more clues.