Internal server error after database update

ℹ️ Support
1

So I had Nextcloud 20.0.4 running on a Centos7 server with MariaDB 5.5.68 and the update page tells me that I need to get MariaDB 10.2 or higher to update to Nextcloud 21.

I followed this page to upgrade the database
https://mariadb.com/docs/operations/upgrades/upgrade-community-server-cs10-6-centos7/
and that process went fine. Didn’t spot any errors.

But now when I try to login I just get “Internal Server Error”

I had a look at /var/www/html/nextcloud/data/nextcloud.log, it wasn’t easy to make sense of it. But I saw this error
General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

Could that be the culprit and what to do?

2

Since mariadb 10.6 Compressed rows are read-only by default.

you can change that setting in the mariadb configuration:

https://mariadb.com/docs/reference/mdb/system-variables/innodb_read_only_compressed/

innodb_read_only_compressed=false

3

Thank you. That was spot-on.