On 15.07.15 17:58, Eduardo Schoedler wrote:

Hi,

I have upgraded now to 6655 and I saw an db error.

Updated to revision 6655.
Observium 0.15.7.6655
Discovery

-- Updating database/file schema
203 -> 204 ... (db) done (1 errors).
-- Done

Looking the logs/db.log file:

[2015/07/09 21:46:19 -0300] poller.php(1595): Failed dbQuery (#1062 - Duplicate entry '73-4006-001exxxxxxxx' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES ('73','4006','17112','001exxxxxxxx','learned')
[2015/07/09 21:46:19 -0300] poller.php(1595): Failed dbQuery (#1062 - Duplicate entry '73-4006-0022yyyyyyd3' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES ('73','4006','17112','0022yyyyyyd3','learned')

...
[2015/07/15 11:49:52 -0300] discovery.php(12686): Failed dbQuery (#1071 - Specified key was too long; max key length is 1000 bytes), Query: ALTER TABLE `slas` DROP INDEX `unique_key`, ADD UNIQUE `unique_key` (`device_id`, `sla_mib`, `sla_index`, `sla_owner`);


Can you verify, please?

Bleh.. indexes.
Try with r6656.

Thanks.

--
Eduardo Schoedler

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

-- 
Mike Stupalov
http://observium.org

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium