Administration: Repair Table

Manually repair a corrupted table. Returns information about affected tables.

Input Parameter Description

NameTypeDescription
table_namesarray of stringsList of tables to query. An asterisk returns all tables.
table_typesmap of string to stringsID of the type per table.
optionsmap of string to strings

Optional parameters.

The default value is an empty map ( {} ).

Supported Parameters (keys)Parameter Description
repair_policy

Corrective action to take.

Supported ValuesDescription
delete_chunksDeletes any corrupted chunks.
shrink_columnsShrinks corrupted chunks to the shortest column.
replay_walManually invokes write-ahead log (WAL) replay on the table.
alter_tableReset columns modification after incomplete alter column.
verify_all

If false only table chunk data already known to be corrupted will be repaired. Otherwise the database will perform a full table scan to check for correctness.

The default value is false.

The supported values are:

  • true
  • false

Output Parameter Description

NameTypeDescription
table_namesarray of stringsList of repaired tables.
repair_statusarray of stringsList of repair status by table.
infomap of string to stringsAdditional information.