Win32 - Monitor running processes

mcutting · Post by **mcutting** » Mon Jan 21, 2008 5:25 am

Every time I create a graph with this template, I get the following error in the log:

01/21/2008 09:41:38 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"update graph_templates_graph set name='|host_description| - Process - |query_hrSWRunName|' where local_graph_id=1978'

The graph seems to create and is updated - just wondered what this was ?

Thanks

streaker69 · Post by **streaker69** » Mon Jan 21, 2008 8:25 am

Error:'1054' = Unknown column error. It would seem that query is just incorrect, as there probably isn't a column named:

|host_description| - Process - |query_hrSWRunName|

That would be my guess.

mcutting · Post by **mcutting** » Mon Jan 21, 2008 8:40 am

Thanks

Brashquido · Post by **Brashquido** » Sat Apr 05, 2008 7:13 pm

First off, great script!!

Have only two issues;

1) The memory usage value displayed for each process is in megabytes, however the unit used is in kilobytes. Is there anything I can do about this?

2) I suspect this is because of very low CPU usage, but I have a problem where the usage of a particular process is not displayed as a percentage and the value displayed is wildly incorrect. Any ideas why, and if it is possible to fix?

BSOD2600 · Post by **BSOD2600** » Sat Apr 05, 2008 7:59 pm

1) hrSWRunPerfMem unit is defined to be "KBytes". rrdtool is simply reporting what it's getting from the host. If you want, you could create a CDEF to change from kb to mb (multiply by 1024.

2) the value have m or u in it? read http://forums.cacti.net/viewtopic.php?t=8168

Brashquido · Post by **Brashquido** » Wed Apr 09, 2008 5:31 pm

Ok, not worth it at this stage I think. Memory usage is reported correctly, just using the wrong units. As for second issue I don't think this can be corrected in Cacti unless there is a way to disable the autoscale on RRDTool.

Stubbed · Post by **Stubbed** » Thu Mar 26, 2009 2:55 pm

Brashquido wrote:Ok, not worth it at this stage I think. Memory usage is reported correctly, just using the wrong units. As for second issue I don't think this can be corrected in Cacti unless there is a way to disable the autoscale on RRDTool.

I have the same "issue" although I would call it a non-issue. It is being reported correctly. In my case my store.exe is taking up ~600mb, cacti is reporting 590.61 k, which is 604784.64 kb.

Spot on.

BSOD2600 · Post by **BSOD2600** » Thu Mar 26, 2009 6:39 pm

Ahh, I think I know whats going on. Edit the graph template for this script and change the Base Value to 1024.

Stubbed · Post by **Stubbed** » Thu Jun 18, 2009 3:26 pm

Is there a way I can graph the total processes? Together with threshold it might help be solve an issue I'm currently having where a process is failing and creating another one every 30 minutes, so after a couple of days I have an extra 80 processes each taking up way too many resources...

BSOD2600 · Post by **BSOD2600** » Thu Jun 18, 2009 4:19 pm

.1.3.6.1.2.1.25.1.6.0 is the current number of processes. Use the generic snmp templates

Stubbed · Post by **Stubbed** » Sun Jun 21, 2009 3:01 pm

Win, cheers. Should have tried a Google, didn't realise there would just be a standard OID.

b3nw · Post by **b3nw** » Thu Jul 16, 2009 3:14 pm

Hello,

I am getting this error when I try to add the graph:

Notice: Undefined index: sgg_12 in /usr/share/cacti/site/graphs_new.php on line 71

Warning: Cannot modify header information - headers already sent by (output started at /usr/share/cacti/site/graphs_new.php:71) in /usr/share/cacti/site/graphs_new.php on line 323

Everything else seems to work fine.

BSOD2600 · Post by **BSOD2600** » Thu Jul 16, 2009 9:10 pm

b3nw: Start a new post in the linux forum. Your issue does not lay with this template. Document your cacti, mysql, php, apache, etc versions. Also read http://docs.cacti.net/manual:087:4_help.2_debugging

b3nw · Post by **b3nw** » Thu Jul 16, 2009 9:13 pm

even if I only get this error when I try to add processes from this script's data pull?

all other graph creation works just fine.

BSOD2600 · Post by **BSOD2600** » Thu Jul 16, 2009 9:27 pm

b3nw wrote:all other graph creation works just fine.

What other graphs have you created and work?

What are your cacti, mysql, php, apache, etc versions? The cacti technical support page show any errors?

Cacti

Win32 - Monitor running processes

Error message in CACTI log

Who is online