EOL packages will not be upgraded?

[pastic]

So I ran pkg upgrade in my web development jail some days ago and afterwards I was surprised to find that mariadb had stayed on version 10.4. Is that because 10.4 has been removed from the (the ? mark) repos and thus broken the upgrade path to 10.5? Or because pkg wont upgrade mariadb to a new major version unless I specifically tells it to?

root@webdev:~  # pkg update
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
root@webdev:~  # pkg upgrade
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
Checking for upgrades (0 candidates): 100%
Processing candidates (0 candidates): 100%
Checking integrity... done (0 conflicting)
Your packages are up to date.
root@webdev:~  # pkg search mariadb10
mariadb1011-client-10.11.4     Multithreaded SQL database (client)
mariadb1011-server-10.11.4     Multithreaded SQL database (server)
mariadb105-client-10.5.20      Multithreaded SQL database (client)
mariadb105-server-10.5.20      Multithreaded SQL database (server)
mariadb106-client-10.6.14      Multithreaded SQL database (client)
mariadb106-server-10.6.14      Multithreaded SQL database (server)
root@webdev:~  # pkg version
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
All repositories are up to date.
apache24-2.4.57_1                  =
...
mariadb104-client-10.4.26          ?
mariadb104-server-10.4.26          ?
...
mod_php81-8.1.20                   =
...

 

[SirDice]

Is that because 10.4 has been removed from the (the ? mark) repos and thus broken the upgrade path to 10.5?

MariaDB 10.4 will never get 'automagically' upgraded to MariaDB 10.5. You need to do this yourself. Are you building from ports/custom repository or are you using the FreeBSD packages? Note that the default 'mysql' is MySQL 8.0.

 

[pastic]

I am using the packages.
I removed 10.4 and installed 10.5 and then mariadb-upgrade was successful. I presume I should thus be fine.
To my knowledge MariaDB 10.6 is the "equivalent" to MySQL 8, I'll check if all looks fine on 10.5 before I continue up to 10.6.
Thanks!

 

[SirDice]

I removed 10.4 and installed 10.5 and then mariadb-upgrade was successful. I presume I should thus be fine.

Yep. That should be it.

To my knowledge MariaDB 10.6 is the "equivalent" to MySQL 8,

Yes, but that's irrelevant. If a port/package requires a mysql client it's going to default to MySQL 8.0, see Mk/bsd.default-versions.mk. databases/mysql80-client will conflict with databases/mariadb105-client (or any of the other versions). So you could end up removing MariaDB server when installing packages.

If you build from ports (or build your own repository), you can set your own default 'mysql' with DEFAULT_VERSIONS+= mysql=105m (to set the default to MariaDB 10.5).

 

[pastic]

So you could end up removing MariaDB server when installing packages.

I did not know that. Thanks for the heads-up.
My jail is a pretty simple FAMP jail that I mainly upgrade to keep current (hardly ever any new packages). Hopefully I will never run into such removals. If I do, my snapshots will come to the rescue while I figure out a strategy.