Thread: Help needed.
Hi there,
I have a problem with postgres. One of my table hold about 65,000 records. If I use the simple select * on this table, the pgadmin tool hangs and the postgres throws up the following exception.
"NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request."
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request."
I wonder what could be wrong. I increased the the buffer size from 256 to 512. Still the same thing.
Could you kindly let me know what could be wrong and what is the resolution.
Thanks,
Naveen
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
On Mon, 27 May 2002 16:04:49 +0530 "Naveen Kaul" <naveenk@systelinc.com> wrote: > Hi there, > > I have a problem with postgres. What version of PostgreSQL is this? (do "select version();") > One of my table hold about 65,000 records. If I use the simple > select * on this table, the pgadmin tool hangs and the postgres > throws up the following exception. <snip> Can you get a stack backtrace? (rebuild with debugging enabled, get the backend to crash, and run gdb on the core-file that will be produced). Cheers, Neil -- Neil Conway <neilconway@rogers.com> PGP Key ID: DB3C29FC