Ad Widget

Collapse

Zabbix web interface issue with Chrome

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mschlegel
    Member
    • Oct 2008
    • 40

    #31
    I applied the fixes to my 1.8.0 server a few minutes ago. So far loading the dashboard & refreshing it several times has not resulted in a UI hang. Without these changes, the UI would pretty readily hang within 1-2 refreshes of the dashboard. I'll post an update here if I do encounter another UI hang.

    Comment

    • mschlegel
      Member
      • Oct 2008
      • 40

      #32
      Ok - I think I discovered an unintended sideeffect to this change:

      After applying the updates, I added a new user group & user. The id's for both ended up being 1, which caused them to not be displayed at all.

      I changed the '$ret2 = DBend($ret2);' line to '$ret3 = DBend($ret2);' and the ID issue goes away.

      Comment

      • wax66
        Junior Member
        • Apr 2009
        • 27

        #33
        Thanks, mschlegel, this resolved my item deletion issue that resulted from the patch as well.
        -Ron

        Comment

        • nelsonab
          Senior Member
          Zabbix Certified SpecialistZabbix Certified Professional
          • Sep 2006
          • 1233

          #34
          I'm not so certain this is the complete fix.

          I just applied and I'm still having the same issue with 1.8.1.

          What was the patch supposed to do? All I can see is the closing of a DB transaction.

          Is the ids table really supposed to have profile id's which are over 7 million after 2 weeks of being installed?

          Can we get some insight into this function get_dbid ?? It would have been really nice if there were a comment or two at the start about what the function is supposed to do and how it's supposed to work then we can all look at it with you and find the error.

          I know I've harped about this for years, maybe I should add "Comment the Zabbix code some more will ya!?" to my sig...
          RHCE, author of zbxapi
          Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
          Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

          Comment

          • nelsonab
            Senior Member
            Zabbix Certified SpecialistZabbix Certified Professional
            • Sep 2006
            • 1233

            #35
            The fix is worse than the problem.

            Now pretty much with every item update I do I get the following error:
            Code:
            [LIST][*] POSSIBLE ERROR: Used incorrect logic in database processing, transaction not started![*] Error in query [insert into auditlog_details (auditdetailid,auditid,table_name,field_name,oldvalue,newvalue) values (,275,'items','description','PCU_Load','PCU_Load3')] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '275,'items','description','PCU_Load','PCU_Load3')' at line 1][*] Item 'Template_APC_General:PowerNet_MIB__rPDULoadStatusLoad_1' updated[*] POSSIBLE ERROR: Used incorrect logic in database processing, transaction not started![/LIST]
            I have verified that the patch from Aly previously is the cause of the error. Backing out the patch causes things to work just as before... So long as no one else accesses Zabbix things are great!
            RHCE, author of zbxapi
            Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
            Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

            Comment

            • ugh
              Senior Member
              • Jun 2009
              • 296

              #36
              we have the same problem
              on different servers, with different intervals
              and a patch leads to similar results as described in the previous post

              *
              often observed when multiple users are browsing screens with lots of graphics
              Last edited by ugh; 01-03-2010, 12:06.

              Comment

              Working...