Cacti log file huge, data not being recorded

[mrjh]

Troubleshooting help needed here, as we're relatively new to Cacti. The install (0.8.8.7) was setup 18 months or so ago, and has worked well.

Our devices are showing as active in terms of SNMP, but no data is being recorded. The log file in c:\Apache24\htdocs\cacti\log is a monster, and is over 50GB in size.

We'd like to retain the data we have collected, but if it means trashing it to ensure we can get Cacti recording data again, then so be it.

What's the best line of troubleshooting?

Many thanks.

[phalek]

As a first step, you can simply rename the logfile ( e.g. cacti.log_old ), then check if your Cacti starts polling again.

[mrjh]

Thanks for that - should have tried that really

Have renamed, and the file is created again - lots of errors:

Code: Select all

11/20/2017 01:35:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select  poller_output.output,  poller_output.time,  UNIX_TIMESTAMP(poller_output.time) as unix_time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  order by poller_output.local_data_id  LIMIT 10000"
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select  poller_output.output,  poller_output.time,  UNIX_TIMESTAMP(poller_output.time) as unix_time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  order by poller_output.local_data_id  LIMIT 10000"
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] Host[9] DS[176] SNMP: v2: 10.50.6.14, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.186, output: 1750483719
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (176, 'traffic_in', '2017-11-20 13:35:01', '1750483719')'
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select  poller_output.output,  poller_output.time,  UNIX_TIMESTAMP(poller_output.time) as unix_time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  order by poller_output.local_data_id  LIMIT 10000"
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] Host[9] DS[176] SNMP: v2: 10.50.6.14, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.186, output: 2614703764
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (176, 'traffic_out', '2017-11-20 13:35:01', '2614703764')'
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select  poller_output.output,  poller_output.time,  UNIX_TIMESTAMP(poller_output.time) as unix_time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  order by poller_output.local_data_id  LIMIT 10000"
11/20/2017 01:35:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select  poller_output.output,  poller_output.time,  UNIX_TIMESTAMP(poller_output.time) as unix_time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)  order by poller_output.local_data_id  LIMIT 10000"

[phalek]

A quick google search on mysql on error 145reveals:

Code: Select all

MySQL error code 145 = Table was marked as crashed and should be repaired

poller_output can be deleted (drop table poller_output) and re-created from the sql statement in the cacti.sql file ( see your cacti dir )

[mrjh]

All sorted. Thanks phalek.