Error in zabbix server log file

[simonuk1]

I get this in the logfile of my zabbix server, anyone know whats it means or what I should be doing to sort it out.

WARNING: nonstandard use of \\ in a string literal at character 746
WARNING: nonstandard use of \\ in a string literal at character 746
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 961
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 746
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 746
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 828
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.

Zabbix 1.6.4
postgresql

Thanks

Simon

[simonuk1]

Have now put the debug level to 4 and get this:

30000:20090524:111626 Trapper got [{
"request":"agent data",
"data":[
{
"host":"ldshsftp01",
"key":"system.cpu.load[,avg1]",
"value":"0.000000",
"clock":1243160182},
{
"host":"ldshsftp01",
"key":"perf_counter[\\PhysicalDisk(_Total)\\Avg. Disk Read Queue Length]",
"value":"0.000000",
"clock":1243160184},
{
"host":"ldshsftp01",
"key":"proc.num[]",
"value":"49",
"clock":1243160184},
{
"host":"ldshsftp01",
"key":"system.swap.size[,free]",
"value":"7645065216",
"clock":1243160184},
{
"host":"ldshsftp01",
"key":"perf_counter[\\System\\threads]",
"value":"779.000000",
"clock":1243160184},
{
"host":"ldshsftp01",
"key":"system.cpu.load[,avg5]",
"value":"0.013333",
"clock":1243160184}],
"clock":1243160186}] len 757
30000:20090524:111626 In process_new_values()
30000:20090524:111626 In process_mass_data()
30000:20090524:111626 In DCinit_nextchecks()
30000:20090524:111626 Query [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.para ms,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype, h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i .ipmi_sensor,i.lastlogsize from hosts h, items i where h.hostid=i.hostid and h.proxy_hostid=0 and h.status=0 and i.status in (0,3) and i.type in (2,7) and ((h.host='ldshsftp01' and i.key_='system.cpu.load[,avg1]') or (h.host='ldshsftp01' and i.key_='perf_counter[\\PhysicalDisk(_Total)\\Avg. Disk Read Queue Length]') or (h.host='ldshsftp01' and i.key_='proc.num[]') or (h.host='ldshsftp01' and i.key_='system.swap.size[,free]') or (h.host='ldshsftp01' and i.key_='perf_counter[\\System\\threads]') or (h.host='ldshsftp01' and i.key_='system.cpu.load[,avg5]')) and h.hostid between 100000000000000 and 199999999999999]
WARNING: nonstandard use of \\ in a string literal at character 807
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 1022
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.

[simonuk1]

Ok found how to get ride of the error message which was being generated by postgres itself.

Edit postgresql.conf, set
escape_string_warning = off
and restart the server.