2011/12/16 Antonio Cesar <[email protected]>: > Pessoal alguem pode me ajudar meu banco esta processando um arquivo txt > atualizado uma determidanda tabela e do nada o servico para. > Segue o log. > > 2011-12-16 09:38:53 BRT LOG: database system was interrupted; last known up > at 2011-12-16 08:24:09 BRT > 2011-12-16 09:38:53 BRT LOG: database system was not properly shut down; > automatic recovery in progress > 2011-12-16 09:38:53 BRT LOG: redo starts at 16/ED000068 > 2011-12-16 09:38:53 BRT LOG: record with zero length at 16/ED001A40 > 2011-12-16 09:38:53 BRT LOG: redo done at 16/ED001978 > 2011-12-16 09:38:53 BRT LOG: last completed transaction was at log time > 2011-12-16 09:30:02.459-03 > 2011-12-16 09:38:53 BRT FATAL: the database system is starting up > 2011-12-16 09:38:53 BRT LOG: database system is ready to accept connections > 2011-12-16 09:38:53 BRT LOG: autovacuum launcher started > 2011-12-16 09:39:54 BRT LOG: server process (PID 5504) was terminated by > exception 0xC0000005 > 2011-12-16 09:39:54 BRT HINT: See C include file "ntstatus.h" for a > description of the hexadecimal value. > 2011-12-16 09:39:54 BRT LOG: terminating any other active server processes > 2011-12-16 09:39:54 BRT WARNING: terminating connection because of crash of > another server process > 2011-12-16 09:39:54 BRT 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. > 2011-12-16 09:39:54 BRT HINT: In a moment you should be able to reconnect > to the database and repeat your command. > 2011-12-16 09:39:54 BRT WARNING: terminating connection because of crash of > another server process > 2011-12-16 09:39:54 BRT 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. > 2011-12-16 09:39:54 BRT HINT: In a moment you should be able to reconnect > to the database and repeat your command. > 2011-12-16 09:39:54 BRT LOG: all server processes terminated; > reinitializing > 2011-12-16 09:40:04 BRT FATAL: pre-existing shared memory block is still in > use > 2011-12-16 09:40:04 BRT HINT: Check if there are any old server processes > still running, and terminate them.
Versão do PostgreSQL e do Windows, por favor. Tem um bug já corrigido na versão 8.4.1, se for o caso, atualize. []s Flavio Gurgel _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
