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 »