Ah! :) http://www.observium.org/svn.log
root@observium:/opt/observium# svn up Updating '.': A update/314.sql U update/313.sql Updated to revision 8214.
root@observium:/opt/observium# /opt/observium/discovery.php -u
-- Updating database/file schema 313 -> 314 # (db) Done (0s). -- Done.
Regards,
Sander Koorneef.
________________________________ From: Sander Koorneef Sent: Friday, November 11, 2016 19:40 To: Observium Network Observation System Subject: RE: [Observium] r8210 database update problem
Hi,
got the logs:
root@observium:~# grep -A 100 'Schema update 312' /opt/observium/logs/update-errors.log
[2016/11/11 16:31:43 +0100] discovery.php(59310): ====== Schema update 312 -> 313 ============== [2016/11/11 16:31:43 +0100] discovery.php(59310): Query: ALTER TABLE `oids_assoc` DROP INDEX `oids_cache`; [2016/11/11 16:31:43 +0100] discovery.php(59310): Error: (1091) Can't DROP 'oids_cache'; check that column/key exists root@observium:~#
Regards, Sander Koorneef.
________________________________ From: observium observium-bounces@observium.org on behalf of Eduardo Schoedler listas@esds.com.br Sent: Friday, November 11, 2016 19:05 To: Observium Network Observation System Subject: Re: [Observium] r8210 database update problem
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.orghttp://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.orgmailto:adama@memetic.org>: What is IGNORE? oO
adam.
Sent from Mailbirdhttp://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.brmailto: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.orgmailto: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.orghttp://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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov http://observium.orghttp://observium.org/
_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Eduardo Schoedler