You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/11/02 06:50:29 UTC

[GitHub] [incubator-doris] hf200012 opened a new issue #6991: [Bug] Error executing insert into select

hf200012 opened a new issue #6991:
URL: https://github.com/apache/incubator-doris/issues/6991


   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   0.14.13.1
   
   ### What's Wrong?
   
   2021-11-02 10:46:56,898 INFO (doris-mysql-nio-pool-23314|121293) [DatabaseTransactionMgr.abortTransaction():1029] abort transaction: TransactionState. transaction id: 66085814, label: insert_5c91afdb5917424c-bcea54bf06a17247, db id: 3672107, table id list: 16319355, callback id: -1, coordinator: FE: 172.22.197.239, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1635821181046, commit time: -1, finish time: 1635821216897, reason: errCode = 2, detailMessage = Cancelled successfully
   
   
   ### What You Expected?
   
   Checked the wrong Query_id: 91afdb5917424c-bcea54bf06a17247
   According to this ID, all relevant logs in fe.log are as follows: 
   ```
   2021-11-02 10:46:21,046 INFO (doris-mysql-nio-pool-23314|121293) [DatabaseTransactionMgr.beginTransaction():304] begin transaction: txn id 66085814 with label insert_5c91afdb5917424c-bcea54bf06a17247 from coordinator FE: 172.22.197.239, listner id: -1
   2021-11-02 10:46:21,064 INFO (doris-mysql-nio-pool-23314|121293) [StmtExecutor.handleInsertStmt():1251] Do insert [insert_5c91afdb5917424c-bcea54bf06a17247] with query id: 5c91afdb5917424c-bcea54bf06a17247
   2021-11-02 10:46:21,064 INFO (doris-mysql-nio-pool-23314|121293) [QeProcessorImpl.registerQuery():75] register query id = 5c91afdb5917424c-bcea54bf06a17247, job: -1
   2021-11-02 10:46:21,065 INFO (doris-mysql-nio-pool-23314|121293) [Coordinator.exec():458] dispatch load job: 5c91afdb5917424c-bcea54bf06a17247 to [TNetworkAddress(hostname:172.22.197.246, port:9060), TNetworkAddress(hostname:172.22.197.247, port:9060), TNetworkAddress(hostname:172.22.197.248, port:9060), TNetworkAddress(hostname:172.22.197.249, port:9060), TNetworkAddress(hostname:172.22.197.242, port:9060), TNetworkAddress(hostname:172.22.197.243, port:9060), TNetworkAddress(hostname:172.22.197.244, port:9060), TNetworkAddress(hostname:172.22.197.245, port:9060), TNetworkAddress(hostname:172.22.197.250, port:9060), TNetworkAddress(hostname:172.22.197.241, port:9060)]
   2021-11-02 10:46:21,175 INFO (thrift-server-pool-38923|120756) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a8, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 55, ip: TNetworkAddress(hostname:172.22.197.247, port:59402)
   2021-11-02 10:46:21,179 INFO (thrift-server-pool-39311|121148) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b4, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 42, ip: TNetworkAddress(hostname:172.22.197.249, port:48368)
   2021-11-02 10:46:21,186 INFO (thrift-server-pool-39329|121166) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1726b, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 99, ip: TNetworkAddress(hostname:172.22.197.246, port:53338)
   2021-11-02 10:46:21,188 INFO (thrift-server-pool-39244|121081) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c9, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 21, ip: TNetworkAddress(hostname:172.22.197.241, port:50190)
   2021-11-02 10:46:21,189 INFO (thrift-server-pool-37254|118141) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a7, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 54, ip: TNetworkAddress(hostname:172.22.197.248, port:58460)
   2021-11-02 10:46:21,201 INFO (thrift-server-pool-39061|120898) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17291, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 77, ip: TNetworkAddress(hostname:172.22.197.246, port:52718)
   2021-11-02 10:46:21,211 INFO (thrift-server-pool-39249|121086) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a9, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 43, ip: TNetworkAddress(hostname:172.22.197.247, port:59414)
   2021-11-02 10:46:21,222 INFO (thrift-server-pool-38913|120746) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17270, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 104, ip: TNetworkAddress(hostname:172.22.197.244, port:59984)
   2021-11-02 10:46:21,229 INFO (thrift-server-pool-39226|121063) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1726f, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 103, ip: TNetworkAddress(hostname:172.22.197.243, port:41524)
   2021-11-02 10:46:21,231 INFO (thrift-server-pool-39261|121098) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1729c, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 66, ip: TNetworkAddress(hostname:172.22.197.246, port:53336)
   2021-11-02 10:46:21,232 INFO (thrift-server-pool-37337|118224) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1726c, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 100, ip: TNetworkAddress(hostname:172.22.197.248, port:58452)
   2021-11-02 10:46:21,233 INFO (thrift-server-pool-38998|120834) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17272, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 106, ip: TNetworkAddress(hostname:172.22.197.250, port:57572)
   2021-11-02 10:46:21,237 INFO (thrift-server-pool-39006|120842) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17273, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 107, ip: TNetworkAddress(hostname:172.22.197.241, port:50172)
   2021-11-02 10:46:21,255 INFO (thrift-server-pool-39163|121000) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17255, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 139, ip: TNetworkAddress(hostname:172.22.197.243, port:41226)
   2021-11-02 10:46:21,260 INFO (thrift-server-pool-39233|121070) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1724a, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 140, ip: TNetworkAddress(hostname:172.22.197.242, port:56448)
   2021-11-02 10:46:21,275 INFO (thrift-server-pool-38934|120767) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17260, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 128, ip: TNetworkAddress(hostname:172.22.197.247, port:59410)
   2021-11-02 10:46:21,290 INFO (thrift-server-pool-39406|121281) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17271, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 105, ip: TNetworkAddress(hostname:172.22.197.245, port:58444)
   2021-11-02 10:46:21,326 INFO (thrift-server-pool-39177|121014) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1726d, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 101, ip: TNetworkAddress(hostname:172.22.197.249, port:48314)
   2021-11-02 10:46:21,338 INFO (thrift-server-pool-38907|120740) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17290, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 76, ip: TNetworkAddress(hostname:172.22.197.241, port:50450)
   2021-11-02 10:46:21,348 INFO (thrift-server-pool-39008|120844) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17253, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 137, ip: TNetworkAddress(hostname:172.22.197.250, port:58294)
   2021-11-02 10:46:21,361 INFO (thrift-server-pool-38653|120374) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17289, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 69, ip: TNetworkAddress(hostname:172.22.197.248, port:37372)
   2021-11-02 10:46:21,367 INFO (thrift-server-pool-39160|120997) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1728a, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 70, ip: TNetworkAddress(hostname:172.22.197.249, port:48258)
   2021-11-02 10:46:21,405 INFO (thrift-server-pool-38406|119936) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1724d, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 131, ip: TNetworkAddress(hostname:172.22.197.248, port:37376)
   2021-11-02 10:46:21,437 INFO (thrift-server-pool-39156|120993) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17250, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 134, ip: TNetworkAddress(hostname:172.22.197.243, port:42240)
   2021-11-02 10:46:21,498 INFO (thrift-server-pool-39312|121149) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1724e, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 132, ip: TNetworkAddress(hostname:172.22.197.249, port:48150)
   2021-11-02 10:46:21,555 INFO (thrift-server-pool-39412|121290) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17254, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 138, ip: TNetworkAddress(hostname:172.22.197.241, port:51022)
   2021-11-02 10:46:21,710 INFO (thrift-server-pool-38431|120016) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1728d, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 73, ip: TNetworkAddress(hostname:172.22.197.244, port:60008)
   2021-11-02 10:46:21,782 INFO (thrift-server-pool-38607|120328) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17251, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 135, ip: TNetworkAddress(hostname:172.22.197.244, port:60012)
   2021-11-02 10:46:21,788 INFO (thrift-server-pool-39162|120999) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1728b, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 71, ip: TNetworkAddress(hostname:172.22.197.242, port:56148)
   2021-11-02 10:46:21,797 INFO (thrift-server-pool-39422|121308) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17252, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 136, ip: TNetworkAddress(hostname:172.22.197.245, port:58552)
   2021-11-02 10:46:21,946 INFO (thrift-server-pool-39161|120998) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1726e, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 102, ip: TNetworkAddress(hostname:172.22.197.242, port:56374)
   2021-11-02 10:46:21,947 INFO (thrift-server-pool-39222|121059) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17274, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 90, ip: TNetworkAddress(hostname:172.22.197.243, port:42244)
   2021-11-02 10:46:21,947 INFO (thrift-server-pool-38648|120369) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17277, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 93, ip: TNetworkAddress(hostname:172.22.197.246, port:52906)
   2021-11-02 10:46:21,947 INFO (thrift-server-pool-37354|118241) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17279, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 95, ip: TNetworkAddress(hostname:172.22.197.248, port:58464)
   2021-11-02 10:46:21,948 INFO (thrift-server-pool-39325|121162) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17278, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 94, ip: TNetworkAddress(hostname:172.22.197.249, port:48372)
   2021-11-02 10:46:21,948 INFO (thrift-server-pool-39415|121298) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1727a, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 96, ip: TNetworkAddress(hostname:172.22.197.245, port:58476)
   2021-11-02 10:46:21,948 INFO (thrift-server-pool-38885|120718) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17275, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 91, ip: TNetworkAddress(hostname:172.22.197.241, port:50196)
   2021-11-02 10:46:21,948 INFO (thrift-server-pool-38958|120791) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1727c, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 98, ip: TNetworkAddress(hostname:172.22.197.250, port:58298)
   2021-11-02 10:46:21,948 INFO (thrift-server-pool-38957|120790) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1727b, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 97, ip: TNetworkAddress(hostname:172.22.197.244, port:60028)
   2021-11-02 10:46:21,949 INFO (thrift-server-pool-39174|121011) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17276, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 92, ip: TNetworkAddress(hostname:172.22.197.242, port:56434)
   2021-11-02 10:46:21,988 INFO (thrift-server-pool-39034|120871) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1728f, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 75, ip: TNetworkAddress(hostname:172.22.197.250, port:58280)
   2021-11-02 10:46:22,234 INFO (thrift-server-pool-39173|121010) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17287, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 67, ip: TNetworkAddress(hostname:172.22.197.246, port:52924)
   2021-11-02 10:46:22,335 INFO (thrift-server-pool-38938|120771) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1724b, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 129, ip: TNetworkAddress(hostname:172.22.197.246, port:52890)
   2021-11-02 10:46:22,511 INFO (thrift-server-pool-39387|121249) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1728e, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 74, ip: TNetworkAddress(hostname:172.22.197.245, port:58400)
   2021-11-02 10:46:23,997 INFO (thrift-server-pool-39220|121057) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1724f, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 133, ip: TNetworkAddress(hostname:172.22.197.242, port:56362)
   2021-11-02 10:46:24,005 INFO (thrift-server-pool-39215|121052) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1728c, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 72, ip: TNetworkAddress(hostname:172.22.197.243, port:41978)
   2021-11-02 10:46:25,439 INFO (thrift-server-pool-39019|120855) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17288, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 68, ip: TNetworkAddress(hostname:172.22.197.247, port:59334)
   2021-11-02 10:46:25,443 INFO (thrift-server-pool-39135|120972) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17293, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 57, ip: TNetworkAddress(hostname:172.22.197.249, port:48364)
   2021-11-02 10:46:25,443 INFO (thrift-server-pool-37350|118237) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17292, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 56, ip: TNetworkAddress(hostname:172.22.197.248, port:58462)
   2021-11-02 10:46:25,444 INFO (thrift-server-pool-39211|121048) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1729b, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 65, ip: TNetworkAddress(hostname:172.22.197.242, port:56358)
   2021-11-02 10:46:25,444 INFO (thrift-server-pool-39074|120911) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17294, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 58, ip: TNetworkAddress(hostname:172.22.197.247, port:59416)
   2021-11-02 10:46:25,444 INFO (thrift-server-pool-39018|120854) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17299, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 63, ip: TNetworkAddress(hostname:172.22.197.250, port:57388)
   2021-11-02 10:46:25,444 INFO (thrift-server-pool-39406|121281) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17298, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 62, ip: TNetworkAddress(hostname:172.22.197.245, port:58444)
   2021-11-02 10:46:25,444 INFO (thrift-server-pool-37200|118087) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1729a, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 64, ip: TNetworkAddress(hostname:172.22.197.244, port:49714)
   2021-11-02 10:46:25,444 INFO (thrift-server-pool-39024|120860) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17297, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 61, ip: TNetworkAddress(hostname:172.22.197.241, port:50452)
   2021-11-02 10:46:25,444 INFO (thrift-server-pool-39253|121090) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17296, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 60, ip: TNetworkAddress(hostname:172.22.197.246, port:53340)
   2021-11-02 10:46:25,445 INFO (thrift-server-pool-38902|120735) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17295, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 59, ip: TNetworkAddress(hostname:172.22.197.243, port:42238)
   2021-11-02 10:46:25,446 INFO (thrift-server-pool-39192|121029) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1729e, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 45, ip: TNetworkAddress(hostname:172.22.197.242, port:56436)
   2021-11-02 10:46:25,446 INFO (thrift-server-pool-39214|121051) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a0, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 47, ip: TNetworkAddress(hostname:172.22.197.247, port:59398)
   2021-11-02 10:46:25,446 INFO (thrift-server-pool-39030|120867) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a2, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 49, ip: TNetworkAddress(hostname:172.22.197.250, port:58292)
   2021-11-02 10:46:25,446 INFO (thrift-server-pool-38868|120697) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a4, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 51, ip: TNetworkAddress(hostname:172.22.197.241, port:50448)
   2021-11-02 10:46:25,446 INFO (thrift-server-pool-38949|120782) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1729d, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 44, ip: TNetworkAddress(hostname:172.22.197.246, port:53260)
   2021-11-02 10:46:25,446 INFO (thrift-server-pool-39251|121088) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a3, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 50, ip: TNetworkAddress(hostname:172.22.197.249, port:48362)
   2021-11-02 10:46:25,446 INFO (thrift-server-pool-38452|120037) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1729f, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 46, ip: TNetworkAddress(hostname:172.22.197.248, port:37368)
   2021-11-02 10:46:25,447 INFO (thrift-server-pool-39171|121008) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a5, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 52, ip: TNetworkAddress(hostname:172.22.197.243, port:40258)
   2021-11-02 10:46:25,447 INFO (thrift-server-pool-38964|120797) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a6, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 53, ip: TNetworkAddress(hostname:172.22.197.244, port:60030)
   2021-11-02 10:46:25,447 INFO (thrift-server-pool-39421|121306) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172a1, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 48, ip: TNetworkAddress(hostname:172.22.197.245, port:58500)
   2021-11-02 10:46:25,448 INFO (thrift-server-pool-39011|120847) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b2, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 40, ip: TNetworkAddress(hostname:172.22.197.249, port:48210)
   2021-11-02 10:46:25,448 INFO (thrift-server-pool-38272|119741) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172ab, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 33, ip: TNetworkAddress(hostname:172.22.197.243, port:42258)
   2021-11-02 10:46:25,448 INFO (thrift-server-pool-37227|118114) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172ad, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 35, ip: TNetworkAddress(hostname:172.22.197.248, INFO (thrift-server-pool-39330|121167) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b1, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 39, ip: TNetworkAddress(hostname:172.22.197.250, port:58422)
   2021-11-02 10:46:25,449 INFO (thrift-server-pool-39259|121096) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172ae, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 36, ip: TNetworkAddress(hostname:172.22.197.242, port:56380)
   2021-11-02 10:46:25,449 INFO (thrift-server-pool-39387|121249) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172aa, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 32, ip: TNetworkAddress(hostname:172.22.197.245, port:58400)
   2021-11-02 10:46:25,449 INFO (thrift-server-pool-39302|121139) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b0, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 38, ip: TNetworkAddress(hostname:172.22.197.247, port:59206)
   2021-11-02 10:46:25,449 INFO (thrift-server-pool-38946|120779) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172ac, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 34, ip: TNetworkAddress(hostname:172.22.197.244, port:60018)
   2021-11-02 10:46:25,449 INFO (thrift-server-pool-38921|120754) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b3, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 41, ip: TNetworkAddress(hostname:172.22.197.241, port:50446)
   2021-11-02 10:46:25,449 INFO (thrift-server-pool-39047|120884) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172af, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 37, ip: TNetworkAddress(hostname:172.22.197.246, port:52928)
   2021-11-02 10:46:25,450 INFO (thrift-server-pool-39331|121168) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172bd, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 30, ip: TNetworkAddress(hostname:172.22.197.249, port:47188)
   2021-11-02 10:46:25,450 INFO (thrift-server-pool-39165|121002) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b7, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 24, ip: TNetworkAddress(hostname:172.22.197.247, port:59400)
   2021-11-02 10:46:25,451 INFO (thrift-server-pool-38898|120731) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b6, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 23, ip: TNetworkAddress(hostname:172.22.197.250, port:58268)
   2021-11-02 10:46:25,451 INFO (thrift-server-pool-39170|121007) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b5, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 22, ip: TNetworkAddress(hostname:172.22.197.242, port:56444)
   2021-11-02 10:46:25,451 INFO (thrift-server-pool-38637|120358) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172be, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 31, ip: TNetworkAddress(hostname:172.22.197.248, port:37370)
   2021-11-02 10:46:25,451 INFO (thrift-server-pool-37317|118204) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172bb, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 28, ip: TNetworkAddress(hostname:172.22.197.246, port:53276)
   2021-11-02 10:46:25,451 INFO (thrift-server-pool-39318|121155) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b9, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 26, ip: TNetworkAddress(hostname:172.22.197.241, port:50036)
   2021-11-02 10:46:25,451 INFO (thrift-server-pool-39398|121267) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172b8, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 25, ip: TNetworkAddress(hostname:172.22.197.245, port:58506)
   2021-11-02 10:46:25,451 INFO (thrift-server-pool-38708|120430) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172ba, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 27, ip: TNetworkAddress(hostname:172.22.197.243, port:42276)
   2021-11-02 10:46:25,452 INFO (thrift-server-pool-38821|120584) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172bc, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 29, ip: TNetworkAddress(hostname:172.22.197.244, port:60002)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-39231|121068) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c0, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 12, ip: TNetworkAddress(hostname:172.22.197.241, port:50182)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-39245|121082) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c6, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 18, ip: TNetworkAddress(hostname:172.22.197.249, port:48156)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-38066|119407) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c2, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 14, ip: TNetworkAddress(hostname:172.22.197.247, port:59364)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-38862|120659) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c7, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 19, ip: TNetworkAddress(hostname:172.22.197.250, port:56054)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-39233|121070) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172bf, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 11, ip: TNetworkAddress(hostname:172.22.197.242, port:56448)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-39426|121314) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c5, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 17, ip: TNetworkAddress(hostname:172.22.197.245, port:58462)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-38953|120786) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c3, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 15, ip: TNetworkAddress(hostname:172.22.197.243, port:42116)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-37345|118232) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c4, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 16, ip: TNetworkAddress(hostname:172.22.197.248, port:58456)
   2021-11-02 10:46:25,453 INFO (thrift-server-pool-39329|121166) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c8, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 20, ip: TNetworkAddress(hostname:172.22.197.246, port:53338)
   2021-11-02 10:46:25,454 INFO (thrift-server-pool-38876|120709) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172c1, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 13, ip: TNetworkAddress(hostname:172.22.197.244, port:60016)
   2021-11-02 10:46:25,458 INFO (thrift-server-pool-39319|121156) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1724c, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 130, ip: TNetworkAddress(hostname:172.22.197.247, port:59412)
   2021-11-02 10:46:25,461 INFO (thrift-server-pool-38951|120784) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1725b, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 123, ip: TNetworkAddress(hostname:172.22.197.250, port:58578)
   2021-11-02 10:46:25,461 INFO (thrift-server-pool-38923|120756) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1725d, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 125, ip: TNetworkAddress(hostname:172.22.197.247, port:59402)
   2021-11-02 10:46:25,462 INFO (thrift-server-pool-39244|121081) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17256, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 118, ip: TNetworkAddress(hostname:172.22.197.241, port:50190)
   2021-11-02 10:46:25,462 INFO (thrift-server-pool-39162|120999) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17257, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 119, ip: TNetworkAddress(hostname:172.22.197.242, port:56148)
   2021-11-02 10:46:25,462 INFO (thrift-server-pool-39311|121148) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17259, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 121, ip: TNetworkAddress(hostname:172.22.197.249, port:48368)
   2021-11-02 10:46:25,462 INFO (thrift-server-pool-39226|121063) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17258, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 120, ip: TNetworkAddress(hostname:172.22.197.243, port:41524)
   2021-11-02 10:46:25,462 INFO (thrift-server-pool-39411|121289) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1725a, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 122, ip: TNetworkAddress(hostname:172.22.197.245, port:58494)
   2021-11-02 10:46:25,462 INFO (thrift-server-pool-37254|118141) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1725c, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 124, ip: TNetworkAddress(hostname:172.22.197.248, port:58460)
   2021-11-02 10:46:25,463 INFO (thrift-server-pool-38959|120792) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1725e, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 126, ip: TNetworkAddress(hostname:172.22.197.244, port:59988)
   2021-11-02 10:46:25,465 INFO (thrift-server-pool-39061|120898) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1725f, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 127, ip: TNetworkAddress(hostname:172.22.197.246, port:52718)
   2021-11-02 10:46:25,465 INFO (thrift-server-pool-39249|121086) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17261, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 108, ip: TNetworkAddress(hostname:172.22.197.247, port:59414)
   2021-11-02 10:46:25,465 INFO (thrift-server-pool-38998|120834) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17266, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 113, ip: TNetworkAddress(hostname:172.22.197.250, port:57572)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39161|120998) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17264, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 111, ip: TNetworkAddress(hostname:172.22.197.242, port:56374)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39163|121000) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17263, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 110, ip: TNetworkAddress(hostname:172.22.197.243, port:41226)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39177|121014) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17265, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 112, ip: TNetworkAddress(hostname:172.22.197.249, port:48314)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-37337|118224) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1726a, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 117, ip: TNetworkAddress(hostname:172.22.197.248, port:58452)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-38913|120746) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17262, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 109, ip: TNetworkAddress(hostname:172.22.197.244, port:59984)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39006|120842) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17269, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 116, ip: TNetworkAddress(hostname:172.22.197.241, port:50172)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-38907|120740) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1727e, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 81, ip: TNetworkAddress(hostname:172.22.197.241, port:50450)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39414|121297) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17267, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 114, ip: TNetworkAddress(hostname:172.22.197.245, port:58348)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-38431|120016) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1727d, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 80, ip: TNetworkAddress(hostname:172.22.197.244, port:60008)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39174|121011) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a1727f, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 82, ip: TNetworkAddress(hostname:172.22.197.242, port:56434)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-38934|120767) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17283, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 86, ip: TNetworkAddress(hostname:172.22.197.247, port:59410)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39160|120997) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17284, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 87, ip: TNetworkAddress(hostname:172.22.197.249, port:48258)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39261|121098) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17280, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 83, ip: TNetworkAddress(hostname:172.22.197.246, port:53336)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39156|120993) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17282, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 85, ip: TNetworkAddress(hostname:172.22.197.243, port:42240)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-38653|120374) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17285, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 88, ip: TNetworkAddress(hostname:172.22.197.248, port:37372)
   2021-11-02 10:46:25,466 INFO (thrift-server-pool-39408|121283) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17281, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 84, ip: TNetworkAddress(hostname:172.22.197.245, port:58498)
   2021-11-02 10:46:25,467 INFO (thrift-server-pool-39008|120844) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17286, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 89, ip: TNetworkAddress(hostname:172.22.197.250, port:58294)
   2021-11-02 10:46:25,468 INFO (thrift-server-pool-38648|120369) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17268, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 115, ip: TNetworkAddress(hostname:172.22.197.246, port:52906)
   2021-11-02 10:46:25,480 INFO (thrift-server-pool-38607|120328) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a17249, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 79, ip: TNetworkAddress(hostname:172.22.197.244, port:60012)
   2021-11-02 10:46:56,897 WARN (doris-mysql-nio-pool-23314|121293) [StmtExecutor.handleInsertStmt():1314] handle insert stmt fail: insert_5c91afdb5917424c-bcea54bf06a17247
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-39030|120867) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172d4, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 0, ip: TNetworkAddress(hostname:172.22.197.250, port:58292)
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-39006|120842) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172ce, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 5, ip: TNetworkAddress(hostname:172.22.197.241, port:50172)
   2021-11-02 10:46:56,897 WARN (thrift-server-pool-39030|120867) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172d4
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-38862|120659) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172cf, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 6, ip: TNetworkAddress(hostname:172.22.197.250, port:56054)
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-39387|121249) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172cb, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 2, ip: TNetworkAddress(hostname:172.22.197.245, port:58400)
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-39331|121168) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172d2, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 9, ip: TNetworkAddress(hostname:172.22.197.249, port:47188)
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-38607|120328) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172d1, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 8, ip: TNetworkAddress(hostname:172.22.197.244, port:60012)
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-38452|120037) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172ca, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 1, ip: TNetworkAddress(hostname:172.22.197.248, port:37368)
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-39211|121048) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172cd, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 4, ip: TNetworkAddress(hostname:172.22.197.242, port:56358)
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39006|120842) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172ce
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-38862|120659) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172cf
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-38607|120328) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172d1
   2021-11-02 10:46:56,897 INFO (thrift-server-pool-39061|120898) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172cc, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 3, ip: TNetworkAddress(hostname:172.22.197.246, port:52718)
   2021-11-02 10:46:56,898 INFO (thrift-server-pool-39074|120911) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172d0, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 7, ip: TNetworkAddress(hostname:172.22.197.247, port:59416)
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39387|121249) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172cb
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39331|121168) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172d2
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39211|121048) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172cd
   2021-11-02 10:46:56,898 INFO (thrift-server-pool-39222|121059) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172d3, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 10, ip: TNetworkAddress(hostname:172.22.197.243, port:42244)
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-38452|120037) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172ca
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39061|120898) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172cc
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39074|120911) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172d0
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39222|121059) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172d3
   2021-11-02 10:46:56,898 INFO (doris-mysql-nio-pool-23314|121293) [DatabaseTransactionMgr.abortTransaction():1029] abort transaction: TransactionState. transaction id: 66085814, label: insert_5c91afdb5917424c-bcea54bf06a17247, db id: 3672107, table id list: 16319355, callback id: -1, coordinator: FE: 172.22.197.239, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1635821181046, commit time: -1, finish time: 1635821216897, reason: errCode = 2, detailMessage = Cancelled successfully
   2021-11-02 10:46:56,927 INFO (doris-mysql-nio-pool-23314|121293) [QeProcessorImpl.unregisterQuery():85] deregister query id 5c91afdb5917424c-bcea54bf06a17247
   ```
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39222|121059) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172d3
   
   Then according to the instance_id, find the be node corresponding to the task at that time
   ```
   2021-11-02 10:46:56,898 INFO (thrift-server-pool-39222|121059) [QeProcessorImpl.reportExecStatus():117] ReportExecStatus(): fragment_instance_id=5c91afdb5917424c-bcea54bf06a172d3, query id=5c91afdb5917424c-bcea54bf06a17247, backend num: 10, ip: TNetworkAddress(hostname:172.22.197.243, port:42244)
   2021-11-02 10:46:56,898 WARN (thrift-server-pool-39222|121059) [Coordinator.updateFragmentExecStatus():1440] one instance report fail, query_id=5c91afdb5917424c-bcea54bf06a17247 instance_id=5c91afdb5917424c-bcea54bf06a172d3
   ```
   Context information of the BE nodeļ¼š
    fragment_instance_id=5c91afdb5917424c-bcea54bf06a172d3
   ```
   1102 10:46:43.478475 (+   649us) compaction.cpp:127] modify rowsets finished
   1102 10:46:43.478487 (+    12us) cumulative_compaction.cpp:77] compaction finished
   1102 10:46:43.478488 (+     1us) cumulative_compaction.cpp:91] save cumulative compaction metrics
   Metrics: {"filtered_rows":0,"input_row_num":1091860,"input_rowsets_data_size":61382297,"input_segments_num":5,"merge_rowsets_latency_us":7823325,"merged_rows":220,"output_row_num":1091640,"output_rowset_data_size":61317205,"output_segments_num":1}
   W1102 10:46:54.757627 434500 tablet.cpp:1376] Trace:
   1102 10:46:51.525960 (+     0us) tablet.cpp:1381] execute cumulative compaction
   1102 10:46:51.525963 (+     3us) cumulative_compaction.cpp:65] got cumulative compaction lock
   1102 10:46:51.525966 (+     3us) compaction.cpp:58] start to do compaction
   1102 10:46:51.526039 (+    73us) compaction.cpp:91] prepare finished
   1102 10:46:54.756524 (+3230485us) compaction.cpp:105] merge rowsets finished
   1102 10:46:54.756763 (+   239us) compaction.cpp:119] output rowset built
   1102 10:46:54.756763 (+     0us) compaction.cpp:123] check correctness finished
   1102 10:46:54.757612 (+   849us) compaction.cpp:127] modify rowsets finished
   1102 10:46:54.757624 (+    12us) cumulative_compaction.cpp:77] compaction finished
   1102 10:46:54.757626 (+     2us) cumulative_compaction.cpp:91] save cumulative compaction metrics
   Metrics: {"filtered_rows":0,"input_row_num":578918,"input_rowsets_data_size":36639523,"input_segments_num":5,"merge_rowsets_latency_us":3230482,"merged_rows":1,"output_row_num":578917,"output_rowset_data_size":36586055,"output_segments_num":1}
   W1102 10:46:56.128003 434471 routine_load_task_executor.cpp:338] consuming failed
   W1102 10:46:56.128266 195734 broker_scan_node.cpp:373] Scanner[0] process failed. status=cancelled
   W1102 10:46:56.128798 434461 fragment_mgr.cpp:238] Got error while opening fragment 21400b93a504478a-bb803e0953fead9f: Internal error: cancelled
   W1102 10:46:56.129115 434461 stream_load_executor.cpp:90] fragment execute failed, query_id=21400b93a504478a-bb803e0953fead9e, err_msg=cancelled, id=21400b93a504478a-bb803e0953fead9e, job_id=15737209, txn_id=66085856, label=ods_china_weather_future_info_td_v1-15737209-21400b93a504478a-bb803e0953fead9e-66085856
   W1102 10:46:56.896185 434434 fragment_mgr.cpp:238] Got error while opening fragment 5c91afdb5917424c-bcea54bf06a172d3: Cancelled: Cancelled
   W1102 10:47:16.141412 434473 routine_load_task_executor.cpp:338] consuming failed
   W1102 10:47:16.141605 195796 broker_scan_node.cpp:373] Scanner[0] process failed. status=cancelled
   W1102 10:47:16.142020 434461 fragment_mgr.cpp:238] Got error while opening fragment 46ad027f5da44657-b1117f1cbeee25d8: Internal error: cancelled
   W1102 10:47:16.142298 434461 stream_load_executor.cpp:90] fragment execute failed, query_id=46ad027f5da44657-b1117f1cbeee25d7, err_msg=cancelled, id=46ad027f5da44657-b1117f1cbeee25d7, job_id=15737209, txn_id=66085890, label=ods_china_weather_future_info_td_v1-15737209-46ad027f5da44657-b1117f1cbeee25d7-66085890
   W1102 10:47:34.959005 434502 tablet.cpp:1376] Trace:
   1102 10:47:30.521492 (+     0us) tablet.cpp:1381] execute cumulative compaction
   1102 10:47:30.521493 (+     1us) cumulative_compaction.cpp:65] got cumulative compaction lock
   1102 10:47:30.521494 (+     1us) compaction.cpp:58] start to do compaction
   1102 10:47:30.521546 (+    52us) compaction.cpp:91] prepare finished
   1102 10:47:34.958330 (+4436784us) compaction.cpp:105] merge rowsets finished
   1102 10:47:34.958528 (+   198us) compaction.cpp:119] output rowset built
   1102 10:47:34.958528 (+     0us) compaction.cpp:123] check correctness finished
   1102 10:47:34.958995 (+   467us) compaction.cpp:127] modify rowsets finished
   1102 10:47:34.959004 (+     9us) cumulative_compaction.cpp:77] compaction finished
   1102 10:47:34.959005 (+     1us) cumulative_compaction.cpp:91] save cumulative compaction metrics
   Metrics: {"filtered_rows":0,"input_row_num":562058,"input_rowsets_data_size":29468059,"input_segments_num":3,"merge_rowsets_latency_us":4436782,"merged_rows":20,"output_row_num":562038,"output_rowset_data_size":29441308,"output_segments_num":1}
   W1102 10:47:35.333396 434500 tablet.cpp:1376] Trace:
   1102 10:47:33.004752 (+     0us) tablet.cpp:1381] execute cumulative compaction
   1102 10:47:33.004754 (+     2us) cumulative_compaction.cpp:65] got cumulative compaction lock
   1102 10:47:33.004756 (+     2us) compaction.cpp:58] start to do compaction
   ```
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] hf200012 commented on issue #6991: [Bug] Error executing insert into select

Posted by GitBox <gi...@apache.org>.
hf200012 commented on issue #6991:
URL: https://github.com/apache/incubator-doris/issues/6991#issuecomment-957145361






-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] hf200012 commented on issue #6991: [Bug] Error executing insert into select

Posted by GitBox <gi...@apache.org>.
hf200012 commented on issue #6991:
URL: https://github.com/apache/incubator-doris/issues/6991#issuecomment-957145361


   After failure, be must be restarted to execute successfully


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] hf200012 commented on issue #6991: [Bug] Error executing insert into select

Posted by GitBox <gi...@apache.org>.
hf200012 commented on issue #6991:
URL: https://github.com/apache/incubator-doris/issues/6991#issuecomment-957145361






-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


[GitHub] [incubator-doris] hf200012 commented on issue #6991: [Bug] Error executing insert into select

Posted by GitBox <gi...@apache.org>.
hf200012 commented on issue #6991:
URL: https://github.com/apache/incubator-doris/issues/6991#issuecomment-957146456


   Only execute this sql without executing the insert operation. There is no problem for 30 consecutive executions. The amount of data returned by this sql is less than 2000 pieces of data.


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org