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 schema000 -> 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 RRDs074 -> 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 noneUpdating '.':At revision 7229.___ _ _/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|Observium Professional 0.15.12.7229-- Updating database/file schema149 -> 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