[DRBD-user] Linstor v0.6.2

[Robert Altnoeder]

On 09/03/2018 04:51 PM, Roberto Resoli wrote:
> Il 03/09/2018 16:32, Yannis Milios ha scritto:
>> Just tried 0.6.2-1 on PVE and it seems to fail with a different error
>> this time (Migration Failed!)....
>>
>> https://privatebin.net/?832d42e56c2734a9#0ZBY7DAQhLAbLSmzc62rokuKSVOkduBAO28lt0UIqrA=
>>
>
> Yes, moreover, downgrading to 0.5.0 is quite annoying, and a backup
> copy of linstor db is required.

The reason for that is that only few databases can run DDL statements
(statements that change the database's structure) in a transaction, so
that they can roll back a partly failed migration.

The databases where this is supported are:
- PostgreSQL
- IBM DB2

The integrated H2 database as well as MySQL, MariaDB, Oracle RDBMS,
Microsoft SQL Server and most others require either manual intervention
or a backup to fully roll back to a previous database structure after a
partially applied migration.

We will consider having LINSTOR backup the database automatically before
trying a migration, so that going back to an older version would be easier.

br,
Robert