【 使用环境 】准生产环境
【 OB or 其他组件 】
【 使用版本 】4.3.5.3
【问题描述】modify 改类型、drop index、drop column都报错“ERROR 1235 (0A000): Not supported feature or function”（create/drop table、add column、modify改大精度没问题）
【复现路径】建截图
【附件及日志】
obclient(admintest@mysql5)[test]> ALTER TABLE app_info_test_modify MODIFY COLUMN owner_id VARCHAR(100) NOT NULL COMMENT ‘负责人ID’;
ERROR 1235 (0A000): Not supported feature or function
obclient(root@mysql5)[test]> select last_trace_id() from dual;
±----------------------------------+
| last_trace_id() |
±----------------------------------+
| YB420ACE4004-00063EB00C9E64A4-0-0 |
±----------------------------------+
1 row in set (0.001 sec)
grep “YB420ACE4004-00063EB00C9E64A4-0-0” /data2/oceanbase/home/log/observer.log*
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:16.230914] INFO [SQL.RESV] calc_ddl_parallelism (ob_ddl_resolver.cpp:13683) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=15] calc ddl parallelism(parallelism=1)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:16.247058] INFO [STORAGE.TRANS] notify_data_source_ (ob_trans_part_ctx.cpp:7652) [569626][T1016_L0_G20][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=1] notify MDS(ret=0, trans_id_={txid:325377586}, ls_id_={id:1}, notify_type=“REGISTER_SUCC”, log_ts={val:18446744073709551615, v:3}, notify_array.count()=1, notify_array=[{register_no_:0, seq_no_:{branch:0, seq:15383}, has_submitted_:false, has_synced_:false, type:“TABLE_LOCK”, data_.length():72, has_deserialized_buffer_ctx_:false}], total_time=0)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:16.249279] INFO [STORAGE.TRANS] notify_data_source_ (ob_trans_part_ctx.cpp:7652) [569626][T1016_L0_G20][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=48] notify MDS(ret=0, trans_id_={txid:325377586}, ls_id_={id:1001}, notify_type=“REGISTER_SUCC”, log_ts={val:18446744073709551615, v:3}, notify_array.count()=1, notify_array=[{register_no_:0, seq_no_:{branch:0, seq:17512}, has_submitted_:false, has_synced_:false, type:“TABLE_LOCK”, data_.length():79, has_deserialized_buffer_ctx_:false}], total_time=0)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.678938] WDIAG [RPC] send (ob_poc_rpc_proxy.h:176) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=19][errcode=-4007] execute rpc fail(addr=“10.206.64.4:2882”, pcode=517, ret=-4007, timeout=999999724)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.678967] WDIAG log_user_error_and_warn (ob_poc_rpc_proxy.cpp:247) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=26][errcode=-4007]
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.678982] WDIAG [SQL.ENG] alter_table_rpc_v2 (ob_table_executor.cpp:875) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=9][errcode=-4007] rpc proxy alter table failed(ret=-4007, ret=“OB_NOT_SUPPORTED”, dst=“10.206.64.4:2882”, alter_table_arg={session_id:778630171833434451, alter_part_type:1000, index_arg_list:[], foreign_key_arg_list:[], alter_table_schema:{alter_type:“OB_INVALID_DDL_OP”, origin_table_name:“app_info_test_modify”, new_database_name:“test”, origin_database_name:“test”, split_partition_name:"", split_high_bound_val:, split_list_row_values:, new_part_name:"", alter_table_schema:{simple_table_schema:{tenant_id:1016, database_id:18446744073709551615, tablegroup_id:18446744073709551615, table_id:589022, association_table_id:18446744073709551615, in_offline_ddl_white_list:false, table_name:“app_info_test_modify”, session_id:0, index_type:0, table_type:3, table_mode:{table_mode_flag:0, pk_mode:0, table_state_flag:0, view_created_method_flag:0, pk_exists:0, auto_increment_mode:0, rowid_mode:0, view_column_filled_flag:0, mv_container_table_flag:0, mv_available_flag:0, table_referenced_by_mv_flag:0, mv_enable_query_rewrite_flag:0, mv_on_query_computation_flag:0, ddl_table_ignore_sync_cdc_flag:0, table_organization_mode:0}, tablespace_id:18446744073709551615, data_table_id:0, name_casemode:-1, schema_version:0, part_level:0, part_option:{part_func_type:0, part_func_expr:"", part_num:1, auto_part:false, auto_part_size:0}, sub_part_option:{part_func_type:0, part_func_expr:"", part_num:0, auto_part:false, auto_part_size:0}, partition_num:0, def_subpartition_num:0, partition_array:null, partition_array_capacity:0, def_subpartition_array:null, hidden_partition_array:null, index_status:1, duplicate_scope:0, encryption:"", encrypt_key:"", master_key_id:18446744073709551615, sub_part_template_flags:0, get_tablet_id():{id:0}, max_dependency_version:-1, object_status:1, is_force_view:false, truncate_version:-1, duplicate_read_consistency:0, storage_cache_policy_type:4, with_dynamic_partition_policy:false}, max_used_column_id:0, sess_active_time:0, rowkey_column_num:0, index_column_num:0, rowkey_split_pos:0, block_size:16384, is_use_bloomfilter:false, progressive_merge_num:0, tablet_size:-1, pctfree:10, load_type:0, index_using_type:0, def_type:1, charset_type:0, collation_type:0, index_status:1, partition_status:0, code_version:1, comment:"", pk_comment:"", create_host:"", tablegroup_name:"", compressor_type:1, row_store_type:4, store_format:0, expire_info:"", view_schema:{view_definition:"", check_option:“none”, is_updatable:“false”, is_materialized:“false”, character_set_client:0, collation_connection:“invalid_type”}, autoinc_column_id:0, auto_increment:1, read_only:false, simple_index_infos:[], base_table_ids:[], rowkey_info:{columns:null, capacity:0}, partition_key_info:{columns:null, capacity:0}, column_cnt:1, table_dop:1, constraints:null, column_array:[{alter_type:“OB_DDL_MODIFY_COLUMN”, is_drop_default:false, is_set_nullable:false, is_set_default:false, origin_column_name:“owner_id”, next_column_name:"", prev_column_name:"", is_unique_key:false, column_group_name:"", is_set_comment:false, alter_column_schema:{tenant_id:1016, table_id:589022, column_id:17, schema_version:0, rowkey_position:0, index_position:0, order_in_rowkey:0, tbl_part_key_pos:0, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, accuracy:{length:100, precision:-1, scale:-1}, is_nullable:false, is_zero_fill:false, is_autoincrement:false, is_hidden:false, charset_type:2, on_update_current_timestamp:false, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, column_name:“owner_id”, comment:“负责人ID”, column_flags:0, extended_type_info:[cnt:0], prev_column_id:18446744073709551615, next_column_id:18446744073709551615, sequence_id:9223372036854775807, encoding_type:9223372036854775807, srs_id:18446744073709551584, udt_set_id:0, sub_type:0, skip_index_attr:{pack:0, min_max:0, sum:0}, lob_chunk_size:262144, column_ref_idxs:NULL, local_session_vars_:{}}}], aux_vp_tid_array:[], index_info:{columns:null, capacity:0}, define_user_id:18446744073709551615, aux_lob_meta_tid:18446744073709551615, aux_lob_piece_tid:18446744073709551615, name_generated_type:0, lob_inrow_threshold:4096, is_column_store_supported:false, max_used_column_group_id:1000, column_group_cnt:0, column_group_array:null, mlog_tid:18446744073709551615, auto_increment_cache_size:0, local_session_vars:{}, index_params:"", exec_env:"", storage_cache_policy:"", merge_engine_type:0, semistruct_encoding_type:{mode:0, reserved:0}, dynamic_partition_policy:""}}, alter_constraint_type:1000, nls_formats:[“DD-MON-RR”, “DD-MON-RR HH.MI.SSXFF AM”, “DD-MON-RR HH.MI.SSXFF AM TZR”], ddl_task_type:0, compat_mode:0, is_alter_columns:true, is_alter_indexs:false, is_alter_options:false, is_alter_partitions:false, is_inner:false, is_update_global_indexes:false, is_convert_to_character:false, skip_sys_table_check:false, need_rebuild_trigger:false, foreign_key_checks:false, is_add_to_scheduler:false, table_id:-1, hidden_table_id:-1, inner_sql_exec_addr:“0.0.0.0:0”, local_session_var:{type:16, val:{“VARCHAR”:"+08:00", collation:“utf8mb4_general_ci”, coercibility:“SYSCONST”}, type:15, val:{“BIGINT UNSIGNED”:1075838976}, type:10064, val:{“VARCHAR”:“DD-MON-RR”, collation:“utf8mb4_general_ci”, coercibility:“SYSCONST”}, type:10065, val:{“VARCHAR”:“DD-MON-RR HH.MI.SSXFF AM”, collation:“utf8mb4_general_ci”, coercibility:“SYSCONST”}, type:10066, val:{“VARCHAR”:“DD-MON-RR HH.MI.SSXFF AM TZR”, collation:“utf8mb4_general_ci”, coercibility:“SYSCONST”}, type:9, val:{“BIGINT”:45}, type:14, val:{“BIGINT”:16777216}}, mview_refresh_info:{mview_table_id:18446744073709551615, last_refresh_scn:{val:18446744073709551615, v:3}, refresh_scn:{val:18446744073709551615, v:3}, start_time:-1, is_mview_complete_refresh:false, mview_target_data_sync_scn:{val:18446744073709551615, v:3}, select_sql:""}, alter_algorithm:2, alter_auto_partition_attr:false, rebuild_index_arg_list:[], client_session_id:1865441986, client_session_create_ts:1757380703932103, lock_priority:20, is_direct_load_partition:false, is_alter_column_group_delayed:false, is_alter_mview_attributes:false, alter_mview_arg:{exec_env:"", is_alter_on_query_computation:false, enable_on_query_computation:false, is_alter_query_rewrite:false, enable_query_rewrite:false, is_alter_refresh_method:false, refresh_method:4, is_alter_refresh_dop:false, refresh_dop:0, is_alter_refresh_start:false, start_time:{“NULL”:“NULL”}, is_alter_refresh_next:false, next_time_expr:"", is_alter_nested_refresh_mode:false, nested_refresh_mode:3}, is_alter_mlog_attributes:false, alter_mlog_arg:{exec_env:"", is_alter_table_dop:false, table_dop:0, is_alter_purge_start:false, start_time:{“NULL”:“NULL”}, is_alter_purge_next:false, next_time_expr:"", is_alter_lob_threshold:false, lob_threshold:0}, part_storage_cache_policy:"", data_version:0})
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679204] WDIAG [SQL.ENG] execute (ob_table_executor.cpp:1192) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=213][errcode=-4007] Failed to alter table rpc v2(ret=-4007)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679242] INFO [SHARE] add_event (ob_event_history_table_operator.h:266) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=7] event table add task(ret=0, event_table_name="__all_server_event_history", sql=INSERT INTO __all_server_event_history (gmt_create, module, event, name1, value1, name2, value2, name3, value3, name4, value4, name5, value5, name6, value6, extra_info, svr_ip, svr_port) VALUES (usec_to_time(1757383097679213), ‘ddl’, ‘alter table execute finish’, ‘tenant_id’, 1016, ‘ret’, -4007, ‘trace_id’, ‘YB420ACE4004-00063EB00C9E64A4-0-0’, ‘task_id’, 0, ‘table_info’, ‘table_id:-1, hidden_table_id:-1’, ‘schema_version’, -1, ‘“0.0.0.0:0”’, ‘10.206.64.4’, 2882))
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679250] INFO [SQL.ENG] execute (ob_table_executor.cpp:1280) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=7] REACH SYSLOG RATE LIMIT [bandwidth]
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679296] INFO [SHARE] add_event (ob_event_history_table_operator.h:266) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=11] event table add task(ret=0, event_table_name="_all_server_event_history", sql=INSERT INTO all_server_event_history (gmt_create, module, event, name1, value1, name2, value2, name3, value3, name4, value4, value5, value6, svr_ip, svr_port) VALUES (usec_to_time(1757383097679263), ‘sql’, ‘execute_cmd’, ‘cmd_type’, 22, ‘sql_text’, X’414C544552205441424C45206170705F696E666F5F746573745F6D6F64696679204D4F4449465920434F4C554D4E206F776E65725F696420564152434841522831303029204E4F54204E554C4C20434F4D4D454E542027E8B49FE8B4A3E4BABA494427’, ‘return_code’, -4007, ‘tenant_id’, 1016, ‘’, ‘’, ‘10.206.64.4’, 2882))
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679305] WDIAG [SQL] open_cmd (ob_result_set.cpp:86) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=6][errcode=-4007] execute cmd failed(ret=-4007)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679312] WDIAG [SQL] open (ob_result_set.cpp:152) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=6][errcode=-4007] execute plan failed(ret=-4007)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679320] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:139) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=5][errcode=-4007] close result set fail(cret=-4007)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679337] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:1079) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=15][errcode=-4007] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err:-4007, err:“OB_NOT_SUPPORTED”, retry_type:0, client_ret:-4007, is_interrupted_by_outer_query:false}, need_retry=false)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679349] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:145) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=11][errcode=-4007] result set open failed, check if need retry(ret=-4007, cli_ret=-4007, retry_ctrl.need_retry()=0)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679383] WDIAG [SERVER] do_process (obmp_query.cpp:1151) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=1][errcode=-4007] execute query fail(ret=-4007, timeout_timestamp=1757384096230690)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679565] WDIAG [SERVER.OMT] process_one (ob_worker_processor.cpp:82) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=7][errcode=-4007] process request fail(ret=-4007)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:17.679572] WDIAG [SERVER.OMT] process (ob_worker_processor.cpp:163) [3388122][T1016_L0_G0][T1016][YB420ACE4004-00063EB00C9E64A4-0-0] [lt=6][errcode=-4007] process request fail(ret=-4007)
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:19.236057] INFO [MDS] try_gc_mds_table (mds_table_handler.cpp:139) [2643912][T1016_Occam][T1016][YB420ACE4004-00063E96176A1A5E-0-0] [lt=0] [GC]gc mds_table(ret=0, ret=“OB_SUCCESS”, valid_node_cnt=0, rec_scn={val:4611686018427387903, v:0}, is_flushing=false, handle_ref_cnt=1, *this={mds_table_handle:{p_mds_table_base:{ctrl_ptr:{ref:1, p_data_block:{this:0x7fe7ee2f4170, ls_id:{id:1001}, tablet_id:{id:215350}, flushing_scn:{val:18446744073709551615, v:3}, rec_scn:{val:4611686018427387903, v:0}, max_aborted_scn:{val:0, v:0}, last_inner_recycled_scn:{val:1, v:0}, total_node_cnt:0, construct_sequence:7103503, debug_info:{do_init_tablet_pointer:0x7fe6b6ddc168, do_remove_tablet_pointer:null, init_ts:“2025-09-09 09:58:17.668142”, last_remove_ts:“1970-01-01 08:00:00.0”, remove_ts:“1970-01-01 08:00:00.0”, last_flush_ts:“1970-01-01 08:00:00.0”, switch_to_empty_shell_ts:“1970-01-01 08:00:00.0”, init_trace_id:YB420ACE4004-00063EB00C9E64A4-0-0, remove_trace_id:Y0-0000000000000000-0-0}}}}, mds_table_id:1}})
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:19.236127] INFO [MDS] unregister_from_mds_table_mgr (mds_table_mgr.cpp:114) [2643912][T1016_Occam][T1016][YB420ACE4004-00063E96176A1A5E-0-0] [lt=66] unregister success(ret=0, ret=“OB_SUCCESS”, p_mds_table={this:0x7fe7ee2f4170, ls_id:{id:1001}, tablet_id:{id:215350}, flushing_scn:{val:18446744073709551615, v:3}, rec_scn:{val:4611686018427387903, v:0}, max_aborted_scn:{val:0, v:0}, last_inner_recycled_scn:{val:1, v:0}, total_node_cnt:0, construct_sequence:7103503, debug_info:{do_init_tablet_pointer:0x7fe6b6ddc168, do_remove_tablet_pointer:null, init_ts:“2025-09-09 09:58:17.668142”, last_remove_ts:“1970-01-01 08:00:00.0”, remove_ts:“1970-01-01 08:00:00.0”, last_flush_ts:“1970-01-01 08:00:00.0”, switch_to_empty_shell_ts:“1970-01-01 08:00:00.0”, init_trace_id:YB420ACE4004-00063EB00C9E64A4-0-0, remove_trace_id:Y0-0000000000000000-0-0}})
/data2/oceanbase/home/log/observer.log.20250909095848643:[2025-09-09 09:58:19.236163] INFO [MDS.EVENT]unregister_from_mds_table_mgr (mds_table_base.cpp:141) [2643912][T1016_Occam][T1016][YB420ACE4004-00063E96176A1A5E-0-0] [lt=34] DESTRUCTED(key={tenant_id:1016, ls_id:{id:1001}, tablet_id:{id:215350}}, event={alloc:null, timestamp:“2025-09-09 09:58:19.236162”, obj_ptr:null, event:“DESTRUCTED”, info_str:"", unit_id:255, key_str:"", writer_type:0, writer_id:0, seq_no:0, redo_scn:{val:18446744073709551615, v:3}, end_scn:{val:18446744073709551615, v:3}, trans_version:{val:18446744073709551615, v:3}, node_type:0, state:5}, mds_table={this:0x7fe7ee2f4170, ls_id:{id:1001}, tablet_id:{id:215350}, flushing_scn:{val:18446744073709551615, v:3}, rec_scn:{val:4611686018427387903, v:0}, max_aborted_scn:{val:0, v:0}, last_inner_recycled_scn:{val:1, v:0}, total_node_cnt:0, construct_sequence:7103503, debug_info:{do_init_tablet_pointer:0x7fe6b6ddc168, do_remove_tablet_pointer:null, init_ts:“2025-09-09 09:58:17.668142”, last_remove_ts:“1970-01-01 08:00:00.0”, remove_ts:“1970-01-01 08:00:00.0”, last_flush_ts:“1970-01-01 08:00:00.0”, switch_to_empty_shell_ts:“1970-01-01 08:00:00.0”, init_trace_id:YB420ACE4004-00063EB00C9E64A4-0-0, remove_trace_id:Y0-0000000000000000-0-0}})
