frankcheong
14-10-2009, 09:02
I have just finished a distributed setup where masternode is using Postgres SQL but all other server is using MYSQL. While from my masternode zabbix_server.log, I found the following error message prompt quite frequently:-
12824:20091013:143958 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: inval
id byte sequence for encoding "UTF8": 0xc227
HINT: This error can also happen if the byte sequence does not match the encodi
ng expected by the server, which is controlled by "client_encoding".
[insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,descri
ption,key_,delay,history,trends,status,value_type, trapper_hosts,units,multiplier
,delta,snmpv3_securityname,snmpv3_securitylevel,sn mpv3_authpassphrase,snmpv3_pri
vpassphrase,formula,error,logtimefmt,templateid,va luemapid,delay_flex,params,ipm
i_sensor) values (4504500000021811,12,'','',161,4504500000010042,'D rive backplan
e temperature','drive_backplane.temperature',30,7,36 5,0,0,'','ÂÂ',0,0,'',0,'',''
I have double checked the encoding in the masternode postgre database as below:-
postgres=# \l+
List of databases
Name | Owner | Encoding | Description
-----------+----------+----------+---------------------------
postgres | postgres | UTF8 |
template0 | postgres | UTF8 |
template1 | postgres | UTF8 | Default template database
zabbix | zabbix | UTF8 |
My question is:-
1. Can I use different database on different node(based on physcial consideration which I can make use of existing DB on some child node without having to running one more DB process).
2. What is the meaning of the error message? What casued it and how to solve it?
Thx very much in advance.
Rgds,
Frank
12824:20091013:143958 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: inval
id byte sequence for encoding "UTF8": 0xc227
HINT: This error can also happen if the byte sequence does not match the encodi
ng expected by the server, which is controlled by "client_encoding".
[insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,descri
ption,key_,delay,history,trends,status,value_type, trapper_hosts,units,multiplier
,delta,snmpv3_securityname,snmpv3_securitylevel,sn mpv3_authpassphrase,snmpv3_pri
vpassphrase,formula,error,logtimefmt,templateid,va luemapid,delay_flex,params,ipm
i_sensor) values (4504500000021811,12,'','',161,4504500000010042,'D rive backplan
e temperature','drive_backplane.temperature',30,7,36 5,0,0,'','ÂÂ',0,0,'',0,'',''
I have double checked the encoding in the masternode postgre database as below:-
postgres=# \l+
List of databases
Name | Owner | Encoding | Description
-----------+----------+----------+---------------------------
postgres | postgres | UTF8 |
template0 | postgres | UTF8 |
template1 | postgres | UTF8 | Default template database
zabbix | zabbix | UTF8 |
My question is:-
1. Can I use different database on different node(based on physcial consideration which I can make use of existing DB on some child node without having to running one more DB process).
2. What is the meaning of the error message? What casued it and how to solve it?
Thx very much in advance.
Rgds,
Frank