<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-2">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font size="-1">Hi,<br>
<br>
I test a pgpool 3.1.3 now with one DB PostgreSQL 9.1 server and
when I run our jmeter test I have only max 80 loggen-in users. In
pgpool I get some errors:<br>
<br>
2012-08-02 14:44:02 ERROR: pid 9743: pool_read: read failed
(Connection reset by peer)<br>
2012-08-02 14:44:02 LOG: pid 9743: ProcessFrontendResponse:
failed to read kind from frontend. frontend abnormally exited<br>
2012-08-02 14:44:07 LOG: pid 9730: ProcessFrontendResponse:
failed to read kind from frontend. frontend abnormally exited<br>
2012-08-02 14:44:07 LOG: pid 9730: ProcessFrontendResponse:
failed to read kind from frontend. frontend abnormally exited<br>
2012-08-02 14:44:14 LOG: pid 7705: do_query: error message from
backend out of memory<br>
2012-08-02 14:44:14 LOG: pid 7705: do_query: error message from
backend out of memory<br>
2012-08-02 14:44:14 LOG: pid 7705: do_query: error message from
backend out of memory<br>
<br>
my config<br>
<br>
listen_addresses = '*'<br>
port = 9988<br>
socket_dir = '/tmp'<br>
pcp_port = 9898<br>
pcp_socket_dir = '/tmp'<br>
pcp_timeout = 0<br>
backend_hostname0 = 'db1'<br>
backend_port0 = 5433<br>
backend_weight0 = 1<br>
backend_data_directory0 = '/opt/PostgresPlus/9.1AS/data'<br>
backend_flag0 = 'ALLOW_TO_FAILOVER'<br>
enable_pool_hba = off<br>
authentication_timeout = 60<br>
ssl = off<br>
num_init_children = 120<br>
max_pool = 5<br>
child_life_time = 300<br>
child_max_connections = 1000<br>
connection_life_time = 0<br>
client_idle_limit = 0<br>
log_destination = 'stderr'<br>
print_timestamp = on<br>
log_connections = off<br>
log_hostname = off<br>
log_statement = off<br>
log_per_node_statement = off<br>
log_standby_delay = 'if_over_threshold'<br>
syslog_facility = 'LOCAL0'<br>
syslog_ident = 'pgpool'<br>
debug_level = 0<br>
pid_file_name = '/var/run/pgpool/pgpool.pid'<br>
logdir = '/tmp'<br>
connection_cache = on<br>
reset_query_list = 'ABORT; DISCARD ALL'<br>
replication_mode = off<br>
replicate_select = off<br>
insert_lock = off<br>
lobj_lock_table = ''<br>
replication_stop_on_mismatch = off<br>
failover_if_affected_tuples_mismatch = off<br>
load_balance_mode = on<br>
ignore_leading_white_space = on<br>
white_function_list = ''<br>
master_slave_mode = on<br>
master_slave_sub_mode = 'stream'<br>
sr_check_period = 0<br>
sr_check_user = 'postgres'<br>
sr_check_password = ''<br>
delay_threshold = 10000000<br>
follow_master_command = ''<br>
parallel_mode = off<br>
enable_query_cache = off<br>
pgpool2_hostname = ''<br>
system_db_hostname = 'localhost'<br>
system_db_port = 5432<br>
system_db_dbname = 'pgpool'<br>
system_db_schema = 'pgpool_catalog'<br>
system_db_user = 'pgpool'<br>
system_db_password = ''<br>
health_check_period = 0<br>
health_check_timeout = 20<br>
health_check_user = 'nobody'<br>
health_check_password = ''<br>
client_idle_limit_in_recovery = 0<br>
relcache_expire = 5<br>
<br>
</font><span id="result_box" class="" lang="en"><span class="hps">The</span>
<span class="hps">target</span> <span class="hps">configuration,</span>
<span class="hps">I would like to</span> <span class="hps">connect</span>
<span class="hps">an additional</span> <span class="hps">2-3</span>
<span class="hps">servers</span> <span class="hps">with</span> <span
class="hps">streaming</span> <span class="hps">replication.<br>
<br>
<br>
</span></span><font size="-1"><br>
<br>
</font>
</body>
</html>