Thanks!

2015-08-09 14:22 GMT-03:00 Mike Stupalov <mike@observium.org>:
> I think it fixed in r6853.
>
> On Fri, Aug 7, 2015 at 6:49 PM, Eduardo Schoedler <listas@esds.com.br>
> wrote:
>>
>> Hi people,
>>
>> Again some errors in logs/db.log:
>>
>> [2015/08/06 18:13:57 -0300] poller.php(6317): Failed dbQuery (#1062 -
>> Duplicate entry '9-1580-xxxxxx1931f' for key 'dev_vlan_mac'), Query:
>> INSERT INTO `vlans_fdb`
>> (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES
>> ('9','1580','','xxxxxx1931f','learned')
>> [2015/08/06 18:14:07 -0300] poller.php(6317): Failed dbQuery (#1062 -
>> Duplicate entry '9-500-xxxxxx6a2ad4' for key 'dev_vlan_mac'), Query:
>> INSERT INTO `vlans_fdb`
>> (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES
>> ('9','500','','xxxxxx6a2ad4','learned')
>> [2015/08/06 18:14:08 -0300] poller.php(6317): Failed dbQuery (#1062 -
>> Duplicate entry '9-500-xxxxxx7e1e41' for key 'dev_vlan_mac'), Query:
>> INSERT INTO `vlans_fdb`
>> (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES
>> ('9','500','','xxxxxx7e1e41','learned')
>> [2015/08/06 18:14:08 -0300] poller.php(6317): Failed dbQuery (#1062 -
>> Duplicate entry '9-500-xxxxxx580c58' for key 'dev_vlan_mac'), Query:
>> INSERT INTO `vlans_fdb`
>> (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES
>> ('9','500','','xxxxxx580c58','learned')
>> [2015/08/06 18:14:09 -0300] poller.php(6317): Failed dbQuery (#1062 -
>> Duplicate entry '9-65-xxxxxx2c13e3' for key 'dev_vlan_mac'), Query:
>> INSERT INTO `vlans_fdb`
>> (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES
>> ('9','65','','xxxxxx2c13e3','learned')
>> [2015/08/06 18:14:10 -0300] poller.php(6317): Failed dbQuery (#1062 -
>> Duplicate entry '9-65-xxxxxx76bbc9' for key 'dev_vlan_mac'), Query:
>> INSERT INTO `vlans_fdb`
>> (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`)  VALUES
>> ('9','65','','xxxxxx76bbc9','')
>>
>> Can you verify, please?
>>
>> Thanks.
>>
>>
>> 2015-07-15 12:20 GMT-03:00 Eduardo Schoedler <listas@esds.com.br>:
>> > Indexes are a necessary evil :)
>> >
>> > All ok now.
>> >
>> > root@lin:/opt/observium# svn update && ./discovery.php -h none -u
>> > Updating '.':
>> > A    update/205.sql
>> > U    update/204.sql
>> > Updated to revision 6656.
>> > Observium 0.15.7.6656
>> > Discovery
>> >
>> > -- Updating database/file schema
>> > 204 -> 205 ... (db) done.
>> > -- Done
>> >
>> >
>> > Thanks!
>> >
>> >
>> > 2015-07-15 12:13 GMT-03:00 Mike Stupalov <mike@observium.org>:
>> >>
>> >> 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
>> >>
>> >
>> >
>> >
>> > --
>> > Eduardo Schoedler
>>
>>
>>
>> --
>> 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
>



--
Eduardo Schoedler