BuildTime: 2025-05-27 18:12:41
TAG: Hotfix_SmartbiV11_20250526
Tid: 0a0e025afa608a79
HostName: aichatv2-tomcat-859fcfc556-xqwql
数据模型引擎: V2.0
获取数据库连接失败[cause Throwable ClassName:java.sql.SQLException]:获取数据库连接失败[cause Throwable ClassName:java.sql.SQLRecoverableException]:IO 错误: The Network Adapter could not establish the connection (CONNECTION_ID=kwgm48SdSWGdgjrCpAi2TQ==),datasourceId=I8a8082da019750a150a1f9e10197671f0ee90188
at smartbi.connectionpool.ConnectionPool.lambda$doGetConnection$1(ConnectionPool.java:829)
at ...(...)
at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:120)
Caused by: java.sql.SQLException: 获取数据库连接失败[cause Throwable ClassName:java.sql.SQLRecoverableException]:IO 错误: The Network Adapter could not establish the connection (CONNECTION_ID=kwgm48SdSWGdgjrCpAi2TQ==)
at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:120)
at smartbi.connectionpool.ConnectionPool.lambda$doGetConnection$1(ConnectionPool.java:825)
at smartbi.monitor.MetricHelper$.withSpan(MetricHelper.scala:148)
at smartbi.monitor.MetricHelper.withSpan(MetricHelper.scala)
at smartbi.connectionpool.ConnectionPool.doGetConnection(ConnectionPool.java:788)
at smartbi.connectionpool.ConnectionPool.driverConnect(ConnectionPool.java:632)
at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:939)
at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:887)
at smartbi.freequery.basicdata.DataSourceHandleHelper.testConnection(DataSourceHandleHelper.java:169)
at smartbi.freequery.basicdata.MetaDataServiceImpl.testConnection(MetaDataServiceImpl.java:575)
at smartbi.freequery.client.datasource.DataSourceService.testConnectionList(DataSourceService.java:454)
at sun.reflect.GeneratedMethodAccessor5401.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:188)
at smartbi.framework.rmi.ClientService.execute(ClientService.java:166)
at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:233)
at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:249)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:276)
at smartbi.aichat.AIChatFilter.doFilter(AIChatFilter.java:56)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:276)
at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:276)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:279)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:265)
at smartbi.freequery.filter.Filter.doFilter(Filter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:92)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.rmi.TransactionFilter.doFilter(TransactionFilter.java:87)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:196)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.LogFilter.doFilter(LogFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.SmartbiApplicationFilter.doFilter(SmartbiApplicationFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:383)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.lang.Thread.run(Thread.java:750)
Caused by: 获取数据库连接失败[cause Throwable ClassName:java.sql.SQLRecoverableException]:IO 错误: The Network Adapter could not establish the connection (CONNECTION_ID=kwgm48SdSWGdgjrCpAi2TQ==)
at smartbi.connectionpool.SmartbiDriverConnectionFactory.createConnectionInner(SmartbiDriverConnectionFactory.java:68)
at ...(...)
at smartbi.connectionpool.SmartbiDriverConnectionFactory.createConnectionInner(SmartbiDriverConnectionFactory.java:62)
Caused by: java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connection (CONNECTION_ID=kwgm48SdSWGdgjrCpAi2TQ==)
at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:892)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:697)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1041)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:89)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:732)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:648)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at smartbi.connectionpool.SmartbiDriverConnectionFactory.createConnectionInner(SmartbiDriverConnectionFactory.java:62)
at smartbi.connectionpool.SmartbiDriverConnectionFactory.createConnection(SmartbiDriverConnectionFactory.java:114)
at smartbi.connectionpool.SmartbiPoolableConnectionFactory.makeObjectInternal(SmartbiPoolableConnectionFactory.java:224)
at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:110)
at smartbi.connectionpool.ConnectionPool.lambda$doGetConnection$1(ConnectionPool.java:825)
at smartbi.monitor.MetricHelper$.withSpan(MetricHelper.scala:148)
at smartbi.monitor.MetricHelper.withSpan(MetricHelper.scala)
at smartbi.connectionpool.ConnectionPool.doGetConnection(ConnectionPool.java:788)
at smartbi.connectionpool.ConnectionPool.driverConnect(ConnectionPool.java:632)
at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:939)
at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:887)
at smartbi.freequery.basicdata.DataSourceHandleHelper.testConnection(DataSourceHandleHelper.java:169)
at smartbi.freequery.basicdata.MetaDataServiceImpl.testConnection(MetaDataServiceImpl.java:575)
at smartbi.freequery.client.datasource.DataSourceService.testConnectionList(DataSourceService.java:454)
at sun.reflect.GeneratedMethodAccessor5401.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:188)
at smartbi.framework.rmi.ClientService.execute(ClientService.java:166)
at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:233)
at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:249)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:276)
at smartbi.aichat.AIChatFilter.doFilter(AIChatFilter.java:56)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:276)
at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:276)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:279)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:265)
at smartbi.freequery.filter.Filter.doFilter(Filter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:92)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.rmi.TransactionFilter.doFilter(TransactionFilter.java:87)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:196)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.LogFilter.doFilter(LogFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.SmartbiApplicationFilter.doFilter(SmartbiApplicationFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:383)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.lang.Thread.run(Thread.java:750)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection (CONNECTION_ID=kwgm48SdSWGdgjrCpAi2TQ==)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:694)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:584)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:938)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:349)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2442)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:656)
... 94 more
Caused by: java.io.IOException: No route to host, socket connect lapse 3087 ms. 10.0.1.34 1521 0 (1/1) true
at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:425)
at oracle.net.nt.TcpNTAdapter.doLocalDNSLookupConnect(TcpNTAdapter.java:307)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:269)
at oracle.net.nt.ConnOption.connect(ConnOption.java:243)
at oracle.net.nt.ConnStrategy.executeConnOption(ConnStrategy.java:980)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:655)
... 99 more
Caused by: java.net.NoRouteToHostException: No route to host
at sun.nio.ch.Net.connect0(Native Method)
at sun.nio.ch.Net.connect(Net.java:482)
at sun.nio.ch.Net.connect(Net.java:474)
at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:647)
at java.nio.channels.SocketChannel.open(SocketChannel.java:189)
at oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:183)
at oracle.net.nt.TimeoutSocketChannel.(TimeoutSocketChannel.java:157)
at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:384)
... 104 more
| 
