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

Strange "return value" when item:db.odbc.select return NULL

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 2.0.3rc1, 2.1.0
    • 2.0.1
    • Server (S)
    • VMWare server, 24GB RAM, 8 core CPU, Linux zabbix_vm 2.6.32-220.el6.x86_64 #1 SMP Wed Nov 9 08:03:13 EST 2011 x86_64 x86_64 x86_64 GNU/Linux, mysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (x86_64) using readline 5.1

      When there is no rows in select statement And query return "null" value in zabbix_server.log, there are very suspicious logs.
      Probably zabbix goes in memory area reserved by any other function.
      Especially look on 16316:20120731 which return absolutely nonsense information got from some config "memory area".


      16315:20120731:122403.447 item [GGSN40990B:db.odbc.select[EMSPort-22-1-RX]] became not supported: Received value [@?] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
      16317:20120731:122616.205 item [GGSN40990B:db.odbc.select[sess-txbytes]] became not supported: Received value [?] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
      16318:20120731:122758.427 item [rmsc-h1:db.odbc.select[tx-in-unknown-files]] became not supported: Received value [p?] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
      16315:20120731:122808.708 item [rmsc-h1:db.odbc.select[tx-in-text-files]] became not supported: Received value [??] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
      16316:20120731:122813.867 item [rmsc-h1:db.odbc.select[tx-out-image-files]] became not supported: Received value [ymax_itemid=null,flags=4 where graphid=5162;update graph_discovery set name='Trafic on interface

      {#SNMPVALUE}

      ' w
      16316:20120731:122953.427 item [GGSN40990B:db.odbc.select[EMSPort-22-3-TX]] became not supported: Received value [P?] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
      16316:20120731:123008.851 item [GGSN40990B:db.odbc.select[EMSPort-22-1-TX]] became not supported: Received value [] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
      16317:20120731:123304.305 item [GGSN40990B:db.odbc.select[EMSPort-27-3-RX]] became not supported: Received value [0?] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
      16317:20120731:123330.411 item [rmsc-h2:db.odbc.select[tx-pass-through-files]] became not supported: Received value [?S] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]


      In the same time:
      mysql> select * from events where device='rmsc-h1';
      Empty set (0.00 sec)

      mysql> select * from events where device='GGSN40990B';
      Empty set (0.00 sec)

      My odbc item for example:


      DSN=MySQLP
      sql=select round(avg(params.param2)) from events LEFT JOIN params ON events.id=params.events_id where itemname = "EMSPort" and device='{$NAZWA}' and itemvalue='223' and eventtime > UNIX_TIMESTAMP()-{$AVG2XTIME};

      Best Regards,
      Grzegorz

        1. 2.0.3rc1-29617-screen-1.png
          2.0.3rc1-29617-screen-1.png
          19 kB
        2. 2.0.3rc1-29617-screen-2.png
          2.0.3rc1-29617-screen-2.png
          128 kB
        3. 2.0.3rc1-29617-screen-3.png
          2.0.3rc1-29617-screen-3.png
          38 kB
        4. 2.0.3rc1-29617-screen-4.png
          2.0.3rc1-29617-screen-4.png
          56 kB
        5. 2.0.3rc1-29617-screen-5.png
          2.0.3rc1-29617-screen-5.png
          117 kB
        6. 2.0.3rc1-29617-screen-6.png
          2.0.3rc1-29617-screen-6.png
          42 kB
        7. 2.0.3rc1-29617-screen-7.png
          2.0.3rc1-29617-screen-7.png
          78 kB
        8. odbc-item.png
          odbc-item.png
          18 kB
        9. zabbix_server.log.png
          zabbix_server.log.png
          88 kB

            Unassigned Unassigned
            mbsit Grzegorz Grabowski
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: