Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri May 25, 2018 9:25 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Cacti log file huge, data not being recorded
PostPosted: Mon Nov 20, 2017 5:53 am 
Offline

Joined: Mon Nov 20, 2017 5:17 am
Posts: 3
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.


Top
 Profile  
 
 Post subject: Re: Cacti log file huge, data not being recorded
PostPosted: Mon Nov 20, 2017 8:31 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2684
Location: Kressbronn, Germany
As a first step, you can simply rename the logfile ( e.g. cacti.log_old ), then check if your Cacti starts polling again.

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: Cacti log file huge, data not being recorded
PostPosted: Mon Nov 20, 2017 8:40 am 
Offline

Joined: Mon Nov 20, 2017 5:17 am
Posts: 3
Thanks for that - should have tried that really :oops:

Have renamed, and the file is created again - lots of errors:
Code:
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"


Top
 Profile  
 
 Post subject: Re: Cacti log file huge, data not being recorded
PostPosted: Mon Nov 20, 2017 9:38 am 
Offline
Cacti Guru User
User avatar

Joined: Thu Jan 31, 2008 6:39 am
Posts: 2684
Location: Kressbronn, Germany
A quick google search on mysql on error 145reveals:

Code:
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 )

_________________
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusTransporter | CereusReporting | nmidWebService | nmidSmokeping | nmidWeb2 |

Code:
CereusServer Master:  SYSTEM STATS: Time:2.5621 Method:spine Processes:1 Threads:16 Hosts:446 HostsPerProcess:446 DataSources:14683 RRDsProcessed:7573
CereusServer Agent:   SYSTEM STATS: Time:27.4840 Method:spine Processes:1 Threads:8 Hosts:16 HostsPerProcess:16 DataSources:114576 RRDsProcessed:48061


Top
 Profile  
 
 Post subject: Re: Cacti log file huge, data not being recorded
PostPosted: Mon Nov 20, 2017 10:49 am 
Offline

Joined: Mon Nov 20, 2017 5:17 am
Posts: 3
All sorted. Thanks phalek.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group