Now, 314.sql is empty! lol
[root@srv /opt/observium]# atualiza-observium Updating '.': A update/314.sql U update/313.sql Updated to revision 8214.
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.16.11.8214 http://www.observium.org
-- Updating database/file schema 313 -> 314 # (db) Done (0s). -- Done. [root@srv /opt/observium]# cat update/314.sql
[root@srv /opt/observium]#
2016-11-11 14:21 GMT-02:00 Adam Armstrong adama@memetic.org:
What is IGNORE? oO
adam.
Sent from Mailbird http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm_campaign=sent-from-mailbird
On 11/11/2016 16:17:01, Eduardo Schoedler listas@esds.com.br wrote: Hi Mike,
root@linux:/opt/observium# grep -A 100 'Schema update 312' ./logs/update-errors.log [2016/11/11 13:12:07 -0200] discovery.php(19340): ====== Schema update 312 -> 313 ============== [2016/11/11 13:12:07 -0200] discovery.php(19340): Query: ALTER TABLE `oids_assoc` DROP INDEX `oids_cache`; [2016/11/11 13:12:07 -0200] discovery.php(19340): Error: (1091) Can't DROP 'oids_cache'; check that column/key exists [2016/11/11 13:12:07 -0200] discovery.php(19340): Query: ALTER IGNORE TABLE `oids_assoc` ADD UNIQUE `oids_cache` (`oid_id`, `device_id`); [2016/11/11 13:12:07 -0200] discovery.php(19340): Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `oids_assoc` ADD UNIQUE `oids_cache` (`oid_id`, `device_id`)' at line 1
Thank you,
2016-11-11 13:50 GMT-02:00 Mike Stupalov mike@observium.org:
Show log output for:
grep -A 100 'Schema update 312' ./logs/update-errors.log
On 11.11.16 18:23, Eduardo Schoedler wrote:
# svn update && ./discovery.php -u Updating '.': U includes/common.inc.php A update/312.sql A update/313.sql Updated to revision 8210.
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.16.11.8210 http://www.observium.org
-- Updating database/file schema 311 -> 312 # (db) .... Done (1s). *312 -> 313 # (db) FF Done (0s, 2 errors).* -- Done.
-- Eduardo Schoedler
observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalovhttp://observium.org
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium