matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

Published 20 hours ago • verified publisher icon matrixorigin

[Bug]: restore account report internal error: can not find table by id

Open YANGGMM opened this issue 1 year ago • 3 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Branch Name

main

Commit ID

newest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image

Expected Behavior

No response

Steps to Reproduce

link:https://github.com/matrixorigin/matrixone/actions/runs/9126291842/job/25094260457?pr=16027

Additional information

No response

YANGGMM avatar May 17 '24 11:05 YANGGMM

Standalone-Multi-CN-e2e-BVT-Test-on-Linux-x64(LAUNCH,PROXY)-reports_副本.zip

YANGGMM avatar May 17 '24 11:05 YANGGMM

2024-05-17 10:02:58 ERROR Executor:269 - [EXPECT RESULT]: null 2024-05-17 10:02:58 ERROR Executor:270 - [ACTUAL RESULT]: internal error: can not find table by id 284501: accountId: 10065

YANGGMM avatar May 17 '24 11:05 YANGGMM

repro: https://github.com/matrixorigin/matrixone/actions/runs/9128002087/job/25100120541

sukki37 avatar May 17 '24 15:05 sukki37 

2024/05/17 10:02:58.669043 +0000 INFO cn-service.frontend frontend/snapshot.go:362 [sp07] start to restore account: 10065 {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "session_info": "snapshot"}
2024/05/17 10:02:58.670593 +0000 INFO compile/sql_executor.go:355 sql_executor exec {"sql": "select count(*) > 0 from `mo_catalog`.`mo_foreign_keys` where refer_db_name = 'acc_test02' and db_name != 'acc_test02';", "txn-id": "018f86013aeb7448aaef8da2833df6ee", "duration": "308.627µs", "AffectedRows": 0}
2024/05/17 10:02:58.670738 +0000 ERROR disttae/engine.go:525 error: internal error: can not find table by id 284501: accountId: 10065  {"span": {"trace_id": "01ae614d-afbd-c048-cf8b-0b29403a94db", "span_id": "4ece47e980f59c20"}}
2024/05/17 10:02:58.670773 +0000 ERROR cn-service.frontend frontend/txn.go:63 internal error: can not find table by id 284501: accountId: 10065  {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "session_info": "", "session_id": "018f8601-3aea-746d-b65c-c1d6e18f371f"}
2024/05/17 10:02:58.670803 +0000 ERROR cn-service.frontend frontend/util.go:504 query trace status {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "connection_id": 0, "statement": "restore account acc01 from snapshot sp07 to account acc01", "status": "fail", "error": "internal error: can not find table by id 284501: accountId: 10065 ", "span": {"trace_id": "01ae614d-afbd-c048-cf8b-0b29403a94db", "span_id": "4ece47e980f59c20"}, "session_info": "", "session_id": "018f8601-3aea-746d-b65c-c1d6e18f371f"}
2024/05/17 10:02:58.671036 +0000 ERROR cn-service.frontend frontend/txn.go:63 internal error: can not find table by id 284501: accountId: 10065  {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "session_info": "connectionId 3|127.0.0.1:36820|{account sys:dump:moadmin -- 0:1:0}|goRoutineId 304|018f85f7-3477-78f7-8b3d-f40c2dc5371a", "session_id": "018f85f7-3477-78f7-8b3d-f40c2dc5371a", "statement_id": "018f8601-3aea-7404-bd5e-1389542bbd55", "txn_id": "018f86013aea7438b61ae297a21ba2a2/Active/S:1715940178663917597-1"}
2024/05/17 10:02:58.671096 +0000 ERROR cn-service.frontend frontend/util.go:504 query trace status {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "connection_id": 3, "statement": "restore account acc01 from snapshot sp07 to account acc01", "status": "fail", "error": "internal error: can not find table by id 284501: accountId: 10065 ", "span": {"trace_id": "01ae614d-afbd-c048-cf8b-0b29403a94db", "span_id": "4ece47e980f59c20"}, "session_info": "connectionId 3|127.0.0.1:36820|{account sys:dump:moadmin -- 0:1:0}|goRoutineId 304|018f85f7-3477-78f7-8b3d-f40c2dc5371a", "session_id": "018f85f7-3477-78f7-8b3d-f40c2dc5371a", "statement_id": "018f8601-3aea-7404-bd5e-1389542bbd55"}


2024/05/17 10:02:58.679101 +0000 ERROR disttae/txn_database.go:347 error: SQL parser error: table "table01" does not exist {"span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}}
2024/05/17 10:02:58.679169 +0000 ERROR engine/entire_engine.go:58 error: internal error: temporary engine not init yet {"span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}}
2024/05/17 10:02:58.679189 +0000 ERROR cn-service.frontend frontend/compiler_context.go:298 Failed to get temp database {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "error": "internal error: temporary engine not init yet", "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3af6-7f32-ab5c-4c3cf7faa1ea", "txn_id": "018f86013af7702e946b24e77954763e/Active/S:1715940178678185477-1"}
2024/05/17 10:02:58.679210 +0000 ERROR cn-service.frontend frontend/compiler_context.go:281 Failed to get table {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "tableName": "table01", "error": "SQL parser error: table \"table01\" does not exist", "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3af6-7f32-ab5c-4c3cf7faa1ea", "txn_id": "018f86013af7702e946b24e77954763e/Active/S:1715940178678185477-1"}
2024/05/17 10:02:58.679267 +0000 ERROR plan/query_builder.go:3500 error: SQL parser error: table "table01" does not exist {"span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}}
2024/05/17 10:02:58.679297 +0000 ERROR cn-service.frontend frontend/txn.go:63 SQL parser error: table "table01" does not exist {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3af6-7f32-ab5c-4c3cf7faa1ea", "txn_id": "018f86013af7702e946b24e77954763e/Active/S:1715940178678185477-1"}
2024/05/17 10:02:58.679330 +0000 ERROR cn-service.frontend frontend/util.go:504 query trace status {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "connection_id": 446, "statement": "select * from table01", "status": "fail", "error": "SQL parser error: table \"table01\" does not exist", "span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}, "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3af6-7f32-ab5c-4c3cf7faa1ea"}
2024/05/17 10:02:58.680217 +0000 INFO tn-service.logtail-server service/server.go:401 handle subscription asynchronously {"uuid": "dd4dccb4-4d3c-41f8-b482-5251dc7a41bf", "server-id": "018f85f7-18ca-7b33-ad93-d9d5bbc44b0d", "table": "db_id:284607 tb_id:284609 "}
2024/05/17 10:02:58.680380 +0000 INFO tn-service.logtail-server service/session.go:518 send subscription response {"uuid": "dd4dccb4-4d3c-41f8-b482-5251dc7a41bf", "server-id": "018f85f7-18ca-7b33-ad93-d9d5bbc44b0d", "stream-id": 1, "remote": "127.0.0.1:47822", "table": "db_id:284607 tb_id:284609 ", "To": "PhysicalTime:1715940178679850410 "}
2024/05/17 10:02:58.680835 +0000 INFO disttae/logtail_consumer.go:747 [logtail-consumer] subscribe tbl[db: 284607, tbl: 284609] succeed


2024/05/17 10:02:58.686720 +0000 INFO cn-service.frontend frontend/snapshot.go:362 [sp08] start to restore account: 10065 {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "session_info": "snapshot"}
2024/05/17 10:02:58.688430 +0000 INFO compile/sql_executor.go:355 sql_executor exec {"sql": "select count(*) > 0 from `mo_catalog`.`mo_foreign_keys` where refer_db_name = 'acc_test02' and db_name != 'acc_test02';", "txn-id": "018f86013afc7f1a9527a6b166a6822f", "duration": "323.636µs", "AffectedRows": 0}
2024/05/17 10:02:58.688569 +0000 ERROR disttae/engine.go:525 error: internal error: can not find table by id 284501: accountId: 10065  {"span": {"trace_id": "01ae614d-afbd-c048-cf8b-0b29403a94db", "span_id": "4ece47e980f59c20"}}
2024/05/17 10:02:58.688607 +0000 ERROR cn-service.frontend frontend/txn.go:63 internal error: can not find table by id 284501: accountId: 10065  {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "session_info": "", "session_id": "018f8601-3afb-7e77-a987-791210b361ca"}
2024/05/17 10:02:58.688636 +0000 ERROR cn-service.frontend frontend/util.go:504 query trace status {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "connection_id": 0, "statement": "restore account acc01 from snapshot sp08 to account acc01", "status": "fail", "error": "internal error: can not find table by id 284501: accountId: 10065 ", "span": {"trace_id": "01ae614d-afbd-c048-cf8b-0b29403a94db", "span_id": "4ece47e980f59c20"}, "session_info": "", "session_id": "018f8601-3afb-7e77-a987-791210b361ca"}
2024/05/17 10:02:58.688864 +0000 ERROR cn-service.frontend frontend/txn.go:63 internal error: can not find table by id 284501: accountId: 10065  {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "session_info": "connectionId 3|127.0.0.1:36820|{account sys:dump:moadmin -- 0:1:0}|goRoutineId 304|018f85f7-3477-78f7-8b3d-f40c2dc5371a", "session_id": "018f85f7-3477-78f7-8b3d-f40c2dc5371a", "statement_id": "018f8601-3afb-7e05-a943-710b7b1f73a6", "txn_id": "018f86013afb7e3d99085f00704a102c/Active/S:1715940178682110033-1"}
2024/05/17 10:02:58.688912 +0000 ERROR cn-service.frontend frontend/util.go:504 query trace status {"uuid": "dd1dccb0-4d3c-41f8-b482-5251dc7a41bf", "connection_id": 3, "statement": "restore account acc01 from snapshot sp08 to account acc01", "status": "fail", "error": "internal error: can not find table by id 284501: accountId: 10065 ", "span": {"trace_id": "01ae614d-afbd-c048-cf8b-0b29403a94db", "span_id": "4ece47e980f59c20"}, "session_info": "connectionId 3|127.0.0.1:36820|{account sys:dump:moadmin -- 0:1:0}|goRoutineId 304|018f85f7-3477-78f7-8b3d-f40c2dc5371a", "session_id": "018f85f7-3477-78f7-8b3d-f40c2dc5371a", "statement_id": "018f8601-3afb-7e05-a943-710b7b1f73a6"}
2024/05/17 10:02:58.694964 +0000 ERROR disttae/txn_database.go:347 error: SQL parser error: table "table01" does not exist {"span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}}
2024/05/17 10:02:58.695034 +0000 ERROR engine/entire_engine.go:58 error: internal error: temporary engine not init yet {"span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}}
2024/05/17 10:02:58.695054 +0000 ERROR cn-service.frontend frontend/compiler_context.go:298 Failed to get temp database {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "error": "internal error: temporary engine not init yet", "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3b06-7d37-a8df-ea4fc27cb55a", "txn_id": "018f86013b067d77a75bd0a416ae7338/Active/S:1715940178694431453-1"}
2024/05/17 10:02:58.695104 +0000 ERROR cn-service.frontend frontend/compiler_context.go:281 Failed to get table {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "tableName": "table01", "error": "SQL parser error: table \"table01\" does not exist", "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3b06-7d37-a8df-ea4fc27cb55a", "txn_id": "018f86013b067d77a75bd0a416ae7338/Active/S:1715940178694431453-1"}
2024/05/17 10:02:58.695151 +0000 ERROR plan/query_builder.go:3500 error: SQL parser error: table "table01" does not exist {"span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}}
2024/05/17 10:02:58.695180 +0000 ERROR cn-service.frontend frontend/txn.go:63 SQL parser error: table "table01" does not exist {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3b06-7d37-a8df-ea4fc27cb55a", "txn_id": "018f86013b067d77a75bd0a416ae7338/Active/S:1715940178694431453-1"}
2024/05/17 10:02:58.695219 +0000 ERROR cn-service.frontend frontend/util.go:504 query trace status {"uuid": "dd1dccb1-4d3c-41f8-b482-5251dc7a41bf", "connection_id": 446, "statement": "select * from table01", "status": "fail", "error": "SQL parser error: table \"table01\" does not exist", "span": {"trace_id": "bce393fe-babe-534c-571e-200cb720c983", "span_id": "71edad8eab7d7c9b"}, "session_info": "connectionId 446|127.0.0.1:35828|{account acc01:test_account:accountadmin -- 10065:2:2}|goRoutineId 9584|018f8600-8464-7802-9bee-b1e08582814e", "session_id": "018f8600-8464-7802-9bee-b1e08582814e", "statement_id": "018f8601-3b06-7d37-a8df-ea4fc27cb55a"}
2024/05/17 10:02:58.698308 +0000 INFO compile/sql_executor.go:355 sql_executor exec {"sql": "select count(*) > 0 from `mo_catalog`.`mo_foreign_keys` where refer_db_name = 'test01' and db_name != 'test01';", "txn-id": "018f86013b09784d8bdc9826bcf304ea", "duration": "332.152µs", "AffectedRows": 0}
2024/05/17 10:02:58.699314 +0000 INFO compile/sql_executor.go:355 sql_executor exec {"sql": "delete from mo_catalog.mo_indexes where database_id = 284607;", "txn-id": "018f86013b09784d8bdc9826bcf304ea", "duration": "892.515µs", "AffectedRows": 1}
2024/05/17 10:02:58.699768 +0000 INFO compile/sql_executor.go:355 sql_executor exec {"sql": "delete from mo_catalog.mo_table_partitions where database_id = 284607;", "txn-id": "018f86013b09784d8bdc9826bcf304ea", "duration": "394.819µs", "AffectedRows": 0}
2024/05/17 10:02:58.700249 +0000 INFO compile/sql_executor.go:355 sql_executor exec {"sql": "delete from `mo_catalog`.`mo_foreign_keys` where db_name = 'test01'", "txn-id": "018f86013b09784d8bdc9826bcf304ea", "duration": "437.379µs", "AffectedRows": 0}
2024/05/17 10:02:58.700551 +0000 INFO rpc/handle.go:841 dropOrTruncateRelation isDrop: true, name: __mo_index_unique_018f8601-3aaf-7af6-8b50-c6a450286f2d, id: 284610, newId: 0, databaseName: test01, databaseId: 284607

YANGGMM avatar May 20 '24 07:05 YANGGMM

是在drop database 'acc_test02' 中报的这个错

drop database if exists acc_test02;
create database acc_test02;
use acc_test02;
drop table if exists pri01;
create table pri01(
                      deptno int unsigned comment '部门编号',
                      dname varchar(15) comment '部门名称',
                      loc varchar(50)  comment '部门所在位置',
                      primary key(deptno)
) comment='部门表';

insert into pri01 values (10,'ACCOUNTING','NEW YORK');
insert into pri01 values (20,'RESEARCH','DALLAS');
insert into pri01 values (30,'SALES','CHICAGO');
insert into pri01 values (40,'OPERATIONS','BOSTON');
select count(*) from pri01;

drop table if exists aff01;
create table aff01(
                      empno int unsigned auto_increment COMMENT '雇员编号',
                      ename varchar(15) comment '雇员姓名',
                      job varchar(10) comment '雇员职位',
                      mgr int unsigned comment '雇员对应的领导的编号',
                      hiredate date comment '雇员的雇佣日期',
                      sal decimal(7,2) comment '雇员的基本工资',
                      comm decimal(7,2) comment '奖金',
                      deptno int unsigned comment '所在部门',
                      primary key(empno),
                      constraint `c1` foreign key (deptno) references pri01 (deptno)
);

insert into aff01 values (7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20);
insert into aff01 values (7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30);
insert into aff01 values (7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30);
insert into aff01 values (7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20);
insert into aff01 values (7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30);
insert into aff01 values (7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30);
insert into aff01 values (7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10);
insert into aff01 values (7788,'SCOTT','ANALYST',7566,'0087-07-13',3000,NULL,20);
insert into aff01 values (7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
insert into aff01 values (7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30);
insert into aff01 values (7876,'ADAMS','CLERK',7788,'0087-07-13',1100,NULL,20);
insert into aff01 values (7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30);
insert into aff01 values (7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20);
insert into aff01 values (7934,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,10);
select count(*) from aff01;

insert into acc_test02.pri01 values (50,'ACCOUNTING','NEW YORK');
insert into acc_test02.aff01 values (9000,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,50);

YANGGMM avatar May 20 '24 08:05 YANGGMM

image

https://github.com/matrixorigin/matrixone/actions/runs/9153290008/job/25162006175?pr=16223

daviszhen avatar May 20 '24 11:05 daviszhen

fixed

YANGGMM avatar May 22 '24 02:05 YANGGMM

观察了一周ci测试，没再出现了

Ariznawlll avatar May 27 '24 08:05 Ariznawlll