Weblogic Server Stuck thread and very high cpu usage when executing a query

We were observing frequent server hangs. On taking thread dumps at the time of hang we found the following culprit thread. [STUCK] ExecuteThread: ‘6’ for queue: ‘weblogic.kernel.Default (self-tuning)’” daemon prio=1 tid=01baae30 nid=55 lwp_id=9965842 runnable [1ff05000..1ff03878] at oracle.jdbc.oci8.OCIDBAccess.do_fetch(Native Method) at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1758) – locked < 36582dd0> (a oracle.jdbc.oci8.OCIDBAccess) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2659) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2832)

Continue reading

Weblogic STUCK Thread on executing query on MS SQL Server 2008

Stuck threads were observed on Weblogic Server. Thread was stuck at this point. at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1579) at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:3730) – locked (a com.microsoft.sqlserver.jdbc.TDSReader) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:5321) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) – locked (a java.lang.Object) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283) After some analysis on

Continue reading