Обсуждение: Postgres 7.0.3 Dying

Поиск
Список
Период
Сортировка

Postgres 7.0.3 Dying

От
Andre Schubert
Дата:
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



Re: Postgres 7.0.3 Dying

От
Tom Lane
Дата:
Andre Schubert <andre.schubert@geyer.kabeljournal.de> writes:
> 010517.09:39:35.143 [20840] query: select getdatabaseencoding()
> out of dynamic memory in yy_create_buffer()

Hm.  Apparently, there is almost no free memory in your system;
perhaps you need more swap space?

            regards, tom lane