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)

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)

Continue reading

Analyzing WebSphere Thread Dump

We can take thread dump on WAS using wsadmin tool in the following way. D:IBMWebSphereAppServerprofilesProcessCommanderbin>wsadmin.bat WASX7209I: Connected to process “server1” on node WKHANFXPNode02 using SOAP conn ector; The type of process is: UnManagedProcess WASX7029I: For help, enter: “$Help help” wsadmin>set

Continue reading