Skip site navigation (1) Skip section navigation (2)

Bug #920: The PostgreSql Server goes down

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #920: The PostgreSql Server goes down
Date: 2003-03-26 06:49:47
Message-ID: 20030326064947.0D280476178@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Kallol Nandi (kallol(at)aworkflow(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
The PostgreSql Server goes down

Long Description
Hi,

I am facing this problem when I start the PostgreSql database server and query any of the database.All the processes are terminated and then the server goes down .
What might the problem? Is there any configuration settings that I might have missed out? Please help.

----------------------------------------------------------------------

bwicdb=# select * from batch_instance;
FATAL 2:  open of /usr/share/postgresql/data/pg_clog/0C81 failed: No such file or directory
FATAL 2:  open of /usr/share/postgresql/data/pg_clog/0C81 failed: No such file or directory server closed the connection unexpectedly
        This probably means the server terminated abnormally before or
while processing the request.
The connection to the server was lost. Attempting reset: DEBUG:  server process (pid 1328) exited with exit code 2
DEBUG:  terminating any other active server processes
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.
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.
Failed.
!# DEBUG:  all server processes terminated; reinitializing shared memory and semaphores 
IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not
enough core 
This error usually means that PostgreSQL's request for a shared memory
segment exceeded available memory or swap space.
To reduce the request size (currently 1441792 bytes), reduce PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).
 
The PostgreSQL Administrator's Guide contains more information about shared memory configuration.
----------------------------------------------------------------------

Eagerly awaiting a reply.

Thanks and Regards,
Kallol.

Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2003-03-26 07:17:12
Subject: Re: Postgresql 7.3.2 Crash
Previous:From: kallol@aworkflow.comDate: 2003-03-26 04:24:51
Subject: PostgreSql Server Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group