Cacti Poller problem 0.8.7e

[angkharaj]

[root@dragon ~]# ps -ex | grep php
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
4466 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
4467 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
5729 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
5730 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
6388 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
6389 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
7066 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
7067 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
11541 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
11542 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
13380 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
13381 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
14416 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
14417 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
18899 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
18900 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
19836 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
19837 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
22311 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
22313 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
23419 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
23420 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
25340 pts/1 R+ 0:00 grep php HOSTNAME=dragon.localdomain TERM=vt100 SHELL=/bin/bash HISTSIZE=1000 KDE_NO_IPV6=1 SSH_CLIENT=10.11.92.71 54844 22 SSH_TTY=/dev/pts/1 USER=root LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35: KDEDIR=/usr MAIL=/var/spool/mail/root PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin INPUTRC=/etc/inputrc PWD=/root LANG=en_US.UTF-8 KDE_IS_PRELINKED=1 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=1 HOME=/root LOGNAME=root SSH_CONNECTION=10.11.92.71 54844 10.10.19.27 22 LESSOPEN=|/usr/bin/lesspipe.sh %s G_BROKEN_FILENAMES=1 _=/bin/grep
26764 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
26765 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
27534 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
27535 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
32126 ? Ss 0:00 /bin/sh -c php /var/www/html/cacti/poller.php > /dev/null 2>&1 SHELL=/bin/sh HOME=/root PATH=/usr/bin:/bin LOGNAME=root USER=root
32127 ? S 4:59 php /var/www/html/cacti/poller.php SHELL=/bin/sh USER=root PATH=/usr/bin:/bin PWD=/root SHLVL=1 HOME=/root LOGNAME=root _=/usr/bin/php
[root@dragon ~]# killall php
[root@dragon ~]# service mysqld stat
Usage: /etc/init.d/mysqld {start|stop|status|condrestart|restart}
[root@dragon ~]#
[root@dragon ~]#
[root@dragon ~]# service mysqld start
Starting MySQL: [ OK ]
[root@dragon ~]#


[root@dragon ~]# top -c
top - 13:16:01 up 11 days, 1:06, 1 user, load average: 2.31, 2.16, 2.19
Tasks: 181 total, 5 running, 176 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.6%us, 15.6%sy, 0.0%ni, 65.2%id, 18.5%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3753984k total, 2502772k used, 1251212k free, 80700k buffers
Swap: 5668856k total, 125204k used, 5543652k free, 993048k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6114 root 20 0 496m 486m 6112 R 22.3 13.3 3:25.66 php /var/www/html/cacti/poller.php
13674 root 18 0 124m 113m 6108 S 10.3 3.1 0:24.04 php /var/www/html/cacti/poller.php
17590 root 20 0 2428 732 628 R 0.7 0.0 0:00.02 sh -c /usr/local/bin/rrdtool fetch /var/www/html/cacti/rra/cco-mme-0701-33b_snmp_oid_11941.rrd AVERAGE --s
2287 root 15 0 32592 48 36 S 0.3 0.0 20:08.31 brcm_iscsiuio
4014 ricci 18 -1 8184 324 312 S 0.3 0.0 16:50.50 ricci -u 101
17538 root 15 0 2352 1096 812 R 0.3 0.0 0:00.01 top -c
17589 root 20 0 4 4 0 R 0.3 0.0 0:00.01 [php]
1 root 15 0 2088 112 80 S 0.0 0.0 5:05.03 init [5]
2 root RT -5 0 0 0 S 0.0 0.0 1:35.85 [migration/0]
3 root 38 19 0 0 0 S 0.0 0.0 0:03.32 [ksoftirqd/0]
4 root RT -5 0 0 0 S 0.0 0.0 0:00.15 [watchdog/0]


I found cacti mysql locked every because had many php error. I must to kill php process and start mysql afterthat
this problem had temporary cleared.
What's happen ? How to solve this problem?



General Information
Date Fri, 20 Mar 2015 13:30:46 +0700
Cacti Version 0.8.7e
Cacti OS unix
SNMP Version NET-SNMP version: 5.3.2.2
RRDTool Version RRDTool 1.3.x
Hosts 1661
Graphs 13949
Data Sources Script/Command: 3
SNMP: 957
SNMP Query: 13089
Total: 14049
Poller Information
Interval 300
Type spine
Items Action[0]: 26886
Action[1]: 3
Total: 26889
Concurrent Processes 98
Max Threads 15
PHP Servers 20
Script Timeout 180
Max OID 60
Last Run Statistics Time:25.2929 Method:spine Processes:98 Threads:15 Hosts:1654 HostsPerProcess:17 DataSources:26889 RRDsProcessed:13861
PHP Information
PHP Version 5.1.6
PHP OS Linux
PHP uname Linux dragon.localdomain 2.6.18-164.el5xen #1 SMP Thu Sep 3 04:47:32 EDT 2009 i686
PHP SNMP Installed
max_execution_time 600
memory_limit 1G