You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by GitBox <gi...@apache.org> on 2019/06/19 07:59:11 UTC

[GitHub] [incubator-doris] kangpinghuang commented on issue #1333: create rollup table failed

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:
users@infra.apache.org


With regards,
Apache Git Services

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