Nextcloud 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

You need to turn off innodb-read-only-compressed. I do this by starting my MySQL docker with

fix-nextcloud-4047-innodb-refuses-to-write-tables-with-row_formatcompressed-or-key_block_size.txt

📋 Copy to clipboard⇓ Download

–skip-innodb-read-only-compressed

Full docker-compose.yml nextcloud section:

fix-nextcloud-4047-innodb-refuses-to-write-tables-with-row_formatcompressed-or-key_block_size.yaml

📋 Copy to clipboard⇓ Download

nextcloud-db:

 image: mariadb

 command: –transaction-isolation=READ-COMMITTED –binlog-format=ROW –innodb-file-per-table=1 –skip-innodb-read-only-compressed

 restart: always

 volumes:

   – ./nextcloud-db:/var/lib/mysql

 environment:

   – MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}

   – MYSQL_PASSWORD=${MYSQL_PASSWORD}

Was this helpful?

0 / 0