On 22.05.2014 11:17, André Freitas wrote:
How i do the roolback to 1.11.3 from 1.12?
drop the added column and update the dbversion column 'version' to 1.11.3
On Wed, 2014-05-21 at 21:47 +0200, Michael Friedrich wrote:
On 21.05.2014 11:23, André Freitas wrote:
Hi,
i was upgrading my icinga core from version 1.10.0 to 1.11.3 and one of
the recommend steps is to upgrade the idoutils to the last version. From
what i understand from documentation regarding idoutils upgrade, i had
to make all incremetal steps from 1.10 -> 1.11 -> 1.11.3 -> 1.12.0.sql
The 1.12.0.sql shouldn't exist. That one slipped into the tarball from a
local git checkout, but does not exist in the support/1.11 git branch.
I've uploaded a new tarball to github without those files not in git.
$ psql -U icinga -d icinga <
module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.11.3.sql
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ERROR: syntax error at or near "("
LINE 1: ...icinga_hoststatus ADD COLUMN is_reachable smallint(6)
DEFAUL...
^
ERROR: syntax error at or near "("
LINE 1: ...nga_servicestatus ADD COLUMN is_reachable smallint(6)
DEFAUL...
^
https://dev.icinga.org/issues/6193
updatedbversion
-----------------
(1 row)
$ psql -U icinga -d icinga <
module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.12.0.sql
ALTER TABLE
updatedbversion
-----------------
(1 row)
$ psql -U icinga -d icinga -c "SELECT * FROM icinga_dbversion;"
dbversion_id | name | version | create_time |
modify_time
--------------+----------+---------+-------------------------------+-------------------------------
1 | idoutils | 1.12.0 | 2013-11-15 12:50:27.416588+00 |
2014-05-13 18:01:46.812382+01
(1 row)
Do a rollback of that one.
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
--
DI (FH) Michael Friedrich
michael.friedr...@gmail.com || icinga open source monitoring
https://twitter.com/dnsmichi || lead core developer
dnsmi...@jabber.ccc.de || https://www.icinga.org/team
irc.freenode.net/icinga || dnsmichi
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
