Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Poller Errors: #95

Closed
interduo opened this issue Dec 27, 2016 · 2 comments
Closed

Poller Errors: #95

interduo opened this issue Dec 27, 2016 · 2 comments

Comments

@interduo
Copy link
Contributor

2016-12-27 11:55:30 - POLLER: Poller[1] Time: 27.3367 s, Poller: , Theads: N/A, Devices: 43
2016-12-27 11:55:31 - CMDPHP SQL Backtrace: (/poller.php: 496 process_poller_output)(/lib/poller.php: 384 db_fetch_assoc_prepared)(/lib/database.php: 348 cacti_debug_backtrace)

@interduo
Copy link
Contributor Author

When I changed to DEBUG log level I realized thath the error is always after UDP Ping.

2016-12-27 12:10:14 - PING Device[82] Description[MT-KolPalB] PING: UDP Ping Success (2.6 ms)
2016-12-27 12:10:14 - CMDPHP SQL Backtrace: (/poller.php: 508 process_poller_output)(/lib/poller.php: 384 db_fetch_assoc_prepared)(/lib/database.php: 348 cacti_debug_backtrace)
2016-12-27 12:10:14 - PING Device[279] Description[P2M-SKP-iduo_skp] SNMP: Device responded to SNMP

@cigamit
Copy link
Member

cigamit commented Dec 27, 2016

You need to rerun the database upgrade script from the latest pull merge. There is a new performance table created that is designed to assist large sites. Here is the SQL.

However, I recommend you rerun the database upgrade script as there are other mandatory table changes besides those below.. It can be found in the cli folder.

php -q upgrade_database.php --forcever=1.0.0

CREATE TABLE IF NOT EXISTS poller_data_template_field_mappings (
data_template_id int(10) unsigned NOT NULL DEFAULT '0',
data_name varchar(25) NOT NULL DEFAULT '',
data_source_names varchar(120) NOT NULL DEFAULT '',
last_updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (data_template_id,data_name,data_source_names))
ENGINE=InnoDB
COMMENT='Tracks mapping of Data Templates to their Data Source Names';

INSERT IGNORE INTO poller_data_template_field_mappings
SELECT dtr.data_template_id, dif.data_name, GROUP_CONCAT(dtr.data_source_name ORDER BY dtr.data_source_name) AS data_source_names, NOW()
FROM data_template_rrd AS dtr
INNER JOIN data_input_fields AS dif
ON dtr.data_input_field_id = dif.id
WHERE dtr.local_data_id=0
GROUP BY dtr.data_template_id, dif.data_name;

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants