Everyone a great god, the younger brother of the project is the high concurrency interface platform, deployed in weblogic , use the activemq control concurrent, each request is executed oracle stored procedure , because the execution time is long, concurrency is larger, which leads to the activemq jams , data source unavailable quantity for super-high and weblogic server status set to Failed , can only be solved, restart the server for help ah, I see the log said two JMS process rob a data source, I don't know ever encountered this problem help!!!!!!!!!!




DEADLOCK DETECTED:
==================

[deadlocked thread] org. Springframework.. JMS listener. DefaultMessageListenerContainer# 0-46:
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Thread 'org. Springframework. JMS. Listener. DefaultMessageListenerContainer# 0-46' is waiting to acquire the lock '... The oracle JDBC driver T4CConnection @ 127 ec81c 'belong by by thread' org. Springframework. JMS. Listener. DefaultMessageListenerContainer# 0-65 '

The Stack trace:
-- -- -- -- -- -- -- -- -- -- -- --
Oracle. SQL. The TypeDescriptor. GetName (TypeDescriptor. Java: 683)
Oracle. JDBC. Oracore. OracleTypeADT. IsInHierarchyOf (OracleTypeADT. Java: 426)
Oracle, the JDBC driver. OraclePreparedStatement. ProcessCompletedBindRow (OraclePreparedStatement. Java: 2072)
Oracle, the JDBC driver. OraclePreparedStatement. ExecuteInternal (OraclePreparedStatement. Java: 3588)
Oracle, the JDBC driver. OraclePreparedStatement. Execute (OraclePreparedStatement. Java: 3694)
Oracle, the JDBC driver. OracleCallableStatement. Execute (OracleCallableStatement. Java: 4755)
Oracle, the JDBC driver. OraclePreparedStatementWrapper. Execute (OraclePreparedStatementWrapper. Java: 1378)
Weblogic. JDBC. Wrapper. PreparedStatement. Execute (99) a PreparedStatement. Java:
Com.sinosig.insurance.ecif.com mon. Dao. Impl. ProcedureDaoImpl. CallStructStrProc (ProcedureDaoImpl. Java: 417)
Com.sinosig.insurance.ecif.com mon. Dao. Impl. ProcedureDaoImpl $$FastClassByCGLIB $$421 f5dcc. Invoke (& lt; The generate
. (ellipses)

[deadlocked thread] org. Springframework.. JMS listener. DefaultMessageListenerContainer# 0-65:
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Thread 'org. Springframework. JMS. Listener. DefaultMessageListenerContainer# 0-65 'is waiting to acquire the lock ' oracle.. JDBC driver. T4CConnection @ 127 a9534 'belong by by thread' org. Springframework.. JMS listener. DefaultMessageListenerContainer# 0-46 '
Reason: the Thread deadlock detected>


<> ===== FULL THREAD DUMP ===============
Wed Apr 20 00:12:28 2016
Oracle more about JRockit over (R) R28.1.4-7-144370-1.6.0 _26-20110617-2130 - Linux - x86_64

"Main Thread id=1" independence idx=0 x4 tid=12690 prio=5 alive, waiting, native_blocked


CodePudding user response:

Find section moderators give you move to the Java area;

CodePudding user response:

I care about is how to solve the problem, the stored procedure can be optimized?