What is IGNORE? oO
adam.
Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] 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 [mailto: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 [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 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]
-- Mike Stupalov http://observium.org [http://observium.org]
_______________________________________________ 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