Thread: all server processes terminated; reinitializing

all server processes terminated; reinitializing

From
"2000 Informatica"
Date:

Estou usando PostgreSQL 8.0.2 instalado no linux Fedora FC2.

Esta é a messagem gravada no meu "serverlog":

WARNING: terminating connection because of crash of another server process

DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

HINT: In a moment you should be able to reconnect to the database and repeat your command.

LOG: all server processes terminated; reinitializing

LOG: database system was interrupted at 2005-05-04 11:39:53 BRT

LOG: checkpoint record is at 0/6CE514D8

LOG: redo record is at 0/6CE514D8; undo record is at 0/0; shutdown TRUE

LOG: next transaction ID: 1229401; next OID: 2226116

LOG: database system was not properly shut down; automatic recovery in progress

LOG: redo starts at 0/6CE51514

LOG: unexpected pageaddr 0/65E5E000 in log file 0, segment 108, offset 15065088

LOG: redo done at 0/6CE5DD24

LOG: database system is ready

 

Como devo proceder?

 

Re: all server processes terminated; reinitializing

From
Markus Schaber
Date:
Hallo, 2000 Informatica,

2000 Informatica wrote:
> Estou usando PostgreSQL 8.0.2 instalado no linux Fedora FC2.
> 
> Esta é a messagem gravada no meu "serverlog":
> 
> WARNING: terminating connection because of crash of another server process
> 
> DETAIL: The postmaster has commanded this server process to roll back
> the current transaction and exit, because another server process exited
> abnormally and possibly corrupted shared memory.

Diese Fehlermeldungen bedeuten, dass ein anderer Prozess des Servers
(also eine andere Verbindung) als die, die diese Logmeldungen
geschrieben hat, abgestürzt ist.

PostgreSQL startet in so einem Fall sicherheitshalber alle Backends neu.

Hoffe, das Hilft,
Schabi