-
Title
repair with exclude or include results in “error : repair does not support table without key after applying include/exclude option” -
Description
When running a repair with “exclude” or “include” option when the table has no key, the repair errors out:
sp_ctrl (alvsupu15:5438)> repair sha90.table2 exclude "char_col"
repairing 1 of 1 objects
repair started; job id 1
sp_ctrl (alvsupu15:5438)> job status
Job ID : 1
PID : 12988
Host : alvsupu15
Started : 11-JUL-17 19:21:44
Job Type : Repair
Status : Done - errors - 1 object completed
ID Tablename Status Time Total Rows %Ce
------ ------------------------------------ ---------- ---------- ---------- ---
1 "SHA90"."TABLE2" Error N/A N/A 0
The following error messages are observed in compare server log (*desvr* log):
desvr 2017-07-11 19:21:47.353305 12988 2 [1] Error: key columns are missing
desvr 2017-07-11 19:21:47.353311 12988 2 [1] Error: repair does not support table without key after applying include/exclude option
desvr 2017-07-11 19:21:47.353363 12988 2 [1] Error occurred.
desvr 2017-07-11 19:21:47.357235 12988 2 [1] DEBUG:schema=SHA90, table name=TABLE2, column_count=2 (de_table_list_table_info,L2336)
-
Cause
The exclude or include will only work if the table has a key. -
Resolution
Either add a unique or primary key and then run repair with “exclude” or “include” option, or avoid using this option.
This is also applicable to Compare / Repair.