r8210 database update problem

Eduardo Schoedler

11 Nov 2016 11 Nov '16

4:23 p.m.

# 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

Attachments:

attachment.html (text/html — 1.9 KB)

Show replies by date

Mike Stupalov

11 Nov 11 Nov

4:50 p.m.

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

Adam Armstrong

4:51 p.m.

I told you about this. You added a remove index, but also removed the line that added the index, so for all eternity, everyone will get an error.

This was kind of stupid.

adam.

Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 11/11/2016 15:50:25, Mike Stupalov mike@observium.org wrote:

Show log output for:

grep -A 100 'Schema update 312' ./logs/update-errors.log

On 11.11.16 18:23, Eduardo Schoedler wrote:

cite="mid:CAHf3uWyD_L8Jxrriu7=hxiwkTHRTpQyYK3thcj7a4jDeUBQs2g@mail.gmail.com" type="cite">

# 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

href="http://www.observium.org%22%3Ehttp://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]

Mike Stupalov

4:54 p.m.

On 11.11.16 18:51, Adam Armstrong wrote:

...

I told you about this. You added a remove index, but also removed the line that added the index, so for all eternity, everyone will get an error.

No, here two errors, I want to know which is second error.

remove index here is not problem, it can be removed since required only for some too fast swedish :)

...

This was kind of stupid.

adam.

Sent from Mailbird http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm_campaign=sent-from-mailbird

...
On 11/11/2016 15:50:25, Mike Stupalov mike@observium.org wrote:

Show log output for:

grep -A 100 'Schema update 312' ./logs/update-errors.log

On 11.11.16 18:23, Eduardo Schoedler wrote:

cite="mid:CAHf3uWyD_L8Jxrriu7=hxiwkTHRTpQyYK3thcj7a4jDeUBQs2g@mail.gmail.com"

type="cite">

# 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

href="http://www.observium.org%22%3Ehttp://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

-- Mike Stupalov http://observium.org

Eduardo Schoedler

5:16 p.m.

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

Adam Armstrong

5:21 p.m.

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,

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.

-- Updating database/file schema 311 -> 312 # (db) .... Done (1s). 312 -> 313 # (db) FF Done (0s, 2 errors). -- Done.

Eduardo Schoedler

-- Mike Stupalov http://observium.org [http://observium.org]

Eduardo Schoedler

_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

Eduardo Schoedler

7:05 p.m.

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.

-- 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

-- Eduardo Schoedler

Sander Koorneef

7:40 p.m.

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.

-- 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,

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.

-- 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.org http://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

Sander Koorneef

7:43 p.m.

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

Regards, Sander Koorneef.

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.

-- 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,

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.

-- 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.org http://observium.org/

_______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

-- Eduardo Schoedler

Sander Koorneef

5:32 p.m.

Hi,

We also updated today, and got one DB update error. I will check the logs.

Sander Koorneef

---- Eduardo Schoedler schreef ----

# svn update && ./discovery.php -u Updating '.': U includes/common.inc.php A update/312.sql A update/313.sql Updated to revision 8210.

-- Updating database/file schema 311 -> 312 # (db) .... Done (1s). 312 -> 313 # (db) FF Done (0s, 2 errors). -- Done.

-- Eduardo Schoedler

3090

Age (days ago)

3090

Last active (days ago)

List overview

Download

9 comments

4 participants

tags (0)

participants (4)

Adam Armstrong
Eduardo Schoedler
Mike Stupalov
Sander Koorneef