Stuck in loading screen Availability report

[MonZabbix]

Version : 6.0.5

Hello everyone!

I wanted to check the report sections of Zabbix, I went on Reports → Availability report.

I displayed my triggers by hosts, everything was working then I clicked on the "By trigger template" on the top right of my screen and my page is constantly loading, I cannot do anything.

Tried to switch back to the "By host" option, still loading doesn't do anything. I restarted the apache service, the zabbix-server , even rebooted my vm's...

If anyone has got a solution, i will really appreciate it.

Thank you a lot.

Proof:

[vladimir_lv]

Hi!
Change DebugLevel parameter in zabbix_server.conf to 4:
DebugLevel = 4
then reload Zabbix server and try to reproduce the issue. Please, attach the log file to this post.

[MonZabbix]

Hi vladimir_lv!

Thank you for your quick reply.

Here is the log file as requested.

https://drive.google.com/file/d/1p1pHdiMtlHZ24eyShsZQnTRFgdJ6wD8F/view?usp=sharing

Preview of the file:

[vladimir_lv]

I am sorry, but there is an error:

There was an error retrieving your file.

[MonZabbix]

Sorry about that, i edited the link above.

Thank you.

[vladimir_lv]

I am sorry, I was wrong. We speak about frontend error, not about server. So, the first thing ( second in our case )) ) I think of is way to increase PHP memory_limit.

[MonZabbix]

No problem Vladimir,

Thank you for trying to help me.

Unfortunately, I increase the PHP memory_limit and it is still looping...

I think i had put too many hosts on the Availibility report section and once I clicked on the "by trigger template" it started looping.

I really don't know what to do.

[vladimir_lv]

Do you have something in the Apache log at the moment when you click on the "By trigger template"? Is the frontend continuing to work if you click on another menu option, for example, Monitoring->Problems?
Also check the version of php-fpm

[MonZabbix]

By default, when I go on Reports → Availability report, It's not going by the option "By host" but It's going by the option "By trigger template".

Yes, my frontend perfectly works on all others menu option, it is only the Availability report one who's not working.

For the php-fpm version, I didn't had it installed, now it is.



On the apache error log, I don't see anything and in the access log I only see that he's trying to acces the report2 ( Availability report) tab.

Preview of the access log:

MYIP - - [10/Jun/2022:10:30:44 +0200] "POST /zabbix/zabbix.php?action=notifications.get&sid=d51955876a adc29a&output=ajax HTTP/1.1" 200 1064 "http://zabbix.local/zabbix/report2.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:31:14 +0200] "POST /zabbix/zabbix.php?action=notifications.get&sid=d51955876a adc29a&output=ajax HTTP/1.1" 200 1065 "http://zabbix.local/zabbix/report2.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:31:44 +0200] "POST /zabbix/zabbix.php?action=notifications.get&sid=d51955876a adc29a&output=ajax HTTP/1.1" 200 1065 "http://zabbix.local/zabbix/report2.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:14 +0200] "POST /zabbix/zabbix.php?action=notifications.get&sid=d51955876a adc29a&output=ajax HTTP/1.1" 200 1065 "http://zabbix.local/zabbix/report2.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:33 +0200] "GET /zabbix/report2.php HTTP/1.1" 200 43049 "http://zabbix.local/zabbix/zabbix.php?action=dashboard.view" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:33 +0200] "GET /zabbix/report2.php HTTP/1.1" 200 43050 "http://zabbix.local/zabbix/zabbix.php?action=dashboard.view" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:34 +0200] "GET /zabbix/report2.php HTTP/1.1" 200 43050 "http://zabbix.local/zabbix/zabbix.php?action=dashboard.view" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:34 +0200] "GET /zabbix/report2.php HTTP/1.1" 200 43049 "http://zabbix.local/zabbix/zabbix.php?action=dashboard.view" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:34 +0200] "GET /zabbix/report2.php HTTP/1.1" 200 43051 "http://zabbix.local/zabbix/zabbix.php?action=dashboard.view" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:34 +0200] "GET /zabbix/report2.php HTTP/1.1" 200 43049 "http://zabbix.local/zabbix/zabbix.php?action=dashboard.view" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:35 +0200] "GET /zabbix/jsLoader.php?ver=6.0.5&lang=fr_FR&files%5B0%5D=cla ss.calendar.js&files%5B1%5D=gtlc.js&files%5B2%5D=r eport2.js&files%5B3%5D=servercheck.js HTTP/1.1" 304 196 "http://zabbix.local/zabbix/report2.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"
MYIP - - [10/Jun/2022:10:32:35 +0200] "GET /zabbix/jsLoader.php?ver=6.0.5&lang=fr_FR&showGuiMessaging =1 HTTP/1.1" 304 196 "http://zabbix.local/zabbix/report2.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36"


As always, thank you for your help Vladimir.

[vladimir_lv]

Hmm... Open your browser in incognito mode and try again. Any success?

[MonZabbix]

Already tried to clear my browser cache, didn't do anything.

Even thought I tried as you said in incognito mode, still page is looping constantly.

I think the issue comes from Zabbix but i don't know where.

[vladimir_lv]

Very strange that there are no errors on the Apache side. Let's check all slow queries for MySQL.
To enable the slow query log, type the following command at the mysql> prompt:
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = X; where X is time in seconds, for example, 5
SET GLOBAL slow_query_log_file = '/path/filename';

To verify that the slow query log is working correctly, log out of the mysql program, and then log back in. Type the following command, replacing X with a value that is greater than the long_query_time setting:
SELECT SLEEP(7);
The slow query log file should contain information about the query.
Then repeat all again and check the slow query log.

[MonZabbix]

Im using postgreSQL as a database. This database is not on the same server as my Zabbix one, it is a remote database server linked to Zabbix, i will try to find the alternative of your solution with postgre and will come back to you.

Thank you Vladimir!

[vladimir_lv]

One more thing, verify the value of max_execution_time, open Availability report->By trigger template and wait as long as value of max_execution_time. Then check Apache error log again

[MonZabbix]

Max execution time is set at 30 seconds,

Checked apache error log, nothing happened. Why does the max execution time for this script is set at 30 seconds and this is still looping?

Checked postgresql logs and I find this error which i believe is unrelated to our issue:

could not rename the temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat" permission denied

[vladimir_lv]

To enable slow query log for PostgreSQL you have to do the following:
Find the location of postgresql.conf file for your database:
find / -name postgresql.conf
Open the file postgresql.conf in your favorite text editor.
vi postgresql.conf
Search for the line: #log_min_duration_statement = -1
Un-comment it and replace it with: log_min_duration_statement = X, where X is time milliseconds, for example, 500
Inside the postgresql.conf, make sure that logging_collector is turned on:
logging_collector = on
Save the file and reload the PostgreSQL.

Did you do that?