[ZBX-15223] Dashboard widgets displaying incorrect data; database performance issues Created: 2018 Nov 27  Updated: 2019 Mar 04  Resolved: 2019 Jan 16

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 4.0.1
Fix Version/s: None

Type: Incident report Priority: Minor
Reporter: Brett Anspach Assignee: Unassigned
Resolution: Commercial support required Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File 2018-11-28_09-31-42.png     PNG File screenshot.png     PNG File screenshot2.png    

 Description   

Upgraded from 3.4.15 to 4.0.1 about 2 weeks ago.  Since then, database performance has decreased dramatically.  Prior to upgrading, SELECTs/sec were <50/sec (achieved by having a large InnoDB cache).  

Result:

After upgrading, SELECTs/sec is now a consistent 300-600/sec causing delayed writes and poor frontend performance:

  • Active triggers will sometimes not resolve (have to manually close them)
  • We use {ITEM.LASTVALUE} extensively in our trigger names.  After upgrading, many times the value displayed in the dashboard, as well as emails generated, will show the value prior to the one that would generate an alert, and no longer updates to show the current value (see screenshot.png).
  • "Duration" column regularly shows negative numbers (see screenshot.png)
  • "Problems by severity" widget take 5-7 seconds to refresh, every time it refreshes (constantly seeing the spinning circle; see screenshot2.png)

 

 Comments   
Comment by Brett Anspach [ 2018 Nov 28 ]

Another problem that pops up several times a day when the "Problems by severity" widget tries to refresh:

Comment by Brett Anspach [ 2018 Dec 05 ]

Performance issues still exist after upgrading from 4.0.1 to 4.0.2.

Comment by Aigars Kadikis [ 2019 Jan 14 ]

Hello Brett,

Please, share the following details:

  1. operating system used + version
  2. database RDMS used + version
  3. database size
  4. partitioning schema for database, if any
  5. web server used + version
  6. database and zabbix server on the same hardware
  7. how is Zabbix installed (from source or rpm packages) and repo used
  8. how was the update done (step-by-step)
  9. attach to the issue Zabbix server log file, database server log file, web server log file
  10. attach to the issue Zabbix server configuration file, database server configuration file, web server configuration file (including php settings)

Regards,

Comment by Brett Anspach [ 2019 Jan 15 ]

Thank you for your reply.  I am currently working with Alexander Yeleseyev via [email protected].

Comment by Aigars Kadikis [ 2019 Jan 16 ]

Than you Brett. Appreciate your response. Will close this ticket.

Comment by Brett Anspach [ 2019 Mar 04 ]

Issue resolved in v4.0.5.

Generated at Fri May 09 06:06:24 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.