zabbix server crash on ubuntu 6.10

[limo]

Hi all,

I have problem on ubuntu 6.10. I have compiled zabbix 1.3.1 and use mysql.

$ ./configure --prefix=/usr/local/zabbix/ --enable-agent --enable-server --with-ldap --with-mysql --with-net-snmp

Installed packages:

ii  libdbd-mysql-perl                          3.0006-1                      A Perl5 database interface to the MySQL data
ii  libmysqlclient14                           4.1.15-1ubuntu5               mysql database client library
ii  libmysqlclient14-dev                       4.1.15-1ubuntu5               mysql database development files
rc  libmysqlclient15-dev                       5.0.24a-9                     mysql database development files
ii  libmysqlclient15off                        5.0.24a-9                     mysql database client library
ii  mysql-client-5.0                           5.0.24a-9                     mysql database client binaries
ii  mysql-common                               5.0.24a-9                     mysql database common files (e.g. /etc/mysql
ii  mysql-server-5.0                           5.0.24a-9                     mysql database server binaries
ii  php5-mysql                                 5.1.6-1ubuntu2.1              MySQL module for php5
ii  php5-mysqli                                5.1.6-1ubuntu2.1              MySQL Improved module for php5
ii  libsnmp4.2                                 4.2.5-5.2                     NET SNMP (Simple Network Management Protocol
ii  libsnmp9                                   5.2.2-5ubuntu1                NET SNMP (Simple Network Management Protocol
ii  libsnmp9-dev                               5.2.2-5ubuntu1                NET SNMP (Simple Network Management Protocol

I tried libmysql15-dev even libmysql14-dev. Zabbix server is runing some small time and then it dies:

 17790:20061231:132409 In get_values()
 17790:20061231:132409 Executing query:select i.itemid,i.key_,h.host,h.port,i.delay,i.description,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h.useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.hostid,h.status,i.value_type,h.errors_from,i.snmp_port,i.delta,i.prevorgvalue,i.lastclock,i.units,i.multiplier,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.formula,h.available,i.status,i.trapper_hosts,i.logtimefmt,i.valuemapid,i.delay_flex from hosts h, items i where i.nextcheck<=1167567849 and i.status in (0,3) and i.type not in (2,7) and h.status=0 and h.disable_until<=1167567849 and h.errors_from=0 and h.hostid=i.hostid and mod(i.itemid,5)=4 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and  h.hostid>=100000000000000*0 and h.hostid<=(100000000000000*0+99999999999999)  order by i.nextcheck
 17786:20061231:132409 After DBselect()
 17786:20061231:132409 GOT VALUE TYPE [0x0]
 17786:20061231:132409 get_value_agent: host[donalisa] ip[] key [kern[maxproc]]
 17786:20061231:132410 Sending [kern[maxproc]
]
 17786:20061231:132410 Executing query:begin;
 17795:20061231:132410 In delete_history(history_log,30064781144,1167567844,-1214563472)
 17795:20061231:132410 Executing query:select min(clock) from history_log where itemid=5014665705841239896
 17786:20061231:132410 Executing query:update items set nextcheck=1167568449, lastclock=1167567849 where itemid=17230
 17787:20061231:132410 After DBselect()
 17787:20061231:132410 GOT VALUE TYPE [0x0]
 17787:20061231:132410 In get_value_simple([nntp]
 17787:20061231:132410 Sysinfo [net.tcp.service[nntp,donalisa]]
 17776:20061231:132410 One child process died. Exiting ...
 17776:20061231:132410 zbx_on_exit() called.
 17788:20061231:132410 Got signal. Exiting ...
 17789:20061231:132410 Got signal. Exiting ...
 17790:20061231:132410 Got signal. Exiting ...
 17792:20061231:132410 Got signal. Exiting ...
 17794:20061231:132410 Got signal. Exiting ...
 17795:20061231:132410 Got signal. Exiting ...
 17796:20061231:132410 Got signal. Exiting ...
 17797:20061231:132410 Got signal. Exiting ...
 17798:20061231:132410 Got signal. Exiting ...
 17791:20061231:132410 Got signal. Exiting ...
 17793:20061231:132410 Got signal. Exiting ...
 17776:20061231:132412 ZABBIX Server stopped

gdb says this, so I think this is mysql client related bug..

 gdb src/zabbix_server/zabbix_server
GNU gdb 6.4.90-debian
Copyright (C) 2006 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "i486-linux-gnu"...Using host libthread_db library "/lib/tls/i686/cmov/libthread_db.so.1".

(gdb) Quit
(gdb) set ch
charset  check
(gdb) set follow-fork-mode child
(gdb) run -c /etc/zabbix/zabbix_server_beta.conf
Starting program: /usr/src/zabbix-1.3.1/src/zabbix_server/zabbix_server -c /etc/zabbix/zabbix_server_beta.conf
[Thread debugging using libthread_db enabled]
[New Thread -1214556496 (LWP 19691)]
[tcsetpgrp failed in terminal_inferior: Operation not permitted]

Program received signal SIGTERM, Terminated.
[Switching to process 19705]
0xffffe410 in __kernel_vsyscall ()
(gdb) backtrace
#0  0xffffe410 in __kernel_vsyscall ()
#1  0xb7bb67cb in poll () from /lib/tls/i686/cmov/libc.so.6
#2  0xb7c453ad in __res_queriesmatch () from /lib/tls/i686/cmov/libresolv.so.2
#3  0xb7c44153 in __libc_res_nquery () from /lib/tls/i686/cmov/libresolv.so.2
#4  0xb7c443f0 in __libc_res_nquery () from /lib/tls/i686/cmov/libresolv.so.2
#5  0xb7c4463a in __libc_res_nsearch () from /lib/tls/i686/cmov/libresolv.so.2
#6  0xb7958976 in _nss_dns_gethostbyname3_r () from /lib/tls/i686/cmov/libnss_dns.so.2
#7  0xb7958b9b in _nss_dns_gethostbyname_r () from /lib/tls/i686/cmov/libnss_dns.so.2
#8  0xb7bd72f7 in gethostbyname_r () from /lib/tls/i686/cmov/libc.so.6
#9  0xb7bd6c40 in gethostbyname () from /lib/tls/i686/cmov/libc.so.6
#10 0x0805fa23 in get_value_agent (item=0xbfb6d1f0, result=0xbfb6d1c8) at checks_agent.c:66
#11 0x080602fc in get_value (item=0xbfb6d1f0, result=0xbfb6d1c8) at poller.c:78
#12 0x08060575 in get_values () at poller.c:263
#13 0x08060d24 in main_poller_loop (type=0, num=1) at poller.c:397
#14 0x08052e69 in MAIN_ZABBIX_ENTRY () at server.c:559
#15 0x0805e328 in daemon_start (allow_root=0) at daemon.c:173
#16 0x080529e8 in main (argc=3, argv=0xbfb6d5b4) at server.c:457
(gdb)

Hope this will help to find the bug...

best regards and happy new yer!

[limo]

Reporting that everything works with 1.3.2!
Thanx!