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.
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 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]
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 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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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]
participants (2)
-
Adam Armstrong -
Romain Winter