[Bug]: restore account to a non-empty account hung in ci test.

[Ariznawlll]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

Ariznawlll

Commit ID

snapshot_br_case_1.2

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job url:https://github.com/matrixorigin/matrixone/actions/runs/9123542825/job/25087552464?pr=16205

log： Compose-multi-cn-e2e-bvt-test-docker-log(PESSIMISTIC).zip Standalone-e2e-BVT-Test-on-Linux-x64(LAUNCH,Optimistic)-reports (1).zip

Expected Behavior

正常执行

Steps to Reproduce

trigger ci in pr

Additional information

No response

[YANGGMM]

restore to a empty account still hung

mysql> create account acc03 admin_name = 'test_account' identified by '111';
No connection. Trying to reconnect...
Connection id:    11920
Current database: *** NONE ***

Query OK, 0 rows affected (0.70 sec)

mysql> 
mysql> 
mysql> restore account acc01 from snapshot sp04 to account acc03;
^C^C -- query aborted
ERROR 1105 (HY000): context canceled

[YANGGMM]

定位到一个分区表的恢复

mysql> restore account acc01 database acc_test04 table index03 from snapshot sp04 to account acc03;
^C^C -- query aborted
ERROR 1105 (HY000): context canceled
mysql> ^C

恢复到本租户没有问题

mysql> restore account acc01 database acc_test04 table index03 from snapshot sp04;
Query OK, 0 rows affected (0.10 sec)

[YANGGMM]

复现方法

drop account if exists acc01;
create account acc01 admin_name = 'test_account' identified by '111';
drop account if exists acc02;
create account acc02 admin_name = 'test_account' identified by '111';



--mysql -h127.0.0.1 -uacc01:test_account -P6001 -p111
drop database if exists acc_test04;
create database acc_test04;
use acc_test04;
drop table if exists index03;
create table index03 (
                         emp_no      int             not null,
                         birth_date  date            not null,
                         first_name  varchar(14)     not null,
                         last_name   varchar(16)     not null,
                         gender      varchar(5)      not null,
                         hire_date   date            not null,
                         primary key (emp_no)
) partition by range columns (emp_no)(
    partition p01 values less than (100001),
    partition p02 values less than (200001),
    partition p03 values less than (300001),
    partition p04 values less than (400001)
);

insert into index03 values (9001,'1980-12-17', 'SMITH', 'CLERK', 'F', '2008-12-17'),
                           (9002,'1981-02-20', 'ALLEN', 'SALESMAN', 'F', '2008-02-20');

select count(*) from acc_test04.index03;
show create table acc_test04.index03;


-- sys
drop snapshot if exists sp04;
create snapshot sp04 for account acc01;


--mysql -h127.0.0.1 -uacc01:test_account -P6001 -p111
show create table acc_test04.index03;

--sys
restore account acc01 database acc_test04 table index03 from snapshot sp04;
restore account acc01 database acc_test04 table index03 from snapshot sp04 to account acc02;

[YANGGMM]

fixed

[Ariznawlll]

观察一阵ci测试

[Ariznawlll]

观察了一阵ci，没再出现这个问题了，先关掉