When I tried to use grpsum aggregate function, I got some zabbix_server error messages in log file and, eventually, zabbix_server crashed. Here is a tiny patch to solve this issue:
--- zabbix-1.1beta9/src/zabbix_server/poller/checks_aggregate.c.org 2006-04-24 10:56:34.000000000 +0200
+++ zabbix-1.1beta9/src/zabbix_server/poller/checks_aggregate.c 2006-05-16 09:39:01.000000000 +0200
@@ -86,7 +86,12 @@
zabbix_log( LOG_LEVEL_DEBUG, "SQL2 [%s]",sql2);
result = DBselect(sql);
- result2 = DBselect(sql2);
+
+ if (strlen(sql2) != 0)
+ result2 = DBselect(sql2);
+ else
+ result2 = NULL;
+
for(i=0;i<DBnum_rows(result)+DBnum_rows(result2);i ++)
{
--- zabbix-1.1beta9/src/zabbix_server/poller/checks_aggregate.c.org 2006-04-24 10:56:34.000000000 +0200
+++ zabbix-1.1beta9/src/zabbix_server/poller/checks_aggregate.c 2006-05-16 09:39:01.000000000 +0200
@@ -86,7 +86,12 @@
zabbix_log( LOG_LEVEL_DEBUG, "SQL2 [%s]",sql2);
result = DBselect(sql);
- result2 = DBselect(sql2);
+
+ if (strlen(sql2) != 0)
+ result2 = DBselect(sql2);
+ else
+ result2 = NULL;
+
for(i=0;i<DBnum_rows(result)+DBnum_rows(result2);i ++)
{
Comment