Arch Linux

a_manthey

Member

Registered: 2017-08-21

Posts: 35

[SOLVED] Issues on nextcloud 22.0.0 and mariadb 10.6

after upgrade of nextcloud to 22.0.0-2 and mariadb to 10.6.3-1 i got an internal server error.
In nextcloud.log i found:

General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

Background and solution here

schard

Forum Moderator

From: Hannover

Registered: 2016-05-06

Posts: 2,111

Website

Re: [SOLVED] Issues on nextcloud 22.0.0 and mariadb 10.6

Since links rot, the workaround is to add

innodb_read_only_compressed=0

to the section [mariadb] in /etc/my.cnf.d/server.cnf.

---

Inofficial first vice president of the Rust Evangelism Strike Force

smirky

Member

From: Bulgaria

Registered: 2013-02-23

Posts: 277

Website

Re: [SOLVED] Issues on nextcloud 22.0.0 and mariadb 10.6

I have no luck with this workarond.
I've tried adding it to the [mariadb], [mariadb-10.6] and [mysqld] sections of /etc/my.cnf.d/server.cnf
After restarting the mariadb service, I still get an internal server error.
However, running:

SET GLOBAL innodb_read_only_compressed=OFF;

in the mariadb SQL client, it seems to make this problem go away until the next service restart.
I tried using "0", "off", "OFF" for values in the config. For some reason they all get accepted just fine, but they don't seem to do anything.
What I haven't tried yet is to add it as a command-line argument for starting the service: "--innodb_read_only_compressed=OFF".
The reason is because I haven't found a way to do it without modifying the package systemd service file, which will be overwritten upon the next update.

Last edited by smirky (2021-08-05 12:29:21)

---

Personal spot  ::  https://www.smirky.net/  ::  Try not to get lost!

hedonist

Member

Registered: 2021-09-18

Posts: 2

Re: [SOLVED] Issues on nextcloud 22.0.0 and mariadb 10.6

I put a separate file in /etc/mysql/conf.d/ , which is included in /etc/mysql/my.cnf with the following contents:

[mariadbd]
innodb_read_only_compressed=0

mind the "d" after mariadb in the brackets! This helped me to update nextcloud in docker container in a synology device.

hedonist

Member

Registered: 2021-09-18

Posts: 2

Re: [SOLVED] Issues on nextcloud 22.0.0 and mariadb 10.6

forgot to be e-mailed regarding this thread.

knille

Member

Registered: 2014-02-24

Posts: 28

Re: [SOLVED] Issues on nextcloud 22.0.0 and mariadb 10.6

unless stated in the arch wiki of mariadb (https://wiki.archlinux.org/title/MariaD … tion_files) on my system mariadb does not take config files from /etc/my.cnf.d/. thus the fix in /etc/my.cnf.d/server.cnf does not work (as it is documented in the wiki, https://wiki.archlinux.org/title/Nextcl … %3E=_10.6). so i had to put

innodb_read_only_compressed = 0

into the [mysqld] section of /etc/my.cnf for fixing the issue.

i don't know whether this is just an issue of my system or whether it is a package problem. you can check what config files your mariadbd takes by:

user@device:~$ mysqld --help --verbose | less
mysqld  Ver 10.6.4-MariaDB-log for Linux on x86_64 (Arch Linux)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Starts the MariaDB database server.

Usage: mysqld [OPTIONS]

Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf 

knille

Member

Registered: 2014-02-24

Posts: 28

Re: [SOLVED] Issues on nextcloud 22.0.0 and mariadb 10.6

i opened a new thread in the networking section about the mariadb config directory issue:

https://bbs.archlinux.org/viewtopic.php?id=269972