[pgpool-general: 3911] Re: pgpool2 "invalid byte sequence for encoding "UTF8": 0xe5 0x02"

Tatsuo Ishii ishii at postgresql.org
Wed Aug 5 16:28:20 JST 2015


There are two possibilites.

1) you are using "client_encoding": ie. your frontend uses ISO-8859-1
   or something like that and PostgreSQL uses UTF-8. Unfortunately
   pgpool-II does not support client_encoding.

2) The data you sent is mungled somewhere between pgpool and
   PostgreSQL. You can check that by comparing 'Dalvik/1.6.0...' (the
   original data in your INSERT statement), that one in the pgool log
   and that one in the PostgreSQL log. You may want to use od to grab
   exact data.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

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


More information about the pgpool-general mailing list