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
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, .... |