<div dir="ltr"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">Hi all! </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">I have trouble with <span class="search-highlight">pgpool</span>. </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">For now I use it in testing mode, at first sight all works fine. But some query (&quot;inserts&quot;), finishing with error </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">Aug  4 18:18:43 pg1 <span class="search-highlight">pgpool</span>: 2015-08-04 18:18:43: pid 18878: LOG:  Parse: Error or notice message from backend: : DB node id: 0 backend pid: 18915 statement: </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">&quot;INSERT INTO &quot;clic&quot; (&quot;a_id&quot;, &quot;app_id&quot;, &quot;c_image_id&quot;, &quot;c_url_id&quot;, &quot;count_id&quot;, &quot;created_at&quot;, &quot;dev_id&quot;, &quot;ip&quot;, &quot;type&quot;, &quot;ua&quot;, &quot;updated_at&quot;, &quot;ur_only&quot;, &quot;w_sk&quot;, &quot;x_fd&quot;) VALUES (&#39;a1a99f3e-f0b5-44b1-98bb-2c10a9bd2112&#39;, 4313, 403, 174, 24, &#39;2015-08-04 18:18:43.766423&#39;, 711675, &#39;119.161.65.6&#39;, 1, &#39;Dalvik/1.6.0 H�#002&quot; message: &quot;invalid byte sequence for encoding &quot;UTF8&quot;: 0xe5 0x02&quot; </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">What I doing wrong? </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">If I connect application without <span class="search-highlight">pgpool</span> - all works without any errors. </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px">Thanx in advance for any help! </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><span class="search-highlight">pgpool</span>-II version 3.4.2 (tataraboshi) </span><br style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:13.4399995803833px"><pre style="color:rgb(0,0,0)">listen_addresses = &#39;*&#39;
port = 5434
socket_dir = &#39;/var/run/postgresql&#39;
listen_backlog_multiplier = 2
pcp_listen_addresses = &#39;*&#39;
pcp_port = 9898
pcp_socket_dir = &#39;/var/run/postgresql&#39;
backend_hostname0 = &#39;10.0.0.1&#39;
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = &#39;/var/lib/postgresql/9.3/main/&#39;
backend_flag0 = &#39;ALLOW_TO_FAILOVER&#39;
enable_pool_hba = off
pool_passwd = &#39;pool_passwd&#39;
authentication_timeout = 60
ssl = on
ssl_key = &#39;/etc/ssl/private/ssl-cert-snakeoil.key&#39;
ssl_cert = &#39;/etc/ssl/certs/ssl-cert-snakeoil.pem&#39;
num_init_children = 48
max_pool = 5
child_life_time = 300
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 0
log_destination = &#39;stderr&#39;
log_connections = off
log_hostname = off
log_statement = off
log_per_node_statement = off
log_standby_delay = &#39;none&#39;
syslog_facility = &#39;LOCAL0&#39;
syslog_ident = &#39;<span class="search-highlight">pgpool</span>&#39;
debug_level = 1
pid_file_name = &#39;/var/run/postgresql/<span class="search-highlight">pgpool</span>.pid&#39;
logdir = &#39;/var/log/postgresql&#39;
connection_cache = on
reset_query_list = &#39;ABORT; DISCARD ALL&#39;
replication_mode = off
replicate_select = off
insert_lock = on
lobj_lock_table = &#39;&#39;
replication_stop_on_mismatch = off
failover_if_affected_tuples_mismatch = off
load_balance_mode = on
ignore_leading_white_space = on
white_function_list = &#39;&#39;
black_function_list = &#39;nextval,setval,nextval,setval&#39;
database_redirect_preference_list = &#39;&#39;
app_name_redirect_preference_list = &#39;&#39;
allow_sql_comments = off
master_slave_mode = on
master_slave_sub_mode = &#39;stream&#39;
sr_check_period = 0
sr_check_user = &#39;postgres&#39;
sr_check_password = &#39;&#39;
delay_threshold = 0
follow_master_command = &#39;&#39;
health_check_period = 0
health_check_timeout = 20
health_check_user = &#39;postgres&#39;
health_check_password = &#39;&#39;
health_check_max_retries = 0
health_check_retry_delay = 1
connect_timeout = 10000
failover_command = &#39;&#39;
failback_command = &#39;&#39;
fail_over_on_backend_error = on
search_primary_node_timeout = 10
recovery_user = &#39;postgres&#39;
recovery_password = &#39;&#39;
recovery_1st_stage_command = &#39;&#39;
recovery_2nd_stage_command = &#39;&#39;
recovery_timeout = 90
client_idle_limit_in_recovery = 0
use_watchdog = off
trusted_servers = &#39;&#39;
ping_path = &#39;/bin&#39;
wd_hostname = &#39;&#39;
wd_port = 9000
wd_authkey = &#39;&#39;
delegate_IP = &#39;&#39;
ifconfig_path = &#39;/sbin&#39;
if_up_cmd = &#39;ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0&#39;
if_down_cmd = &#39;ifconfig eth0:0 down&#39;
arping_cmd = &#39;arping -U $_IP_$ -w 1&#39;
clear_memqcache_on_escalation = on
wd_escalation_command = &#39;&#39;
wd_lifecheck_method = &#39;heartbeat&#39;
wd_interval = 10
wd_heartbeat_port = 9694
wd_heartbeat_keepalive = 2
wd_heartbeat_deadtime = 30
heartbeat_destination0 = &#39;host0_ip1&#39;
heartbeat_destination_port0 = 9694 
heartbeat_device0 = &#39;&#39;
wd_life_point = 3
wd_lifecheck_query = &#39;SELECT 1&#39;
wd_lifecheck_dbname = &#39;template1&#39;
wd_lifecheck_user = &#39;postgres&#39;
wd_lifecheck_password = &#39;&#39;
relcache_expire = 0
relcache_size = 256
check_temp_table = on
check_unlogged_table = on
memory_cache_enabled = on
memqcache_method = &#39;shmem&#39;
memqcache_memcached_host = &#39;localhost&#39;
memqcache_memcached_port = 11211
memqcache_total_size = 67108864
memqcache_max_num_cache = 1000000
memqcache_expire = 0
memqcache_auto_cache_invalidation = on
memqcache_maxcache = 409600
memqcache_cache_block_size = 10485760
memqcache_oiddir = &#39;/var/log/<span class="search-highlight">pgpool</span>/oiddir&#39;
white_memqcache_table_list = &#39;&#39;
black_memqcache_table_list = &#39;&#39;</pre>
</div>