YANGGMM

单独开事务执行是没有问题的 ```mysql mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> drop table if exists `bmsql_history`; Query OK, 0 rows affected (0.01 sec) mysql> use tpcc; Database changed mysql>...

```mysql mysql> begin; Query OK, 0 rows affected (0.01 sec) mysql> mysql> drop table if exists `bmsql_history`; Query OK, 0 rows affected (0.03 sec) mysql> use tpcc; Database changed mysql>...

**在执行restore中insert之前先提交事务，restore就可以顺利通过，感觉是backGroundExec的事务问题**

在statement 执行入口添加log ```mysql ----------------------- executeStmtWithIncrStmt sql : restore account sys database tpcc table `bmsql_history` from snapshot sp_01 snapshotTs : 1715844568861921000 ----------------------- ----------------------- executeStmtWithIncrStmt sql : drop table if exists tpcc.bmsql_history...

frontend 执行的log ```mysql ----------------------- executeStmtWithIncrStmt sql : drop table if exists tpcc.bmsql_history snapshotTs : 1715845293989984000 ----------------------- ----------------------- executeStmtWithIncrStmt sql : show full tables from `tpcc` {snapshot = 'sp_01'} snapshotTs :...

**compile阶段的ts 跟 前端的ts 以及 snapshot的ts都对得上** ```mysql ----------------------- executeStmtWithIncrStmt sql : insert into `tpcc`.`bmsql_history` SELECT * FROM `tpcc`.`bmsql_history` {snapshot = 'sp_01'} snapshotTs : 1715847008536497000 ----------------------- ----------------------- compileTableScanDataSource schemaName : tpcc relationName...

{"level":"INFO","time":"2023/11/21 10:14:57.785146 +0000","name":"cn-service.frontend","caller":"frontend/mysql_cmd_executor.go:3341","msg":"time of Exec.Run : 5.40788172s","uuid":"37303538-3661-6561-3235-363337366537","session_info":"connectionId 1335568|172.20.6.3:35916|{account 738c8806_aa7b_412c_8370_59e47141cfaf:admin:accountadmin -- 9000001:2:2}|goRoutineId 4131|794115f0-8856-11ee-a532-3e8dd997aa03","session_id":"794115f0-8856-11ee-a532-3e8dd997aa03","statement_id":"**cf6e625e-8856-11ee-a532-3e8dd997aa03**"} 从log中看这个statement是执行成功的 {"level":"ERROR","time":"2023/11/21 10:17:43.914261 +0000","caller":"fileservice/aliyun_sdk.go:258","msg":"error: file mo-20231120/data/query_result_meta/738c8806_aa7b_412c_8370_59e47141cfaf_**cf6e625e-8856-11ee-a532-3e8dd997aa03**.blk is not found"} 然后在aliyun中找不到这个文件 需要看看这个statement的具体内容 还需要看看aliyun中是否有这个文件

从aliyun的bucket中查看确实没有这个文件

still working