How i do the roolback to 1.11.3 from 1.12?
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
