kangpinghuang commented on issue #1333: create rollup table failed URL: https://github.com/apache/incubator-doris/issues/1333#issuecomment-503451780 use show alter table to see the job, the job history will be deleted in 12 hours, so the history will be missing. And the grep the audit log, I found the sql log. So I grep the fe.log and found the following log: 2019-06-17 10:24:14,592 INFO 17200 [StmtExecutor.analyze():338] begin to analyze stmt: 27201956 2019-06-17 10:24:14,624 INFO 17200 [Database.checkQuota():243] database[default_cluster:fengjing] data quota: left bytes: 78.672 TB / total: 200.000 TB 2019-06-17 10:24:14,625 INFO 17200 [RollupHandler.processAddRollup():100] process add rollup[log_data_trace_query_rollup] based on [null] 2019-06-17 10:24:14,628 INFO 15187 [QeProcessorImpl.unregisterQuery():68] deregister query id 99c4438778dd4429-b549b315df9d6319 2019-06-17 10:24:14,629 INFO 15187 [StmtExecutor.analyze():338] begin to analyze stmt: 27201957 2019-06-17 10:24:14,634 INFO 17200 [AlterHandler.addAlterJob():75] add rollup job[44295067] 2019-06-19 01:28:36,671 INFO 10352 [Coordinator.traceInstance():348] query id=63111b60c65b4d92-87b16c16202a50f7,fragment=[F00{plan=AGGREGATE (update finalize)(OlapScan Node),instance=[{id=63111b60c65b4d92-87b16c16202a50f8,host=TNetworkAddress(hostname:1*, port:9060),range=[id0,range=[{tid=44350062,ver=500}]]}]}] 2019-06-19 01:28:36,677 INFO 26 [RollupJob.tryFinishJob():704] create rollup index[44436500] finished in partition[44328252] 2019-06-19 01:28:36,677 WARN 26 [RollupJob.tryFinishJob():661] replica [[replicaId=44437622, BackendId=10033, version=-1, versionHash=0, dataSize=23176316502, rowCount=270414809, lastFailedVersion=9681, lastFailedVersionHash=3784291257667412394, lastSuccessVersion=10468, lastSuccessVersionHash=2021636897179037639, lastFailedTimestamp=1560810682059, schemaHash=1948936074, state=ROLLUP]] last failed version > 0 and have finished history rollup job, its a bad replica, remove it from rollup tablet 2019-06-19 01:28:36,677 WARN 26 [RollupJob.tryFinishJob():661] replica [[replicaId=44437623, BackendId=10025, version=-1, versionHash=0, dataSize=21899413237, rowCount=270411059, lastFailedVersion=10133, lastFailedVersionHash=8653497327105978753, lastSuccessVersion=10468, lastSuccessVersionHash=2021636897179037639, lastFailedTimestamp=1560832744914, schemaHash=1948936074, state=ROLLUP]] last failed version > 0 and have finished history rollup job, its a bad replica, remove it from rollup tablet 2019-06-19 01:28:36,677 WARN 26 [RollupJob.tryFinishJob():661] replica [[replicaId=44437624, BackendId=10026, version=-1, versionHash=0, dataSize=23338912747, rowCount=270153986, lastFailedVersion=9145, lastFailedVersionHash=2374855925960547368, lastSuccessVersion=10468, lastSuccessVersionHash=2021636897179037639, lastFailedTimestamp=1560786244552, schemaHash=1948936074, state=ROLLUP]] last failed version > 0 and have finished history rollup job, its a bad replica, remove it from rollup tablet 2019-06-19 01:28:36,678 WARN 26 [RollupJob.tryFinishJob():677] rollup job[44295067] cancelled. rollup tablet[44437621] has few health replica. num: 0 2019-06-19 01:28:36,678 WARN 26 [RollupHandler.runOneCycle():594] cancel rollup[log_data_trace_query_rollup] cause bad rollup job[44295067] 2019-06-19 01:28:36,685 INFO 26 [AlterHandler.addFinishedOrCancelledAlterJob():134] add rollup job[44295067] to finished or cancel list It seems that the rollup job failed because of the drawback of replicas' version
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
