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'