Re: Disaster after do-release-upgrade to Ubuntu Server 22.04.1

[John Elsworth]

I did the following -

find / -name error.log

It found two: one for apache and one for mysql. The mysql error.log was empty.

The FROZEN message, if I understood it correctly, gave two impossible options: 1) either change the existing Nextcloud database, or 2) install an older version of mysql.

1) Without a functioning mysql how could I use mysqldump to restore nextcloud.sql ? (I had created nextcloud.sql with mysqldump before upgrading Nextcloud, and before the Ubuntu release upgrade).
2) Attempting to change the faulty mysql installation was blocked by its post install script.

Information on recovering from this situation is sparse, but I did find a way:

Stop the package manager from interfering -

cd/var/lib/mysql/info/
rm -rf ./mysql-*
dpkg —remove —force-remove-reinstreq mysql-server-8.0

This enabled to successfully install mariadb-server which removed whatever remained of mysql-server-8.0 . The existing database was accepted by mariadb.

So delighted to have a working Nextcloud instance again.

Perhaps this information helps someone.