Otto, Sergei, I will just add my view on the subject here. Our documentation warns users that downgrades are not supported, even between minor versions, note the last paragraph. https://mariadb.com/kb/en/downgrading-between-major-versions-of-mariadb/ Rather than offer a half-truth, I would us just take a clear stance. We either fully support downgrading between minor versions officially (which has implications on how we approach bug fixes, especially on the storage side), or we don't even encourage it at all, stating "at your own risk", or do a full dump and restore as the only recovery method. Once this is decided, the rest of the decisions should be made based on that. If you want to take a middle of the road approach, where downgrades work, unless specifically mentioned in the release notes, that needs to be documented too *and we need to test that in our CI*, which as far as I know, we do not. So, Sergei, we should make a decision (or if one already has been made but I am not aware of it, put it in writing on the KB). Vicentiu On Thu, 27 Jul 2023, 16:25 Otto Kekäläinen via developers, < developers@lists.mariadb.org> 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.
So you are implying now that if a user runs say MariaDB 10.6.9 and upgraded to 10.6.12 and ran mariadb-upgrade, and after a week of running 10.6.12 and some serious bug has occurred and the user wants to swap back to MariaDB 10.6.9 by going back to old binaries but still keep running oldest data it is no longer possible in MariaDB?
If the above is no longer possible in MariaDB, how long do you recommend users to run a new binary but postpone running mariadb-upgrade after upgrading to a new minor version? A week? A month? _______________________________________________ developers mailing list -- developers@lists.mariadb.org To unsubscribe send an email to developers-leave@lists.mariadb.org