Remote Poller Err Cacti 1.2.23

[cbotts]

I reccently upgraded our cacti with and its remote pollers.

I am randomly seeing this error on one of the remote pollers. It will shwo the error randonly and then clear and run for a while and then it shows up again. Can anyone advise what to look for. I know its missing a column last upated. But in which table and i assume this is on the remote poller side. My couple othe remote poller logs do not show this error.

2023-01-25 13:40:15 - SYSTEM STATS: Time:13.3674 Method:spine Processes:3 Threads:8 Hosts:206 HostsPerProcess:69 DataSources:2755 RRDsProcessed:0
2023-01-25 13:39:13 - SYSTEM MAINT STATS: Time:0.00
2023-01-25 13:39:13 - SYSTEM STATS: Time:11.3624 Method:spine Processes:3 Threads:8 Hosts:206 HostsPerProcess:69 DataSources:2755 RRDsProcessed:0
2023-01-25 13:38:15 - SYSTEM MAINT STATS: Time:0.00
2023-01-25 13:38:14 - SYSTEM STATS: Time:12.3632 Method:spine Processes:3 Threads:8 Hosts:206 HostsPerProcess:69 DataSources:2755 RRDsProcessed:0
2023-01-25 13:37:15 - SYSTEM MAINT STATS: Time:0.00
2023-01-25 13:37:14 - SYSTEM STATS: Time:12.3681 Method:spine Processes:3 Threads:8 Hosts:206 HostsPerProcess:69 DataSources:2755 RRDsProcessed:0
2023-01-25 13:36:14 - SYSTEM MAINT STATS: Time:0.00
2023-01-25 13:36:13 - SYSTEM STATS: Time:12.3667 Method:spine Processes:3 Threads:8 Hosts:206 HostsPerProcess:69 DataSources:2725 RRDsProcessed:0
2023-01-25 13:35:40 - CMDPHP SQL Backtrace: (/remote_agent.php[72]:run_remote_data_query(), /remote_agent.php[439]:run_data_query(), /lib/data_query.php[396]:poller_push_reindex_data_to_poller(), /lib/poller.php[1929]:db_fetch_assoc_prepared(), /lib/database.php[697]:db_execute_prepared())
2023-01-25 13:35:40 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'last_updated' in 'where clause'
2023-01-25 13:35:39 - CMDPHP SQL Backtrace: (/remote_agent.php[72]:run_remote_data_query(), /remote_agent.php[439]:run_data_query(), /lib/data_query.php[396]:poller_push_reindex_data_to_poller(), /lib/poller.php[1912]:db_fetch_assoc_prepared(), /lib/database.php[697]:db_execute_prepared())
2023-01-25 13:35:39 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'last_updated' in 'where clause'
2023-01-25 13:35:39 - CMDPHP SQL Backtrace: (/remote_agent.php[72]:run_remote_data_query(), /remote_agent.php[439]:run_data_query(), /lib/data_query.php[396]:poller_push_reindex_data_to_poller(), /lib/poller.php[1905]:db_fetch_assoc_prepared(), /lib/database.php[697]:db_execute_prepared())
2023-01-25 13:35:39 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'last_updated' in 'where clause'
2023-01-25 13:35:15 - SYSTEM MAINT STATS: Time:0.00
2023-01-25 13:35:14 - SYSTEM STATS: Time:13.3693 Method:spine Processes:3 Threads:8 Hosts:205 HostsPerProcess:69 DataSources:2724 RRDsProcessed:0
2023-01-25 13:34:14 - SYSTEM MAINT STATS: Time:0.00
2023-01-25 13:34:13 - SYSTEM STATS: Time:12.3638 Method:spine Processes:3 Threads:8 Hosts:205 HostsPerProcess:69 DataSources:2724 RRDsProcessed:0
2023-01-25 13:33:14 - SYSTEM MAINT STATS: Time:0.00
2023-01-25 13:33:13 - SYSTEM STATS: Time:12.3637 Method:spine Processes:3 Threads:8 Hosts:205 HostsPerProcess:69 DataSources:2718 RRDsProcessed:0

[TheWitness]

This has been fixed in the 1.2.x branch on GitHub. Just update the affected file, or take the whole thing. 1.2.24 coming very soon. No new features, just bug fixing now.

[cbotts]

Thanks so much! Have a great day!