[ZBXNEXT-3201] New high-performance view of current problems Created: 2016 Mar 18 Updated: 2017 Jul 19 Resolved: 2016 Dec 15 |
|
Status: | Closed |
Project: | ZABBIX FEATURE REQUESTS |
Component/s: | API (A), Frontend (F), Installation (I), Server (S) |
Affects Version/s: | None |
Fix Version/s: | 3.2.0alpha1, 3.2.0alpha2, 3.2.0beta2 |
Type: | Change Request | Priority: | Major |
Reporter: | Alexander Vladishev | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 9 |
Labels: | events, performance | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Attachments: | event details.png event_ack.png macros.png new-icon-green.png new-icon-grey.png new-icon-red.png new-icon-yellow.png no_data_sort_host.jpg old-icon-grey.png old-icon-red.png old-icon-yellow.png problem_sort.png space.png tag_lenght.png time_bar_issue.png unixtime 0.png | ||||||||||||
Issue Links: |
|
Description |
Current way of working with a list of active problems is very inefficient due to complex processing of historical table events. Also Zabbix displays problems in two different views: Monitoring?Triggers and Monitoring?Events. It confuses users and makes little sense. Another serious usability issue is displaying of OK events everywhere. It takes valuable space and makes reading of current problems confusing. It is proposed to make a unified view Monitoring?Problems that will take advantage of the new table problem and will contain list of active problems as well as history of problems. |
Comments |
Comment by Marc [ 2016 Apr 01 ] | ||||||||||
By stating to "[...] make a unified view [..]", is it meant to provide this view in addition or to replace the current views Triggers and Events, resp. to implement one view that supports each of these aspects? While I can confirm that it is indeed confusing to new or non-power-users, it is pretty valuable to have these two aspects on issues. One aspect for the current state and another aspect for identifying what happened at a certain period in time. A replacement view for Triggers and Events that provides several aspects sounds to be the best approach to me but is possibly also the most challenging one from a UX perspective. However, if a good implementation design is found, that's to say one view that allows different kind of aspects with flexible but intuitive filter options, then this promises to become a huge improvement to users. Btw, yet another aspect could be ZBXNEXT-2695. | ||||||||||
Comment by Alexei Vladishev [ 2016 May 27 ] | ||||||||||
The new view is supposed to support all functionality we already have under Monitoring->Triggers and Monitoring->Events along with additional filtering options and much better performance. | ||||||||||
Comment by Alexander Vladishev [ 2016 Jul 15 ] | ||||||||||
Available in development branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201 | ||||||||||
Comment by Alexander Vladishev [ 2016 Jul 15 ] | ||||||||||
(1) Changed translation strings: Strings added:
iivs CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Jul 15 ] | ||||||||||
Available in pre-3.1.0 (trunk) r61049. | ||||||||||
Comment by Alexander Vladishev [ 2016 Jul 18 ] | ||||||||||
(2) Related to Administration -> Media types: "exec_params_count" can be removed. sasha RESOLVED in trunk@61073,61074 iivs CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Jul 18 ] | ||||||||||
(3) Links to event details is missing from problem view sasha RESOLVED in trunk@61077 iivs CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Jul 18 ] | ||||||||||
(4) Broken "Host" column in Monitoring->Triggers view sasha RESOLVED in trunk@61081 iivs CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Jul 18 ] | ||||||||||
(5) Bulk acknowledge sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61346. gunarspujats CLOSED | ||||||||||
Comment by Ivo Kurzemnieks [ 2016 Jul 19 ] | ||||||||||
(6) [D] API documentation updated
RESOLVED gunarspujats CLOSED | ||||||||||
Comment by Ivo Kurzemnieks [ 2016 Jul 19 ] | ||||||||||
(8) [F] Acknowledging problems, view switches to last page. So does the cancel. sasha RESOLVED in trunk@r61145 iivs CLOSED | ||||||||||
Comment by Ivo Kurzemnieks [ 2016 Jul 19 ] | ||||||||||
(9) [F] Problems page shows 8689+ records at the bottom, while other pages show only 1001+. Also API count returns 9849 records. Filter was reset, so shouldn't everything be selected? sasha Problem view does not show old resolved problems. It depends on "Display OK triggers for" option. sasha RESOLVED in trunk@r61143 iivs CLOSED | ||||||||||
Comment by Ivo Kurzemnieks [ 2016 Jul 19 ] | ||||||||||
(10) [F] Sorting by severity doesn't change. Looks exactly like sorted by time. alexei RESOLVED in trunk@r61120 iivs Looks good now. | ||||||||||
Comment by Ivo Kurzemnieks [ 2016 Jul 19 ] | ||||||||||
(11) [F] As discussed, the extension of Monitoring -> Problems view from sasha RESOLVED in r62098 Strings added:
gunarspujats CLOSED | ||||||||||
Comment by Ivo Kurzemnieks [ 2016 Jul 19 ] | ||||||||||
(12) [A] Specification states that possible sorting columns for problem.get are eventid and clock, however objectid is implemented as well. Also there is no clock index on problem table. sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61320. gunarspujats CLOSED | ||||||||||
Comment by Ivo Kurzemnieks [ 2016 Jul 19 ] | ||||||||||
(13) [F] Coding style and other minor issues:
sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61316 gunarspujats CLOSED | ||||||||||
Comment by Alexei Vladishev [ 2016 Jul 20 ] | ||||||||||
(14) [F] sorting by priority in problem view does not work alexei RESOLVED in revision 61120. iivs How is this different from (10)? sasha CLOSED as duplicate of (10) | ||||||||||
Comment by Alexei Vladishev [ 2016 Jul 20 ] | ||||||||||
(15) [F] after first in-line refresh all sorting links in table header become incorrect sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61336. gunarspujats CLOSED | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Jul 28 ] | ||||||||||
(16) [F] Performance issue (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /var/www/zbxnext_3274/include/classes/api/CRelationMap.php on line 77 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 78 bytes) in /var/www/zbxnext_3274/include/classes/api/CApiService.php on line 286 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /var/www/zbxnext_3274/include/classes/api/CApiService.php on line 286 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /var/www/zbxnext_3274/include/classes/api/CApiService.php on line 286 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /var/www/zbxnext_3274/include/classes/api/CApiService.php on line 286 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 64 bytes) in (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /var/www/zbxnext_3274/include/classes/api/CRelationMap.php on line 48 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 80 bytes) in /var/www/zbxnext_3274/include/db.inc.php on line 599 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 85 bytes) in /var/www/zbxnext_3274/include/db.inc.php on line 599 (mod_fastcgi.c.2673) FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 78 bytes) in /var/www/zbxnext_3274/include/classes/api/CRelationMap.php on line 73 Moved from sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61291:r61312 sandis.neilands It is better now however with 105k problems the "Problems" page still runs out of memory. This shouldn't happen since we show only 20 pages, e.g. 1000 problems by default. gunarspujats CLOSED | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Jul 28 ] | ||||||||||
(17) [F] Moved from sandis.neilands: What does the 'Action' column in 'Problems' page is supposed to show? Just the actions taken for problem event, problem and ok event? sasha RESOLVED in r62041 Strings added:
Strings deleted:
gunarspujats CLOSED sasha added displaying of total number of actions in r62141 RESOLVED gunarspujats CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 02 ] | ||||||||||
(18) Different filter controls in Monitoring->Triggers, Monitoring->Overview and Monitoring->Problems sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61335. gunarspujats CLOSED | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 02 ] | ||||||||||
(19) [F] if sorting by host empty list, errors Undefined variable: triggers_hosts [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() in include/classes/screens/CScreenProblem.php:166] Invalid argument supplied for foreach() [zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() in include/classes/screens/CScreenProblem.php:166] picture no_data_sort_host.jpg sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61348. | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 04 ] | ||||||||||
(20) [F] Based on specification "Displayed tag and tag value length is limited to N pixels". No limit to N pixels, now displaying all 255 symbols of tag and tag value sasha Already fixed in | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 04 ] | ||||||||||
(21) [F] no space between third tag and '...' , with space looks better sasha RESOLVED in dev branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 r61436 gunarspujats CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 05 ] | ||||||||||
svn://svn.zabbix.com/branches/dev/ZBXNEXT-3201-1 was merged to trunk r61447. | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 22 ] | ||||||||||
2nd phase was implemented in pre-3.2.0alpha2 r61801. | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 22 ] | ||||||||||
(22) 2nd phase translation strings: Strings added:
Strings deleted:
oleg.egorov CLOSED | ||||||||||
Comment by richlv [ 2016 Aug 22 ] | ||||||||||
(23) changelog entry currently says :
it might be worth specifying what was improved (performance ? something else ?) sasha CLOSED as duplicate of (6) richlv hmm, will the person updating the API docs remember to change the changelog entry ? maybe that's worth adding in that subissue ? sasha You are right! FIXED in r64478 CLOSED | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 23 ] | ||||||||||
(24) [F] when use filtering options "Show:History", "Tags:any tag name and tag value" geting error Error in query [SELECT e.eventid,e.objectid,e.clock,e.ns FROM events e WHERE e.source='0' AND e.object='0' AND EXISTS (SELECT NULL FROM event_tag et WHERE e.eventid=et.eventid AND et.tag='TagName' AND UPPER(pt.value) LIKE'%TESTVALUE%' ESCAPE '!') AND e.clock>='1408860125' AND e.clock<='1471932125' AND e.value='1' ORDER BY e.eventid DESC LIMIT 1001 OFFSET 0] [Unknown column 'pt.value' in 'where clause'] sasha RESOLVED in r61872 oleg.egorov CLOSED | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Aug 23 ] | ||||||||||
(25) [F] Time bar issue in Monitoring->Problems if selected all period sasha Cannot reproduce. Seems the bug is related to timebar. CLOSED | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 23 ] | ||||||||||
(26) [F] not renamed labels according specification in Administration->General->Trigger displaying options: sasha it is decided to leave these labels without changes CLOSED | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 23 ] | ||||||||||
(27) [F] according to the specification "Show events not older than (in days)" and "Max count of events per trigger to show" should be removed in Administration->General->GUI sasha These fields already used in tr_status.php. Specification must be updated. WON'T FIX | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Aug 23 ] | ||||||||||
(28) [I] Missed upgrade patch, event_expire and event_show_max should be removed from config table. sasha These fields already used in tr_status.php. Specification must be updated. WON'T FIX | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 23 ] | ||||||||||
(29) [F] sorting by any type, change current page number oleg.egorov After bulk acknowledge happens same issue sasha RESOLVED in r61873 natalja.zabbix UI successfully tested oleg.egorov CLOSED | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Aug 23 ] | ||||||||||
(30) [A] Slow query SQL (65.140725) SELECT e.eventid,e.objectid,e.clock,e.ns FROM events e WHERE e.source='0' AND e.object='0' AND (e.objectid BETWEEN '15353' AND '15398' OR e.objectid BETWEEN '15411' AND '15423' OR e.objectid BETWEEN '15493' AND '15505' OR e.objectid BETWEEN '16165' AND '16177' OR e.objectid BETWEEN '16180' AND '16189' OR e.objectid IN ('15440','15441','15442','15443','15543','15547','15548','15550','15551','15553','15561','15563','16162')) AND EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hg,triggers t WHERE e.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND (hg.groupid BETWEEN '4' AND '9' OR hg.groupid BETWEEN '16' AND '25' OR hg.groupid IN ('1','2','11','12','14','30','32','43','45','46','47','48')) AND i.hostid='10343' AND e.objectid=t.triggerid AND t.priority='5') AND e.acknowledged=0 AND e.clock>='1436821200' AND e.clock<='1457902800' AND e.value='1' ORDER BY e.eventid DESC LIMIT 1001 OFFSET 0 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem->getData() → CScreenProblem->getDataEvents() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include\classes\api\services\CEvent.php:379 Debug info: Total time: 69.799992 Total SQL time: 66.112774000004 SQL count: 2339 (selects: 1523 | executes: 816) Peak memory usage: 63.25M Memory limit: 3072M Installation: 3,055,333 - events 2,167 - triggers sasha I can't reproduce this issue. SQL (0.232991): SELECT e.eventid,e.objectid,e.clock,e.ns FROM events e WHERE e.source='0' AND e.object='0' AND e.objectid IN ('13666','13782','13784','13786','13788','13790','13792','13794','13796','13798','13800','13802','13804','13806','13808','13810','13812','13814','13816','13818','13820','13822','13824','13826','13828','13830','13832','13834','13836','13838','13840','13842','13844','13846','13848','13850','13852','13854','13856','13858','13860','13862','13864','13866','13868','13870','13872','13874','13876','13878') AND EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hg,triggers t WHERE e.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND (hg.groupid BETWEEN '4' AND '16' OR hg.groupid IN ('1','2')) AND i.hostid IN ('10084','10105') AND e.objectid=t.triggerid AND t.priority IN ('2','3','4','5')) AND e.acknowledged=0 AND e.clock>='1408909797' AND e.clock<='1471981797' AND e.value='1' ORDER BY e.eventid DESC LIMIT 1001 OFFSET 0 zabbix.php:21 → require_once() → ZBase->run() → ZBase->processRequest() → CView->getOutput() → include() → CScreenProblem->get() → CScreenProblem->getData() → CScreenProblem->getDataEvents() → CFrontendApiWrapper->get() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → call_user_func_array() → CEvent->get() → DBselect() in include/classes/api/services/CEvent.php:379 Debug info: ******************** Script profiler ******************** Total time: 0.298484 Total SQL time: 0.262083 SQL count: 58 (selects: 35 | executes: 23) Peak memory usage: 6.75M Memory limit: 512M Installation: 1,135,455 - events 402 - triggers sasha WON'T FIX | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Aug 23 ] | ||||||||||
(31) [F] In Monitoring->Problems displaying event acknowledge errors. Open in the new tab Event acknowledge , then try to submit space till page refreshed without error message. sasha WON'T FIX | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Aug 23 ] | ||||||||||
(32) [F] Triggers (tr_status.php) regression In "Trigger" page select old, problem trigger, then on popup select "Problems" link... and there is no result, because it's was old issue. sasha Already discussed with alexei. It was decided to show only recent problems from triggers popup menu. WON'T FIX | ||||||||||
Comment by Natalja Romancaka [ 2016 Aug 24 ] | ||||||||||
(33) [F] macros not opened in trigger input after filtering sasha RESOLVED in r61876 natalja.zabbix UI successfully tested oleg.egorov CLOSED | ||||||||||
Comment by Oleg Egorov (Inactive) [ 2016 Aug 24 ] | ||||||||||
(34) [F] Possible memory leak, tested on IE11 Will be tested on other browsers. Night test results: iivs My IE11 is eating 28kb/s. Over night it ate around 1.6GB of RAM. Trying to resize browser in the morning and using navigation to check if browser still works, it just freezes up and still continues to consume more memory. At this point I'm not sure if this is the only page or any page with 30s (default) refresh and left unattended for long periods of time. oleg.egorov Won't fix. CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 25 ] | ||||||||||
Fixed in pre-3.2.0beta1 r61938. | ||||||||||
Comment by Backoffice Team [ 2016 Aug 29 ] | ||||||||||
When housekeeper remove an event (or in our test we truncated events table), the Monitoring => problems page shows an event age equal as the start of time, or unixtime at least. The events page seems to be OK. See the attachments below.
| ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 30 ] | ||||||||||
backoffice.team, it is already fixed under | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 30 ] | ||||||||||
(35) Show details filter option is not implemented sasha RESOLVED in r62059 gunarspujats CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 30 ] | ||||||||||
(36) Problems in CLOSING state are not blinking sasha RESOLVED in r62060 gunarspujats CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 31 ] | ||||||||||
(37) Applied new icons
sasha RESOLVED in r62125 gunarspujats CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Aug 31 ] | ||||||||||
(11), (17), (35), (36) and (37) are fixed in pre-3.2.0beta2 r62146. | ||||||||||
Comment by Natalja Romancaka [ 2016 Sep 02 ] | ||||||||||
(38) [F] incorrect values in "action" and "tag" column in exported csv file from Monitoring->Problem page. Tag column empty, but in action column tag values iivs RESOLVED in r62308 natalja.zabbix ui successfully tested sasha CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Sep 06 ] | ||||||||||
(39) [F] fixed displaying of actions popup; added footer for truncated action list sasha RESOLVED in r62326. Strings deleted:
oleg.egorov Fixed coding style in r62332. CLOSED | ||||||||||
Comment by Alexander Vladishev [ 2016 Sep 06 ] | ||||||||||
(38) and (39) are fixed in pre-3.2.0beta3 r62334. |