mymeiyi opened a new pull request, #17678: URL: https://github.com/apache/doris/pull/17678
…it a rollback transation insert # Proposed changes Issue Number: close #xxx ## Problem summary When client do transaction insert and quit withoud commit or rollback, the plan fragment will be executed in Be until timeout. fe log: ``` 2023-03-10 19:53:53,738 INFO (mysql-nio-pool-4|2451) [DatabaseTransactionMgr.abortTransaction():1257] abort transaction: TransactionState. transaction id: 66108, label: txn_insert_dd92e517ce914249-96f63c694369928c, db id: 10092, table id list: 30028, callback id: -1, coordinator: FE: 127.0.0.1, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1678449233220, commit time: -1, finish time: 1678449233736, reason: timeout successfully ``` be log: ``` I0310 19:53:53.395712 695864 new_load_stream_mgr.h:44] put stream load pipe: a89c5c39c88b4171-9fc44906714b90c7 I0310 19:53:53.396684 695864 stream_load_executor.cpp:46] begin to execute job. label=txn_insert_dd92e517ce914249-96f63c694369928c, txn_id=66108, query_id=a89c5c39c88b4171-9fc44906714b90c7 I0310 19:53:53.413743 695864 fragment_mgr.cpp:632] query_id: a89c5c39c88b4171-9fc44906714b90c7 coord_addr TNetworkAddress(hostname=127.0.0.1, port=9089) total fragment num on current host: 0 I0310 19:53:53.416023 695864 fragment_mgr.cpp:684] Register query/load memory tracker, query/load id: a89c5c39c88b4171-9fc44906714b90c7 limit: 2.00 GB I0310 19:53:53.416114 695864 plan_fragment_executor.cpp:88] PlanFragmentExecutor::prepare|query_id=a89c5c39c88b4171-9fc44906714b90c7|instance_id=a89c5c39c88b4171-9fc44906714b90c8|backend_num=0|pthread_id=140275927877376 I0310 19:53:53.495054 695105 fragment_mgr.cpp:488] PlanFragmentExecutor::_exec_actual|query_id=a89c5c39c88b4171-9fc44906714b90c7|instance_id=a89c5c39c88b4171-9fc44906714b90c8|pthread_id=140281794856704 I0310 19:53:53.495085 695105 plan_fragment_executor.cpp:222] PlanFragmentExecutor::open|query_id=a89c5c39c88b4171-9fc44906714b90c7|instance_id=a89c5c39c88b4171-9fc44906714b90c8|mem_limit=2.00 GB I0310 19:53:53.523222 695798 internal_service.cpp:177] tablet writer open, id=a89c5c39c88b4171-9fc44906714b90c7, index_id=30029, txn_id=66108 I0310 19:53:53.524181 695798 tablets_channel.cpp:60] open tablets channel: (id=a89c5c39c88b4171-9fc44906714b90c7,index_id=30029), tablets num: 1, timeout(s): 259200 I0310 19:54:22.446105 695363 load_channel_mgr.cpp:183] load channel[0]: LoadChannel(id=a89c5c39c88b4171-9fc44906714b90c7, mem=0, last_update_time=1678449233, is high priority: 0) I0310 19:55:22.446957 695363 load_channel_mgr.cpp:183] load channel[0]: LoadChannel(id=a89c5c39c88b4171-9fc44906714b90c7, mem=0, last_update_time=1678449233, is high priority: 0) I0310 19:56:22.447104 695363 load_channel_mgr.cpp:183] load channel[0]: LoadChannel(id=a89c5c39c88b4171-9fc44906714b90c7, mem=0, last_update_time=1678449233, is high priority: 0) I0310 19:57:22.447242 695363 load_channel_mgr.cpp:183] load channel[0]: LoadChannel(id=a89c5c39c88b4171-9fc44906714b90c7, mem=0, last_update_time=1678449233, is high priority: 0) ``` ## Checklist(Required) * [ ] Does it affect the original behavior * [ ] Has unit tests been added * [ ] Has document been added or modified * [ ] Does it need to update dependencies * [ ] Is this PR support rollback (If NO, please explain WHY) ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
