.log de la bd

From: "Conrado Blasetti" <conrado(at)mapfre(dot)com(dot)ar>
To: "pgsql-es-ayuda" <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: .log de la bd
Date: 2009-03-06 14:43:55
Message-ID: 76A99F19229DC440909CF1B905F8012C07B7572F@sar001998.Mapfre.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Gente, bueno, tengo instalado la bd en winxp donde tambien corre una app desktop en vb.net.
Ya se, no son las condiciones...

Consulta, me reclama que la maquina se congela a cada rato (debe reiniciar) y quiero descartar que sea el sistema (bd y app), ya que en otro cliente vienen funcionando otro sistema con las mismas caracteristicas y sin ningun problema aparente.

Me conecto a la bd con Npgsql.dll, sin tocar los parámetros por default. Se conecta a la bd cuando abren el sistema y se desconecta cuando lo cierran, pero no se cierra, lo dejan ahí, puede ser el timeout? Si fuese asi, no debería congelarme el SO, no?
Bueno, cualquier comentario al respecto, será bienvenido.

Saludos,
Conrado

Este son los logs (entre todos los que tienen):

postgresql-2009-03-05_121121.log

2009-03-05 12:11:22 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:11:22 ARST FATAL: the database system is starting up
2009-03-05 12:11:22 ARST LOG: database system was interrupted; last known up at 2009-03-05 12:03:37 ARST
2009-03-05 12:11:22 ARST LOG: database system was not properly shut down; automatic recovery in progress
2009-03-05 12:11:22 ARST LOG: redo starts at 0/11FC8D0
2009-03-05 12:11:22 ARST LOG: record with zero length at 0/1208E68
2009-03-05 12:11:22 ARST LOG: redo done at 0/1208E38
2009-03-05 12:11:22 ARST LOG: last completed transaction was at log time 2009-03-05 12:08:16.843-02
2009-03-05 12:11:25 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:11:25 ARST FATAL: the database system is starting up
2009-03-05 12:11:25 ARST LOG: database system is ready to accept connections
2009-03-05 12:11:26 ARST LOG: autovacuum launcher started
2009-03-05 12:11:26 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:11:47 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:11:57 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:12:01 ARST LOG: could not receive data from client: Unknown winsock error 10061
2009-03-05 12:12:01 ARST LOG: unexpected EOF on client connection
2009-03-05 12:12:07 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"

postgresql-2009-03-05_122126.log (el error en el insert lo capturo desde la app, no lo saca del sistema)

2009-03-05 12:21:26 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:21:26 ARST FATAL: the database system is starting up
2009-03-05 12:21:26 ARST LOG: database system was interrupted; last known up at 2009-03-05 12:16:28 ARST
2009-03-05 12:21:26 ARST LOG: database system was not properly shut down; automatic recovery in progress
2009-03-05 12:21:26 ARST LOG: redo starts at 0/12159A8
2009-03-05 12:21:26 ARST LOG: record with zero length at 0/1222980
2009-03-05 12:21:26 ARST LOG: redo done at 0/1222948
2009-03-05 12:21:26 ARST LOG: last completed transaction was at log time 2009-03-05 12:16:36.078-02
2009-03-05 12:21:27 ARST LOG: database system is ready to accept connections
2009-03-05 12:21:27 ARST LOG: autovacuum launcher started
2009-03-05 12:21:29 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:21:58 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:22:06 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:28:18 ARST ERROR: null value in column "per_pago" violates not-null constraint
2009-03-05 12:28:18 ARST CONTEXT: SQL statement "INSERT INTO recibos_01 ( nro_recibo, cod_alumno, cod_familia, per_pago, venc_tip_cta, venc_real_tip_cta, imp_tip_cta, imp_cal_cta, imp_a_pagar_cta, imp_pagado, fec_pago, cod_agrup_estado, cod_estado, fec_equipo, fec_equipo_full, cod_usr, mca_importe_manual, mca_pago_anulado, mca_pago_parcial, mca_pago_anticipado, mca_pago_perdon, nro_recibo_anterior, nro_recibo_siguiente, mca_condicion_especial, mca_hjjo_maestro, imp_desc_hijo_maestro, mca_beca, imp_desc_beca, porc_descuento, imp_descuento, nro_hijo, imp_desc_hijo, cod_nivel, observaciones, mca_impreso, tip_cta ) VALUES ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 )"
PL/pgSQL function "recibos_01_insert" line 3 at SQL statement
PL/pgSQL function "recibos_gen03" line 377 at assignment
PL/pgSQL function "pagos_generacion_manual" line 9 at assignment
2009-03-05 12:28:18 ARST STATEMENT: select pagos_generacion_manual('USUARIO', null, null, 1821::NUMERIC, 'CCOM', 'S', 'GENERACION MANUAL DE CUOTA', TO_CHAR(0.00,'FM9999999999.90')::NUMERIC, TO_CHAR(0.00,'FM9999999999.90')::NUMERIC) as dato

postgresql-2009-03-05_124136.log

2009-03-05 12:41:36 ARST LOG: database system was interrupted; last known up at 2009-03-05 12:36:29 ARST
2009-03-05 12:41:36 ARST LOG: database system was not properly shut down; automatic recovery in progress
2009-03-05 12:41:36 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:41:36 ARST FATAL: the database system is starting up
2009-03-05 12:41:36 ARST LOG: redo starts at 0/1246EF8
2009-03-05 12:41:36 ARST LOG: record with zero length at 0/1250B80
2009-03-05 12:41:36 ARST LOG: redo done at 0/1250B50
2009-03-05 12:41:36 ARST LOG: last completed transaction was at log time 2009-03-05 12:38:52.437-02
2009-03-05 12:41:37 ARST LOG: database system is ready to accept connections
2009-03-05 12:41:37 ARST LOG: autovacuum launcher started
2009-03-05 12:41:39 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:42:31 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 12:42:43 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"

postgresql-2009-03-05_131303.log

2009-03-05 13:13:03 ARST LOG: database system was interrupted; last known up at 2009-03-05 13:06:39 ARST
2009-03-05 13:13:03 ARST LOG: database system was not properly shut down; automatic recovery in progress
2009-03-05 13:13:03 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 13:13:03 ARST FATAL: the database system is starting up
2009-03-05 13:13:03 ARST LOG: redo starts at 0/128CB40
2009-03-05 13:13:03 ARST LOG: record with zero length at 0/129D380
2009-03-05 13:13:03 ARST LOG: redo done at 0/129D350
2009-03-05 13:13:03 ARST LOG: last completed transaction was at log time 2009-03-05 13:11:32.343-02
2009-03-05 13:13:04 ARST LOG: database system is ready to accept connections
2009-03-05 13:13:04 ARST LOG: autovacuum launcher started
2009-03-05 13:13:06 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 13:13:19 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 13:13:52 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 13:40:41 ARST LOG: could not receive data from client: Unknown winsock error 10061
2009-03-05 13:40:41 ARST LOG: unexpected EOF on client connection
2009-03-05 13:41:02 ARST LOG: could not receive data from client: Unknown winsock error 10061
2009-03-05 13:41:02 ARST LOG: unexpected EOF on client connection
2009-03-05 13:41:03 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 13:41:11 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 13:41:16 ARST LOG: could not receive data from client: Unknown winsock error 10061
2009-03-05 13:41:16 ARST LOG: unexpected EOF on client connection
2009-03-05 13:41:45 ARST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2009-03-05 14:01:43 ARST LOG: could not receive data from client: Unknown winsock error 10061
2009-03-05 14:01:43 ARST LOG: unexpected EOF on client connection
2009-03-05 14:05:04 ARST LOG: could not receive data from client: Unknown winsock error 10061
2009-03-05 14:05:04 ARST LOG: unexpected EOF on client connection
2009-03-05 14:07:47 ARST LOG: received fast shutdown request
2009-03-05 14:07:47 ARST LOG: aborting any active transactions
2009-03-05 14:07:47 ARST LOG: autovacuum launcher shutting down
2009-03-05 14:07:47 ARST LOG: shutting down
2009-03-05 14:07:48 ARST LOG: database system is shut down

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2009-03-06 15:01:51 Re: .log de la bd
Previous Message Conrado Blasetti 2009-03-06 14:36:07 RE: Linea de comandos