Parada inesperada del servidor.

From: "Dimas Ayala" <dimasayala(at)gmail(dot)com>
To: "Postgres Espaniol" <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Parada inesperada del servidor.
Date: 2006-08-07 15:33:27
Message-ID: fd8818d50608070833m1b9e8e52xf18cae041a6babf1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hoy en la mañana que llege a la empresa me encontre con la sorpresa que mi
servidor postgres estaba Parado... Los usuarios dejaron de accesar al server
desde el 04 al 06 de Agosto por vacaciones aqui en El Salvador..

Pero el 05 de Agosto el servidor se Paro.. REvisando el Log encontre lo
siguiente...
Esto es todo lo que tiene el log del 04 de agosto. Porque nadie se conecto
ese dia.
<root%[local]%2006-08-04 04:30:31 CST>LOG: transaction ID wrap limit is
1074781911, limited by database "migracion"
<root%[local]%2006-08-04 04:30:31 CST>LOG: transaction ID wrap limit is
1074781911, limited by database "migracion"
<root%[local]%2006-08-04 20:00:01 CST>FATAL: database "migracionOC" does
not exist

Esto es todo lo que tiene el log del 05 de agosto. Porque nadie se conecto
ese dia. Pero aqui es donde el server se paro.. Y nadie estuvo en la empresa
ese dia..

<%%2006-08-05 04:31:06 CST>LOG: archived transaction log file
"00000001000000000000004B"
<root%[local]%2006-08-05 04:33:35 CST>LOG: transaction ID wrap limit is
1074782037, limited by database "migracion"
<root%[local]%2006-08-05 04:33:35 CST>LOG: transaction ID wrap limit is
1074782037, limited by database "migracion"
<%%2006-08-05 15:32:09 CST>LOG: logger shutting down

Log del 07 de agosto..
<%%2006-08-07 08:24:11 CST>LOG: database system was interrupted at
2006-08-05 04:35:40 CST
<%%2006-08-07 08:24:11 CST>WARNING: autovacuum not started because of
misconfiguration
<%%2006-08-07 08:24:11 CST>HINT: Enable options "stats_start_collector" and
"stats_row_level".
<%%2006-08-07 08:24:11 CST>LOG: checkpoint record is at 0/4C563E08
<%%2006-08-07 08:24:11 CST>LOG: redo record is at 0/4C563E08; undo record
is at 0/0; shutdown FALSE
<%%2006-08-07 08:24:11 CST>LOG: next transaction ID: 1040338; next OID:
61449
<%%2006-08-07 08:24:11 CST>LOG: next MultiXactId: 599; next
MultiXactOffset: 49698
<%%2006-08-07 08:24:11 CST>LOG: database system was not properly shut down;
automatic recovery in progress
<%%2006-08-07 08:24:11 CST>LOG: record with zero length at 0/4C563E4C
<%%2006-08-07 08:24:11 CST>LOG: redo is not required
<%%2006-08-07 08:24:11 CST>LOG: database system is ready
<%%2006-08-07 08:24:11 CST>LOG: transaction ID wrap limit is 1074782037,
limited by database "migracion"

Cualquier comentario es bien venido..

Adios

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Juanpe 2006-08-07 17:33:51 Procedimiento almacenado en C
Previous Message Patricio Cifuentes Ithal 2006-08-07 14:53:42 Re: Delete de filas que no sean esta, ni esta, ....