The migration from dbSchema table to attributes table was kinda messy, so there will likely be some errors during the update scripts (and if there are poller/discovery processes running at the time of update)
adam. On 21/07/2015 14:24:01, Romain Winter romain@openmindedit.nl wrote: Hi, Im sorry i have no idea, probally 65xx.
No problems detected at all, when testing the software.
Regards, Romain.
On 07/21/2015 03:21 PM, Adam Armstrong wrote:
You can ignore that. You already have those columns, so no problem.
BTW, what version were you upgrading from?
adam. On 21/07/2015 14:19:25, Romain Winter romain@openmindedit.nl [mailto:romain@openmindedit.nl] wrote: Hi, Im upgrading to reversion 6718
Im getting database error's while upgrading:
cat update-errors.log [2015/05/28 15:04:58 +0200] discovery.php(13518): ====== Schema update 137 -> 138 ============== [2015/05/28 15:04:58 +0200] discovery.php(13518): Query: ALTER TABLE `sensors` ADD `entPhysicalIndex_measured` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL AFTER `sensor_custom_limit`; [2015/05/28 15:04:58 +0200] discovery.php(13518): Error: Duplicate column name 'entPhysicalIndex_measured' [2015/05/28 15:04:58 +0200] discovery.php(13518): Query: ALTER TABLE `sensors` ADD `measured_class` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `entPhysicalIndex_measured`; [2015/05/28 15:04:58 +0200] discovery.php(13518): Error: Duplicate column name 'measured_class' [2015/05/28 15:04:58 +0200] discovery.php(13518): Query: ALTER TABLE `sensors` ADD `measured_entity` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `measured_class`; [2015/05/28 15:04:58 +0200] discovery.php(13518): Error: Duplicate column name 'measured_entity'
Also, db.log
cat db.log [2015/07/21 15:13:02 +0200] poller.php(1056): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/07/21 15:13:08 +0200] discovery.php(1128): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/07/21 15:13:08 +0200] discovery.php(1128): Failed dbQuery (#1146 - Table 'observium.dbSchema' doesn't exist), Query: UPDATE `dbSchema` set `version` ='211'
Anybody having the same issue?
Kind regards, Romain winter.
--
[OpenmindedIT] [http://www.open-minded-it.nl]
Adres: Aphroditestraat 23 5047 TW Tilburg
tel: 0031 (0) 13 707 8093 fax: 0031 (0) 13 570 1113 Web: www.openmindedit.nl [http://www.open-minded-it.nl] E-mail: r.winter@openmindedit.nl [mailto:r.winter@openmindedit.nl]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
--
[OpenmindedIT] [http://www.open-minded-it.nl]
Adres: Aphroditestraat 23 5047 TW Tilburg
tel: 0031 (0) 13 707 8093 fax: 0031 (0) 13 570 1113 Web: www.openmindedit.nl [http://www.open-minded-it.nl] E-mail: r.winter@openmindedit.nl [mailto:r.winter@openmindedit.nl]