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

"Query failed" runtime error observed when opening item value widget config that was listening a deleted widget

XMLWordPrintable

    • S24-W38/39, S24-W40/41
    • 0.125

      Problem description: In case it an Item value widget is listening items from another widget, and this broadcaster widget gets deleted, then the following runtime error is observed in php log after opening this Item value widget configuration form:

      pg_query(): Query failed: ERROR:  invalid input syntax for type bigint: ""
      LINE 1: ...lue_type FROM items i WHERE i.flags IN (0,4) AND i.itemid=''
                                                                           ^ [jsrpc.php:872 -> CApiWrapper->__call() -> CFrontendApiWrapper->callMethod() -> CApiWrapper->callMethod() -> CFrontendApiWrapper->callClientMethod() -> CLocalApiClient->callMethod() -> CItem->get() -> DBselect() -> pg_query() -> CConfigFile->{closure}() in include/db.inc.php:249]
      

      Steps to reproduce:

      1. Create a new dashboard on a fresh installation of zabbix
      2. Add the following widgets to this dashboard:
        1. An "Item navigator" widget, that allows to select "Available memory" items
        2. An "Item value" widget, that listens to items that are selected on the above "Item navigator" widget.
      3. Wait for the "Available memory" item on Zabbix server to get some data
      4. Open created dashboard in edit mode
      5. Delete the previously created "Item navigator" widget
      6. Open "Item value" widget configuration form
      7. Check for runtime errors

      Result: the previously mentioned runtime error is observed.
      Expected: no runtime errors should be observed.

            averza Andrejs Verza
            solonkins Sergejs Olonkins
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 1h
                1h
                Remaining:
                Time Spent - 0.5h Remaining Estimate - 0.5h
                0.5h
                Logged:
                Time Spent - 0.5h Remaining Estimate - 0.5h
                0.5h