Re: [Observium] observium Digest, Vol 65, Issue 120
Adam no. I didn't press ctrl-c
On Wednesday, December 23, 2015, observium-request@observium.org wrote:
Send observium mailing list submissions to observium@observium.org javascript:;
To subscribe or unsubscribe via the World Wide Web, visit http://postman.memetic.org/cgi-bin/mailman/listinfo/observium or, via email, send a message with subject or body 'help' to observium-request@observium.org javascript:;
You can reach the person managing the list at observium-owner@observium.org javascript:;
When replying, please edit your Subject line so it is more specific than "Re: Contents of observium digest..."
Today's Topics:
- error when upgrading (Mehmet Akcin)
- Re: error when upgrading (Adam Armstrong)
- using postfix_qshape (Andry Nata wijaya)
Message: 1 Date: Wed, 23 Dec 2015 15:07:45 -0800 From: Mehmet Akcin <mehmet@akcin.net javascript:;> To: observium@observium.org javascript:; Subject: [Observium] error when upgrading Message-ID: <404A1A6C-BCA5-45ED-8619-6B866E51A5FA@akcin.net javascript:;
Content-Type: text/plain; charset="utf-8"
hey there
just moving from community edition to latest subscriber edition
I am getting an error here
root@observium.lax:/opt/observium# ./discovery.php -u
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7231 http://www.observium.org
-- Updating database/file schema 185 -> 186 ... (db) done (9 errors).
any idea how to fix this? here is how my logs look like
root@observium.lax:/opt/observium# tail /opt/observium/logs/update-errors.log [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `devices` ADD INDEX `disabled_lastpolled` (`disabled`, `last_polled_timetaken`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'disabled_lastpolled' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv4_addresses` ADD INDEX `ipv4_address` (`ipv4_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv4_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv6_addresses` ADD INDEX `ipv6_address` (`ipv6_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv6_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `mac_accounting` ADD INDEX `device_ma` (`device_id`, `ma_id`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'device_ma' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `dbSchema` ADD PRIMARY KEY (`version`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1062) Duplicate entry '185' for key ?PRIMARY'
Hmm. I'm not sure how this could have happened. It'll probably be a little fiddly to fix, if it's possible at all.
If you don't really care about eventlog history, you can just remove the database and allow it to create a new one.
Alternatively look at the dbSchema table and remove the duplicate and try re-running the update :)
adam.
Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm...] On 24/12/2015 03:20:06, Mehmet Akcin mehmet@akcin.net wrote: Adam no. I didn't press ctrl-c
On Wednesday, December 23, 2015, <observium-request@observium.org [mailto:observium-request@observium.org]> wrote:
Send observium mailing list submissions to observium@observium.org
To subscribe or unsubscribe via the World Wide Web, visit http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium] or, via email, send a message with subject or body 'help' to observium-request@observium.org
You can reach the person managing the list at observium-owner@observium.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of observium digest..."
Today's Topics:
1. error when upgrading (Mehmet Akcin) 2. Re: error when upgrading (Adam Armstrong) 3. using postfix_qshape (Andry Nata wijaya)
----------------------------------------------------------------------
Message: 1 Date: Wed, 23 Dec 2015 15:07:45 -0800 From: Mehmet Akcin mehmet@akcin.net To: observium@observium.org Subject: [Observium] error when upgrading Message-ID: 404A1A6C-BCA5-45ED-8619-6B866E51A5FA@akcin.net Content-Type: text/plain; charset="utf-8"
hey there
just moving from community edition to latest subscriber edition
I am getting an error here
root@observium.lax:/opt/observium# ./discovery.php -u
___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |__ | __/| | \ V / | || |_| || | | | | | ___/ |_.__/ |___/ ___||_| _/ |_| __,_||_| |_| |_| Observium Professional 0.15.12.7231 http://www.observium.org [http://www.observium.org]
-- Updating database/file schema 185 -> 186 ... (db) done (9 errors).
any idea how to fix this? here is how my logs look like
root@observium.lax:/opt/observium# tail /opt/observium/logs/update-errors.log [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `devices` ADD INDEX `disabled_lastpolled` (`disabled`, `last_polled_timetaken`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'disabled_lastpolled' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv4_addresses` ADD INDEX `ipv4_address` (`ipv4_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv4_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv6_addresses` ADD INDEX `ipv6_address` (`ipv6_address`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv6_address' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `mac_accounting` ADD INDEX `device_ma` (`device_id`, `ma_id`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'device_ma' [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `dbSchema` ADD PRIMARY KEY (`version`); [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1062) Duplicate entry '185' for key ?PRIMARY'
participants (2)
-
Adam Armstrong -
Mehmet Akcin