Cacti

Seem something wrong on rrdcleaner.php, but not effect to polling :) === 2023-01-04 15:36:58 - CMDPHP SQL Backtrace: (/rrdcleaner.php[72]:list_rrd(), /rrdcleaner.php[368]:db_fetch_assoc(), /lib/database.php[677]:db_fetch_assoc_prepared(), /lib/database.php[697]:db_execute_prepared()) 2023-01-04 15:3...

At the end I changed the crontab command from run by user <cacti> to <root>, also add "--force" after polling.php, seem work now. */5 * * * * root /usr/bin/php /var/www/html/cacti/poller.php --force > /dev/null 2>&1 === 2023-01-04 15:10:29 - SYSTEM MAINT STATS: Time:0.01 2023-01-04 15:...

Install spine and test as below

===
2023-01-04 13:05:02 - SYSTEM MAINT STATS: Time:0.01
2023-01-04 13:05:01 - SYSTEM STATS: Time:299.5981 Method:spine Processes:1 Threads:1 Hosts:326 HostsPerProcess:326 DataSources:329 RRDsProcessed:0
===

Better now but still cannot polling within 300 seconds. === 2023-01-04 11:05:00 - SYSTEM MAINT STATS: Time:0.01 2023-01-04 11:05:00 - SYSTEM STATS: Time:298.5888 Method:cmd.php Processes:1 Threads:1 Hosts:326 HostsPerProcess:326 DataSources:329 RRDsProcessed:0 2023-01-04 11:05:00 - SYSTEM WARNING: P...

Haha, another error come now after adjusted the sql setting value === 2023-01-04 10:50:02 - SYSTEM WARNING: System Polling is Disabled! Therefore, data collection from the poller will be suspended till re-enabled. 2023-01-04 10:45:52 - CMDPHP SQL Backtrace: (/utilities.php[25]:include(), /include/au...

php -q upgrade_database.php --forcever=1.2.22
NOTE: Repairing Tables for Local Database
Upgrading from v1.2.22
Upgrading from v1.2.22 (DB 1.2.23) to v1.2.23
++[xxxxxx]#
[xxxxxx]#

Seem it crash again when polling, I just stopped the polling and copy the log... === 2023-01-04 10:15:01 - POLLER: Poller[1] PID[13362] Maximum runtime of 298 second s exceeded. Exiting. 2023-01-04 10:15:01 - SYSTEM WARNING: Primary Admin account notifications disabl ed! Unable to send administrativ...

When I setting this value, cacti still warning that the value not correct, any advise? Thank you. === sort_buffer_size 0.25 M <= -404.39 M When performing joins, if they are below this size, they will be kept in memory and never written to a temporary file. As this is a per connection memory allocat...

Could I set 16M for that value? or need to be smaller?

global.sort_buffer_size = 2097152
global.read_buffer_size = 131072
global.read_rnd_buffer_size = 262144
global.join_buffer_size = 1048576000

Variable_name Value alter_algorithm DEFAULT analyze_sample_percentage 100.000000 aria_block_size 8192 aria_checkpoint_interval 30 aria_checkpoint_log_activity 1048576 aria_encrypt_tables OFF aria_force_start_after_recovery_failures 0 aria_group_commit none aria_group_commit_interval 0 aria_log_file_...

Aborted_clients 0 Aborted_connects 0 Aborted_connects_preauth 0 Access_denied_errors 0 Acl_column_grants 0 Acl_database_grants 2 Acl_function_grants 0 Acl_procedure_grants 0 Acl_package_spec_grants 0 Acl_package_body_grants 0 Acl_proxy_users 2 Acl_role_grants 0 Acl_roles 0 Acl_table_grants 2 Acl_use...

alter_algorithm DEFAULT analyze_sample_percentage 100 aria_block_size 8,192 aria_checkpoint_interval 30 aria_checkpoint_log_activity 1,048,576 aria_encrypt_tables OFF aria_force_start_after_recovery_failures 0 aria_group_commit none aria_group_commit_interval 0 aria_log_file_size 1,073,741,824 aria_...

aggregate_graph_templates InnoDB 0 0 16,384 32,768 utf8mb4_unicode_ci Dynamic Template Definitions for Aggregate Graphs aggregate_graph_templates_graph InnoDB 0 0 16,384 0 utf8mb4_unicode_ci Dynamic Aggregate Template Graph Data aggregate_graph_templates_item InnoDB 0 0 16,384 0 utf8mb4_unicode_ci D...

Date Wed, 04 Jan 2023 09:42:05 +0800 Cacti Version 1.2.22 Cacti OS unix RSA Fingerprint a9:ce:82:ef:61:9f:9d:c1:e4:09:dd:ae:f7:e0:10:61 NET-SNMP Version NET-SNMP version: 5.7.2 RRDtool Version Configured 1.4.0+ RRDtool Version Found 1.4.8 Devices 336 Graphs 339 Data Sources Script Server: 339 Total:...