Hi, I just updated for the first time in a couple of weeks, and got an error applying the updates.
Here is the console message and update-errors log: /opt/observium# php ./discovery.php -h none
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.8.6911 http://www.observium.org
-- Updating database/file schema 219 -> 220 ... (db) done. 220 -> 221 ... (db) done. 221 -> 222 ... (db) done. 222 -> 223 ... (db) done. 223 -> 224 ... (db) done (2 errors). 224 -> 225 ... (db) done. 225 -> 226 ... (db) done. 226 -> 227 ... (db) done. 227 -> 228 ... (db) done. -- Done.
[2015/08/21 09:48:29 -0700] discovery.php(12283): ====== Schema update 223 -> 224 ============== [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` ADD `last_ok` INT NULL AFTER `last_recovered` ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1114) The table '#sql-42b4_3c28dc' is full [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` CHANGE `last_checked` `last_checked` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_changed` `last_changed` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_recovered` `last_recovered` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_ok` `last_ok` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_failed` `last_failed` INT( 10 ) NULL DEFAULT NULL ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1054) Unknown column 'last_ok' in 'alert_table-state'
Thank You
Sholom Shapiro | Senior Systems Engineer
Viking Technology Partners
sholom@vikingtech.consulting
310.948.2438
Viking Technology Partners
10501 W. Gowan Road, Suite 170
Las Vegas, Nevada 89129
vikingtech.consulting http://www.vikingtech.consulting @vikingtechs https://twitter.com/VikingTechs
Hi,
This is because your alert table was full. We're going to have to do a larger fix for this shortly.
If you restart your MyS On 21/08/2015 17:53:53, Sholom Shapiro sholom@vikingtech.consulting wrote: Hi, I just updated for the first time in a couple of weeks, and got an error applying the updates.
Here is the console message and update-errors log: /opt/observium# php ./discovery.php -h none
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.8.6911 http://www.observium.org [http://www.observium.org]
-- Updating database/file schema 219 -> 220 ... (db) done. 220 -> 221 ... (db) done. 221 -> 222 ... (db) done. 222 -> 223 ... (db) done. 223 -> 224 ... (db) done (2 errors). 224 -> 225 ... (db) done. 225 -> 226 ... (db) done. 226 -> 227 ... (db) done. 227 -> 228 ... (db) done. -- Done.
[2015/08/21 09:48:29 -0700] discovery.php(12283): ====== Schema update 223 -> 224 ============== [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` ADD `last_ok` INT NULL AFTER `last_recovered` ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1114) The table '#sql-42b4_3c28dc' is full [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` CHANGE `last_checked` `last_checked` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_changed` `last_changed` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_recovered` `last_recovered` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_ok` `last_ok` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_failed` `last_failed` INT( 10 ) NULL DEFAULT NULL ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1054) Unknown column 'last_ok' in 'alert_table-state'
Thank You
Sholom Shapiro | Senior Systems Engineer Viking Technology Partners sholom@vikingtech.consulting [mailto:sholom@vikingtech.consulting] 310.948.2438
Viking Technology Partners 10501 W. Gowan Road, Suite 170 Las Vegas, Nevada 89129
vikingtech.consulting [http://www.vikingtech.consulting] @vikingtechs [https://twitter.com/VikingTechs]
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Restart your MySQL server and then manually re-apply the contents of update/224.sql, it should be fine.
( mysql -u <user> -p<password> <observium database> < update/224.sql )
adam. On 21/08/2015 17:57:46, Adam Armstrong adama@memetic.org wrote: Hi,
This is because your alert table was full. We're going to have to do a larger fix for this shortly.
If you restart your MyS On 21/08/2015 17:53:53, Sholom Shapiro sholom@vikingtech.consulting wrote: Hi, I just updated for the first time in a couple of weeks, and got an error applying the updates.
Here is the console message and update-errors log: /opt/observium# php ./discovery.php -h none
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.8.6911 http://www.observium.org [http://www.observium.org]
-- Updating database/file schema 219 -> 220 ... (db) done. 220 -> 221 ... (db) done. 221 -> 222 ... (db) done. 222 -> 223 ... (db) done. 223 -> 224 ... (db) done (2 errors). 224 -> 225 ... (db) done. 225 -> 226 ... (db) done. 226 -> 227 ... (db) done. 227 -> 228 ... (db) done. -- Done.
[2015/08/21 09:48:29 -0700] discovery.php(12283): ====== Schema update 223 -> 224 ============== [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` ADD `last_ok` INT NULL AFTER `last_recovered` ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1114) The table '#sql-42b4_3c28dc' is full [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` CHANGE `last_checked` `last_checked` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_changed` `last_changed` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_recovered` `last_recovered` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_ok` `last_ok` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_failed` `last_failed` INT( 10 ) NULL DEFAULT NULL ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1054) Unknown column 'last_ok' in 'alert_table-state'
Thank You
Sholom Shapiro | Senior Systems Engineer Viking Technology Partners sholom@vikingtech.consulting [mailto:sholom@vikingtech.consulting] 310.948.2438
Viking Technology Partners 10501 W. Gowan Road, Suite 170 Las Vegas, Nevada 89129
vikingtech.consulting [http://www.vikingtech.consulting] @vikingtechs [https://twitter.com/VikingTechs]
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Thanks! It looks like that worked.
Sholom Shapiro | Senior Systems Engineer
Viking Technology Partners
sholom@vikingtech.consulting
310.948.2438
Viking Technology Partners
10501 W. Gowan Road, Suite 170
Las Vegas, Nevada 89129
vikingtech.consulting http://www.vikingtech.consulting @vikingtechs https://twitter.com/VikingTechs
On Fri, Aug 21, 2015 at 9:58 AM, Adam Armstrong adama@memetic.org wrote:
Restart your MySQL server and then manually re-apply the contents of update/224.sql, it should be fine.
( mysql -u <user> -p<password> <observium database> < update/224.sql )
adam.
On 21/08/2015 17:57:46, Adam Armstrong adama@memetic.org wrote: Hi,
This is because your alert table was full. We're going to have to do a larger fix for this shortly.
If you restart your MyS
On 21/08/2015 17:53:53, Sholom Shapiro sholom@vikingtech.consulting wrote: Hi, I just updated for the first time in a couple of weeks, and got an error applying the updates.
Here is the console message and update-errors log: /opt/observium# php ./discovery.php -h none
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.8.6911 http://www.observium.org
-- Updating database/file schema 219 -> 220 ... (db) done. 220 -> 221 ... (db) done. 221 -> 222 ... (db) done. 222 -> 223 ... (db) done. 223 -> 224 ... (db) done (2 errors). 224 -> 225 ... (db) done. 225 -> 226 ... (db) done. 226 -> 227 ... (db) done. 227 -> 228 ... (db) done. -- Done.
[2015/08/21 09:48:29 -0700] discovery.php(12283): ====== Schema update 223 -> 224 ============== [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` ADD `last_ok` INT NULL AFTER `last_recovered` ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1114) The table '#sql-42b4_3c28dc' is full [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` CHANGE `last_checked` `last_checked` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_changed` `last_changed` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_recovered` `last_recovered` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_ok` `last_ok` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_failed` `last_failed` INT( 10 ) NULL DEFAULT NULL ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1054) Unknown column 'last_ok' in 'alert_table-state'
Thank You
Sholom Shapiro | Senior Systems Engineer
Viking Technology Partners
sholom@vikingtech.consulting
310.948.2438
Viking Technology Partners
10501 W. Gowan Road, Suite 170
Las Vegas, Nevada 89129
vikingtech.consulting http://www.vikingtech.consulting @vikingtechs https://twitter.com/VikingTechs _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Adam Armstrong -
Sholom Shapiro