-
Incident report
-
Resolution: Duplicate
-
Major
-
None
-
1.6.5
-
None
-
None
-
CentOS 5.3 - 2.6.18-128.1.16.el5xen - x86_64
PostgreSQL 8.3.7-1PGDG.rhel5
Zabbix 1.6.5
On attempting to add a node , on the slave node, the following error is entered into the log files:
[Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: function md5(numeric) does not exist
LINE 1: ...||status||','||md5(macros)||','||md5(agent)||','||md5(time)|...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
[insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 30,'httptest',httptestid,1,md5(name)||','||applicationid||','||lastcheck||','||nextcheck||','||curstate||','||curstep||','||lastfailedstep||','||delay||','||status||','||md5(macros)||','||md5(agent)||','||md5(time)||','||md5(error) from httptest where 1=1 and httptestid between 3000000000000000 and 3099999999999999]
According to the PostgreSQL documentation, md5() only has md5(string), which would explain the error.
I ain't no programmer, but the only reference I found to md5() was in nodesender.c, which uses a md5(%s) on line 97, seemingly without explicitly casting %s as a string.
As it stands, this would seem to be stopping my two nodes from communicating with each other effectively.
\
- duplicates
-
ZBX-416 Proposal patch: Fix problem of implicit cast with PostgreSQL 8.3
- Closed