Op vrijdag 15 juli 2016 19:14:49 CEST schreef Michal Kubecek:
(TL;DR: first (longer) part is intended mainly for people using Firebird RDBMS on their Tumbleweed systems; the RFC part is in the last paragraph.)
Hello,
the upgrade of Firebird RDBMS packages to version 3.0 is already in openSUSE:Factory so that it should reach Tumbleweed if a few days.
Unfortunately, this major version upgrade is one of the cases illustrating a week point of rolling distributions: there are big steps that cannot be divided into many small ones. In particular, version 3.0 comes with new database file format (On Disk Structure, ODS) which is incompatible with ODS11 used by version 2.5. To make things worse, the incompatibility goes both ways, i.e. 3.0 binaries do not work with ODS11 databases. Therefore the only way to migrate a database is via a backup with version 2.5 gbak and restore with version 3.0 gbak.
To make life easier, I prepared a compat-firebird25 package providing version 2.5 libfbembed and minimal set of utilities (including gbak) linked against it; these are renamed so that the compat package does not collide with regular firebird 3.0 packages. There is also a script fb25-migratedb to migrate a 2.5 database to 3.0 format (via backup and restore) and README file explaining how to use it. The package is currently in my home:mkubecek:firebird30 OBS repository (published).
There are also other issues, e.g. the security database cannot be fully migrated in an automated way, these are described in upstream Release Notes and README.SUSE from firebird 3.0 package.
Note: if anyone prefers to stay with Firebird 2.5 on Tumbleweed, home:mkubecek:firebird25 OBS repository provides up-to-date packages (updated approximately once a month to current git snapshot). The home:mkubecek:firebird30 or server:database repositories provide Firebird 3.0 packages for older distributions (the former with (ir)regularly updated snapshots, the latter with what is in Factory or planned to be submitted to it).
Request for comments: would it make sense to have the compat-firebird25 package (a one-shot migration tool which also violates some of the packaging guidelines) in Tumbleweed (and one day in Leap 43)? Or is it fully sufficient (or preferrable) to provide it in an unofficial OBS repository?
Michal Kubeček
firebird-classic removed, firebird-server installed. Application using firebird starts normally, I don't see any issues right away -- Gertjan Lettink, a.k.a. Knurpht openSUSE Board Member openSUSE Forums Team -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org