[Pgpool-general] connect to pgpool using windows pgODBC.exe problem

[Axel Weber]

Hi,
I encountered a problem when I try to connect to pgpool using the
pgODBC.exe deployed as SystemDNS on a windowsNT system.

Attached you'll find the syslog excerpt.

I would be pleased to get any help on that matter.


Axel

Syslog:
---------------------------------------------
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235: I am
1235 accept fd 6
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
Protocol Major: 2 Minor: 0 database: SmartMaz user: abit
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235: read
kind from backend C
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
pool_process_query: kind from backend: C
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
pool_read_string: read all from pending data. po:4 len:1
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
Complete Command Response: string: "SET"
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235: read
kind from backend pending data Z len: 0 po: 0
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
pool_process_query: kind from backend: Z
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235: read
kind from frontend Q(51)
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
pool_read_string: read all from pending data. po:0 len:0
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
Query:  
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235: read
kind from backend I
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235: read
kind from frontend Q(51)
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
pool_read_string: read all from pending data. po:0 len:0
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235:
Query:  
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1235: read
kind from backend pending data 
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 ERROR: pid 1235: kind
is 0!
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 LOG:   pid 1235:
do_child: exits with status 1 due to error
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 8438:
reap_handler called
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 8438:
child 1235 exits with status 256 by signal 0
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 1275: I am
1275
Oct 19 11:27:33 clever pgpool: 2005-10-19 11:27:33 DEBUG: pid 8438: fork
a new child pid 1275
Oct 19 11:30:01 clever cron[1278]: (root) CMD (test
-x /usr/sbin/run-crons && /usr/sbin/run-crons )
Oct 19 11:30:25 clever pgpool: 2005-10-19 11:30:25 DEBUG: pid 31534:
child life 300 seconds expired
Oct 19 11:30:25 clever pgpool: 2005-10-19 11:30:25 DEBUG: pid 8438:
reap_handler called
Oct 19 11:30:25 clever pgpool: 2005-10-19 11:30:25 DEBUG: pid 8438:
child 31534 exits with status 512 by signal 0
Oct 19 11:30:25 clever pgpool: 2005-10-19 11:30:25 DEBUG: pid 1289: I am
1289
Oct 19 11:30:25 clever pgpool: 2005-10-19 11:30:25 DEBUG: pid 8438: fork
a new child pid 1289

----------------------------------------------------------------
----------------------------------------------------------------
pgpool.conf:
#
# pgpool configuration file sample
# $Header: /cvsroot/pgpool/pgpool/pgpool.conf.sample,v 1.1.1.1
2005/02/14 14:52:21 t-ishii Exp $

# host name or IP address to listen on: '*' for all, '' for no TCP/IP
connections
listen_addresses = '*'

# port number for pgpool
port = 9999

# Unix domain socket path. Debian package default
to /var/run/postgresql!
socket_dir = '/tmp'

# host name where PostgreSQL server is running on. '' means localhost
using UNIX
# domain socket
backend_host_name = 'clever'

# port number PostgreSQL server is running on.
backend_port = 5432

# Unix domain socket path for the backend. Debian package default
to /var/run/postgresql!
backend_socket_dir = '/tmp'

# host name where secondary PostgreSQL server is running on. '' means
localhost using UNIX
# domain socket
#secondary_backend_host_name = 'smart'

# port number secondary PostgreSQL server is running on.
# 0 means no secondrary PostgreSQL
#secondary_backend_port = 5432

# number of pre-forked child process
num_init_children = 4

# numer of connection pool allowed for a child process.
max_pool = 4

# if idle for this seconds, child exits. 0 means no timeout.
child_life_time = 300

# if idle for this seconds, connection to PostgreSQL closes. 0 means
# no timeout
connection_life_time = 0

# logging directory
logdir = '/var/run'

# replication mode
replication_mode = false

# set this to true if you want to avoid deadlock situation when
# replication enabled.
# there will be noticable performance degration, however.
# a work around is set this to false and insert /*STRICT*/ comment
# at the beginning of the SQL command.
replication_strict = true

# when replication_strict is set to false, there will be a chance for
# deadlocks. set this to non 0 (in milli seconds) to detect this
# situation and resolve the deadlock aborting current session.
replication_timeout = 5000

# load balancing mode. i.e. all SELECT except in a transaction block
# are load balanced. This is ignored if replication_mode is false.
load_balance_mode = false

# load balance weight for master and secondary. actual weight is
# calculated by weight_master:weight_secondary. For example both
#
# weight_master = 10 and weight_secondary = 5
# weight_master = 4 and weight_secondary = 2
#
# are regarded as master has double the weight comparing with secondary.
# master and secondary have same weight in the default.
weight_master = 0.5
weight_secondary = 0.5

# if there's a data mismatch between master and secondary
# start degenration to stop replication mode
replication_stop_on_mismatch = false

# semicolon separated list of quries to be issued at the end of session
reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'

# if true print time stamp to each log line
print_timestamp = true

# if true, operate in master/slave mode
master_slave_mode = false

# if true, cache connection pool
connection_cache = true

# health check timeout. 0 means no timeout;
health_check_timeout = 20

# health check period. 0 means no health check
health_check_period = 0

# health check user
health_check_user = 'postgres'