Mysql compression problems

Nextcloud version (eg, 20.0.5): 22.2.0.2
Operating system and version (eg, Ubuntu 20.04): manjaro 5.10.70-1
Apache or nginx version (eg, Apache 2.4.25): 2.4.49
PHP version (eg, 7.4): 8.0.11

The issue you are facing:
I cannot log in anymore, this is written to the nextcloud log

TypeError: array_map(): Argument #2 ($array) must be of type array, null given in /srv/http/nextcloud/apps/logreader/lib/Log/Formatter.php:65
Stack trace:
#0 /srv/http/nextcloud/apps/logreader/lib/Log/Formatter.php(65): array_map()
#1 /srv/http/nextcloud/apps/logreader/lib/Log/Formatter.php(48): OCA\LogReader\Log\Formatter->formatTraceLine()
#2 [internal function]: OCA\LogReader\Log\Formatter->OCA\LogReader\Log{closure}()
#3 /srv/http/nextcloud/apps/logreader/lib/Log/Formatter.php(49): array_map()
#4 /srv/http/nextcloud/apps/logreader/lib/Log/Formatter.php(35): OCA\LogReader\Log\Formatter->formatException()
#5 /srv/http/nextcloud/apps/logreader/lib/Command/Tail.php(76): OCA\LogReader\Log\Formatter->formatMessage()
#6 /srv/http/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OCA\LogReader\Command\Tail->execute()
#7 /srv/http/nextcloud/core/Command/Base.php(168): Symfony\Component\Console\Command\Command->run()
#8 /srv/http/nextcloud/3rdparty/symfony/console/Application.php(1009): OC\Core\Command\Base->run()
#9 /srv/http/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
#10 /srv/http/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
#11 /srv/http/nextcloud/lib/private/Console/Application.php(209): Symfony\Component\Console\Application->run()
#12 /srv/http/nextcloud/console.php(99): OC\Console\Application->run()
#13 /srv/http/nextcloud/occ(11): require_once(‘/srv/http/nextc…’)

I found online that this can be solved by adding the following to the mysql config:

innodb_read_only_compressed=OFF

Nextcloud runs great after that, but I cannot use the mysql-console anymore:

[MKTP nextcloud]# mysql -u root
mysql: unknown variable ‘innodb_read_only_compressed=OFF’

Is this the first time you’ve seen this error? (Y/N): Yes

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => # removed # ,
  'passwordsalt' => # removed # ,
  'secret' => # removed # ,
  'trusted_domains' =>
  array (
    0 => # removed, fqdn of my server # ,
    1 => # removed, local ip of my server # ,
  ),
  'datadirectory' => '/srv/http/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '22.2.0.2',
  'overwrite.cli.url' => # removed # ,
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => # removed # ,
  'installed' => true,
  'updater.secret' => # removed # ,
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'default_phone_region' => 'DE',
);