-
Notifications
You must be signed in to change notification settings - Fork 264
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Bug]: restore account to a non-empty account hung in ci test. #16213
Labels
kind/bug
Something isn't working
phase/testing
severity/s0
Extreme impact: Cause the application to break down and seriously affect the use
Milestone
Comments
Ariznawlll
added
kind/bug
Something isn't working
needs-triage
severity/s0
Extreme impact: Cause the application to break down and seriously affect the use
labels
May 17, 2024
YANGGMM
changed the title
[Bug]: snapshot case hung in ci test.
[Bug]: restore account to a non-empty account hung in ci test.
May 17, 2024
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 |
定位到一个分区表的恢复 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) |
复现方法 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; |
This was referenced May 20, 2024
fixed |
观察一阵ci测试 |
观察了一阵ci,没再出现这个问题了,先关掉 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
kind/bug
Something isn't working
phase/testing
severity/s0
Extreme impact: Cause the application to break down and seriously affect the use
Is there an existing issue for the same bug?
Branch Name
Ariznawlll
Commit ID
snapshot_br_case_1.2
Other Environment Information
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
Additional information
No response
The text was updated successfully, but these errors were encountered: