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.
Ad Widget
Collapse
Zabbix web interface issue with Chrome
Collapse
X
-
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
-
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
-
The fix is worse than the problem.
Now pretty much with every item update I do I get the following error:
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!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]
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
-
Comment