[DOC] Missing allowed values explanation for innodb_corrupt_table_action variable

Bug #1025705 reported by Volans
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Hrvoje Matijakovic
5.5
Fix Released
Medium
Hrvoje Matijakovic

Bug Description

[In:Percona Server Documentation]

In the "Handle Corrupted Tables" ( http://www.percona.com/doc/percona-server/5.5/reliability/innodb_corrupt_table_action.html ) page the explanation of the different accepted values for the variable "innodb_corrupt_table_action" are missing.

Please provide a detailed explanation of different behaviour of InnoDB corrupted tables for the "assert" and "warn" values.

Tags: doc

Related branches

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

1. Basically assert is 0 (default behavior, to crash) and warn is 1 (warn and disable).

2. Actually there is another value - salvage

=====
const char *corrupt_table_action_names[]=
{
  "assert", /* 0 */
  "warn", /* 1 */
  "salvage", /* 2 */
  NullS
};
=====

From the code I have seen it looks like 'salvage' filters writes (in _fil_io) or to skip a corrupted record (in row_search_for_mysql).

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

IIRC "salvage" has some history behind it why it's not a documented option choice.

Revision history for this message
Volans (volans) wrote :

When the value is set to "warn" and the table is disabled and set as corrupted, the server will try to automatically recovery the table or the information is just logged into the error log file?

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

The latter, no recovery or writes will happen.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1263

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.