[SOLVED]- issue with poller spine write dabase

[totor51320]

hi guys

i need help, my issue with poller is the time exceeded
POLLER: Poller[1] Maximum runtime of 58 seconds exceeded. Exiting.
SYSTEM STATS: Time:59.5004 Method:spine Processes:30 Threads:40 Hosts:136 HostsPerProcess:5 DataSources:8336 RRDsProcessed:3880
SPINE: Poller[1] ERROR: SQL Failed! Error:'167', Message:'Out of range value for column 'id' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 13732, NOW(), '0000-00-00 00:00:00')'


but when i launch spine manualy /usr/local/spine/bin/spine -V 5 -R -S

DEBUG: PHP Script Server Pipes Closed
DEBUG: Allocated Variable Memory Freed
DEBUG: MYSQL Free & Close Completed
DEBUG: Net-SNMP Close Completed
Time: 38.3427 s, Threads: 40, Devices: 136

he worked manualy. i don't undersand. why not worked poller cacti

[netniV]

First change the number of processes, you have way too many if you are using spine. There should be one process per CPU. Then make sure you have a reasonable number of threads. Not really sure what that error is, do you have a backtrace that goes with it?

[totor51320]

i disabled all host

2018/05/03 11:49:00 - POLLER: Poller[1] Maximum runtime of 58 seconds exceeded. Exiting.
2018/05/03 11:49:00 - SYSTEM STATS: Time:58.1717 Method:spine Processes:6 Threads:200 Hosts:0 HostsPerProcess:0 DataSources:0 RRDsProcessed:0
2018/05/03 11:49:01 - SPINE: Poller[1] ERROR: SQL Failed! Error:'167', Message:'Out of range value for column 'id' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 3021, NOW(), '0000-00-00 00:00:00')'

but spine is exceeded. is very strange

[netniV]

OK, you have an SQL problem going on. The ID is automatically generated but MySQL is saying that the ID is actually beyond the range of the ID column. Can you do a mysql dump of that table? poller_time.

[totor51320]

/*
Source Server : Cacti
Source Server Type : MariaDB
Source Server Version : 50556
Source Host : localhost:3306
Source Schema : cacti

Target Server Type : MariaDB
Target Server Version : 50556
File Encoding : 65001

Date: 03/05/2018 13:19:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for poller_time
-- ----------------------------
DROP TABLE IF EXISTS `poller_time`;
CREATE TABLE `poller_time` (
`id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`pid` int(11) UNSIGNED NOT NULL DEFAULT 0,
`poller_id` int(10) UNSIGNED NOT NULL DEFAULT 1,
`start_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
`end_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`) USING BTREE,
INDEX `poller_id_end_time`(`poller_id`, `end_time`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 16777216 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;

[netniV]

OK, the problem here is the mediumint(). Your autoincrement value has reached the maximum, therefore any more attempts to insert into the Poller_Time table will result in an error since we can't go beyond that value.

A quick fix would be to change it to INT rather than MEDIUMINT. Long term, this needs raising as a bug on the GitHub website to be able to handle the auto_increment problem.
https://github.com/cacti/cacti/issues/

[totor51320]

Thank you for your help.