Re: Interpretar errores en log

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Raúl Andrés Duque Murillo <ra_duque(at)yahoo(dot)com(dot)mx>
Cc: Lista - PostgreSQL <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: Interpretar errores en log
Date: 2009-11-05 12:53:43
Message-ID: 20091105125343.GA3694@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Raúl Andrés Duque Murillo escribió:
> Cordial saludo.
>
> Tengo estos errores en el log de una base de datos 8.3.7 bajo windows y no sé exactamente cómo interpretarlos:

¿Cuáles son los que te preocupan?

> 2009-11-03 06:29:39 COT 0 LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
> 2009-11-03 06:29:39 COT 127.0.0.1 0 FATAL: the database system is starting up
> 2009-11-03 06:29:39 COT 0 LOG: database system was interrupted; last known up at 2009-11-01 20:18:23 COT
> 2009-11-03 06:29:39 COT 0 LOG: database system was not properly shut down; automatic recovery in progress
> 2009-11-03 06:29:39 COT 0 LOG: redo starts at 4/30FCA600
> 2009-11-03 06:29:40 COT 0 LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
> 2009-11-03 06:29:40 COT 127.0.0.1 0 FATAL: the database system is starting up
> 2009-11-03 06:29:40 COT 0 LOG: unexpected pageaddr 4/2910A000 in log file 4, segment 49, offset 1089536
> 2009-11-03 06:29:40 COT 0 LOG: redo done at 4/31107600
> 2009-11-03 06:29:46 COT 0 LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
> 2009-11-03 06:29:46 COT 127.0.0.1 0 FATAL: the database system is starting up
> 2009-11-03 06:29:47 COT 0 LOG: database system is ready to accept connections
> 2009-11-03 06:29:47 COT 0 LOG: autovacuum launcher started
> ....
> 2009-11-03 22:42:44 COT 0 LOG: could not connect socket for statistics collector: Unknown winsock error 10061
> 2009-11-03 22:42:44 COT 0 LOG: disabling statistics collector for lack of working socket
> 2009-11-03 22:42:44 COT 0 WARNING: autovacuum not started because of misconfiguration
> 2009-11-03 22:42:44 COT 0 HINT: Enable the "track_counts" option.
> 2009-11-03 22:42:44 COT 0 LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
> 2009-11-03 22:42:44 COT 127.0.0.1 0 LOG: could not receive data from client: Unknown winsock error 10061
> 2009-11-03 22:42:44 COT 127.0.0.1 0 LOG: incomplete startup packet
> 2009-11-03 22:42:44 COT 0 LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
> 2009-11-03 22:42:44 COT 127.0.0.1 0 FATAL: the database system is starting up
> 2009-11-03 22:42:44 COT 0 LOG: database system was interrupted; last known up at 2009-11-03 18:44:53 COT
> 2009-11-03 22:42:44 COT 0 LOG: database system was not properly shut down; automatic recovery in progress
> 2009-11-03 22:42:44 COT 0 LOG: record with zero length at 4/31D88ED8
> 2009-11-03 22:42:44 COT 0 LOG: redo is not required
> 2009-11-03 22:42:45 COT 0 LOG: database system is ready to accept connections
>
>
> Atentamente,
>
> RAUL DUQUE
> Bogotá, Colombia
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature database 4566 (20091102) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>

--
Alvaro Herrera Vendo parcela en Valdivia: http://alvherre.cl/caboblanco
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Silvio Quadri 2009-11-05 13:01:27 [pgsql-es-ayuda] Ejecutar sentencias fuera de transaccion en una función
Previous Message Raúl Andrés Duque Murillo 2009-11-05 11:37:13 Ejecutar sentencias fuera de transaccion en una función