Answers.Body: <p>To solve this set innodb_read_only_compressed to OFF in my.cnf (or upgrade MariaDB to at least 10.6.6, which sets this value to OFF by default)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-06-13T13:35:02.670Z
Answers.LastActivityDate: 2022-06-13T13:35:02.670Z
Answers.UserDisplayName: Catorghans
Body: <p>Upgrade to 5.50.1 failed with</p>
  <p>[nativecode=4047 ** InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.]</p>
  <p>It has MariaDB 10.6.5, which sets the innodb_read_only_compressed by default to ON</p>
  <p><a href="https://mariadb.com/docs/reference/mdb/system-variables/innodb_read_only_compressed/" rel="nofollow noreferrer">https://mariadb.com/docs/reference/mdb/system-variables/innodb_read_only_compressed/</a></p>
  
Tags: <upgrade>
Title: Upgrade to 5.50.1 failed with "InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED"
ThreadText: # Upgrade to 5.50.1 failed with "InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED"
  
  (Asked by: username_0 on 2022-06-13)
  
  Upgrade to 5.50.1 failed with
  
  [nativecode=4047 \*\* InnoDB refuses to write tables with ROW\_FORMAT=COMPRESSED or KEY\_BLOCK\_SIZE.]
  
  It has MariaDB 10.6.5, which sets the innodb\_read\_only\_compressed by default to ON
  
  <https://mariadb.com/docs/reference/mdb/system-variables/innodb_read_only_compressed/>
  
  **Tags:** upgrade
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-06-13. Score: 1
  
  To solve this set innodb\_read\_only\_compressed to OFF in my.cnf (or upgrade MariaDB to at least 10.6.6, which sets this value to OFF by default)
  
  
  ---
  
  