Postgres 7.0.3 Dying

From: Andre Schubert <andre(dot)schubert(at)geyer(dot)kabeljournal(dot)de>
To: psql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres 7.0.3 Dying
Date: 2001-05-22 07:11:18
Message-ID: 3B0A1116.B72E31FF@geyer.kabeljournal.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I have a problem with my Postgres Server.
The last time the servers terminates itself and the following entries in
the log files are written, but i don't no what they say.
I'am running Postgres 7.0.3
On RedHat Immunix 6.2

*********************************************************************
Log-Entries( Debug-Level 2 )

/usr/bin/postmaster: BackendStartup: pid 20840 user nw_manager db
db_netzwerkmanagement socket 5
010517.09:39:35.133 [20840] read_pg_options: verbose=2,query=2,syslog=0
FindExec: found "/usr/bin/postgres" using argv[0]
010517.09:39:35.134 [20840] started: host=213.68.241.40 user=nw_manager
database=db_netzwerkmanagement
010517.09:39:35.134 [20840] InitPostgres
010517.09:39:35.142 [20840] reset_client_encoding()..
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 20839 exited with status 0
010517.09:39:35.142 [20840] reset_client_encoding() done.
010517.09:39:35.143 [20840] StartTransactionCommand
010517.09:39:35.143 [20840] query: select getdatabaseencoding()
out of dynamic memory in yy_create_buffer()
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 20840 exited with status 512
Server process (pid 20840) exited with status 512 at Thu May 17 09:39:35
2001
Terminating any active server processes...
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20606
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20497
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 15454
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 15453
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 15057
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 5976
010517.09:39:35.179 [15454] 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.
010517.09:39:35.186 [15453] 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.
010517.09:39:35.194 [15057] 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.
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 15454 exited with status 256
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20606
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20497
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 15453
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 15057
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 5976
/usr/bin/postmaster: CleanupProc: pid 15453 exited with status 256
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20606
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20497
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 15057
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 5976
/usr/bin/postmaster: CleanupProc: pid 15057 exited with status 256
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20606
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20497
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 5976
010517.09:39:35.204 [20497] 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.
010517.09:39:35.215 [20606] 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.
010517.09:39:35.226 [5976] 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.
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 20606 exited with status 256
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 20497
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 5976
/usr/bin/postmaster: CleanupProc: pid 20497 exited with status 256
/usr/bin/postmaster: CleanupProc: sending SIGUSR1 to process 5976
/usr/bin/postmaster: CleanupProc: pid 5976 exited with status 256
Server processes were terminated at Thu May 17 09:39:35 2001
Reinitializing shared memory and semaphores
010517.09:39:35.229 [5434] shmem_exit(0)
010517.09:39:35.232 [5434] IpcMemoryCreate: shmget failed (Das
Argument ist ungültig) key=5432101, size=17627136, permission=600
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
010517.09:39:35.232 [5434] FATAL 1: ShmemCreate: cannot create region
010517.09:39:35.232 [5434] proc_exit(0)
010517.09:39:35.232 [5434] shmem_exit(0)
010517.09:39:35.298 [5434] exit(0)
postmaster successfully started up.
FindExec: found "/usr/bin/postgres" using argv[0]
010517.09:53:36.224 [20963] DEBUG: Data Base System is starting up at
Thu
May 17 09:53:36 2001
010517.09:53:36.239 [20963] DEBUG: Data Base System was interrupted
being
in production at Fri May 11 11:07:50 2001
010517.09:53:36.250 [20963] DEBUG: Data Base System is in production
state

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomasz Misterka 2001-05-22 08:18:32 user delete problem
Previous Message Dronamraju Rajesh 2001-05-22 06:50:12 Re: cannot connect using terminal nor pgaccess