http://starrocks.io logo
Join Slack
Powered by
getting error : ``` - analytics.outbound_batch_or...
# questions-and-troubleshooting
g
getting error :
Copy code
- analytics.outbound_batch_order_metrics (FAILED) - last_refresh_error_message: Refresh mv outbound_batch_order_metrics failed after 1 times, try lock failed: 0, error-msg : com.starrocks.common.StarRocksException: Failed to get scan range, no queryable replica found in tablet=6953072 replica= schema_hash=638018454 version=1161
    at com.starrocks.planner.OlapScanNode.addScanRangeLocations(OlapScanNode.java:614)
anyone please help
Copy code
analytics.outbound_batch_order_metrics (FAILED) - last_refresh_error_message: Refresh mv outbound_batch_order_metrics failed after 1 times, try lock failed: 0, error-msg : com.starrocks.common.StarRocksException: Failed to get scan range, no queryable replica found in tablet=6953072 replica= schema_hash=638018454 version=1161
    at com.starrocks.planner.OlapScanNode.addScanRangeLocations(OlapScanNode.java:614)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalOlapScan(PlanFragmentBuilder.java:1031)
 [wrapped] com.starrocks.sql.common.StarRocksPlannerException: Build Exec OlapScanNode fail, scan info is invalid
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalOlapScan(PlanFragmentBuilder.java:1037)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalOlapScan(PlanFragmentBuilder.java:454)
    at com.starrocks.sql.optimizer.operator.physical.PhysicalOlapScanOperator.accept(PhysicalOlapScanOperator.java:248)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visit(PlanFragmentBuilder.java:522)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalTopN(PlanFragmentBuilder.java:2578)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalTopN(PlanFragmentBuilder.java:454)
    at com.starrocks.sql.optimizer.operator.physical.PhysicalTopNOperator.accept(PhysicalTopNOperator.java:164)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visit(PlanFragmentBuilder.java:522)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalDistribution(PlanFragmentBuilder.java:2552)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalDistribution(PlanFragmentBuilder.java:454)
    at com.starrocks.sql.optimizer.operator.physical.PhysicalDistributionOperator.accept(PhysicalDistributionOperator.java:75)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visit(PlanFragmentBuilder.java:522)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalTopN(PlanFragmentBuilder.java:2578)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalTopN(PlanFragmentBuilder.java:454)
    at com.starrocks.sql.optimizer.operator.physical.PhysicalTopNOperator.accept(PhysicalTopNOperator.java:164)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visit(PlanFragmentBuilder.java:522)
    at com.starrocks.sql.plan.PlanFragmentBuilder$PhysicalPlanTranslator.visitPhysicalAnalytic(PlanFragmentBuilde
output of show tablet 6953072 analytics,ob_picklist_item_metrics,p20250923,ob_picklist_item_metrics,10007,324952,6953068,324953,true,SHOW PROC '/dbs/10007/324952/partitions/6953068/324953/6953072';
Copy code
SHOW PROC '/dbs/10007/324952/partitions/6953068/324953/6953072';
6953072,[8912281],28MB,458081,0
i have created mv on top of mv, both async, is it the issue?
sorry, in this case this mv depends on two partition table which are getting loaded via routine load
another error:
Copy code
analytics.post_ob_sc_funnel (FAILED) - last_refresh_error_message: Refresh mv post_ob_sc_funnel failed after 1 times, try lock failed: 0, error-msg : org.apache.thrift.transport.TTransportException: Socket is closed by peer.
    at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:177)
    at org.apache.thrift.transport.TTransport.readAll(TTransport.java:100)
    at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:519)
    at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:387)
    at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:271)
    at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
    at com.starrocks.thrift.BackendService$Client.recv_submit_tasks(BackendService.java:240)
    at com.starrocks.thrift.BackendService$Client.submit_tasks(BackendService.java:227)
    at com.starrocks.task.TabletTaskExecutor.lambda$sendTask$4(TabletTaskExecutor.java:348)
    at com.starrocks.rpc.ThriftRPCRequestExecutor.call(ThriftRPCRequestExecutor.java:67)
    at com.starrocks.rpc.ThriftRPCRequestExecutor.call(ThriftRPCRequestExecutor.java:33)
    at com.starrocks.task.TabletTaskExecutor.lambda$sendTask$5(TabletTaskExecutor.java:345)
 [wrapped] java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Socket is closed by peer.
    at com.starrocks.task.TabletTaskExecutor.lambda$sendTask$5(TabletTaskExecutor.java:351)
 [wrapped] java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Socket is closed by peer.
    at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396)
    at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073)
    at com.starrocks.task.TabletTaskExecutor.sendCreateReplicaTasks(TabletTaskExecutor.java:323)
 [wrapped] java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Socket is closed by peer.
    at com.starrocks.task.TabletTaskExecutor.sendCreateReplicaTasks(TabletTaskExecutor.java:329)
some other task are failing due to this: ERRORS: Build Exec OlapScanNode fail, scan info is invalid
r
Can you check the status of your backends and the tablet health?
Copy code
show backends;
show proc '/dbs/10007/324952/partitions/6953068/324953/6953072';
g
The output for this i have already attached above
r
My bad. Can you run this command on your fe and cn log
Copy code
grep "\<6953072\>" fe/log/fe.log
grep "\<6953072\>" be/log/cn.INFO
Open in Slack
PreviousNext
Powered by