Call to dbms_index_manager.refresh fails after upgrading to version 1.3.0
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 2.9k
- Forks
- 339
- Avg merge
- 1d 19h
- Merged PRs (30d)
- 52
Description
Environment
- Version: OceanBase seekdb
- Revision: 100000062026050810-3d42dddc51f7aab2a9742414f59f380b0e805b53
- Build Branch: HEAD
- Build Time: May 8 2026 10:27:55
- Build Flags: RelWithDebInfo
- Is this an RD-provided temporary version? No
Description
After upgrading from seekdb version 1.2.0 to version 1.3.0, executing the stored procedure call dbms_index_manager.refresh; results in an error.
Steps to Reproduce
- Using seekdb version 1.2.0, create a table and insert vector-related data.
- Upgrade to seekdb version 1.3.0.
- Execute
call dbms_index_manager.refresh;. - The command fails with an error.
Error Message:
ERROR 1049 (42000): Unknown database 'dbms_index_manager'
Log Information
Logs were filtered using the trace ID YB427F000001-0006519AED2D4752-0-0.
$grep "YB427F000001-0006519AED2D4752-0-0" seekdb.log*
seekdb.log:[2026-05-12 16:50:39.428521] WDIAG [SQL.RESV] get_database_id (ob_schema_checker.cpp:449) [986360][T1_L0_G0][T1][YB427F000001-0006519AED2D4752-0-0] [lt=14][errcode=-4002] invalid arguments(tenant_id=1, database_name=, ret=-4002)
seekdb.log:[2026-05-12 16:50:39.428544] WDIAG [SQL.RESV] resolve_sp_access_name (ob_resolver_utils.cpp:1701) [986360][T1_L0_G0][T1][YB427F000001-0006519AED2D4752-0-0] [lt=22][errcode=-4002] fail to exec schema_checker.get_database_id(tenant_id, current_database, database_id)(ret=-4002)
seekdb.log:[2026-05-12 16:50:39.428553] INFO [SHARE.SCHEMA] get_database_id (ob_schema_getter_guard.cpp:965) [986360][T1_L0_G0][T1][YB427F000001-0006519AED2D4752-0-0] [lt=6] database not exist(tenant_id=1, database_name=dbms_index_manager)
seekdb.log:[2026-05-12 16:50:39.428564] WDIAG [SQL.RESV] get_database_id (ob_schema_checker.cpp:470) [986360][T1_L0_G0][T1][YB427F000001-0006519AED2D4752-0-0] [lt=11][errcode=-5154] database is not exist(tenant_id=1, catalog_id=0, database_name=dbms_index_manager, ret=-5154)
seekdb.log:[2026-05-12 16:50:39.428572] WDIAG [SQL.RESV] get_package_id (ob_schema_checker.cpp:1250) [986360][T1_L0_G0][T1][YB427F000001-0006519AED2D4752-0-0] [lt=6][errcode=-5559] package is not exist(tenant_id=1, database_id=201001, package_name=dbms_index_manager, ret=-5559)
seekdb.log:[2026-05-12 16:50:39.428582] WDIAG [SQL.RESV] resolve_sp_access_name (ob_resolver_utils.cpp:1720) [986360][T1_L0_G0][T1][YB427F000001-0006519AED2D4752-0-0] [lt=9][errcode=-5154] get database id failed(package_or_db_name=dbms_index_manager, ret=-5154)
seekdb.log:[2026-05-12 16:50:39.428590] WDIAG resolve_sp_access_name (ob_resolver_utils.cpp:1721) [986360][T1_L0_G0][T1][YB427F000001-0006519AED2D4752-0-0] [lt=6][errcode=-5154] Unknown database 'dbms_index_manager'
... (additional log lines follow)
Additional Context
- Reproducibility: Consistently reproducible (必现).
- Test Changes: The issue appeared after replacing with the new version.
- Other Environment Anomalies: No.
- Log Directory:
/var/lib/oceanbase/log - Connection String:
mysql -h -P2881 -uroot - Environment Info: SSH access via
work@
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the resolver paths named in the logs, especially resolve_sp_access_name in ob_resolver_utils.cpp and get_database_id/get_package_id in ob_schema_checker.cpp. Reproduce the 1.2.0-to-1.3.0 upgrade and run the failing CALL, then trace why dbms_index_manager is resolved as a database. Done means the procedure executes successfully after upgrade with a regression test covering this scenario.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 45/100