Cacti Appliance linux PHP.CMD Error

[faraz_judean]

This cacti appliance is installed on ESX 3.5i having following:
System Cacti Appliance customized by rbuild having cacti version 0.87b Having Operating system
2.6.26.8-0.1.gcc3.4.x86.i686 i686 i686 i386 GNU/Linux
This Appliance has very limited virtual disk size i.e. 1gb only and was filled now i have improvised as follows:


I have mounted (using --bind) /OTher_HDD_drive/log/ to /var/log/ due to shortage of space ion root file system and now seems to getting this error in message log.



*************************************************************
Nov 6 19:17:39 graph Cacti[2956]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (656, 'traffic_out', '2009-11-06 19:17:10', '1065158661')'
Nov 6 19:17:39 graph Cacti[2937]: CMDPHP: Host[5] DS[138] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:39 graph Cacti[2956]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (657, 'traffic_in', '2009-11-06 19:17:10', '0')'
Nov 6 19:17:39 graph Cacti[2941]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (145, 'traffic_out', '2009-11-06 19:17:37', '25436656')'
Nov 6 19:17:39 graph Cacti[2934]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (137, '5min_cpu', '2009-11-06 19:16:56', '6')'
Nov 6 19:17:39 graph Cacti[2939]: CMDPHP: Host[5] DS[136] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:39 graph Cacti[2937]: CMDPHP: Host[5] DS[139] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:39 graph Cacti[2956]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (657, 'traffic_out', '2009-11-06 19:17:10', '0')'
Nov 6 19:17:39 graph Cacti[2941]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (146, 'traffic_in', '2009-11-06 19:17:37', '0')'
Nov 6 19:17:39 graph Cacti[2934]: CMDPHP: Host[5] DS[138] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:39 graph Cacti[2934]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (138, 'load_1min', '2009-11-06 19:16:56', 'U')'
Nov 6 19:17:39 graph Cacti[2956]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (658, 'traffic_in', '2009-11-06 19:17:10', '853478044')'
Nov 6 19:17:39 graph Cacti[2937]: CMDPHP: Host[5] DS[140] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:39 graph Cacti[2941]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (146, 'traffic_out', '2009-11-06 19:17:37', '20834991')'
Nov 6 19:17:39 graph Cacti[2934]: CMDPHP: Host[5] DS[139] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:39 graph Cacti[2934]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (139, 'load_15min', '2009-11-06 19:16:56', 'U')'
Nov 6 19:17:39 graph Cacti[2956]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (658, 'traffic_out', '2009-11-06 19:17:10', '3252862819')'
Nov 6 19:17:40 graph Cacti[2937]: CMDPHP: Host[5] DS[141] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:40 graph Cacti[2941]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (147, 'traffic_in', '2009-11-06 19:17:37', '0')'
Nov 6 19:17:40 graph Cacti[2934]: CMDPHP: Host[5] DS[140] WARNING: Result from SNMP not valid. Partial Result: No Such Object avail
Nov 6 19:17:40 graph Cacti[2934]: CMDPHP: ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, tim
e, output) values (140, 'load_5min', '2009-11-06 19:16:56', 'U')'
*************************************************************
when i removes the mount point then every things seems to work fine but /root space will soon get filled and services gets stuck like mysqld FYI..command df status is as follows:

[root@graph log]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 1046128 967156 25832 98% /
none 1037724 0 1037724 0% /dev/shm



Can any body sugest me better way to increase disk size on VM @ esx 3.5i OR or mount couple of folders within root to redirect data to other disk.

Also can you tell me impact of mounting /var and /srv/mysqld and /srv/cacti folders to other folder in different partition using mount --bind command.
I would really appericiate your response....
Regards,

MFR

[gandalf]

To me it seems that the mysql tables need more space
R.

[zgamer]

Also take a look at your mysql log's to see if they are reporting any problems with the database integrity.

[faraz_judean]

Thanks for reply, now problem solved but i like to share this experience with you guys.

When looking on sql error logs its was really what one of you sugested sql space quench. Errors were posted in sql.err.log as follows.

Number of processes running now: 0
091029 14:09:53 mysqld restarted
091029 14:09:53 InnoDB: Started; log sequence number 0 43655
091029 14:09:53 [ERROR] /usr/sbin/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
091029 14:09:53 [ERROR] Can't start server: can't create PID file: No space left on device

but reason to that was I was mounting /otherDrive to /var it was primarly due to permission error, i had resolved all one by one by chmod individual folder.
df status is as follows:

[root@graph cacti]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 1046128 655376 337612 67% /
none 1037724 0 1037724 0% /dev/shm
/dev/sdb1 30961664 931060 28457844 4% /Graph_data
/Graph_data/var/log 30961664 931060 28457844 4% /var/log
/Graph_data/mysql 30961664 931060 28457844 4% /srv/mysql
/Graph_data/cacti 30961664 931060 28457844 4% /srv/cacti




many thanks for your followup, keep spreading knowledge like you are doing now.

Faraz