[Pgpool-general] pgpool-II hanging

[Rainer.Rohmfeld at emuge.de]

Hello,

we are testing pgpool-II for data replication in our PostgreSQL-Cluster.
pgpool is hanging during the combinations of select and update/insert 
statements
within a transaction. We have reduced all to the following script:

---- begin sql ---
SELECT 'DBD::Pg ping test';
BEGIN;
select *  from sometable;
COMMIT 
select * from anothertable;
--- end sql ----

pgpool is hanging after the commit-Statement.


#---pgpool.conf --------------
listen_addresses = '*'
port = 5432
pcp_port = 9898
socket_dir = '/var/run/postgresql'
...
replication_mode = true
replication_timeout = 5000
load_balance_mode = true
replicate_select = false
replication_stop_on_mismatch = true
reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
print_timestamp = true
connection_cache = true
health_check_timeout = 20
health_check_period = 60
health_check_user = 'nobody'
insert_lock = true
ignore_leading_white_space = true
...
parallel_mode = false
enable_query_cache = false
backend_hostname0 = 'dbfs2'
backend_port0 = 5435
backend_weight0 = 1
backend_data_directory0 = '/pgpool/dbfs2'
backend_hostname1 = 'dbfs3'
backend_port1 = 5435
backend_weight1 = 1
backend_data_directory1 = '/pgpool/dbfs3'
enable_pool_hba = false
#--- end pgpool.conf

After setting 
replicate_select = true

all is working fine. 

----
Best Regards / Mit freundlichen Grüßen 

Dr. R. Rohmfeld 
IT und Software Development

e-mail: Rainer.Rohmfeld at emuge.de

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20071221/15dc99f7/attachment.html