[Pgpool-general] No results if not in a transaction

[Bruce Skelton]

Our web application uses  DBIx::Class to support db operations. The query
rarely returns any results if not in a transaction. If the request is
wrapped by a txn_do or a txn_being/txn_commit call(s), then the results are
100% successful. Any help in resolving this would be greatly appreciated. I
have attached the relevant entries from the pgpool log of a successful query
and an unsuccesful query. It's interesting that there is no statement and I
have log_statement=true.
Configuration:
pgpool-II version 2.1(inamiboshi),
  a generic connection pool/replication/load balance server for PostgreSQL
(PostgreSQL) 8.2.3
Slony for replication

listen_addresses = '*'
port = 5432
pcp_port = 9898
socket_dir = '/var/run'
pcp_socket_dir = '/var/run'
backend_socket_dir = '/var/run'
pcp_timeout = 10
num_init_children = 40
max_pool = 4
child_life_time = 10
connection_life_time = 30
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
logdir = '/var/run'
replication_mode = false
replication_timeout = 5000
load_balance_mode = true
replication_stop_on_mismatch = false
replicate_select = true
reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_timestamp = true
master_slave_mode = true
connection_cache = true
health_check_timeout = 20
health_check_period = 0
health_check_user = 'nobody'
failover_command = ''
failback_command = ''
insert_lock = false
ignore_leading_white_space = true
log_statement = true
log_connections = true
log_hostname = true
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = 'devload'
system_db_hostname = 'localhost'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = ''
backend_hostname0 = 'devmaster'
backend_port0 = 5432
backend_weight0 = 0.2
backend_data_directory0 = '/data'
backend_hostname1 = 'devreplica'
backend_port1 = 5432
backend_weight1 = 0.6
backend_data_directory1 = '/data1'
enable_pool_hba = false
recovery_user = 'nobody'
recovery_password = ''
recovery_1st_stage_command = ''
recovery_2nd_stage_command = ''

Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090518/f5ba031a/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: transaction
Type: application/octet-stream
Size: 39062 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20090518/f5ba031a/attachment-0001.obj