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