a lot of zombie processes with cactid

[luckyeraser]

Hi

cactid produces a lot of zombie processes on my machine, all graph are up to date, but the machine is very slow during a poll.
The zombies are all php processes. about 300!


with cmd.php as poller, everything is fine but it tooks 50% longer then cactid.

Statistics:

07/15/2006 10:02:02 PM - SYSTEM STATS: Time:121.7181 Method:cactid Processes:3 Threads:20 Hosts:106 HostsPerProcess:36 DataSources:2120 RRDsProcessed:1263

07/15/2006 10:08:06 PM - SYSTEM STATS: Time:185.9576 Method:cmd.php Processes:3 Threads:N/A Hosts:106 HostsPerProcess:36 DataSources:2120 RRDsProcessed:1261



Enviroment:

Fedora 2
php 4.3.10
MySQL 3.23.58
HP Proliant DL 360 G3, Xeon Processor, 1 GB RAM



Any ideas ?

Michael

[TheWitness]

Can you please test the SVN version of Cactid. It is in Branch_0_8_6. Please provide feeback.

TheWitness

[luckyeraser]

I tried it, but i get compiler errors

===
[root@hades cactid]# make

if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT sql.o -MD -MP -MF ".deps/sql.Tpo" -c -o sql.o sql.c; \
then mv -f ".deps/sql.Tpo" ".deps/sql.Po"; else rm -f ".deps/sql.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT cactid.o -MD -MP -MF ".deps/cactid.Tpo" -c -o cactid.o cactid.c; \
then mv -f ".deps/cactid.Tpo" ".deps/cactid.Po"; else rm -f ".deps/cactid.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT util.o -MD -MP -MF ".deps/util.Tpo" -c -o util.o util.c; \
then mv -f ".deps/util.Tpo" ".deps/util.Po"; else rm -f ".deps/util.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT snmp.o -MD -MP -MF ".deps/snmp.Tpo" -c -o snmp.o snmp.c; \
then mv -f ".deps/snmp.Tpo" ".deps/snmp.Po"; else rm -f ".deps/snmp.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT locks.o -MD -MP -MF ".deps/locks.Tpo" -c -o locks.o locks.c; \
then mv -f ".deps/locks.Tpo" ".deps/locks.Po"; else rm -f ".deps/locks.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT poller.o -MD -MP -MF ".deps/poller.Tpo" -c -o poller.o poller.c; \
then mv -f ".deps/poller.Tpo" ".deps/poller.Po"; else rm -f ".deps/poller.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT nft_popen.o -MD -MP -MF ".deps/nft_popen.Tpo" -c -o nft_popen.o nft_popen.c; \
then mv -f ".deps/nft_popen.Tpo" ".deps/nft_popen.Po"; else rm -f ".deps/nft_popen.Tpo"; exit 1; fi
nft_popen.c: In function `nft_popen':
nft_popen.c:188: error: `environ' undeclared (first use in this function)
nft_popen.c:188: error: (Each undeclared identifier is reported only once
nft_popen.c:188: error: for each function it appears in.)
make: *** [nft_popen.o] Error 1
[root@hades cactid]#

==

[TheWitness]

my bad. Let me check that... I will have a new version shortly.

TheWitness

[TheWitness]

Fixed. My system had it defined in another include. You should be all set now.

TheWitness

[luckyeraser]

Ok, i will try it tomorrow

It's almost 23:00 here and my girl friend is very unhappy about my pc sessions in the night


regards
Michael

[luckyeraser]

oh, very fast, so i will try it now

[luckyeraser]

new problem during compiling

==
.
.
.

s.o -MD -MP -MF ".deps/keywords.Tpo" -c -o keywords.o keywords.c; \
then mv -f ".deps/keywords.Tpo" ".deps/keywords.Po"; else rm -f ".deps/keywords.Tpo"; exit 1; fi
if gcc -DHAVE_CONFIG_H -I. -I. -I./config -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -MT error.o -MD -MP -MF ".deps/error.Tpo" -c -o error.o error.c; \
then mv -f ".deps/error.Tpo" ".deps/error.Po"; else rm -f ".deps/error.Tpo"; exit 1; fi
gcc -I/usr/include/net-snmp -I/usr/include/net-snmp -I/usr/include/mysql -g -O2 -L/usr/local/ssl/lib -L/usr/lib -L/usr/lib -L/usr/lib/mysql -o cactid sql.o cactid.o util.o snmp.o locks.o poller.o nft_popen.o php.o ping.o keywords.o error.o -lnetsnmp -lcrypto -lz -lpthread -lm -lnsl
sql.o(.text+0x30): In function `db_insert':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:55: undefined reference to `mysql_query'
sql.o(.text+0x7d):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:56: undefined reference to `mysql_error'
sql.o(.text+0xf7): In function `db_query':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:93: undefined reference to `mysql_query'
sql.o(.text+0x15c):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c undefined reference to `mysql_store_result'
sql.o(.text+0x205): In function `db_connect':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:150: undefined reference to `mysql_init'
sql.o(.text+0x22f):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:157: undefined reference to `mysql_real_connect'
sql.o(.text+0x291):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:175: undefined reference to `mysql_error'
sql.o(.text+0x2ab):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:175: undefined reference to `mysql_error'
sql.o(.text+0x32d): In function `db_disconnect':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/sql.c:185: undefined reference to `mysql_close'
cactid.o(.text+0x2cc): In function `main':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/cactid.c:390: undefined reference to `mysql_num_rows'
cactid.o(.text+0x3b2):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/cactid.c:423: undefined reference to `mysql_fetch_row'
cactid.o(.text+0x563):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/cactid.c:578: undefined reference to `mysql_free_result'
cactid.o(.text+0x571):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/cactid.c:579: undefined reference to `mysql_close'
util.o(.text+0x94): In function `getsetting':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/util.c:101: undefined reference to `mysql_num_rows'
util.o(.text+0xaa):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/util.c:101: undefined reference to `mysql_fetch_row'
util.o(.text+0x762): In function `read_config_options':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/util.c:367: undefined reference to `mysql_num_rows'
util.o(.text+0x7d2):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/util.c:396: undefined reference to `mysql_free_result'
poller.o(.text+0x34d): In function `poll_host':
/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:436: undefined reference to `mysql_num_rows'
poller.o(.text+0x422):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:452: undefined reference to `mysql_fetch_row'
poller.o(.text+0xb72):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:775: undefined reference to `mysql_free_result'
poller.o(.text+0xb80):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:781: undefined reference to `mysql_close'
poller.o(.text+0x1794):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:439: undefined reference to `mysql_num_rows'
poller.o(.text+0x17e7):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:330: undefined reference to `mysql_num_rows'
poller.o(.text+0x1816):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:333: undefined reference to `mysql_fetch_row'
poller.o(.text+0x1e86):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:223: undefined reference to `mysql_num_rows'
poller.o(.text+0x1eae):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:228: undefined reference to `mysql_free_result'
poller.o(.text+0x1ebc):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:232: undefined reference to `mysql_close'
poller.o(.text+0x1ecf):/install/cactid/cacti/branches/BRANCH_0_8_6/cactid/poller.c:237: undefined reference to `mysql_fetch_row'
collect2: ld returned 1 exit status
make: *** [cactid] Error 1
[root@hades cactid]#

[TheWitness]

Refresh SVN, then run "./configure" and post your results. It looks as though I appear to be finding your mysql libraries in the configure process, but something is getting lost in the mail.

Taking a break myself.

TheWitness

[TheWitness]

Another note, you must run "autoconf" prior to "./configure".

TheWitness

[luckyeraser]

the same problem

look at the attach

[TheWitness]

Ok, look in the following directory for libmysqlclient.a or libmysqlclient.so

/usr/lib/mysql

Let me know what you find.

TheWitness

[luckyeraser]

Note, if have no proplems during compiling the relaesed cactid 0.8.6g




[root@hades mysql]# ll
total 1816
-rw-r--r-- 1 root root 10784 Apr 3 2005 libdbug.a
-rw-r--r-- 1 root root 33840 Apr 3 2005 libheap.a
-rw-r--r-- 1 root root 14410 Apr 3 2005 libmerge.a
-rw-r--r-- 1 root root 238224 Apr 3 2005 libmyisam.a
-rw-r--r-- 1 root root 22056 Apr 3 2005 libmyisammrg.a
-rw-r--r-- 1 root root 295278 Apr 3 2005 libmysqlclient.a
-rw-r--r-- 1 root root 300568 Apr 3 2005 libmysqlclient_r.a
lrwxrwxrwx 1 root root 26 Mar 17 20:50 libmysqlclient_r.so -> libmysqlclient_r.so.10.0.0
lrwxrwxrwx 1 root root 26 Mar 17 20:10 libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
-rwxr-xr-x 1 root root 215352 Apr 3 2005 libmysqlclient_r.so.10.0.0
lrwxrwxrwx 1 root root 24 Mar 17 20:50 libmysqlclient.so -> libmysqlclient.so.10.0.0
lrwxrwxrwx 1 root root 24 Mar 17 20:10 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
-rwxr-xr-x 1 root root 213356 Apr 3 2005 libmysqlclient.so.10.0.0
-rw-r--r-- 1 root root 143510 Apr 3 2005 libmystrings.a
-rw-r--r-- 1 root root 187886 Apr 3 2005 libmysys.a
-rw-r--r-- 1 root root 104992 Apr 3 2005 libnisam.a
-rwxr-xr-x 1 root root 10682 Apr 3 2005 mysqlbug
-rwxr-xr-x 1 root root 3059 Apr 3 2005 mysql_config
[root@hades mysql]# pwd
/usr/lib/mysql
[root@hades mysql]#

[TheWitness]

What about /usr/include/mysql. Are all the *.h files there? This does not make sense. If should be making fine.

TheWitness

[TheWitness]

Oops, I just saw it. You need to do a "make clean" and make sure that your sql.o file is removed. Then remake again. You should be all set then.

TheWitness