[Pgpool-general] errormessage if backendfailes while executing query

[Michael Menge]

Hi,

we want to use pgpool-II to build a HA webmailsolution.

We use pgpool-II 2.3.3 with 2 postgres 8.3.9 backends in
replication mode.

If the connection to one database is lost befor a query is run
everything works as expected. But if one backend goes down while
a query is run, the client will recieve the following error:

##################
kind mismatch among backends. Possible last query was: "UPDATE  
test_history set tid=1;" kind details are: 0[C] 1[E: terminating  
connection due to administrator command]
TIP:  check data consistency among db nodes
Server beendete die Verbindung unerwartet
         Das heißt wahrscheinlich, daß der Server abnormal beendete
         bevor oder während die Anweisung bearbeitet wurde.
Die Verbindung zum Server wurde verloren.  Versuche Reset: Fehlgeschlagen.
##################

I would expect pgpool not to show an error, but to detatche the failed
backend.

Is this a bug or a config error?

Regards

       Michael Menge

####### pgpool.conf ############

listen_addresses = '*'
port = 5432
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 32
max_pool = 4
child_life_time = 300
connection_life_time = 0
child_max_connections = 0
client_idle_limit = 0
authentication_timeout = 60
logdir = '/tmp/pgpool'
pid_file_name = '/var/run/pgpool/pgpool.pid'
replication_mode = true
load_balance_mode = true
replication_stop_on_mismatch = false
replicate_select = false
reset_query_list = 'ABORT; DISCARD ALL'
print_timestamp = true
master_slave_mode = false
connection_cache = true
health_check_timeout = 20
health_check_period = 0
health_check_user = 'postgres'
failover_command = 'date >> /tmp/pgpool/fail.log; echo host:%h,  
failover new master id:%m, old master id: %M >> /tmp/pgpool/fail.log'
failback_command = 'date >> /tmp/pgpool/fail.log; echo host:%h,  
failback new master id:%m, old master id: %M >> /tmp/pgpool/fail.log'
failback_command = ''
fail_over_on_backend_error = true
insert_lock = true
ignore_leading_white_space = true
log_statement = false
log_per_node_statement = false
log_connections = true
log_hostname = true
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = 'localhost'
system_db_hostname = ''
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = ''
backend_hostname0 = 'backend1.example.com'
backend_port0 = 9999
backend_weight0 = 1
backend_data_directory0 = '/var/lib/pgsql/data'
backend_hostname1 = 'backend2.example.com'
backend_port1 = 9999
backend_weight1 = 1
backend_data_directory1 = '/var/lib/pgsql/data'
enable_pool_hba = false
recovery_user = 'postgres'
recovery_password = ''
recovery_2nd_stage_command = 'pgpool-recovery-pitr'
recovery_timeout = 90
client_idle_limit_in_recovery = 10
lobj_lock_table = ''
ssl = false



--------------------------------------------------------------------------------
M.Menge                                Tel.: (49) 7071/29-70316
Universität Tübingen                   Fax.: (49) 7071/29-5912
Zentrum für Datenverarbeitung          mail:  
michael.menge at zdv.uni-tuebingen.de
Wächterstraße 76
72074 Tübingen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5339 bytes
Desc: S/MIME Signatur
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100427/e33a05d3/attachment.bin>