Hi, Otto, On Jul 27, Otto Kekäläinen wrote:
Hi!
Automatically performing the upgrade in the server would pretty much mean that downgrade is officially impossible.
Historically the server mostly worked fine without mysql_upgrade, with few exceptions (like, when a bug in collations required indexes to be rebuilt).
Supporting "downgrades" shouldn't be tied to whether or not a DBA ran mariadb-upgrade, but whether they upgraded a *minor* version or a *major* version. For minor version downgrades should be possible even after running mariadb-upgrade.
No, this is logically impossible. If you upgrade from the version X to the version Y (and it doesn't matter whether it's a major or a minor upgrade) and mariadb-upgrade changes *something* (anything at all) then by definition the datadir will be not as the version X expects it and version X won't be able to read it anymore because, as an older version, it cannot possibly take into account changes made by the mariadb-upgrade of the newer version Y. So the question is, as Vicențiu put it - what is the official position of MariaDB regarding downgrades? Shall we support them or not? What would you prefer us to do? Why? Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org