Problems with fresh installation - svn revision 7229 (and stable too)
# php includes/update/update.php -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done. 002 -> 003 ... (db) done. 003 -> 004 ... (db) done. 004 -> 005 ... (db) done. 005 -> 006 ... (db) done. 006 -> 007 ... (db) done. 007 -> 008 ... (db) done. 008 -> 009 ... (db) done. 009 -> 010 ... (db) done. 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done. 013 -> 014 ... (db) done. 014 -> 015 ... (db) done. 015 -> 016 ... (db) done. 016 -> 017 ... (db) done. 017 -> 018 ... (db) done. 018 -> 019 ... (db) done. 019 -> 020 ... (db) done. 020 -> 021 ... (db) done. 021 -> 022 ... (db) done. 022 -> 023 ... (db) done. 023 -> 024 ... (db) done. 024 -> 025 ... (db) done. 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done. 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done. 031 -> 032 ... (db) done. 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done. 036 -> 037 ... (db) done. 037 -> 038 ... (db) done. 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done. 042 -> 043 ... (db) done. 043 -> 044 ... (db) done. 044 -> 045 ... (db) done. 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done. 048 -> 049 ... (db) done. 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done. 054 -> 055 ... (db) done. 055 -> 056 ... (db) done. 056 -> 057 ... (db) done. 057 -> 058 ... (db) done. 058 -> 059 ... (db) done. 059 -> 060 ... (db) done. 060 -> 061 ... (db) done. 061 -> 062 ... (db) done. 062 -> 063 ... (db) done. 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done. 068 -> 069 ... (db) done. 069 -> 070 ... (db) done. 070 -> 071 ... (db) done. 071 -> 072 ... (db) done. 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done. 075 -> 076 ... (db) done. 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done. 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done. 085 -> 086 ... (db) done. 086 -> 087 ... (db) done. 087 -> 088 ... (db) done. 088 -> 089 ... (db) done. 089 -> 090 ... (db) done. 090 -> 091 ... (db) done. 091 -> 092 ... (db) done. 092 -> 093 ... (db) done. 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done. 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done. 099 -> 100 ... (db) done. 100 -> 101 ... (db) done. 101 -> 102 ... (db) done. 102 -> 103 ... (db) done. 103 -> 104 ... (db) done. 104 -> 105 ... (db) done. 105 -> 106 ... (db) done. 106 -> 107 ... (db) done. 107 -> 108 ... (db) done. 108 -> 109 ... (db) done. 109 -> 110 ... (db) done. 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done. 114 -> 115 ... (db) done. 115 -> 116 ... (db) done. 116 -> 117 ... (db) done. 117 -> 118 ... (db) done. 118 -> 119 ... (db) done. 119 -> 120 ... (db) done. 120 -> 121 ... (db) done. 121 -> 122 ... (db) done. 122 -> 123 ... (db) done. 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 125 -> 126 ... (db) done. 126 -> 127 ... (php) Converting FDB count RRD ds fdb->value: 127 -> 128 ... (php) Rename old storage RRDs and DB: 128 -> 129 ... (php) Rename old mempools RRDs and DB: 129 -> 130 ... (db) done. 130 -> 131 ... (db) done. 131 -> 132 ... (db) done. 132 -> 133 ... (db) done. 133 -> 134 ... (db) done. 134 -> 135 ... (db) done. 135 -> 136 ... (db) done. 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done. 139 -> 140 ... (db) done. 140 -> 141 ... (db) done. 141 -> 142 ... (db) done. 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done. 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done. 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (2 errors).
# svn update && ./discovery.php -h none Updating '.': At revision 7229.
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7229 http://www.observium.org
-- Updating database/file schema 149 -> 150 ... (db) done (10 errors).
# cat update-errors.log [2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ============== [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms'
# cat db.log [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050 - Table 'entity_permissions' already exists), Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.bill_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.devices_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.devices_perms'), Query: DROP TABLE `devices_perms`;
These updates were a long time ago. The failing queries were probably fixing earlier changes.
I'm fairly sure you can ignore them!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 4 December 2015 11:16:33 pm Eduardo Schoedler listas@esds.com.br wrote:
# php includes/update/update.php -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done. 002 -> 003 ... (db) done. 003 -> 004 ... (db) done. 004 -> 005 ... (db) done. 005 -> 006 ... (db) done. 006 -> 007 ... (db) done. 007 -> 008 ... (db) done. 008 -> 009 ... (db) done. 009 -> 010 ... (db) done. 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done. 013 -> 014 ... (db) done. 014 -> 015 ... (db) done. 015 -> 016 ... (db) done. 016 -> 017 ... (db) done. 017 -> 018 ... (db) done. 018 -> 019 ... (db) done. 019 -> 020 ... (db) done. 020 -> 021 ... (db) done. 021 -> 022 ... (db) done. 022 -> 023 ... (db) done. 023 -> 024 ... (db) done. 024 -> 025 ... (db) done. 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done. 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done. 031 -> 032 ... (db) done. 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done. 036 -> 037 ... (db) done. 037 -> 038 ... (db) done. 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done. 042 -> 043 ... (db) done. 043 -> 044 ... (db) done. 044 -> 045 ... (db) done. 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done. 048 -> 049 ... (db) done. 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done. 054 -> 055 ... (db) done. 055 -> 056 ... (db) done. 056 -> 057 ... (db) done. 057 -> 058 ... (db) done. 058 -> 059 ... (db) done. 059 -> 060 ... (db) done. 060 -> 061 ... (db) done. 061 -> 062 ... (db) done. 062 -> 063 ... (db) done. 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done. 068 -> 069 ... (db) done. 069 -> 070 ... (db) done. 070 -> 071 ... (db) done. 071 -> 072 ... (db) done. 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done. 075 -> 076 ... (db) done. 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done. 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done. 085 -> 086 ... (db) done. 086 -> 087 ... (db) done. 087 -> 088 ... (db) done. 088 -> 089 ... (db) done. 089 -> 090 ... (db) done. 090 -> 091 ... (db) done. 091 -> 092 ... (db) done. 092 -> 093 ... (db) done. 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done. 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done. 099 -> 100 ... (db) done. 100 -> 101 ... (db) done. 101 -> 102 ... (db) done. 102 -> 103 ... (db) done. 103 -> 104 ... (db) done. 104 -> 105 ... (db) done. 105 -> 106 ... (db) done. 106 -> 107 ... (db) done. 107 -> 108 ... (db) done. 108 -> 109 ... (db) done. 109 -> 110 ... (db) done. 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done. 114 -> 115 ... (db) done. 115 -> 116 ... (db) done. 116 -> 117 ... (db) done. 117 -> 118 ... (db) done. 118 -> 119 ... (db) done. 119 -> 120 ... (db) done. 120 -> 121 ... (db) done. 121 -> 122 ... (db) done. 122 -> 123 ... (db) done. 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 125 -> 126 ... (db) done. 126 -> 127 ... (php) Converting FDB count RRD ds fdb->value: 127 -> 128 ... (php) Rename old storage RRDs and DB: 128 -> 129 ... (php) Rename old mempools RRDs and DB: 129 -> 130 ... (db) done. 130 -> 131 ... (db) done. 131 -> 132 ... (db) done. 132 -> 133 ... (db) done. 133 -> 134 ... (db) done. 134 -> 135 ... (db) done. 135 -> 136 ... (db) done. 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done. 139 -> 140 ... (db) done. 140 -> 141 ... (db) done. 141 -> 142 ... (db) done. 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done. 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done. 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (2 errors).
# svn update && ./discovery.php -h none Updating '.': At revision 7229.
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7229 http://www.observium.org
-- Updating database/file schema 149 -> 150 ... (db) done (10 errors).
# cat update-errors.log [2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ============== [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms'
# cat db.log [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050 - Table 'entity_permissions' already exists), Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.bill_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.devices_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.devices_perms'), Query: DROP TABLE `devices_perms`;
-- Eduardo Schoedler
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Adam,
Take a deep look in log, you will see the process stops on update 150 from database. I don't even know if entire database is there.
Even if I create entire database from the db_schema_mysql.sql file, there is a lot of errors in db.log from discovery and poller.
I'm installing a fresh copy of Observium in a Freebsd with mysql (I've tried 5.6 and switched to 5.5 to see if the version was the problem).
I sent in private an e-mail with the errors.
Thank you.
2015-12-05 1:29 GMT-02:00 Adam Armstrong adama@observium.org:
These updates were a long time ago. The failing queries were probably fixing earlier changes.
I'm fairly sure you can ignore them!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 4 December 2015 11:16:33 pm Eduardo Schoedler listas@esds.com.br wrote:
# php includes/update/update.php -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done. 002 -> 003 ... (db) done. 003 -> 004 ... (db) done. 004 -> 005 ... (db) done. 005 -> 006 ... (db) done. 006 -> 007 ... (db) done. 007 -> 008 ... (db) done. 008 -> 009 ... (db) done. 009 -> 010 ... (db) done. 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done. 013 -> 014 ... (db) done. 014 -> 015 ... (db) done. 015 -> 016 ... (db) done. 016 -> 017 ... (db) done. 017 -> 018 ... (db) done. 018 -> 019 ... (db) done. 019 -> 020 ... (db) done. 020 -> 021 ... (db) done. 021 -> 022 ... (db) done. 022 -> 023 ... (db) done. 023 -> 024 ... (db) done. 024 -> 025 ... (db) done. 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done. 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done. 031 -> 032 ... (db) done. 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done. 036 -> 037 ... (db) done. 037 -> 038 ... (db) done. 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done. 042 -> 043 ... (db) done. 043 -> 044 ... (db) done. 044 -> 045 ... (db) done. 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done. 048 -> 049 ... (db) done. 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done. 054 -> 055 ... (db) done. 055 -> 056 ... (db) done. 056 -> 057 ... (db) done. 057 -> 058 ... (db) done. 058 -> 059 ... (db) done. 059 -> 060 ... (db) done. 060 -> 061 ... (db) done. 061 -> 062 ... (db) done. 062 -> 063 ... (db) done. 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done. 068 -> 069 ... (db) done. 069 -> 070 ... (db) done. 070 -> 071 ... (db) done. 071 -> 072 ... (db) done. 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done. 075 -> 076 ... (db) done. 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done. 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done. 085 -> 086 ... (db) done. 086 -> 087 ... (db) done. 087 -> 088 ... (db) done. 088 -> 089 ... (db) done. 089 -> 090 ... (db) done. 090 -> 091 ... (db) done. 091 -> 092 ... (db) done. 092 -> 093 ... (db) done. 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done. 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done. 099 -> 100 ... (db) done. 100 -> 101 ... (db) done. 101 -> 102 ... (db) done. 102 -> 103 ... (db) done. 103 -> 104 ... (db) done. 104 -> 105 ... (db) done. 105 -> 106 ... (db) done. 106 -> 107 ... (db) done. 107 -> 108 ... (db) done. 108 -> 109 ... (db) done. 109 -> 110 ... (db) done. 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done. 114 -> 115 ... (db) done. 115 -> 116 ... (db) done. 116 -> 117 ... (db) done. 117 -> 118 ... (db) done. 118 -> 119 ... (db) done. 119 -> 120 ... (db) done. 120 -> 121 ... (db) done. 121 -> 122 ... (db) done. 122 -> 123 ... (db) done. 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 125 -> 126 ... (db) done. 126 -> 127 ... (php) Converting FDB count RRD ds fdb->value: 127 -> 128 ... (php) Rename old storage RRDs and DB: 128 -> 129 ... (php) Rename old mempools RRDs and DB: 129 -> 130 ... (db) done. 130 -> 131 ... (db) done. 131 -> 132 ... (db) done. 132 -> 133 ... (db) done. 133 -> 134 ... (db) done. 134 -> 135 ... (db) done. 135 -> 136 ... (db) done. 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done. 139 -> 140 ... (db) done. 140 -> 141 ... (db) done. 141 -> 142 ... (db) done. 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done. 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done. 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (2 errors).
# svn update && ./discovery.php -h none Updating '.': At revision 7229.
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7229 http://www.observium.org
-- Updating database/file schema 149 -> 150 ... (db) done (10 errors).
# cat update-errors.log [2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ============== [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms'
# cat db.log [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050 - Table 'entity_permissions' already exists), Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.bill_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.devices_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.devices_perms'), Query: DROP TABLE `devices_perms`;
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Ahh yes. I see now.
Update 152 is a php script, so it seems like this is failing to run for some reason.
Can you try turning on PHP's errors and re-running the update, to see if there's a useful error?
php includes/update/update.php -d
adam. On 05/12/2015 04:31:54, Eduardo Schoedler listas@esds.com.br wrote: Adam,
Take a deep look in log, you will see the process stops on update 150 from database. I don't even know if entire database is there.
Even if I create entire database from the db_schema_mysql.sql file, there is a lot of errors in db.log from discovery and poller.
I'm installing a fresh copy of Observium in a Freebsd with mysql (I've tried 5.6 and switched to 5.5 to see if the version was the problem).
I sent in private an e-mail with the errors.
Thank you.
2015-12-05 1:29 GMT-02:00 Adam Armstrong <adama@observium.org [mailto:adama@observium.org]>:
These updates were a long time ago. The failing queries were probably fixing earlier changes. I'm fairly sure you can ignore them! Adam. Sent with AquaMail for Android http://www.aqua-mail.com [http://www.aqua-mail.com] On 4 December 2015 11:16:33 pm Eduardo Schoedler <listas@esds.com.br [mailto:listas@esds.com.br]> wrote: # php includes/update/update.php -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done. 002 -> 003 ... (db) done. 003 -> 004 ... (db) done. 004 -> 005 ... (db) done. 005 -> 006 ... (db) done. 006 -> 007 ... (db) done. 007 -> 008 ... (db) done. 008 -> 009 ... (db) done. 009 -> 010 ... (db) done. 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done. 013 -> 014 ... (db) done. 014 -> 015 ... (db) done. 015 -> 016 ... (db) done. 016 -> 017 ... (db) done. 017 -> 018 ... (db) done. 018 -> 019 ... (db) done. 019 -> 020 ... (db) done. 020 -> 021 ... (db) done. 021 -> 022 ... (db) done. 022 -> 023 ... (db) done. 023 -> 024 ... (db) done. 024 -> 025 ... (db) done. 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done. 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done. 031 -> 032 ... (db) done. 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done. 036 -> 037 ... (db) done. 037 -> 038 ... (db) done. 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done. 042 -> 043 ... (db) done. 043 -> 044 ... (db) done. 044 -> 045 ... (db) done. 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done. 048 -> 049 ... (db) done. 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done. 054 -> 055 ... (db) done. 055 -> 056 ... (db) done. 056 -> 057 ... (db) done. 057 -> 058 ... (db) done. 058 -> 059 ... (db) done. 059 -> 060 ... (db) done. 060 -> 061 ... (db) done. 061 -> 062 ... (db) done. 062 -> 063 ... (db) done. 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done. 068 -> 069 ... (db) done. 069 -> 070 ... (db) done. 070 -> 071 ... (db) done. 071 -> 072 ... (db) done. 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done. 075 -> 076 ... (db) done. 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done. 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done. 085 -> 086 ... (db) done. 086 -> 087 ... (db) done. 087 -> 088 ... (db) done. 088 -> 089 ... (db) done. 089 -> 090 ... (db) done. 090 -> 091 ... (db) done. 091 -> 092 ... (db) done. 092 -> 093 ... (db) done. 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done. 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done. 099 -> 100 ... (db) done. 100 -> 101 ... (db) done. 101 -> 102 ... (db) done. 102 -> 103 ... (db) done. 103 -> 104 ... (db) done. 104 -> 105 ... (db) done. 105 -> 106 ... (db) done. 106 -> 107 ... (db) done. 107 -> 108 ... (db) done. 108 -> 109 ... (db) done. 109 -> 110 ... (db) done. 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done. 114 -> 115 ... (db) done. 115 -> 116 ... (db) done. 116 -> 117 ... (db) done. 117 -> 118 ... (db) done. 118 -> 119 ... (db) done. 119 -> 120 ... (db) done. 120 -> 121 ... (db) done. 121 -> 122 ... (db) done. 122 -> 123 ... (db) done. 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 125 -> 126 ... (db) done. 126 -> 127 ... (php) Converting FDB count RRD ds fdb->value: 127 -> 128 ... (php) Rename old storage RRDs and DB: 128 -> 129 ... (php) Rename old mempools RRDs and DB: 129 -> 130 ... (db) done. 130 -> 131 ... (db) done. 131 -> 132 ... (db) done. 132 -> 133 ... (db) done. 133 -> 134 ... (db) done. 134 -> 135 ... (db) done. 135 -> 136 ... (db) done. 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done. 139 -> 140 ... (db) done. 140 -> 141 ... (db) done. 141 -> 142 ... (db) done. 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done. 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done. 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (2 errors).
# svn update && ./discovery.php -h none Updating '.': At revision 7229.
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7229 http://www.observium.org [http://www.observium.org]
-- Updating database/file schema 149 -> 150 ... (db) done (10 errors).
# cat update-errors.log [2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ============== [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms'
# cat db.log [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050 - Table 'entity_permissions' already exists), Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.bill_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.devices_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.devices_perms'), Query: DROP TABLE `devices_perms`;
--
Eduardo Schoedler
_______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ 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]
--
Eduardo Schoedler
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi Eduardo,
you do a clean install?
Please do some debug steps:
drop database (if exist), recreate it and run DB schema update dut with debug flag and pipe output to file ./discovery.php -dd -u > /tmp/update_debug.txt
Than send to me this file (update_debug.txt)
On Sat, Dec 5, 2015 at 7:31 AM, Eduardo Schoedler listas@esds.com.br wrote:
Adam,
Take a deep look in log, you will see the process stops on update 150 from database. I don't even know if entire database is there.
Even if I create entire database from the db_schema_mysql.sql file, there is a lot of errors in db.log from discovery and poller.
I'm installing a fresh copy of Observium in a Freebsd with mysql (I've tried 5.6 and switched to 5.5 to see if the version was the problem).
I sent in private an e-mail with the errors.
Thank you.
2015-12-05 1:29 GMT-02:00 Adam Armstrong adama@observium.org:
These updates were a long time ago. The failing queries were probably fixing earlier changes.
I'm fairly sure you can ignore them!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 4 December 2015 11:16:33 pm Eduardo Schoedler listas@esds.com.br wrote:
# php includes/update/update.php -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done. 002 -> 003 ... (db) done. 003 -> 004 ... (db) done. 004 -> 005 ... (db) done. 005 -> 006 ... (db) done. 006 -> 007 ... (db) done. 007 -> 008 ... (db) done. 008 -> 009 ... (db) done. 009 -> 010 ... (db) done. 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done. 013 -> 014 ... (db) done. 014 -> 015 ... (db) done. 015 -> 016 ... (db) done. 016 -> 017 ... (db) done. 017 -> 018 ... (db) done. 018 -> 019 ... (db) done. 019 -> 020 ... (db) done. 020 -> 021 ... (db) done. 021 -> 022 ... (db) done. 022 -> 023 ... (db) done. 023 -> 024 ... (db) done. 024 -> 025 ... (db) done. 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done. 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done. 031 -> 032 ... (db) done. 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done. 036 -> 037 ... (db) done. 037 -> 038 ... (db) done. 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done. 042 -> 043 ... (db) done. 043 -> 044 ... (db) done. 044 -> 045 ... (db) done. 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done. 048 -> 049 ... (db) done. 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done. 054 -> 055 ... (db) done. 055 -> 056 ... (db) done. 056 -> 057 ... (db) done. 057 -> 058 ... (db) done. 058 -> 059 ... (db) done. 059 -> 060 ... (db) done. 060 -> 061 ... (db) done. 061 -> 062 ... (db) done. 062 -> 063 ... (db) done. 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done. 068 -> 069 ... (db) done. 069 -> 070 ... (db) done. 070 -> 071 ... (db) done. 071 -> 072 ... (db) done. 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done. 075 -> 076 ... (db) done. 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done. 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done. 085 -> 086 ... (db) done. 086 -> 087 ... (db) done. 087 -> 088 ... (db) done. 088 -> 089 ... (db) done. 089 -> 090 ... (db) done. 090 -> 091 ... (db) done. 091 -> 092 ... (db) done. 092 -> 093 ... (db) done. 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done. 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done. 099 -> 100 ... (db) done. 100 -> 101 ... (db) done. 101 -> 102 ... (db) done. 102 -> 103 ... (db) done. 103 -> 104 ... (db) done. 104 -> 105 ... (db) done. 105 -> 106 ... (db) done. 106 -> 107 ... (db) done. 107 -> 108 ... (db) done. 108 -> 109 ... (db) done. 109 -> 110 ... (db) done. 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done. 114 -> 115 ... (db) done. 115 -> 116 ... (db) done. 116 -> 117 ... (db) done. 117 -> 118 ... (db) done. 118 -> 119 ... (db) done. 119 -> 120 ... (db) done. 120 -> 121 ... (db) done. 121 -> 122 ... (db) done. 122 -> 123 ... (db) done. 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 125 -> 126 ... (db) done. 126 -> 127 ... (php) Converting FDB count RRD ds fdb->value: 127 -> 128 ... (php) Rename old storage RRDs and DB: 128 -> 129 ... (php) Rename old mempools RRDs and DB: 129 -> 130 ... (db) done. 130 -> 131 ... (db) done. 131 -> 132 ... (db) done. 132 -> 133 ... (db) done. 133 -> 134 ... (db) done. 134 -> 135 ... (db) done. 135 -> 136 ... (db) done. 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done. 139 -> 140 ... (db) done. 140 -> 141 ... (db) done. 141 -> 142 ... (db) done. 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done. 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done. 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (2 errors).
# svn update && ./discovery.php -h none Updating '.': At revision 7229.
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7229 http://www.observium.org
-- Updating database/file schema 149 -> 150 ... (db) done (10 errors).
# cat update-errors.log [2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ============== [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms'
# cat db.log [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146
- Table 'observium.observium_attribs' doesn't exist), Query: SELECT
`attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054
- Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE
`alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054
- Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE
`alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146
- Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE
`ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146
- Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE
`ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146
- Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms`
SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050
- Table 'entity_permissions' already exists), Query: RENAME TABLE
`ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146
- Table 'observium.bill_perms' doesn't exist), Query: INSERT
`entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146
- Table 'observium.devices_perms' doesn't exist), Query: INSERT
`entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051
- Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`;
[2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051
- Unknown table 'observium.devices_perms'), Query: DROP TABLE
`devices_perms`;
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Adam Armstrong -
Adam Armstrong -
Eduardo Schoedler -
Mike Stupalov