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

Error Occurs on Monitoring > Problems Page with MariaDB 10.5.1

XMLWordPrintable

    • Documentation backlog
    • 0.1

      On Zabbix 7.0 documentation, MariaDB 10.5.00-11.5.X are supported, but an issue below occurs at least on 10.5.1.

      Steps to reproduce:

      1. Create user and apply the settings below
        1. On "User roles" page, set the "User type" to Admin or User, and uncheck "Dashboards" of "Access to UI elements".
        2. On "User groups" page, add any host groups to "Host permissions".
      2. Login to Zabbix web frontend with the user configured above.

      Result:
      Zabbix shows Monitoring>Problems page with an error message "System error occurred. Please contact Zabbix administrator."

      Query error is also output on error_log of HTTPD.

      [Fri Dec 13 06:30:03.906245 2024] [proxy_fcgi:error] [pid 3531:tid 140232049501952] [client 192.168.10.155:51139] AH01071: Got error 'PHP message: PHP Warning:  Error in query [SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity,p.cause_eventid FROM problem p,functions f,items i,host_hgset hh,permission pp WHERE p.source=0 AND p.object=0 AND p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hh.hostid AND hh.hgsetid=pp.hgsetid AND pp.ugsetid=2 AND NOT EXISTS (SELECT NULL FROM functions f1 JOIN items i1 ON f1.itemid=i1.itemid JOIN host_hgset hh1 ON i1.hostid=hh1.hostid LEFT JOIN permission pp1 ON hh1.hgsetid=pp1.hgsetid AND pp1.ugsetid=pp.ugsetid WHERE p.objectid=f1.triggerid AND pp1.permission IS NULL) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND p.cause_eventid IS  NULL AND (p.r_eventid IS NULL OR p.r_clock>1734071103) ORDER BY p.eventid DESC LIMIT 1001] [Unknown column 'pp.ugsetid' in 'on clause'] in /usr/share/zabbix/include/db.inc.php on line 243', referer: http://192.168.11.212/zabbix/zabbix.php?show=1&name=&acknowledgement_status=0&inventory%5B0%5D%5Bfield%5D=type&inventory%5B0%5D%5Bvalue%5D=&evaltype=0&tags%5B0%5D%5Btag%5D=&tags%5B0%5D%5Boperator%5D=0&tags%5B0%5D%5Bvalue%5D=&show_tags=3&tag_name_format=0&tag_priority=&show_opdata=0&show_timeline=1&filter_name=&filter_show_counter=0&filter_custom_time=0&sort=clock&sortorder=DESC&age_state=0&show_symptoms=0&show_suppressed=0&acknowledged_by_me=0&compact_view=0&details=0&highlight_row=0&action=problem.view
      

      After upgrading to MariaDB 10.5.27, the error does not appear.

            afediuk Andrii Fediuk
            shirai Sayaka Hirai
            Team Doc
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: