Test environment how to won't appear such mistakes, search online for a long time general explanation is the network is bad, connect session is closed,,, these are associated with the database itself, and I'm the only through DBLINK check other database will have problems in the system, have a great spirit encountered such a problem,
Project is a micro service architecture, the use of druid connection pool: durid - 1.1.5
Attached some exception information:
Java, SQL SQLRecoverableException: No more data to read from the socket
At oracle, the JDBC driver. T4CMAREngineNIO. PrepareForReading (T4CMAREngineNIO. Java: 119)
At oracle, the JDBC driver. T4CMAREngineNIO. UnmarshalUB1 (T4CMAREngineNIO. Java: 534)
At oracle, the JDBC driver. T4CTTIfun. The receive (T4CTTIfun. Java: 485)
At oracle, the JDBC driver. T4CTTIfun. DoRPC (T4CTTIfun. Java: 252)
At oracle, the JDBC driver. T4C8Oall. DoOALL (T4C8Oall. Java: 612)
At oracle, the JDBC driver. T4CPreparedStatement. DoOall8 (T4CPreparedStatement. Java: 226)
At oracle, the JDBC driver. T4CPreparedStatement. DoOall8 (T4CPreparedStatement. Java: 59)
At oracle, the JDBC driver. T4CPreparedStatement. ExecuteForRows (T4CPreparedStatement. Java: 910)
At oracle, the JDBC driver. OracleStatement. ExecuteMaybeDescribe (OracleStatement. Java: 933)
At oracle, the JDBC driver. OracleStatement. DoExecuteWithTimeout (OracleStatement. Java: 1082)
At oracle, the JDBC driver. OraclePreparedStatement. ExecuteInternal (OraclePreparedStatement. Java: 3780)
At oracle, the JDBC driver. T4CPreparedStatement. ExecuteInternal (T4CPreparedStatement. Java: 1343)
At oracle, the JDBC driver. OraclePreparedStatement. Execute (OraclePreparedStatement. Java: 3887)
At oracle, the JDBC driver. OraclePreparedStatementWrapper. Execute (OraclePreparedStatementWrapper. Java: 1079)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_execute (FilterChainImpl. Java: 3051)
At com. Alibaba. Druid. Filter. FilterAdapter. PreparedStatement_execute (FilterAdapter. Java: 1080)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_execute (FilterChainImpl. Java: 3049)
At com. Alibaba. Druid. Filter. FilterEventAdapter. PreparedStatement_execute (FilterEventAdapter. Java: 440)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_execute (FilterChainImpl. Java: 3049)
At com. Alibaba. Druid. Filter. FilterEventAdapter. PreparedStatement_execute (FilterEventAdapter. Java: 440)
At com. Alibaba. Druid. Filter. FilterChainImpl. PreparedStatement_execute (FilterChainImpl. Java: 3049)
At com. Alibaba. Druid. Proxy. JDBC. PreparedStatementProxyImpl. Execute (PreparedStatementProxyImpl. Java: 167)
At com. Alibaba. Druid. Pool. DruidPooledPreparedStatement. Execute (DruidPooledPreparedStatement. Java: 494)
The at org. Apache. Ibatis. Executor. Statement. PreparedStatementHandler. Query (PreparedStatementHandler. Java: 63)
The at org. Apache. Ibatis. Executor. Statement. RoutingStatementHandler. Query (RoutingStatementHandler. Java: 79)
At sun. Reflect. GeneratedMethodAccessor170. Invoke (Unknown Source)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (498) Method. The Java:
The at org. Apache. Ibatis. Plugin. Plugin. Invoke (plugin. Java: 63)
At com. Sun. Proxy. $Proxy231. Query (Unknown Source)
The at org. Apache. Ibatis. Executor. SimpleExecutor. DoQuery (SimpleExecutor. Java: 63)
The at org. Apache. Ibatis. Executor. BaseExecutor. QueryFromDatabase (BaseExecutor. Java: 324)
The at org. Apache. Ibatis. Executor. BaseExecutor. Query (BaseExecutor. Java: 156)
The at org. Apache. Ibatis. Executor. CachingExecutor. Query (CachingExecutor. Java: 109)
The at org. Apache. Ibatis. Executor. CachingExecutor. Query (CachingExecutor. Java: 83)
The at org. Apache. Ibatis. Session. Defaults. DefaultSqlSession. SelectList (DefaultSqlSession. Java: 148)
The at org. Apache. Ibatis. Session. Defaults. DefaultSqlSession. SelectList (DefaultSqlSession. Java: 141)
The at org. Apache. Ibatis. Session. Defaults. DefaultSqlSession. SelectOne (DefaultSqlSession. Java: 77)
At sun. Reflect. GeneratedMethodAccessor226. Invoke (Unknown Source)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (498) Method. The Java:
The at org. Mybatis. Spring. SqlSessionTemplate $SqlSessionInterceptor. Invoke (SqlSessionTemplate. Java: 434)
At com. Sun. Proxy. $Proxy111. SelectOne (Unknown Source)
The at org. Mybatis. Spring. SqlSessionTemplate. SelectOne (SqlSessionTemplate. Java: 167)
The at org. Apache. Ibatis. Binding. MapperMethod. Execute (MapperMethod. Java: 82)
The at org. Apache. Ibatis. Binding. MapperProxy. Invoke (MapperProxy. Java: 59)
At com. Sun. Proxy. $Proxy176. SelectHisVinInfoFromPF (Unknown Source)
CodePudding user response:
Try to rebuild the dblink
CodePudding user response:
If multiple threads to run, try to reduce the concurrent to & lt;=4 try...CodePudding user response:
The telecom industry do you do?CodePudding user response:
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull