Forum OpenACS Q&A: postgresql random errors

Collapse
1: postgresql random errors
Posted by Gilbert Wong on 10/31/00 07:33 AM
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
2: Response to postgresql random errors (response to 1)
Posted by Don Baccus on 10/31/00 01:50 PM
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.