versao postgresql-8.4.6-1
Windows 7

Em 16/12/2011 12:12, Flavio Henrique Araque Gurgel escreveu:
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

<<attachment: cgcesarsoares.vcf>>

_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a