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'