[MDEV-21740] "XtraDB/InnoDB Recovery Modes" page claims DROP TABLE can be executed Created: 2020-02-15  Updated: 2020-02-19  Resolved: 2020-02-19

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Storage Engine - InnoDB
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Philippe Cloutier Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

https://mariadb.com/kb/en/innodb-recovery-modes/ contains the following paragraph:

To recover the tables, you can execute SELECTs to dump data, and DROP TABLE to remove corrupted tables.

The claim that DROP TABLE can be executed is only true for some modes. In reality, DROP TABLE (and any other manipulation) is disallowed starting from mode 4:

> DROP TABLE familipedia.page;
ERROR 1036 (HY000): Table 'page' is read only

Indeed, https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html explains that "An innodb_force_recovery setting of 4 or greater places InnoDB in read-only mode." (although that seems to be inaccurate for MySQL, as the same page claims mode 4 supports DROP TABLE).

Note that it would be appreciated to make it clear if purging MariaDB data is the only solution when MariaDB fails to start in mode 3.



 Comments   
Comment by Ian Gilfillan [ 2020-02-19 ]

Clarified earlier in the text that until MariaDB 10.2.7, mode 0 was the only mode permitting changes to the data. From MariaDB 10.2.7, write transactions are only permitted with mode 3 or less.

Generated at Thu Feb 08 09:09:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.