[ZBX-4849] Trigger frozen Created: 2012 Apr 09  Updated: 2017 May 30  Resolved: 2012 Apr 18

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.10
Fix Version/s: 1.8.13rc1

Type: Incident report Priority: Minor
Reporter: Rafael Gomes Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: trigger
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 6
Linux hermes 2.6.32-220.el6.x86_64 #1 SMP Tue Dec 6 19:48:22 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux
php-5.3.3-3.el6_2.6.x86_64
php-common-5.3.3-3.el6_2.6.x86_64
php-mysql-5.3.3-3.el6_2.6.x86_64
php-xml-5.3.3-3.el6_2.6.x86_64
php-bcmath-5.3.3-3.el6_2.6.x86_64
php-mcrypt-5.3.3-1.el6.x86_64
php-mbstring-5.3.3-3.el6_2.6.x86_64
php-cli-5.3.3-3.el6_2.6.x86_64
php-pdo-5.3.3-3.el6_2.6.x86_64
php-gd-5.3.3-3.el6_2.6.x86_64
php-php-gettext-1.0.11-3.el6.noarch
httpd-2.2.15-15.el6.centos.1.x86_64
mysql-server-5.1.61-1.el6_2.1.x86_64
mysql-libs-5.1.61-1.el6_2.1.x86_64
mysql-devel-5.1.61-1.el6_2.1.x86_64
mysql-5.1.61-1.el6_2.1.x86_64
zabbix-server-mysql-1.8.10-1.el6.x86_64
zabbix-1.8.10-1.el6.x86_64
zabbix-web-1.8.10-1.el6.noarch
zabbix-agent-1.8.10-1.el6.x86_64
zabbix-server-1.8.10-1.el6.x86_64
zabbix-web-mysql-1.8.10-1.el6.noarc


Attachments: XML File zbx_templates_export(2).xml     XML File zbx_templates_export(3).xml    

 Description   

I was working on trigger of template, when that page don't open any triggers.
I did refresh that page, just return blank page.

I restart all services (Apache, Zabbix-server, mysqld) and no changes.

I saw in my zabbix monitor that my query per second of mysqld increase from 30 qps for more than 1000.

I check all tables through phpMyAdmin and return just ok.

This template was added in one host only, I disabled that host. Export this template, remove and import again. Now I can access that trigger of template again.

I can't clone that host, because the problem remains. I needed to create a new host and put that template to work fine.

How can I fix this problem? Because all history of this host was lost.



 Comments   
Comment by Rafael Gomes [ 2012 Apr 09 ]

How to reproduce:

configuration -> template -> trigger link of the template -> Blank page

Comment by Rafael Gomes [ 2012 Apr 09 ]

Template

Comment by richlv [ 2012 Apr 09 ]

do you see any errors in the webserver log ?

Comment by Rafael Gomes [ 2012 Apr 09 ]

Just that PHP Error:

[Sun Apr 08 21:23:43 2012] [error] [client 172.21.21.6] PHP Fatal error: Maximum execution time of 600 seconds exceeded in /usr/share/zabbix/api/classes/class.chost.php on line 308, referer: https://monitoramento.br/templates.php?sid=c8f4b917c7b01a43
[Sun Apr 08 22:04:21 2012] [error] [client 172.21.21.6] PHP Fatal error: Maximum execution time of 600 seconds exceeded in /usr/share/zabbix/include/db.inc.php on line 435, referer: https://monitoramento.brtemplates.php?sid=c8f4b917c7b01a43
[Sun Apr 08 22:09:45 2012] [error] [client 172.21.21.6] PHP Fatal error: Maximum execution time of 600 seconds exceeded in /usr/share/zabbix/api/classes/class.chost.php on line 510, referer: https://monitoramento.br/index.php?request=%2Ftriggers.php%3Fgroupid%3D1%26hostid%3D10001

Comment by Pavels Jelisejevs (Inactive) [ 2012 Apr 10 ]

I'm having difficulties reproducing the problem. What page exactly was failing, the trigger configuration page with the list of all triggers on that template, or the configuration page of a specific trigger?

Could you please also export the Template_Servidor and all the templates Template_Servidor may be linked to?

Comment by Rafael Gomes [ 2012 Apr 10 ]

Was failing when I tried edit a trigger in template page.

I will attach Template_servidor too.

Comment by Rafael Gomes [ 2012 Apr 10 ]

Template_Servidor

Comment by Pavels Jelisejevs (Inactive) [ 2012 Apr 12 ]

It seems that the problem is caused by the "Memória RAM em nível alarmante" trigger: it has both an item from the template, and from the "Zabbix server" host in it's expression. Zabbix doesn't support mixing host and template items in a trigger expression, and a validation error should have occurred, when you saved the trigger, but didn't due to a bug. Try to delete this trigger and recreate it without the host item, it should work.

In the mean time I'll fix the expression validation.

Comment by Rafael Gomes [ 2012 Apr 12 ]

Did you reproduced the problem?

Because my problem don't appear immediately after put this two triggers.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Apr 12 ]

Only with that trigger, others work fine.

Comment by Rafael Gomes [ 2012 Apr 12 ]

Great else, problem solved? Do you will write a patch to avoid this problem?

Comment by Pavels Jelisejevs (Inactive) [ 2012 Apr 13 ]

Yes, it will be fixed soon.

You'll still need to recreate the trigger without the host item on your installation though.

Comment by Rafael Gomes [ 2012 Apr 13 ]

Here works well without duplicate trigger.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Apr 16 ]

RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-4849.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Apr 25 ]

Fixed in 1.8 r27086.

CLOSED.

Generated at Sat Apr 27 01:32:55 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.