What is IGNORE? oO

adam.

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 list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

-- 
Mike Stupalov
http://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