Skip to content

[Bug]:restore BVT case failed by Duplicate entry #23792

@gouhongshen

Description

@gouhongshen

Is there an existing issue for the same bug?

  • I have checked the existing issues.

Branch Name

main

Commit ID

latest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job: https://github.com/matrixorigin/matrixone/actions/runs/22566620533/job/65364066545?pr=23789

2026-03-02 08:17:36 ERROR Executor:385 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/cluster_level_snapshot_restore_cluster.sql][row:422][restore cluster{snapshot="cluster_level_snapshot"};] was executed failed, con[id=0, user=dump, ***
2026-03-02 08:17:36 ERROR Executor:389 - [EXPECT RESULT]:
null
2026-03-02 08:17:36 ERROR Executor:390 - [ACTUAL RESULT]:
Duplicate entry '(164,sub01)' for key '__mo_index_idx_col'
2026-03-02 08:17:36 ERROR RSRow:46 - The column count does not equal with each other,one is [2],but the other is [3]
2026-03-02 08:17:36 ERROR Executor:385 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/cluster_level_snapshot_restore_cluster.sql][row:425][select * from departments;] was executed failed, con[id=0, user=dump, ***
2026-03-02 08:17:36 ERROR Executor:389 - [EXPECT RESULT]:
➤ department_id[12,0,0]  ¦  department_name[12,0,0]  𝄀
1  ¦  HR  𝄀
2  ¦  Engineering
2026-03-02 08:17:36 ERROR Executor:390 - [ACTUAL RESULT]:
➤ department_id[4,32,0]  ¦  newcolumn[4,32,0]  ¦  department_name[12,-1,0]  𝄀
1  ¦  null  ¦  HR  𝄀
2  ¦  null  ¦  Engineering
2026-03-02 08:17:36 ERROR RSRow:58 - The value of [row:0,column:1] does not equal with each other,one is [CREATE TABLE `departments` (\n  `department_id` int NOT NULL AUTO_INCREMENT,\n  `department_name` varchar(100) DEFAULT NULL,\n  PRIMARY KEY (`department_id`)\n)],but the other is [CREATE TABLE `departments` (\n  `department_id` int NOT NULL AUTO_INCREMENT,\n  `newcolumn` int DEFAULT NULL,\n  `department_name` varchar(100) DEFAULT NULL,\n  PRIMARY KEY (`department_id`)\n)]
2026-03-02 08:17:36 ERROR Executor:385 - 

Expected Behavior

No response

Steps to Reproduce

see above

Additional information

No response

Metadata

Metadata

Assignees

Labels

kind/bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions