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?
Thanks.
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
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 listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalovhttp://observium.org
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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
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
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
Hi people,
Again errors on vlans_fdb:
[2015/10/15 21:06:37 -0300] poller.php(23183): Failed dbQuery (#1062 - Duplicate entry '35-1000-xxxxxx52775' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('35','1000','3704','xxxxxx52775','learned') [2015/10/15 21:06:37 -0300] poller.php(23183): Failed dbQuery (#1062 - Duplicate entry '35-1000-xxxxxx666194' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('35','1000','3704','xxxxxx666194','learned') [2015/10/15 21:06:37 -0300] poller.php(23183): Failed dbQuery (#1062 - Duplicate entry '35-1000-xxxxxx7585e8' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('35','1000','3704','xxxxxx7585e8','learned') [2015/10/15 21:06:37 -0300] poller.php(23183): Failed dbQuery (#1062 - Duplicate entry '35-1000-xxxxxx99fc7a' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('35','1000','3704','xxxxxx99fc7a','learned') [2015/10/15 21:06:37 -0300] poller.php(23183): Failed dbQuery (#1062 - Duplicate entry '35-1000-xxxxxx6b8102' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('35','1000','3704','xxxxxx6b8102','learned') [2015/10/15 21:06:37 -0300] poller.php(23183): Failed dbQuery (#1062 - Duplicate entry '35-1000-xxxxxxc85254' for key 'dev_vlan_mac'), Query: INSERT INTO `vlans_fdb` (`device_id`,`vlan_id`,`port_id`,`mac_address`,`fdb_status`) VALUES ('35','1000','3704','xxxxxxc85254','learned')
Thanks.
2015-08-10 12:19 GMT-03:00 Eduardo Schoedler listas@esds.com.br:
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
participants (2)
-
Eduardo Schoedler -
Mike Stupalov