On 22/01/2016 11:18:29, Dirk-Willem van Gulik <dirkx@webweaving.org> wrote:
FWIIW - may be that the STRICT mode is not the only delta. Spotted below error[1] during the initial discovery/poll cycle; and [2] in the update-error log (we are trying to figure out why the port graphs stopped updating).
All on a -latest community version as of a few hours ago. Against "MYSQL Server version: 5.6.27 Source distribution” and PHP 5.6.17 (cli).
Dw
1:
SQL[SELECT *, I.`port_id` AS `port_id` FROM `ports` AS I LEFT JOIN `ports-state` AS S ON I.`port_id` = S.`port_id` WHERE `device_id` = '1']
RUNTIME[0.00157404s]
…..
SQL[INSERT INTO `ports` (`device_id`,`ifIndex`) VALUES ('1','29')]
RUNTIME[0.00024199s]
ERROR[Error in query: (1062) Duplicate entry '1-29' for key 'device_ifIndex']
SQL[SELECT * FROM `ports` WHERE `port_id` = '']
RUNTIME[0.00043392s]
Adding: po1(29)()
SQL[INSERT INTO `ports` (`device_id`,`ifIndex`) VALUES ('1','30')]
RUNTIME[0.00025010s]
ERROR[Error in query: (1062) Duplicate entry '1-30' for key 'device_ifIndex’]
….
2:
[observium@observium /usr/local/www/observium/logs]$ more update-errors.log
[2016/01/22 12:09:22 +0000] discovery.php(23667): ====== Schema update 137 -> 138 ==============
[2016/01/22 12:09:22 +0000] discovery.php(23667): Query: ALTER TABLE `sensors` ADD `entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL AFTER `sensor_custom_limit`;
[2016/01/22 12:09:22 +0000] discovery.php(23667): Error: (1060) Duplicate column name 'entPhysicalIndex_measured'
[2016/01/22 12:09:22 +0000] discovery.php(23667): Query: ALTER TABLE `sensors` ADD `measured_class` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `entPhysicalIndex_measured`;
[2016/01/22 12:09:22 +0000] discovery.php(23667): Error: (1060) Duplicate column name 'measured_class'
[2016/01/22 12:09:22 +0000] discovery.php(23667): Query: ALTER TABLE `sensors` ADD `measured_entity` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `measured_class`;
[2016/01/22 12:09:22 +0000] discovery.php(23667): Error: (1060) Duplicate column name ‘measured_entity'
_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium