From: | "Paulina Quezada" <paulina(dot)quezada(at)gmail(dot)com> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Servidor no se recupera despues de una caida... |
Date: | 2007-01-04 14:05:34 |
Message-ID: | 3babf2fc0701040605y7a9fde6ew1c34d25b675858d9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola, tengo problemas con mi servidor postgres, ya van dos caídas desde ayer
y no ha podido recuperarse, he tenido que volver a instalar postgres y crear
nuevamente la base de datos con el último respaldo con pérdida de datos en
el tiempo en que estaba funcionando ya que el sistema está en producción.
El servidor está en corriendo bajo Windows, no hay problemas de espacio en
disco, ni velocidad de procesador, lo que si, no he cambiado ningún
parámetro de configuración del postgres, dejé lo que está por default (eso
podria tener que ver en las caidas?) El sistema ha estado funcionando
relativamente desde noviembre y ayer fue la primera caida y hoy en la tarde
la segunda, en las dos no se pudo recuperar.
Revisando el log estos son los mensajes antes de la caida:
2007-01-02 08:19:40 LOG: received fast shutdown request
2007-01-02 08:19:40 LOG: aborting any active transactions
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:40 FATAL: terminating connection due to administrator
command
2007-01-02 08:19:57 LOG: checkpoints are occurring too frequently (16
seconds apart)
2007-01-02 08:19:57 HINT: Consider increasing the configuration parameter
"checkpoint_segments".
2007-01-02 08:20:02 FATAL: terminating connection due to administrator
command
2007-01-02 08:20:07 LOG: shutting down
Y al tratar de recuperarse este es el log:
2007-01-02 08:21:32 LOG: database system shutdown was interrupted at
2007-01-02 08:20:07 Hora est. del Pacífico de SA
2007-01-02 08:21:32 LOG: checkpoint record is at 3/7E043F20
2007-01-02 08:21:32 LOG: redo record is at 3/7E037ED8; undo record is at
0/0; shutdown FALSE
2007-01-02 08:21:32 LOG: next transaction ID: 1791243; next OID: 1550932
2007-01-02 08:21:32 LOG: database system was not properly shut down;
automatic recovery in progress
2007-01-02 08:21:32 LOG: redo starts at 3/7E037ED8
2007-01-02 08:21:33 PANIC: could not open relation 1663/18515/1545642: No
such file or directory
This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.
2007-01-02 08:21:33 LOG: startup process (PID 1492) was terminated by
signal 3
2007-01-02 08:21:33 LOG: aborting startup due to startup process failure
2007-01-02 08:21:33 LOG: logger shutting down
En la segunda caída este fue el log:
2007-01-03 14:46:29 LOG: received fast shutdown request
2007-01-03 14:46:29 LOG: aborting any active transactions
2007-01-03 14:46:29 FATAL: terminating connection due to administrator
command
2007-01-03 14:46:29 FATAL: terminating connection due to administrator
command
2007-01-03 14:46:29 LOG: checkpoints are occurring too frequently (0
seconds apart)
2007-01-03 14:46:29 HINT: Consider increasing the configuration parameter
"checkpoint_segments".
2007-01-03 14:46:29 FATAL: terminating connection due to administrator
command
2007-01-03 14:46:29 FATAL: terminating connection due to administrator
command
2007-01-03 14:46:50 LOG: server process (PID 3480) was terminated by signal
58
2007-01-03 14:46:50 LOG: terminating any other active server processes
2007-01-03 14:46:50 WARNING: terminating connection because of crash of
another server process
2007-01-03 14:46:50 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.
2007-01-03 14:46:50 HINT: In a moment you should be able to reconnect to
the database and repeat your command.
2007-01-03 14:46:51 FATAL: terminating connection due to administrator
command
2007-01-03 14:46:51 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.
2007-01-03 14:46:51 HINT: In a moment you should be able to reconnect to
the database and repeat your command.
2007-01-03 14:46:51 WARNING: terminating connection because of crash of
another server process
2007-01-03 14:46:52 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.
2007-01-03 14:46:52 HINT: In a moment you should be able to reconnect to
the database and repeat your command.
2007-01-03 14:46:52 WARNING: terminating connection because of crash of
another server process
…
2007-01-03 14:47:01 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.
2007-01-03 14:47:01 HINT: In a moment you should be able to reconnect to
the database and repeat your command.
2007-01-03 14:47:08 LOG: all server processes terminated; reinitializing
Si alguien me puede ayudar les agradecería muchísimo, ya que la verdad estoy
muy preocupada porque no puedo asegurar la confiabilidad en la base de
datos.
Att,
Paulina Quezada
From | Date | Subject | |
---|---|---|---|
Next Message | Sonia Malave | 2007-01-04 14:13:42 | Ayuda! |
Previous Message | dAnkO Vera | 2007-01-04 13:44:21 | al importar pasaron comillas en una tabla |