taosdata / TDengine

High-performance, scalable time-series database designed for Industrial IoT (IIoT) scenarios
https://tdengine.com
GNU Affero General Public License v3.0
23.24k stars 4.84k forks source link

Error: SpringBoot + Mybatis generates core dump file, resulting in Java process being killed #14457

Closed fgdsfgfdsgdsfgsdfg closed 4 months ago

fgdsfgfdsgdsfgsdfg commented 2 years ago

Bug Description springboot +mybatis 执行SQL报错:生成了异常文件

#

A fatal error has been detected by the Java Runtime Environment:

#

EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x00007ffa1c685de1, pid=6296, tid=0x0000000000002c78

#

JRE version: Java(TM) SE Runtime Environment (8.0_231-b11) (build 1.8.0_231-b11)

Java VM: Java HotSpot(TM) 64-Bit Server VM (25.231-b11 mixed mode windows-amd64 compressed oops)

Problematic frame:

C [taos.dll+0x245de1]

#

Failed to write core dump. Minidumps are not enabled by default on client versions of Windows

#

If you would like to submit a bug report, please visit:

http://bugreport.java.com/bugreport/crash.jsp

The crash happened outside the Java Virtual Machine in native code.

See problematic frame for where to report the bug.

#

--------------- T H R E A D ---------------

Current thread (0x000000001ead5000): JavaThread "http-nio-8099-exec-2" daemon [_thread_in_native, id=11384, stack(0x0000000021a70000,0x0000000021b70000)]

siginfo: ExceptionCode=0xc0000005, reading address 0x0000000000000008

Registers: RAX=0x0000000000000000, RBX=0x000000002266aa30, RCX=0x0000000021b5f1f8, RDX=0x00000000010c0000 RSP=0x0000000021b5f090, RBP=0x0000000021b6bc30, RSI=0x00000000200fe98e, RDI=0x0000000021b5f1a8 R8 =0x0000000000d83300, R9 =0x0000000000000001, R10=0x0000000000008000, R11=0x0000000021b5f140 R12=0x0000000000000000, R13=0x000000002266aa30, R14=0x0000000021b6bc78, R15=0x000000001ead5000 RIP=0x00007ffa1c685de1, EFLAGS=0x0000000000010217

Top of Stack: (sp=0x0000000021b5f090) 0x0000000021b5f090: cccccccccccccccc cccccccccccccccc 0x0000000021b5f0a0: cccccccccccccccc cccccccccccccccc 0x0000000021b5f0b0: 0000000000000000 00000000cccccccc 0x0000000021b5f0c0: cccccccccccccccc cccccccccccccccc 0x0000000021b5f0d0: cccccccccccccccc cccccccccccccccc 0x0000000021b5f0e0: cccccccccccccccc cccccccccccccccc 0x0000000021b5f0f0: cccccccccccccccc cccccccccccccccc 0x0000000021b5f100: cccccccccccccccc cccccccccccccccc 0x0000000021b5f110: cccccccccccccccc cccccccccccccccc 0x0000000021b5f120: cccccccccccccccc cccccccccccccccc 0x0000000021b5f130: cccccccccccccccc cccccccccccccccc 0x0000000021b5f140: cccccccccccccccc cccccccccccccccc 0x0000000021b5f150: cccccccccccccccc cccccccccccccccc 0x0000000021b5f160: cccccccccccccccc cccccccccccccccc 0x0000000021b5f170: cccccccccccccccc cccccccccccccccc 0x0000000021b5f180: cccccccccccccccc cccccccccccccccc

Instructions: (pc=0x00007ffa1c685de1) 0x00007ffa1c685dc1: 74 09 8b 44 24 2c e9 a6 02 00 00 48 8b 84 24 30 0x00007ffa1c685dd1: 01 00 00 48 8b 00 48 89 44 24 20 48 8b 44 24 20 0x00007ffa1c685de1: 8b 40 08 89 44 24 28 83 7c 24 28 00 0f 8c d9 00 0x00007ffa1c685df1: 00 00 48 8b 44 24 20 b9 01 00 00 00 48 89 84 24

Register to memory mapping:

RAX=0x0000000000000000 is an unknown value RBX={method} {0x000000002266aa38} 'fetchRowImp' '(JJLcom/taosdata/jdbc/TSDBResultSetRowData;)I' in 'com/taosdata/jdbc/TSDBJNIConnector' RCX=0x0000000021b5f1f8 is pointing into the stack for thread: 0x000000001ead5000 RDX=0x00000000010c0000 is an unknown value RSP=0x0000000021b5f090 is pointing into the stack for thread: 0x000000001ead5000 RBP=0x0000000021b6bc30 is pointing into the stack for thread: 0x000000001ead5000 RSI=0x00000000200fe98e is pointing into metadata RDI=0x0000000021b5f1a8 is pointing into the stack for thread: 0x000000001ead5000 R8 =0x0000000000d83300 is an unknown value R9 =0x0000000000000001 is an unknown value R10=0x0000000000008000 is an unknown value R11=0x0000000021b5f140 is pointing into the stack for thread: 0x000000001ead5000 R12=0x0000000000000000 is an unknown value R13={method} {0x000000002266aa38} 'fetchRowImp' '(JJLcom/taosdata/jdbc/TSDBResultSetRowData;)I' in 'com/taosdata/jdbc/TSDBJNIConnector' R14=0x0000000021b6bc78 is pointing into the stack for thread: 0x000000001ead5000 R15=0x000000001ead5000 is a thread

Stack: [0x0000000021a70000,0x0000000021b70000], sp=0x0000000021b5f090, free space=956k Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) C [taos.dll+0x245de1] C [taos.dll+0x2449d8] C [taos.dll+0x95395] C [taos.dll+0x7164] C [taos.dll+0x62834] C [taos.dll+0x62caa] C [taos.dll+0x5d64d] C [taos.dll+0x738a] C [taos.dll+0x73d3] C [taos.dll+0x10e0a] C [taos.dll+0x953ef] C [taos.dll+0x7164] C [taos.dll+0x62c44] C [taos.dll+0x5d64d] C [taos.dll+0x77ad] C [taos.dll+0x6b7b9] C [taos.dll+0x3377] C 0x0000000003521b30

Java frames: (J=compiled Java code, j=interpreted, Vv=VM code) j com.taosdata.jdbc.TSDBJNIConnector.fetchRowImp(JJLcom/taosdata/jdbc/TSDBResultSetRowData;)I+0 j com.taosdata.jdbc.TSDBJNIConnector.fetchRow(JLcom/taosdata/jdbc/TSDBResultSetRowData;)I+7 j com.taosdata.jdbc.TSDBResultSet.next()Z+122 j com.zaxxer.hikari.pool.HikariProxyResultSet.next()Z+4 j org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(Lorg/apache/ibatis/executor/resultset/ResultSetWrapper;Lorg/apache/ibatis/mapping/ResultMap;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/mapping/ResultMapping;)V+46 j org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(Lorg/apache/ibatis/executor/resultset/ResultSetWrapper;Lorg/apache/ibatis/mapping/ResultMap;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/mapping/ResultMapping;)V+37 j org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(Lorg/apache/ibatis/executor/resultset/ResultSetWrapper;Lorg/apache/ibatis/mapping/ResultMap;Ljava/util/List;Lorg/apache/ibatis/mapping/ResultMapping;)V+50 j org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(Ljava/sql/Statement;)Ljava/util/List;+94 j org.apache.ibatis.executor.statement.PreparedStatementHandler.query(Ljava/sql/Statement;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List;+17 j org.apache.ibatis.executor.statement.RoutingStatementHandler.query(Ljava/sql/Statement;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List;+6 j org.apache.ibatis.executor.SimpleExecutor.doQuery(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List;+45 j org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/cache/CacheKey;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List;+20 j org.apache.ibatis.executor.BaseExecutor.query(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/cache/CacheKey;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List;+119 j org.apache.ibatis.executor.CachingExecutor.query(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;Lorg/apache/ibatis/cache/CacheKey;Lorg/apache/ibatis/mapping/BoundSql;)Ljava/util/List;+105 j com.github.pagehelper.PageInterceptor.intercept(Lorg/apache/ibatis/plugin/Invocation;)Ljava/lang/Object;+276 j org.apache.ibatis.plugin.Plugin.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object;+51 j com.sun.proxy.$Proxy203.query(Lorg/apache/ibatis/mapping/MappedStatement;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;Lorg/apache/ibatis/session/ResultHandler;)Ljava/util/List;+29 j org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Ljava/lang/String;Ljava/lang/Object;Lorg/apache/ibatis/session/RowBounds;)Ljava/util/List;+25 j org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List;+6 v ~StubRoutines::call_stub j sun.reflect.NativeMethodAccessorImpl.invoke0(Ljava/lang/reflect/Method;Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;+0 j sun.reflect.NativeMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;+100 j sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;+6 j java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;+56 j org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object;+30 j com.sun.proxy.$Proxy111.selectList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List;+20 j org.mybatis.spring.SqlSessionTemplate.selectList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List;+6 j org.apache.ibatis.binding.MapperMethod.executeForMany(Lorg/apache/ibatis/session/SqlSession;[Ljava/lang/Object;)Ljava/lang/Object;+61 j org.apache.ibatis.binding.MapperMethod.execute(Lorg/apache/ibatis/session/SqlSession;[Ljava/lang/Object;)Ljava/lang/Object;+191 j org.apache.ibatis.binding.MapperProxy.invoke(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object;+73 j com.sun.proxy.$Proxy120.getActiveInfo(Ljava/lang/String;Ljava/util/ArrayList;)Ljava/util/List;+20 j com.device.service.impl.GatewayServiceImpl.getStatusBySnType(Lcom/tsdata/model/HostInfoVo;)Ljava/util/List;+168 j com.device.service.impl.GatewayServiceImpl$$FastClassBySpringCGLIB$$a317117b.invoke(ILjava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;+178 j org.springframework.cglib.proxy.MethodProxy.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;+19 j org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(Ljava/lang/Object;Ljava/lang/reflect/Method;[Ljava/lang/Object;Lorg/springframework/cglib/proxy/MethodProxy;)Ljava/lang/Object;+107 j com.device.service.impl.GatewayServiceImpl$$EnhancerBySpringCGLIB$$b3f83483.getStatusBySnType(Lcom/tsdata/model/HostInfoVo;)Ljava/util/List;+36 j com.device.controller.GatewayController.getStatusBySnType(Lcom/tsdata/model/HostInfoVo;)Lcom/device/common/RestResult;+42 v ~StubRoutines::call_stub J 2158 sun.reflect.NativeMethodAccessorImpl.invoke0(Ljava/lang/reflect/Method;Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (0 bytes) @ 0x000000000397efbf [0x000000000397ef40+0x7f] J 2157 C1 sun.reflect.NativeMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (104 bytes) @ 0x000000000397f754 [0x000000000397f3a0+0x3b4] J 2143 C1 sun.reflect.DelegatingMethodAccessorImpl.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (10 bytes) @ 0x00000000039795fc [0x00000000039795a0+0x5c] J 2142 C1 java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; (62 bytes) @ 0x000000000397854c [0x0000000003978420+0x12c] j org.springframework.web.method.support.InvocableHandlerMethod.doInvoke([Ljava/lang/Object;)Ljava/lang/Object;+16 j org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(Lorg/springframework/web/context/request/NativeWebRequest;Lorg/springframework/web/method/support/ModelAndViewContainer;[Ljava/lang/Object;)Ljava/lang/Object;+56 j org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(Lorg/springframework/web/context/request/ServletWebRequest;Lorg/springframework/web/method/support/ModelAndViewContainer;[Ljava/lang/Object;)V+4 j org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Lorg/springframework/web/method/HandlerMethod;)Lorg/springframework/web/servlet/ModelAndView;+244 j org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Lorg/springframework/web/method/HandlerMethod;)Lorg/springframework/web/servlet/ModelAndView;+81 j org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljava/lang/Object;)Lorg/springframework/web/servlet/ModelAndView;+7 j org.springframework.web.servlet.DispatcherServlet.doDispatch(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+257 j org.springframework.web.servlet.DispatcherServlet.doService(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+212 j org.springframework.web.servlet.FrameworkServlet.processRequest(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+71 j org.springframework.web.servlet.FrameworkServlet.doPost(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+3 j javax.servlet.http.HttpServlet.service(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+149 j org.springframework.web.servlet.FrameworkServlet.service(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;)V+33 j javax.servlet.http.HttpServlet.service(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+36 j org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+304 j org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101 j org.apache.tomcat.websocket.server.WsFilter.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Ljavax/servlet/FilterChain;)V+21 j org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+135 j org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101 j org.springframework.web.filter.RequestContextFilter.doFilterInternal(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljavax/servlet/FilterChain;)V+21 j org.springframework.web.filter.OncePerRequestFilter.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Ljavax/servlet/FilterChain;)V+147 j org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+135 j org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101 j org.springframework.web.filter.FormContentFilter.doFilterInternal(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljavax/servlet/FilterChain;)V+38 j org.springframework.web.filter.OncePerRequestFilter.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Ljavax/servlet/FilterChain;)V+147 j org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+135 j org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101 j org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljavax/servlet/FilterChain;)V+53 j org.springframework.web.filter.OncePerRequestFilter.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;Ljavax/servlet/FilterChain;)V+147 j org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+135 j org.apache.catalina.core.ApplicationFilterChain.doFilter(Ljavax/servlet/ServletRequest;Ljavax/servlet/ServletResponse;)V+101 j org.apache.catalina.core.StandardWrapperValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+694 j org.apache.catalina.core.StandardContextValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+166 j org.apache.catalina.authenticator.AuthenticatorBase.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+260 j org.apache.catalina.core.StandardHostValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+114 j org.apache.catalina.valves.ErrorReportValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+6 j org.apache.catalina.core.StandardEngineValve.invoke(Lorg/apache/catalina/connector/Request;Lorg/apache/catalina/connector/Response;)V+45 j org.apache.catalina.connector.CoyoteAdapter.service(Lorg/apache/coyote/Request;Lorg/apache/coyote/Response;)V+199 j org.apache.coyote.http11.Http11Processor.service(Lorg/apache/tomcat/util/net/SocketWrapperBase;)Lorg/apache/tomcat/util/net/AbstractEndpoint$Handler$SocketState;+784 j org.apache.coyote.AbstractProcessorLight.process(Lorg/apache/tomcat/util/net/SocketWrapperBase;Lorg/apache/tomcat/util/net/SocketEvent;)Lorg/apache/tomcat/util/net/AbstractEndpoint$Handler$SocketState;+113 j org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Lorg/apache/tomcat/util/net/SocketWrapperBase;Lorg/apache/tomcat/util/net/SocketEvent;)Lorg/apache/tomcat/util/net/AbstractEndpoint$Handler$SocketState;+442 j org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun()V+221 j org.apache.tomcat.util.net.SocketProcessorBase.run()V+21 j java.util.concurrent.ThreadPoolExecutor.runWorker(Ljava/util/concurrent/ThreadPoolExecutor$Worker;)V+95 j java.util.concurrent.ThreadPoolExecutor$Worker.run()V+5 j org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run()V+4 j java.lang.Thread.run()V+11 v ~StubRoutines::call_stub

--------------- P R O C E S S ---------------

Java Threads: ( => current thread ) 0x0000000020487800 JavaThread "logback-7" daemon [_thread_blocked, id=6880, stack(0x000000001af00000,0x000000001b000000)] 0x0000000020486000 JavaThread "logback-6" daemon [_thread_blocked, id=12624, stack(0x000000001ac00000,0x000000001ad00000)] 0x0000000020483800 JavaThread "logback-5" daemon [_thread_blocked, id=1200, stack(0x0000000001490000,0x0000000001590000)] 0x000000002047a000 JavaThread "logback-4" daemon [_thread_blocked, id=18372, stack(0x0000000001390000,0x0000000001490000)] 0x000000002047c000 JavaThread "logback-3" daemon [_thread_blocked, id=8404, stack(0x0000000001290000,0x0000000001390000)] 0x0000000020480800 JavaThread "HikariPool-2 housekeeper" daemon [_thread_blocked, id=10136, stack(0x0000000029fa0000,0x000000002a0a0000)] 0x0000000020480000 JavaThread "lettuce-nioEventLoop-4-4" daemon [_thread_in_native, id=20444, stack(0x0000000028e90000,0x0000000028f90000)] 0x0000000020478800 JavaThread "lettuce-nioEventLoop-4-3" daemon [_thread_in_native, id=20848, stack(0x0000000027b80000,0x0000000027c80000)] 0x000000002047f000 JavaThread "lettuce-eventExecutorLoop-1-4" daemon [_thread_blocked, id=19760, stack(0x0000000027a80000,0x0000000027b80000)] 0x000000002047b800 JavaThread "lettuce-eventExecutorLoop-1-3" daemon [_thread_blocked, id=10156, stack(0x0000000027980000,0x0000000027a80000)] 0x000000002047e800 JavaThread "lettuce-eventExecutorLoop-1-2" daemon [_thread_blocked, id=11192, stack(0x0000000027880000,0x0000000027980000)] 0x000000002047d800 JavaThread "lettuce-eventExecutorLoop-1-1" daemon [_thread_blocked, id=3160, stack(0x0000000027780000,0x0000000027880000)] 0x000000002047d000 JavaThread "lettuce-nioEventLoop-4-2" daemon [_thread_in_native, id=13836, stack(0x0000000025660000,0x0000000025760000)] 0x000000002047a800 JavaThread "lettuce-nioEventLoop-4-1" daemon [_thread_in_native, id=8584, stack(0x0000000025560000,0x0000000025660000)] 0x0000000020479000 JavaThread "commons-pool-evictor" daemon [_thread_blocked, id=19596, stack(0x000000001c3d0000,0x000000001c4d0000)] 0x000000001eae0000 JavaThread "DestroyJavaVM" [_thread_blocked, id=12592, stack(0x0000000003200000,0x0000000003300000)] 0x000000001eadf800 JavaThread "HikariPool-1 housekeeper" daemon [_thread_blocked, id=11924, stack(0x0000000024f60000,0x0000000025060000)] 0x000000001ead8000 JavaThread "http-nio-8099-Acceptor" daemon [_thread_in_native, id=15492, stack(0x0000000022470000,0x0000000022570000)] 0x000000001eade800 JavaThread "http-nio-8099-ClientPoller" daemon [_thread_in_native, id=20892, stack(0x0000000022370000,0x0000000022470000)] 0x000000001eade000 JavaThread "http-nio-8099-exec-10" daemon [_thread_blocked, id=16408, stack(0x0000000022270000,0x0000000022370000)] 0x000000001ead6800 JavaThread "http-nio-8099-exec-9" daemon [_thread_blocked, id=18180, stack(0x0000000022170000,0x0000000022270000)] 0x000000001eadd000 JavaThread "http-nio-8099-exec-8" daemon [_thread_blocked, id=4836, stack(0x0000000022070000,0x0000000022170000)] 0x000000001eadc800 JavaThread "http-nio-8099-exec-7" daemon [_thread_blocked, id=8120, stack(0x0000000021f70000,0x0000000022070000)] 0x000000001eadb800 JavaThread "http-nio-8099-exec-6" daemon [_thread_blocked, id=11280, stack(0x0000000021e70000,0x0000000021f70000)] 0x000000001ead4000 JavaThread "http-nio-8099-exec-5" daemon [_thread_blocked, id=12052, stack(0x0000000021d70000,0x0000000021e70000)] 0x000000001eadb000 JavaThread "http-nio-8099-exec-4" daemon [_thread_blocked, id=17432, stack(0x0000000021c70000,0x0000000021d70000)] 0x000000001ead3800 JavaThread "http-nio-8099-exec-3" daemon [_thread_blocked, id=6172, stack(0x0000000021b70000,0x0000000021c70000)] =>0x000000001ead5000 JavaThread "http-nio-8099-exec-2" daemon [_thread_in_native, id=11384, stack(0x0000000021a70000,0x0000000021b70000)] 0x000000001eada000 JavaThread "http-nio-8099-exec-1" daemon [_thread_blocked, id=17868, stack(0x0000000021970000,0x0000000021a70000)] 0x000000001ead7000 JavaThread "http-nio-8099-BlockPoller" daemon [_thread_in_native, id=14248, stack(0x0000000021870000,0x0000000021970000)] 0x000000001ead8800 JavaThread "spring.cloud.inetutils" daemon [_thread_blocked, id=13300, stack(0x0000000021570000,0x0000000021670000)] 0x000000001ead9800 JavaThread "File Watcher" daemon [_thread_blocked, id=19004, stack(0x000000001fda0000,0x000000001fea0000)] 0x000000001bc4f000 JavaThread "Live Reload Server" daemon [_thread_in_native, id=18176, stack(0x000000001fea0000,0x000000001ffa0000)] 0x000000001bc4c800 JavaThread "mysql-cj-abandoned-connection-cleanup" daemon [_thread_blocked, id=9020, stack(0x000000001f6a0000,0x000000001f7a0000)] 0x000000001bc50800 JavaThread "container-0" [_thread_blocked, id=17556, stack(0x000000001f5a0000,0x000000001f6a0000)] 0x000000001bc4c000 JavaThread "Catalina-utility-2" [_thread_blocked, id=9712, stack(0x000000001f4a0000,0x000000001f5a0000)] 0x000000001bc52000 JavaThread "Catalina-utility-1" [_thread_blocked, id=19440, stack(0x000000001f3a0000,0x000000001f4a0000)] 0x000000001bc51800 JavaThread "logback-2" daemon [_thread_blocked, id=18836, stack(0x000000001c5d0000,0x000000001c6d0000)] 0x000000001a587800 JavaThread "RMI Scheduler(0)" daemon [_thread_blocked, id=16644, stack(0x000000001b000000,0x000000001b100000)] 0x000000001a4cf000 JavaThread "RMI TCP Accept-0" daemon [_thread_in_native, id=14736, stack(0x000000001ad00000,0x000000001ae00000)] 0x000000001a4c2000 JavaThread "RMI TCP Accept-3006" daemon [_thread_in_native, id=8984, stack(0x000000001ab00000,0x000000001ac00000)] 0x000000001a4b2800 JavaThread "RMI TCP Accept-0" daemon [_thread_in_native, id=20080, stack(0x000000001aa00000,0x000000001ab00000)] 0x000000001a1ff800 JavaThread "Service Thread" daemon [_thread_blocked, id=15972, stack(0x000000001a900000,0x000000001aa00000)] 0x000000001a1f8800 JavaThread "C1 CompilerThread2" daemon [_thread_blocked, id=20304, stack(0x000000001a800000,0x000000001a900000)] 0x000000001a1a3000 JavaThread "C2 CompilerThread1" daemon [_thread_blocked, id=10648, stack(0x000000001a700000,0x000000001a800000)] 0x000000001a19e800 JavaThread "C2 CompilerThread0" daemon [_thread_blocked, id=16416, stack(0x000000001a600000,0x000000001a700000)] 0x0000000018167800 JavaThread "JDWP Command Reader" daemon [_thread_in_native, id=13812, stack(0x0000000019d00000,0x0000000019e00000)] 0x0000000018163800 JavaThread "JDWP Event Helper Thread" daemon [_thread_blocked, id=14312, stack(0x0000000019c00000,0x0000000019d00000)] 0x0000000018160000 JavaThread "JDWP Transport Listener: dt_socket" daemon [_thread_blocked, id=15136, stack(0x0000000019b00000,0x0000000019c00000)] 0x0000000019543800 JavaThread "Attach Listener" daemon [_thread_blocked, id=16484, stack(0x0000000019a00000,0x0000000019b00000)] 0x0000000018122800 JavaThread "Signal Dispatcher" daemon [_thread_blocked, id=14212, stack(0x0000000019900000,0x0000000019a00000)] 0x00000000033fe000 JavaThread "Finalizer" daemon [_thread_blocked, id=20000, stack(0x00000000193a0000,0x00000000194a0000)] 0x00000000033fb000 JavaThread "Reference Handler" daemon [_thread_blocked, id=12584, stack(0x00000000192a0000,0x00000000193a0000)]

Other Threads: 0x00000000180e7800 VMThread [stack: 0x00000000191a0000,0x00000000192a0000] [id=4228] 0x000000001a4d4000 WatcherThread [stack: 0x000000001ae00000,0x000000001af00000] [id=21176]

VM state:not at safepoint (normal execution)

VM Mutex/Monitor currently owned by a thread: None

heap address: 0x0000000080000000, size: 2048 MB, Compressed Oops mode: 32-bit Narrow klass base: 0x0000000000000000, Narrow klass shift: 3 Compressed class space size: 1073741824 Address: 0x0000000100000000

Heap: PSYoungGen total 568832K, used 500271K [0x00000000d5580000, 0x0000000100000000, 0x0000000100000000) eden space 538112K, 92% used [0x00000000d5580000,0x00000000f3e0bf18,0x00000000f6300000) from space 30720K, 0% used [0x00000000f6300000,0x00000000f6300000,0x00000000f8100000) to space 30208K, 0% used [0x00000000fe280000,0x00000000fe280000,0x0000000100000000) ParOldGen total 119808K, used 37087K [0x0000000080000000, 0x0000000087500000, 0x00000000d5580000) object space 119808K, 30% used [0x0000000080000000,0x0000000082437e88,0x0000000087500000) Metaspace used 66376K, capacity 70348K, committed 70576K, reserved 1110016K class space used 8701K, capacity 9371K, committed 9392K, reserved 1048576K

Card table byte_map: [0x00000000128c0000,0x0000000012cd0000] byte_map_base: 0x00000000124c0000

Marking Bits: (ParMarkBitMap*) 0x0000000067676d90 Begin Bits: [0x0000000013380000, 0x0000000015380000) End Bits: [0x0000000015380000, 0x0000000017380000)

Polling page: 0x0000000001020000

CodeCache: size=245760Kb used=14524Kb max_used=14524Kb free=231235Kb bounds [0x0000000003500000, 0x0000000004340000, 0x0000000012500000] total_blobs=8018 nmethods=7409 adapters=529 compilation: enabled

Compilation events (10 events): Event: 342.888 Thread 0x000000001a1f8800 7544 1 com.fasterxml.jackson.core.json.UTF8JsonGenerator::writeString (115 bytes) Event: 342.888 Thread 0x000000001a1f8800 nmethod 7544 0x000000000432f110 code [0x000000000432f2c0, 0x000000000432f618] Event: 342.888 Thread 0x000000001a1f8800 7545 1 java.nio.Buffer::nextPutIndex (31 bytes) Event: 342.888 Thread 0x000000001a1f8800 nmethod 7545 0x000000000432f8d0 code [0x000000000432fa40, 0x000000000432fbe8] Event: 342.888 Thread 0x000000001a1f8800 7546 1 java.nio.HeapByteBuffer::put (16 bytes) Event: 342.889 Thread 0x000000001a1f8800 nmethod 7546 0x000000000432fcd0 code [0x000000000432fe40, 0x0000000004330008] Event: 342.891 Thread 0x000000001a1f8800 7547 1 com.fasterxml.jackson.databind.ser.std.NullSerializer::serialize (5 bytes) Event: 342.891 Thread 0x000000001a1f8800 nmethod 7547 0x00000000043301d0 code [0x0000000004330320, 0x0000000004330468] Event: 342.891 Thread 0x000000001a1f8800 7548 1 com.fasterxml.jackson.core.json.UTF8JsonGenerator::writeNull (11 bytes) Event: 342.891 Thread 0x000000001a1f8800 nmethod 7548 0x0000000004330510 code [0x0000000004330680, 0x00000000043307d8]

GC Heap History (10 events): Event: 11.065 GC heap before {Heap before GC invocations=14 (full 2): PSYoungGen total 305664K, used 290134K [0x00000000d5580000, 0x00000000f0b80000, 0x0000000100000000) eden space 274432K, 100% used [0x00000000d5580000,0x00000000e6180000,0x00000000e6180000) from space 31232K, 50% used [0x00000000e6180000,0x00000000e70d5ba8,0x00000000e8000000) to space 30208K, 0% used [0x00000000eee00000,0x00000000eee00000,0x00000000f0b80000) ParOldGen total 109056K, used 39197K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 35% used [0x0000000080000000,0x0000000082647458,0x0000000086a80000) Metaspace used 32026K, capacity 33334K, committed 33584K, reserved 1079296K class space used 4253K, capacity 4525K, committed 4656K, reserved 1048576K Event: 11.104 GC heap after Heap after GC invocations=14 (full 2): PSYoungGen total 417280K, used 16068K [0x00000000d5580000, 0x00000000f0a80000, 0x0000000100000000) eden space 388096K, 0% used [0x00000000d5580000,0x00000000d5580000,0x00000000ed080000) from space 29184K, 55% used [0x00000000eee00000,0x00000000efdb13b0,0x00000000f0a80000) to space 29696K, 0% used [0x00000000ed080000,0x00000000ed080000,0x00000000eed80000) ParOldGen total 109056K, used 43365K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 39% used [0x0000000080000000,0x0000000082a59488,0x0000000086a80000) Metaspace used 32026K, capacity 33334K, committed 33584K, reserved 1079296K class space used 4253K, capacity 4525K, committed 4656K, reserved 1048576K } Event: 12.706 GC heap before {Heap before GC invocations=15 (full 2): PSYoungGen total 417280K, used 404164K [0x00000000d5580000, 0x00000000f0a80000, 0x0000000100000000) eden space 388096K, 100% used [0x00000000d5580000,0x00000000ed080000,0x00000000ed080000) from space 29184K, 55% used [0x00000000eee00000,0x00000000efdb13b0,0x00000000f0a80000) to space 29696K, 0% used [0x00000000ed080000,0x00000000ed080000,0x00000000eed80000) ParOldGen total 109056K, used 43365K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 39% used [0x0000000080000000,0x0000000082a59488,0x0000000086a80000) Metaspace used 32396K, capacity 33764K, committed 33840K, reserved 1079296K class space used 4312K, capacity 4598K, committed 4656K, reserved 1048576K Event: 12.747 GC heap after Heap after GC invocations=15 (full 2): PSYoungGen total 417792K, used 10485K [0x00000000d5580000, 0x00000000fa180000, 0x0000000100000000) eden space 388096K, 0% used [0x00000000d5580000,0x00000000d5580000,0x00000000ed080000) from space 29696K, 35% used [0x00000000ed080000,0x00000000edabd620,0x00000000eed80000) to space 28672K, 0% used [0x00000000f8580000,0x00000000f8580000,0x00000000fa180000) ParOldGen total 109056K, used 44477K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 40% used [0x0000000080000000,0x0000000082b6f488,0x0000000086a80000) Metaspace used 32396K, capacity 33764K, committed 33840K, reserved 1079296K class space used 4312K, capacity 4598K, committed 4656K, reserved 1048576K } Event: 15.489 GC heap before {Heap before GC invocations=16 (full 2): PSYoungGen total 417792K, used 398581K [0x00000000d5580000, 0x00000000fa180000, 0x0000000100000000) eden space 388096K, 100% used [0x00000000d5580000,0x00000000ed080000,0x00000000ed080000) from space 29696K, 35% used [0x00000000ed080000,0x00000000edabd620,0x00000000eed80000) to space 28672K, 0% used [0x00000000f8580000,0x00000000f8580000,0x00000000fa180000) ParOldGen total 109056K, used 44477K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 40% used [0x0000000080000000,0x0000000082b6f488,0x0000000086a80000) Metaspace used 41917K, capacity 43892K, committed 44080K, reserved 1087488K class space used 5537K, capacity 5926K, committed 5936K, reserved 1048576K Event: 15.538 GC heap after Heap after GC invocations=16 (full 2): PSYoungGen total 564224K, used 23309K [0x00000000d5580000, 0x00000000f9f00000, 0x0000000100000000) eden space 538112K, 0% used [0x00000000d5580000,0x00000000d5580000,0x00000000f6300000) from space 26112K, 89% used [0x00000000f8580000,0x00000000f9c43780,0x00000000f9f00000) to space 30720K, 0% used [0x00000000f6300000,0x00000000f6300000,0x00000000f8100000) ParOldGen total 109056K, used 44925K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 41% used [0x0000000080000000,0x0000000082bdf4a8,0x0000000086a80000) Metaspace used 41917K, capacity 43892K, committed 44080K, reserved 1087488K class space used 5537K, capacity 5926K, committed 5936K, reserved 1048576K } Event: 16.700 GC heap before {Heap before GC invocations=17 (full 2): PSYoungGen total 564224K, used 181567K [0x00000000d5580000, 0x00000000f9f00000, 0x0000000100000000) eden space 538112K, 29% used [0x00000000d5580000,0x00000000df00c720,0x00000000f6300000) from space 26112K, 89% used [0x00000000f8580000,0x00000000f9c43780,0x00000000f9f00000) to space 30720K, 0% used [0x00000000f6300000,0x00000000f6300000,0x00000000f8100000) ParOldGen total 109056K, used 44925K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 41% used [0x0000000080000000,0x0000000082bdf4a8,0x0000000086a80000) Metaspace used 46914K, capacity 49294K, committed 49360K, reserved 1091584K class space used 6198K, capacity 6641K, committed 6704K, reserved 1048576K Event: 16.722 GC heap after Heap after GC invocations=17 (full 2): PSYoungGen total 568832K, used 7775K [0x00000000d5580000, 0x0000000100000000, 0x0000000100000000) eden space 538112K, 0% used [0x00000000d5580000,0x00000000d5580000,0x00000000f6300000) from space 30720K, 25% used [0x00000000f6300000,0x00000000f6a97d88,0x00000000f8100000) to space 30208K, 0% used [0x00000000fe280000,0x00000000fe280000,0x0000000100000000) ParOldGen total 109056K, used 54064K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 49% used [0x0000000080000000,0x00000000834cc278,0x0000000086a80000) Metaspace used 46914K, capacity 49294K, committed 49360K, reserved 1091584K class space used 6198K, capacity 6641K, committed 6704K, reserved 1048576K } Event: 16.722 GC heap before {Heap before GC invocations=18 (full 3): PSYoungGen total 568832K, used 7775K [0x00000000d5580000, 0x0000000100000000, 0x0000000100000000) eden space 538112K, 0% used [0x00000000d5580000,0x00000000d5580000,0x00000000f6300000) from space 30720K, 25% used [0x00000000f6300000,0x00000000f6a97d88,0x00000000f8100000) to space 30208K, 0% used [0x00000000fe280000,0x00000000fe280000,0x0000000100000000) ParOldGen total 109056K, used 54064K [0x0000000080000000, 0x0000000086a80000, 0x00000000d5580000) object space 109056K, 49% used [0x0000000080000000,0x00000000834cc278,0x0000000086a80000) Metaspace used 46914K, capacity 49294K, committed 49360K, reserved 1091584K class space used 6198K, capacity 6641K, committed 6704K, reserved 1048576K Event: 16.920 GC heap after Heap after GC invocations=18 (full 3): PSYoungGen total 568832K, used 0K [0x00000000d5580000, 0x0000000100000000, 0x0000000100000000) eden space 538112K, 0% used [0x00000000d5580000,0x00000000d5580000,0x00000000f6300000) from space 30720K, 0% used [0x00000000f6300000,0x00000000f6300000,0x00000000f8100000) to space 30208K, 0% used [0x00000000fe280000,0x00000000fe280000,0x0000000100000000) ParOldGen total 119808K, used 37087K [0x0000000080000000, 0x0000000087500000, 0x00000000d5580000) object space 119808K, 30% used [0x0000000080000000,0x0000000082437e88,0x0000000087500000) Metaspace used 46884K, capacity 49246K, committed 49360K, reserved 1091584K class space used 6194K, capacity 6633K, committed 6704K, reserved 1048576K }

Deoptimization events (0 events): No events

Classes redefined (0 events): No events

Internal exceptions (10 events): Event: 342.887 Thread 0x000000001ead5000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException': 6> (0x00000000f23a66a0) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\interpreterRuntime.cpp, line 368] Event: 342.888 Thread 0x000000001ead5000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException': 22> (0x00000000f23a78e0) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\interpreterRuntime.cpp, line 368] Event: 342.888 Thread 0x000000001ead5000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException': 23> (0x00000000f23a88b0) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\interpreterRuntime.cpp, line 368] Event: 342.888 Thread 0x000000001ead5000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException': 22> (0x00000000f23a99b0) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\interpreterRuntime.cpp, line 368] Event: 342.889 Thread 0x000000001ead5000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException': 105> (0x00000000f23ab578) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\interpreterRuntime.cpp, line 368] Event: 342.894 Thread 0x000000001eada000 Exception <a 'java/io/IOException'> (0x00000000f3897d40) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\prims\jni.cpp, line 710] Event: 342.896 Thread 0x000000001ead5000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException': 40> (0x00000000f39d8890) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\interpreterRuntime.cpp, line 368] Event: 342.897 Thread 0x000000001ead5000 Exception <a 'java/lang/ArrayIndexOutOfBoundsException': 52> (0x00000000f39d9b08) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\interpreter\interpreterRuntime.cpp, line 368] Event: 342.912 Thread 0x000000001eada000 Exception <a 'java/io/IOException'> (0x00000000f39b2238) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\prims\jni.cpp, line 710] Event: 342.913 Thread 0x000000001eada000 Exception <a 'java/io/IOException'> (0x00000000f39b2d08) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u231\13620\hotspot\src\share\vm\prims\jni.cpp, line 710]

Events (10 events): Event: 342.913 Thread 0x000000001eada000 DEOPT PACKING pc=0x00000000040f5334 sp=0x0000000021a6dae0 Event: 342.913 Thread 0x000000001eada000 DEOPT UNPACKING pc=0x00000000035475d0 sp=0x0000000021a6d900 mode 1 Event: 342.913 Thread 0x000000001eada000 DEOPT PACKING pc=0x00000000040f527c sp=0x0000000021a6dc70 Event: 342.913 Thread 0x000000001eada000 DEOPT UNPACKING pc=0x00000000035475d0 sp=0x0000000021a6da90 mode 1 Event: 342.914 Executing VM operation: RevokeBias Event: 342.914 Executing VM operation: RevokeBias done Event: 342.914 Executing VM operation: RevokeBias Event: 342.914 Executing VM operation: RevokeBias done Event: 342.914 Executing VM operation: RevokeBias Event: 342.914 Executing VM operation: RevokeBias done

Dynamic libraries: 0x00007ff7e8c20000 - 0x00007ff7e8c57000 C:\Program Files\Java\jdk1.8.0_231\bin\java.exe 0x00007ffa4c220000 - 0x00007ffa4c410000 C:\Windows\SYSTEM32\ntdll.dll 0x00007ffa4b1e0000 - 0x00007ffa4b292000 C:\Windows\System32\KERNEL32.DLL 0x00007ffa49610000 - 0x00007ffa498b3000 C:\Windows\System32\KERNELBASE.dll 0x00007ffa4a9d0000 - 0x00007ffa4aa73000 C:\Windows\System32\ADVAPI32.dll 0x00007ffa4b470000 - 0x00007ffa4b50e000 C:\Windows\System32\msvcrt.dll 0x00007ffa4b510000 - 0x00007ffa4b5a7000 C:\Windows\System32\sechost.dll 0x00007ffa4b720000 - 0x00007ffa4b840000 C:\Windows\System32\RPCRT4.dll 0x00007ffa4a2d0000 - 0x00007ffa4a464000 C:\Windows\System32\USER32.dll 0x00007ffa4a2a0000 - 0x00007ffa4a2c1000 C:\Windows\System32\win32u.dll 0x00007ffa4b370000 - 0x00007ffa4b396000 C:\Windows\System32\GDI32.dll 0x00007ffa491b0000 - 0x00007ffa49344000 C:\Windows\System32\gdi32full.dll 0x00007ffa49350000 - 0x00007ffa493ee000 C:\Windows\System32\msvcp_win.dll 0x00007ffa4a1a0000 - 0x00007ffa4a29a000 C:\Windows\System32\ucrtbase.dll 0x00007ffa41920000 - 0x00007ffa41ba5000 C:\Windows\WinSxS\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.18362.418_none_e6c6b287130d565d\COMCTL32.dll 0x00007ffa4a4e0000 - 0x00007ffa4a816000 C:\Windows\System32\combase.dll 0x00007ffa49440000 - 0x00007ffa494c0000 C:\Windows\System32\bcryptPrimitives.dll 0x00007ffa4c0c0000 - 0x00007ffa4c0ee000 C:\Windows\System32\IMM32.DLL 0x0000000067830000 - 0x0000000067902000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\msvcr100.dll 0x0000000066e50000 - 0x00000000676f6000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\server\jvm.dll 0x00007ffa4c170000 - 0x00007ffa4c178000 C:\Windows\System32\PSAPI.DLL 0x00007ffa44ff0000 - 0x00007ffa44ff9000 C:\Windows\SYSTEM32\WSOCK32.dll 0x00007ffa4b840000 - 0x00007ffa4b8af000 C:\Windows\System32\WS2_32.dll 0x00007ffa473f0000 - 0x00007ffa47414000 C:\Windows\SYSTEM32\WINMM.dll 0x00007ffa425e0000 - 0x00007ffa425ea000 C:\Windows\SYSTEM32\VERSION.dll 0x00007ffa47170000 - 0x00007ffa4719d000 C:\Windows\SYSTEM32\winmmbase.dll 0x00007ffa493f0000 - 0x00007ffa4943a000 C:\Windows\System32\cfgmgr32.dll 0x00007ffa3e860000 - 0x00007ffa3e86f000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\verify.dll 0x00007ffa3b1f0000 - 0x00007ffa3b219000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\java.dll 0x00007ffa3e780000 - 0x00007ffa3e7b5000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\jdwp.dll 0x00007ffa42b00000 - 0x00007ffa42b08000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\npt.dll 0x00007ffa3e750000 - 0x00007ffa3e773000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\instrument.dll 0x00007ffa3e460000 - 0x00007ffa3e476000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\zip.dll 0x00007ffa4aa90000 - 0x00007ffa4b175000 C:\Windows\System32\SHELL32.dll 0x00007ffa4bdd0000 - 0x00007ffa4be79000 C:\Windows\System32\shcore.dll 0x00007ffa499f0000 - 0x00007ffa4a16f000 C:\Windows\System32\windows.storage.dll 0x00007ffa49190000 - 0x00007ffa491af000 C:\Windows\System32\profapi.dll 0x00007ffa49140000 - 0x00007ffa4918a000 C:\Windows\System32\powrprof.dll 0x00007ffa490f0000 - 0x00007ffa49100000 C:\Windows\System32\UMPDC.dll 0x00007ffa4be80000 - 0x00007ffa4bed2000 C:\Windows\System32\shlwapi.dll 0x00007ffa49120000 - 0x00007ffa49131000 C:\Windows\System32\kernel.appcore.dll 0x00007ffa49920000 - 0x00007ffa49937000 C:\Windows\System32\cryptsp.dll 0x00007ffa42900000 - 0x00007ffa42909000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\dt_socket.dll 0x00007ffa48900000 - 0x00007ffa48967000 C:\Windows\system32\mswsock.dll 0x00007ffa425f0000 - 0x00007ffa425fd000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\management.dll 0x00007ffa38be0000 - 0x00007ffa38bfa000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\net.dll 0x00007ffa38790000 - 0x00007ffa387a2000 C:\Program Files\Java\jdk1.8.0_231\jre\bin\nio.dll 0x00007ffa3b1d0000 - 0x00007ffa3b1e6000 C:\Windows\system32\napinsp.dll 0x00007ffa3b1b0000 - 0x00007ffa3b1ca000 C:\Windows\system32\pnrpnsp.dll 0x00007ffa48650000 - 0x00007ffa4871a000 C:\Windows\SYSTEM32\DNSAPI.dll 0x00007ffa4aa80000 - 0x00007ffa4aa88000 C:\Windows\System32\NSI.dll 0x00007ffa48610000 - 0x00007ffa4864a000 C:\Windows\SYSTEM32\IPHLPAPI.DLL 0x00007ffa3e3f0000 - 0x00007ffa3e3fe000 C:\Windows\System32\winrnr.dll 0x00007ffa45940000 - 0x00007ffa4595c000 C:\Windows\system32\NLAapi.dll 0x00007ffa32400000 - 0x00007ffa32415000 C:\Windows\system32\wshbth.dll 0x00007ffa425c0000 - 0x00007ffa425ca000 C:\Windows\System32\rasadhlp.dll 0x00007ffa43cd0000 - 0x00007ffa43d47000 C:\Windows\System32\fwpuclnt.dll 0x00007ffa4a170000 - 0x00007ffa4a196000 C:\Windows\System32\bcrypt.dll 0x00007ffa48470000 - 0x00007ffa484a3000 C:\Windows\system32\rsaenh.dll 0x00007ffa49010000 - 0x00007ffa49035000 C:\Windows\SYSTEM32\USERENV.dll 0x00007ffa48ad0000 - 0x00007ffa48adc000 C:\Windows\SYSTEM32\CRYPTBASE.dll 0x00007ffa43f50000 - 0x00007ffa43f66000 C:\Windows\SYSTEM32\dhcpcsvc6.DLL 0x00007ffa43f30000 - 0x00007ffa43f4c000 C:\Windows\SYSTEM32\dhcpcsvc.DLL 0x00007ffa1c440000 - 0x00007ffa1c8fc000 C:\Windows\System32\taos.dll 0x00007ffa4bee0000 - 0x00007ffa4c036000 C:\Windows\System32\ole32.dll 0x00007ffa375a0000 - 0x00007ffa375bb000 C:\Windows\SYSTEM32\MPR.dll 0x00007ffa3c2f0000 - 0x00007ffa3c4e4000 C:\Windows\SYSTEM32\dbghelp.dll

VM Arguments: jvm_args: -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:3007,suspend=y,server=n -XX:TieredStopAtLevel=1 -Xverify:none -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=3006 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -Djava.rmi.server.hostname=localhost -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:E:\ideaIU-2018.2.3\lib\rt\debugger-agent.jar=file:/C:/Users/sjcj03/AppData/Local/Temp/capture.props -Dfile.encoding=UTF-8 java_command: com.IotEdgeApplication java_class_path (initial): C:\Program Files\Java\jdk1.8.0_231\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_231\jre\lib\rt.jar;E:\workspace\sc-iot-edge\target\classes;C:\Users\sjcj03.m2\repository\org\springframework\boot\spring-boot-starter-data-jdbc\2.2.1.RELEASE\spring-boot-starter-data-jdbc-2.2.1.RELEASE.jar;C:\Users\sjcj03.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\2.2.1.RELEASE\spring-boot-starter-jdbc-2.2.1.RELEASE.jar;C:\Users\sjcj03.m2\repository\com\zaxxer\HikariCP\3.4.1\HikariCP-3.4.1.jar;C:\Users\sjcj03.m2\repository\org\springframework\spring-jdbc\5.2.1.RELEASE\spring-jdbc-5.2.1.RELEASE.jar;C:\Users\sjcj03.m2\repository\org\springframework\data\spring-data-jdbc\1.1.1.RELEASE\spring-data-jdbc-1.1.1.RELEASE.jar;C:\Users\sjcj03.m Launcher Type: SUN_STANDARD

Environment Variables: JAVA_HOME=C:\Program Files\Java\jdk1.8.0_231 PATH=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Git\cmd;C:\Program Files\TortoiseGit\bin;C:\Program Files\nodejs\;E:\maven-3.8.1\maven-3.8.1\bin;C:\Program Files\Java\jdk1.8.0_231\bin;C:\Users\sjcj03\AppData\Local\Microsoft\WindowsApps;C:\Users\sjcj03\AppData\Roaming\npm USERNAME=sjcj03 OS=Windows_NT PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 85 Stepping 6, GenuineIntel

--------------- S Y S T E M ---------------

OS: Windows 10.0 , 64 bit Build 18362 (10.0.18362.329)

CPU:total 4 (initial active 4) (2 cores per cpu, 1 threads per core) family 6 model 85 stepping 6, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, sse4.1, sse4.2, popcnt, avx, avx2, aes, clmul, erms, rtm, 3dnowpref, lzcnt, tsc, bmi1, bmi2, adx

Memory: 4k page, physical 8388048k(442836k free), swap 17300944k(2863184k free)

vm_info: Java HotSpot(TM) 64-Bit Server VM (25.231-b11) for windows-amd64 JRE (1.8.0_231-b11), built on Oct 5 2019 03:11:30 by "java_re" with MS VC++ 10.0 (VS2010)

time: Sat Jul 02 14:29:43 2022 timezone: 中国标准时间 elapsed time: 343 seconds (0d 0h 5m 43s)

Expected Behavior 调用mybatis的XML,执行的SQL内容为: SELECT ts AS ts, ts as sort, code AS sn, device_status as status from iot.iot_device_status where ts between '2022-06-29 14:24:29' and '2022-07-02 11:40:58.291' and status = 1 and sn = '1234567' order by ts asc limit 1 union all SELECT ts AS ts, ts as sort, code AS sn, device_status as status from iot.iot_device_status where ts between '2022-06-29 14:24:29' and '2022-07-02 11:40:58.291' and status = 1 and sn = '1234567' order by ts desc limit 1 union all SELECT ts AS ts, ts as sort, code AS sn, device_status as status from iot.iot_device_status where ts between '2022-07-02 11:40:58.291' and '2022-07-02 11:40:58.289' and status = 1 and sn = '1234567' order by ts asc limit 1 union all SELECT ts AS ts, ts as sort, code AS sn, device_status as status from iot.iot_device_status where ts between '2022-07-02 11:40:58.291' and '2022-07-02 11:40:58.289' and status = 1 and sn = '1234567' order by ts desc limit 1 union all SELECT ts AS ts, ts as sort, code AS sn, device_status as status from iot.iot_device_status where ts between '2022-07-02 11:40:58.289' and '2022-07-02 11:40:58.289' and status = 1 and sn = '1234567' order by ts asc limit 1 union all SELECT ts AS ts, ts as sort, code AS sn, device_status as status from iot.iot_device_status where ts between '2022-07-02 11:40:58.289' and '2022-07-02 11:40:58.289' and status = 1 and sn = '1234567' order by ts desc limit 1 建表语句为: create stable if not exists iot.iot_device_status (ts TIMESTAMP ,status NCHAR(50) ,time TIMESTAMP , code NCHAR(50) ,device_status int, type NCHAR(50) ) tags (sn NCHAR(50) ) 数据库数据情况: 2022-07-02 11:41:23.904 1 2022-07-01 16:19:10.254 12345 1 2 1234567 2022-07-02 11:41:23.901 1 2022-07-01 16:19:10.254 12345678 0 1 1234567 2022-07-02 11:40:58.291 0 2022-07-01 16:19:10.254 12345 1 2 1234567 2022-07-02 11:40:58.289 0 2022-07-01 16:19:10.254 12345678 0 1 1234567 2022-07-02 11:36:09.777 1 2022-07-01 16:19:10.254 12345 1 2 1234567 2022-07-02 11:36:09.775 1 2022-07-01 16:19:10.254 12345678 0 1 1234567

Screenshots If applicable, add screenshots to help explain your problem.

Environment (please complete the following information):

Additional Context Add any other context about the problem here.

yu285 commented 4 months ago

2.x 版本目前官方已经不维护支持了,请迁移升级到最新的 3.x 版本吧。操作手册为:https://www.taosdata.com/tdengine-engineering/17753.html。3.x 和 2.x 相比是全方位更加优越的,关于3.x 的主要特性可以结合这篇文章和官方文档一起了解:https://www.taosdata.com/tdengine-engineering/21550.html