Nextcloud Error after upgrading / fresh install "General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE."

[eitschalot]

HI, after setting up nextcloud on the last release I get following error:
"Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE."

In the nextcloud forum I found even the solution: https://help.nextcloud.com/t/update-to-next-cloud-21-0-2-has-get-an-error/117028

But I am still puzzled how to configure the yaml file for the database to put in this fix?
Can someone please help?

[eitschalot]

Got an update:
A very very ugly but working solution is to fix the mariadb version to release 10.5. Apparently the latest version of mariadb is not supported and I did not find a way to pass the env value as described in the post on the nextcloud forum.

So what you need to do is to change file "team-container/team-nextcloud/templates/deploy_database.yaml" and change the entry "image: mariadb" to "image:mariadb:10.5"

After that change the database boots correctly and nextcloud will work again.

Still I hope that nextcloud will again support the latest version of mariadb properly....