Re: [I] [Bug] Msg: 305 executeStatement failed. Fetch Schema failed. [iotdb]

2024-02-27 Thread via GitHub 


myysophia commented on issue #8762:
URL: https://github.com/apache/iotdb/issues/8762#issuecomment-1968022009

   1.2.2 依然有这个报错
   `2024-02-28 09:24:20 [http-nio-80-exec-13] ERROR 
t.n.v.e.i.RestExceptionHandler$Companion [LoggerImpl.kt : 95] - 
handle-exception - 305: [INTERNAL_SERVER_ERROR(305)] Exception occurred: 
"SELECT LAST_VALUE(ep1), LAST_VALUE(ep2) from 
root.emsplus.snAA0001.AMC,root.emsplus.snAA0002.AMC where time < 
2024-02-28T00:00:00.000 ". executeStatement failed. Fetch Schema failed.  -
   81a603be-6b73-4d27-9d58-e5256e470753
   org.apache.iotdb.rpc.StatementExecutionException: 305: 
[INTERNAL_SERVER_ERROR(305)] Exception occurred: "SELECT LAST_VALUE(ep1), 
LAST_VALUE(ep2) from root.emsplus.snAA0001.AMC,root.emsplus.snAA0002.AMC where 
time < 2024-02-28T00:00:00.000 ". executeStatement failed. Fetch Schema failed.
   at org.apache.iotdb.rpc.RpcUtils.verifySuccess(RpcUtils.java:96)
   at 
org.apache.iotdb.rpc.RpcUtils.verifySuccessWithRedirection(RpcUtils.java:116)
   at 
org.apache.iotdb.session.SessionConnection.executeQueryStatement(SessionConnection.java:359)
   at 
org.apache.iotdb.session.Session.executeStatementMayRedirect(Session.java:745)
   at 
org.apache.iotdb.session.Session.executeQueryStatement(Session.java:716)
   at 
org.apache.iotdb.session.pool.SessionPool.executeQueryStatement(SessionPool.java:2707)
   at 
tech.novastar.energy.repository.iotdb.IotTemplateImpl.executeQueryStatement(IotTemplateImpl.kt:149)
   at 
tech.novastar.energy.application.cloud.impl.adapter.IotDBServiceAdapterImpl.findValue(IotDBServiceAdapterImpl.kt:50)
   at 
tech.novastar.energy.application.cloud.impl.adapter.StationServiceAdapterImpl.calculateStationCharged(StationServiceAdapterImpl.kt:131)
   at 
tech.novastar.energy.application.cloud.impl.adapter.StationServiceAdapterImpl.calculateTotalStationCharged(StationServiceAdapterImpl.kt:227)
   at 
tech.novastar.energy.application.cloud.impl.index.IndexRestfulServiceImpl.systemInfo(IndexRestfulServiceImpl.kt:190)
   at jdk.internal.reflect.GeneratedMethodAccessor1679.invoke(Unknown 
Source)
   at 
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.base/java.lang.reflect.Method.invoke(Method.java:566)
   at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
   at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
   at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
   at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
   at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
   at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
   at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
   at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
   at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
   at 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
   at 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
   at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
   at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
   at 
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
   at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
   at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
   at 
tech.novastar.vnnox.communication.impl.restful.HttpRequestFilter.doFilter(HttpRequestFilter.kt:46)
   at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
   at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
   at 
org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:109)
   at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

Re: [I] [Bug] Msg: 305 executeStatement failed. Fetch Schema failed. [iotdb]

2024-01-31 Thread via GitHub 


alextinng commented on issue #8762:
URL: https://github.com/apache/iotdb/issues/8762#issuecomment-1920579541

   > 类似的问题：
   > 
   > ```java
   > 2023-10-10 17:15:42,451 [pool-245-IoTDB-ClientRPC-Processor-8533] WARN  
o.a.i.d.u.ErrorHandlingUtils:63 - Status code: INTERNAL_SERVER_ERROR(305). 
executeStatement failed
   > java.lang.RuntimeException: cannot fetch schema, status is: 301, msg is: 
Execute FragmentInstance failed: Ratis request failed 6@group-000203A5 is 
not in [RUNNING]: current state is CLOSED
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetchExecutor.executeSchemaFetchQuery(ClusterSchemaFetchExecutor.java:205)
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetchExecutor.fetchSchemaOfPreciseMatchOrPreciseDeviceUsingTemplate(ClusterSchemaFetchExecutor.java:116)
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetcher.fetchSchema(ClusterSchemaFetcher.java:139)
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetcher.fetchSchema(ClusterSchemaFetcher.java:50)
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.AnalyzeVisitor.analyzeSchema(AnalyzeVisitor.java:337)
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.AnalyzeVisitor.visitQuery(AnalyzeVisitor.java:233)
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.AnalyzeVisitor.visitQuery(AnalyzeVisitor.java:186)
   > at 
org.apache.iotdb.db.queryengine.plan.statement.crud.QueryStatement.accept(QueryStatement.java:696)
   > at 
org.apache.iotdb.db.queryengine.plan.statement.StatementVisitor.process(StatementVisitor.java:128)
   > at 
org.apache.iotdb.db.queryengine.plan.analyze.Analyzer.analyze(Analyzer.java:48)
   > at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.analyze(QueryExecution.java:309)
   > at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.(QueryExecution.java:169)
   > at 
org.apache.iotdb.db.queryengine.plan.Coordinator.createQueryExecution(Coordinator.java:113)
   > at 
org.apache.iotdb.db.queryengine.plan.Coordinator.execute(Coordinator.java:147)
   > at 
org.apache.iotdb.db.protocol.thrift.impl.ClientRPCServiceImpl.executeStatementInternal(ClientRPCServiceImpl.java:298)
   > at 
org.apache.iotdb.db.protocol.thrift.impl.ClientRPCServiceImpl.executeStatementV2(ClientRPCServiceImpl.java:739)
   > at 
org.apache.iotdb.db.protocol.thrift.impl.ClientRPCServiceImpl.executeQueryStatementV2(ClientRPCServiceImpl.java:729)
   > at 
org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$executeQueryStatementV2.getResult(IClientRPCService.java:3819)
   > at 
org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$executeQueryStatementV2.getResult(IClientRPCService.java:3799)
   > at 
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
   > at 
org.apache.iotdb.db.protocol.thrift.ProcessorWithMetrics.process(ProcessorWithMetrics.java:64)
   > at 
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:248)
   > at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   > at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   > at java.lang.Thread.run(Thread.java:750)
   > 
   > 2023-10-10 16:40:09,628 
[pool-245-IoTDB-ClientRPC-Processor-8553$20231010_084009_82955_6.1.0] ERROR 
o.a.i.d.q.e.e.RegionReadExecutor:85 - Execute FragmentInstance in 
ConsensusGroup SchemaRegion[933] failed.
   > org.apache.iotdb.consensus.exception.RatisRequestFailedException: Ratis 
request failed 6@group-000203A5 is not in [RUNNING]: current state is CLOSED
   > at 
org.apache.iotdb.consensus.ratis.RatisConsensus.read(RatisConsensus.java:351)
   > at 
org.apache.iotdb.db.queryengine.execution.executor.RegionReadExecutor.execute(RegionReadExecutor.java:77)
   > at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchLocally(FragmentInstanceDispatcherImpl.java:350)
   > at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchOneInstance(FragmentInstanceDispatcherImpl.java:246)
   > at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchRead(FragmentInstanceDispatcherImpl.java:122)
   > at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatch(FragmentInstanceDispatcherImpl.java:109)
   > at 
org.apache.iotdb.db.queryengine.plan.scheduler.ClusterScheduler.start(ClusterScheduler.java:115)
   > at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.schedule(QueryExecution.java:342)
   > at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.start(QueryExecution.java:231)

Re: [I] [Bug] Msg: 305 executeStatement failed. Fetch Schema failed. [iotdb]

2023-10-10 Thread via GitHub 


IceMimosa commented on issue #8762:
URL: https://github.com/apache/iotdb/issues/8762#issuecomment-1754806156

   类似的问题：
   
   ```java
   
   2023-10-10 17:15:42,451 [pool-245-IoTDB-ClientRPC-Processor-8533] WARN  
o.a.i.d.u.ErrorHandlingUtils:63 - Status code: INTERNAL_SERVER_ERROR(305). 
executeStatement failed
   java.lang.RuntimeException: cannot fetch schema, status is: 301, msg is: 
Execute FragmentInstance failed: Ratis request failed 6@group-000203A5 is 
not in [RUNNING]: current state is CLOSED
   at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetchExecutor.executeSchemaFetchQuery(ClusterSchemaFetchExecutor.java:205)
   at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetchExecutor.fetchSchemaOfPreciseMatchOrPreciseDeviceUsingTemplate(ClusterSchemaFetchExecutor.java:116)
   at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetcher.fetchSchema(ClusterSchemaFetcher.java:139)
   at 
org.apache.iotdb.db.queryengine.plan.analyze.schema.ClusterSchemaFetcher.fetchSchema(ClusterSchemaFetcher.java:50)
   at 
org.apache.iotdb.db.queryengine.plan.analyze.AnalyzeVisitor.analyzeSchema(AnalyzeVisitor.java:337)
   at 
org.apache.iotdb.db.queryengine.plan.analyze.AnalyzeVisitor.visitQuery(AnalyzeVisitor.java:233)
   at 
org.apache.iotdb.db.queryengine.plan.analyze.AnalyzeVisitor.visitQuery(AnalyzeVisitor.java:186)
   at 
org.apache.iotdb.db.queryengine.plan.statement.crud.QueryStatement.accept(QueryStatement.java:696)
   at 
org.apache.iotdb.db.queryengine.plan.statement.StatementVisitor.process(StatementVisitor.java:128)
   at 
org.apache.iotdb.db.queryengine.plan.analyze.Analyzer.analyze(Analyzer.java:48)
   at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.analyze(QueryExecution.java:309)
   at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.(QueryExecution.java:169)
   at 
org.apache.iotdb.db.queryengine.plan.Coordinator.createQueryExecution(Coordinator.java:113)
   at 
org.apache.iotdb.db.queryengine.plan.Coordinator.execute(Coordinator.java:147)
   at 
org.apache.iotdb.db.protocol.thrift.impl.ClientRPCServiceImpl.executeStatementInternal(ClientRPCServiceImpl.java:298)
   at 
org.apache.iotdb.db.protocol.thrift.impl.ClientRPCServiceImpl.executeStatementV2(ClientRPCServiceImpl.java:739)
   at 
org.apache.iotdb.db.protocol.thrift.impl.ClientRPCServiceImpl.executeQueryStatementV2(ClientRPCServiceImpl.java:729)
   at 
org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$executeQueryStatementV2.getResult(IClientRPCService.java:3819)
   at 
org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$executeQueryStatementV2.getResult(IClientRPCService.java:3799)
   at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
   at 
org.apache.iotdb.db.protocol.thrift.ProcessorWithMetrics.process(ProcessorWithMetrics.java:64)
   at 
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:248)
   at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   at java.lang.Thread.run(Thread.java:750)
   
   2023-10-10 16:40:09,628 
[pool-245-IoTDB-ClientRPC-Processor-8553$20231010_084009_82955_6.1.0] ERROR 
o.a.i.d.q.e.e.RegionReadExecutor:85 - Execute FragmentInstance in 
ConsensusGroup SchemaRegion[933] failed.
   org.apache.iotdb.consensus.exception.RatisRequestFailedException: Ratis 
request failed 6@group-000203A5 is not in [RUNNING]: current state is CLOSED
   at 
org.apache.iotdb.consensus.ratis.RatisConsensus.read(RatisConsensus.java:351)
   at 
org.apache.iotdb.db.queryengine.execution.executor.RegionReadExecutor.execute(RegionReadExecutor.java:77)
   at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchLocally(FragmentInstanceDispatcherImpl.java:350)
   at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchOneInstance(FragmentInstanceDispatcherImpl.java:246)
   at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchRead(FragmentInstanceDispatcherImpl.java:122)
   at 
org.apache.iotdb.db.queryengine.plan.scheduler.FragmentInstanceDispatcherImpl.dispatch(FragmentInstanceDispatcherImpl.java:109)
   at 
org.apache.iotdb.db.queryengine.plan.scheduler.ClusterScheduler.start(ClusterScheduler.java:115)
   at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.schedule(QueryExecution.java:342)
   at 
org.apache.iotdb.db.queryengine.plan.execution.QueryExecution.start(QueryExecution.java:231)
   at