[Bug]: Unknown database test01

daviszhen commented 1 week ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Branch Name

main

Commit ID

latest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

2024-11-07 04:42:08 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/cluster_level_snapshot_restore_view_to_nonsys.sql][row:397][restore account acc01 from snapshot sp06;] was executed failed, con[id=0, user=dump, ***
2024-11-07 04:42:08 ERROR Executor:271 - [EXPECT RESULT]:
null
2024-11-07 04:42:08 ERROR Executor:272 - [ACTUAL RESULT]:
Unknown database test01
2024-11-07 04:42:08 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-07 04:42:08 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/cluster_level_snapshot_restore_view_to_nonsys.sql][row:400][select * from test01.EmployeeSalaryRanking;] was executed failed, con[id=1, user=acc01:test_account, ***
2024-11-07 04:42:08 ERROR Executor:271 - [EXPECT RESULT]:
employeeid    employeename    salary    salaryrank
3    Charlie    90000.00    1
2    Bob    80000.00    2
5    Eva    75000.00    3
1    Alice    70000.00    4
4    David    65000.00    5
2024-11-07 04:42:08 ERROR Executor:272 - [ACTUAL RESULT]:
Unknown database test01
2024-11-07 04:42:08 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/cluster_level_snapshot_restore_view_to_nonsys.sql][row:401][drop database test01;] was executed failed, con[id=1, user=acc01:test_account, ***
2024-11-07 04:42:08 ERROR Executor:271 - [EXPECT RESULT]:
null
2024-11-07 04:42:08 ERROR Executor:272 - [ACTUAL RESULT]:
Can't drop database 'test01'; database doesn't exist
2024-11-07 04:42:08 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-07 04:42:08 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.
2024-11-07 04:42:08 INFO  Executor:692 - select mo_ctl('cn','synccommit','') with sys user[dump] successfully.

Expected Behavior

no failure

Steps to Reproduce

https://github.com/matrixorigin/matrixone/actions/runs/11716507722/job/32634687612?pr=19819

Additional information

No response

YANGGMM commented 1 week ago

frontend/snapshot.go:667","msg":"[019304ee-052a-7d67-814e-bb995f30fd9f_sp06_mock] start to restore db: test01, restore timestamp: 1730954528007055169" frontend/snapshot.go:1380","msg":"[019304ee-052a-7d67-814e-bb995f30fd9f_sp06_mock] get create database test01 sql: select datname, dat_createsql from mo_catalog.mo_database {snapshot = '019304ee-052a-7d67-814e-bb995f30fd9f_sp06_mock'} where datname = 'test01' and account_id = 10110"

"frontend/snapshot.go:1388","msg":"error: Unknown database test01