ERROR 9099 (HY000)

MySQL [oceanbase]> alter system restore omsmysql until time=‘2025-12-10 15.54.42’ with ‘pool_list=pool_oms_oracle’;
ERROR 9099 (HY000): omsmysql restore failed, ROOTSERVICE : OB_NOT_SUPPORTED(-4007) on “10.10.1.74:2882” with traceid YB420A0A014A-0006457A173F06D0-0-0
MySQL [oceanbase]>

[2025-12-11 19:36:41.984758] INFO [SHARE.SCHEMA] get_tenant_info (ob_schema_getter_guard.cpp:2130) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=20] tenant not exist(tenant_name=omsmysql)
[2025-12-11 19:36:41.984818] WDIAG [SHARE.SCHEMA] get_tenant_id (ob_schema_getter_guard.cpp:416) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=59][errcode=-5160] Can not find tenant(tenant_name=omsmysql)
[2025-12-11 19:36:41.984845] WDIAG [SQL.ENG] sync_wait_tenant_created_ (ob_restore_executor.cpp:135) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=21][errcode=-5160] failed to get tenant id from schema guard(ret=-5160, ret=“OB_ERR_INVALID_TENANT_NAME”, tenant_name=omsmysql)
[2025-12-11 19:36:41.994451] WDIAG [SQL.ENG] sync_wait_tenant_created_ (ob_restore_executor.cpp:168) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=21][errcode=-9099] restore tenant failed.(ret=-9099, tenant_name=omsmysql, comment=“ROOTSERVICE : OB_NOT_SUPPORTED(-4007) on “10.10.1.74:2882” with traceid YB420A0A014A-0006457A173F06AF-0-0”)
[2025-12-11 19:36:41.994505] WDIAG sync_wait_tenant_created_ (ob_restore_executor.cpp:169) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=48][errcode=-9099] omsmysql restore failed, ROOTSERVICE : OB_NOT_SUPPORTED(-4007) on “10.10.1.74:2882” with traceid YB420A0A014A-0006457A173F06AF-0-0
[2025-12-11 19:36:41.994515] WDIAG [SQL.ENG] sync_wait_tenant_created_ (ob_restore_executor.cpp:181) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=10][errcode=-9099] sync wait tenant created failed(ret=-9099, cost_ts=46, tenant_name=omsmysql)
[2025-12-11 19:36:41.994527] WDIAG [SQL.ENG] execute (ob_restore_executor.cpp:102) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=10][errcode=-9099] failed to sync wait tenant created(ret=-9099)
[2025-12-11 19:36:41.994622] INFO [SHARE] add_event (ob_event_history_table_operator.h:266) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=9] 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(1765453001994540), ‘sql’, ‘execute_cmd’, ‘cmd_type’, 208, ‘sql_text’, X’616C7465722073797374656D20726573746F7265206F6D736F7261636C6520756E74696C2074696D653D27323032352D31322D31302031352E35342E34322720776974682027706F6F6C5F6C6973743D706F6F6C5F6F6D735F6F7261636C6527’, ‘return_code’, -9099, ‘tenant_id’, 1, ‘’, ‘’, ‘10.10.1.74’, 2882))
[2025-12-11 19:36:41.994655] WDIAG [SQL] open_cmd (ob_result_set.cpp:103) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=30][errcode=-9099] execute cmd failed(ret=-9099)
[2025-12-11 19:36:41.994665] WDIAG [SQL] open (ob_result_set.cpp:164) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=10][errcode=-9099] execute plan failed(ret=-9099)
[2025-12-11 19:36:41.994676] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:144) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=8][errcode=-9099] close result set fail(cret=-9099)
[2025-12-11 19:36:41.994691] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:1066) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=8][errcode=-9099] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err
:-9099, err
:“OB_RESTORE_TENANT_FAILED”, retry_type:0, client_ret:-9099}, need_retry=false)
[2025-12-11 19:36:41.994711] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:150) [13936][T1_L0_G0][T1][YB420A0A014A-0006457A446F9307-0-0] [lt=19][errcode=-9099] result set open failed, check if need retry(ret=-9099, cli_ret=-9099, retry_ctrl
.need_retry()=0)
@

@助手

@论坛小助手

ERROR 9099 (HY000) 表示恢复操作失败。根据日志信息,错误的根本原因是 OB_NOT_SUPPORTED(-4007),表示尝试的操作未被支持。具体地,您试图恢复名为 omsmysql 的租户,但在尝试获取该租户信息时发现它不存在,进而导致恢复失败。可能是因为租户确实不存在,或者是您使用的 OceanBase 数据库版本不支持此类恢复操作。

解决方法:

  1. 检查 omsmysql 租户是否真的存在。可以使用 show databases; 或者 select * from oceanbase.__all_tenant; 来验证。
  2. 确认您的 OceanBase 版本是否支持此恢复操作。如果不确定,建议查阅官方文档或联系技术支持以获取帮助。

具体信息可参考以下文档:

  1. 9000 ~ 9499
  2. 按表恢复前准备
1 个赞

until time=‘2025-12-10 15.54.42’
这里你用冒号试试

向大佬们学习

学习一下

学习一下