Cacti does not create .rrd files

[ldemestico]

Hello,

Im new in cacti, yesterday I upgrade 0.8x version to 1.1.30 since then the new graphics (with new scripts) trows this error: ERROR: opening '/opt/cacti/rra/andromeda_andromedaconumapach_211.rrd': No such file or directory

root@monitor:/opt/cacti/rra# ls -la /opt/cacti/rra/andromeda_andromedaconumapach_211.rrd
ls: cannot access '/opt/cacti/rra/andromeda_andromedaconumapach_211.rrd': No such file or directory
root@monitor:/opt/cacti/rra# ls -la .
total 10528
drwxrwxrwx 2 www-data www-data 12288 ene 9 18:58 .
drwxr-xr-x 17 www-data www-data 4096 ene 9 15:01 ..
-rwxrwxrwx 1 www-data www-data 47992 ene 9 15:16 andromeda_cpu_137.rrd
-rwxrwxrwx 1 www-data www-data 56408 ene 9 15:16 andromeda_cpu_162.rrd

cacti log:


01/09/2018 01:10:01 PM - CMDPHP: Poller[0] ERROR: There are no RRA's assigned to local_data_id: 212.
01/09/2018 01:10:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /opt/cacti/rra/andromeda_traffic_in_212.rrd --template traffic_in:traffic_out N:92713:92713

rrdtools 1.5.5

Please help!









cacti II log:



2018/01/09 19:10:01 - SPINE: Poller[1] Device[14] TH[1] DS[211] SCRIPT: sh /opt/cacti/scripts/CheckMEM.sh 162.243.196.168 'apache', output: 13.2
2018/01/09 19:10:01 - SPINE: Poller[1] Device[14] TH[1] DS[203] SNMP: v1: andromeda, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, value: 2031882
2018/01/09 19:10:01 - SPINE: Poller[1] Device[14] TH[1] DS[212] SNMP: v1: andromeda, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 92713
2018/01/09 19:10:01 - SPINE: Poller[1] Device[14] TH[1] DS[212] SNMP: v1: andromeda, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 92713
2018/01/09 19:10:01 - SPINE: Poller[1] Device[14] TH[1] Total Time: 0.24 Seconds
2018/01/09 19:10:01 - SPINE: Poller[1] Device[14] TH[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
2018/01/09 19:10:01 - SPINE: Poller[1] DEBUG: The Value of Active Threads is 0 for Device ID 14
2018/01/09 19:10:01 - SPINE: Poller[1] POLLR: Active Threads is 0, Pending is 0
01/09/2018 01:10:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /opt/cacti/rra/andromeda_cpu_system_203.rrd --template cpu_system 1515525001:2031882
01/09/2018 01:10:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=211 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
01/09/2018 01:10:01 PM - CMDPHP: Poller[0] ERROR: There are no RRA's assigned to local_data_id: 211.
01/09/2018 01:10:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /opt/cacti/rra/andromeda_andromedaconumapach_211.rrd --template andromedaconumapach N:13.2
01/09/2018 01:10:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select data_template_data.rrd_step, rra.x_files_factor, rra.steps, rra.rows, rra_cf.consolidation_function_id, (rra.rows*rra.steps) as rra_order from data_template_data left join data_template_data_rra on (data_template_data.id=data_template_data_rra.data_template_data_id) left join rra on (data_template_data_rra.rra_id=rra.id) left join rra_cf on (rra.id=rra_cf.rra_id) where data_template_data.local_data_id=212 and (rra.steps is not null or rra.rows is not null) order by rra_cf.consolidation_function_id,rra_order"
01/09/2018 01:10:01 PM - CMDPHP: Poller[0] ERROR: There are no RRA's assigned to local_data_id: 212.
01/09/2018 01:10:01 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /opt/cacti/rra/andromeda_traffic_in_212.rrd --template traffic_in:traffic_out N:92713:92713
2018/01/09 19:10:02 - SPINE: Poller[1] SPINE: The Final Value of Threads is 0
2018/01/09 19:10:02 - SPINE: Poller[1] DEBUG: Thread Cleanup Complete
2018/01/09 19:10:02 - SPINE: Poller[1] DEBUG: PHP Script Server Pipes Closed
2018/01/09 19:10:02 - SPINE: Poller[1] DEBUG: Allocated Variable Memory Freed
2018/01/09 19:10:02 - SPINE: Poller[1] DEBUG: MYSQL Free & Close Completed
2018/01/09 19:10:02 - SPINE: Poller[1] DEBUG: Net-SNMP Close Completed
2018/01/09 19:10:02 - SPINE: Poller[1] Time: 1.0352 s, Threads: 2, Devices: 1

[netniV]

The query used is

Code: Select all

SELECT dtd.rrd_step, dsp.x_files_factor,
                dspr.steps, dspr.rows, dspc.consolidation_function_id,
                (dspr.rows*dspr.steps) AS rra_order
                FROM data_template_data AS dtd
                LEFT JOIN data_source_profiles AS dsp
                ON dtd.data_source_profile_id=dsp.id
                LEFT JOIN data_source_profiles_rra AS dspr
                ON dsp.id=dspr.data_source_profile_id
                LEFT JOIN data_source_profiles_cf AS dspc
                ON dsp.id=dspc.data_source_profile_id
                WHERE dtd.local_data_id = ?
                AND (dspr.steps IS NOT NULL OR dspr.rows IS NOT NULL)
                ORDER BY dspc.consolidation_function_id, rra_order

Replacing the question mark with the id. These are upgraded from the 0.8.8 versions using called RRA tables. If you still have an 'rra' table and not 'data_source_profiles_rra' then , then the upgrade process didn't complete so you should try running the cli/update_database.php script.

If those tables have been changed, then the upgrade 1_0_0.php failed to convert your RRA's. I think if you go into your data sources and then save them, it should start to populate.