team-container
team-container copied to clipboard
Nextcloud Error after upgrading / fresh install "General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE."
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?
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....