Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-986

Incorrect call to md5() by nodesender on Postgres db

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major 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.
      \

            sasha Alexander Vladishev
            the_loeki Ronald van Zantvoort
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: