problemas con pgpool-II

From: Diego Ayala <netdiego81(at)gmail(dot)com>
To: Postgres Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: problemas con pgpool-II
Date: 2010-08-04 12:55:34
Message-ID: AANLkTinDDVMRaqpD3ggE=MH=fhAXOzYpzfiKYK5YdupH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Buenos dias listeros, quisiera consultarles si alguno tuvo algun problema
parecido al mio, y si lo pudo solucionar, tengo 2 server, conectados
mediante pgpool-II, en el cual la replicacion funcionaba de ambos lados, es
decir, de A a B y de B a A, pero desde hace unos dias, la replicacion de A a
B no funciona, levanta el pgpool, inicia sin errores, pero mediante el debug
pude visualizar este mensaje:
pgpool-II successfully started. version 2.3.3 (tomiteboshi)
2010-08-04 08:49:31 DEBUG: pid 19287: I am PCP 19287
2010-08-04 08:49:39 DEBUG: pid 19282: I am 19282 accept fd 5
2010-08-04 08:49:39 LOG: pid 19282: connection received: host=[local]
2010-08-04 08:49:39 DEBUG: pid 19282: Protocol Major: 3 Minor: 0 database:
postgres user: postgres
2010-08-04 08:49:39 DEBUG: pid 19282: new_connection: connecting 0 backend
2010-08-04 08:49:39 DEBUG: pid 19282: new_connection: connecting 1 backend

2010-08-04 08:49:39 DEBUG: pid 19282: new_connection: skipping slot 1
because backend_status = 3

2010-08-04 08:49:39 DEBUG: pid 19282: pool_ssl: SSL requested but SSL
support is not available
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length: slot: 0
length: 8
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 27
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: client_encoding
value: LATIN1
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 23
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: DateStyle value:
ISO, DMY
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 25
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: integer_datetimes
value: on
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 27
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: IntervalStyle
value: postgres
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 20
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: is_superuser
value: on
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 27
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: server_encoding
value: LATIN1
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 25
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: server_version
value: 8.4.1
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 35
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name:
session_authorization value: postgres
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 36
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name:
standard_conforming_strings value: off
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length2: master
slot: 0 length: 30
2010-08-04 08:49:39 DEBUG: pid 19282: 0 th backend: name: TimeZone value:
America/Asuncion
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length: slot: 0
length: 12
2010-08-04 08:49:39 DEBUG: pid 19282: pool_send_auth_ok: send pid 19290 to
frontend
2010-08-04 08:49:39 DEBUG: pid 19282: select_load_balancing_node: selected
backend id is 0
2010-08-04 08:49:39 DEBUG: pid 19282: read_kind_from_backend: read kind from
0 th backend Z NUM_BACKENDS: 2
2010-08-04 08:49:39 DEBUG: pid 19282: pool_process_query: kind from backend:
Z
2010-08-04 08:49:39 DEBUG: pid 19282: pool_read_message_length: slot: 0
length: 5
2010-08-04 08:49:39 DEBUG: pid 19282: ReadyForQuery: message length: 5
2010-08-04 08:49:39 DEBUG: pid 19282: ReadyForQuery: transaction state: I

new_connection: skipping slot 1 because backend_status = 3 Haciendo el
proceso a la inversa, del server B a A, no me sale ese mensaje, y la
replicacion funciona perfectamente, alguien sabe a que podria deberse eso,
ya revise todas las configuraciones del pgpool.cong, pg_hba.conf, compare
con la del server B y no hay diferencias..

Les agradeceria su ayuda.

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message David Montoya 2010-08-04 13:39:10 Re: problemas con pgpool-II
Previous Message Silvio Quadri 2010-08-04 12:31:14 Re: Problemas con el espacio de disco al ejecutar una consulta