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

DB Monitoring stopped working after upgrade to 3.2

    Details

      Description

      I have some item which query an Oracle DB. After upgrading to 3.2 from 3.0 (no issues regarding my zabbix postgresql DB upgrade) I have found that my ODBC Item is not working anymore. I perform simple query against an Oracle (RAC) user table using odbc. the same sql using isql is working fine:
      One example of sql is the following:

      SELECT count (*),trunc(first_time) FROM v$loghist a where trunc( first_time)=trunc(sysdate) and THREAD# =1 group by trunc(first_time);
      

      This sql is used as item in db monitoring. Before upgrading it was working fine.
      Any advice?

      With Best Regards,

      Alessandro

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                alessandro.mariotti@p-a.it Alessandro Mariotti
              • Votes:
                6 Vote for this issue
                Watchers:
                28 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: