Bug 44502

Версия
======

nagiosdigger-0.9-alt6.noarch
nagios-3.0.6-alt16.x86_64
postgresql14-14.5-alt1.x86_64

Дистрибутивы
============

- p10-server-10-x86-64

Шаги воспроизведения
====================

1. Настроить nagios, клиентов с osec, настроить nagiosdigger на работу с PostgreSQL.
2. Получить некоторые логи с nagios.
3. Перейти в веб-интерфейс Nagiosdigger: https://server/nagiosdigger
4. Перейти в Predict Problems → pearson correlation, проверить значение.

Ожидаемый результат: отсутствие ошибок SQL.

Фактический результат: присутствуют ошибки SQL.

        Query failed: ОШИБКА: деление на ноль: SELECT host2, service2, ABS((psum - (sum1 * sum2 / n)) / sqrt((sum1sq - pow(sum1, 2.0) / n) * (sum2sq - pow(sum2, 2.0) / n))) AS r, n FROM (SELECT n1.host AS host1, n1.service AS service1, n2.host AS host2, n2.service AS service2, SUM(n1.count) AS sum1, SUM(n2.count) AS sum2, SUM(n1.count * n1.count) AS sum1sq, SUM(n2.count * n2.count) AS sum2sq, SUM(n1.count * n2.count) AS psum, COUNT(*) AS n FROM (SELECT host, service, hour, COUNT(*) AS count FROM logs WHERE status_type='HARD' GROUP BY host, service, hour) AS n1, (SELECT host, service, hour, COUNT(*) AS count FROM logs WHERE status_type='HARD' GROUP BY host, service, hour) AS n2 WHERE n1.hour = n2.hour AND n1.host = 'nagios-node-10.88.9.29' AND n1.service = 'A system file changed' AND (n2.host != 'nagios-node-10.88.9.29' OR n2.service != 'A system file changed') GROUP BY host1, service1, host2, service2) AS matching ORDER BY r DESC, n DESC LIMIT 5