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-5912Zentrum für Datenverarbeitung mail: [email protected]
Wächterstraße 76 72074 Tübingen
smime.p7s
Description: S/MIME Signatur
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
