This discussion is archived
2 Replies Latest reply: Feb 11, 2009 4:52 AM by Jim Smith RSS

Consistent Hang

Jim Smith Expert
Currently Being Moderated
I am getting a consistent hang. I have a connection open, I am typing a sqlstatement into the worksheet and everyting stops completely.

1.5.3 on Xp Pro,
CVS Version (External)     (CVSNT) 2.5.03 (Scorpio) Build 2382 (client/server)
Java(TM) Platform     1.6.0_07
Oracle IDE     1.5.3.57.83
Versioning Support     1.5.3.57.83


Thread dump
Full thread dump Java HotSpot(TM) Client VM (10.0-b23 mixed mode):

"pool-2-thread-1" prio=6 tid=0x03a76800 nid=0x84 waiting on condition [0x06f3f000..0x06f3fa94]
   java.lang.Thread.State: WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x13e355d8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1925)
        at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:358)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:946)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:906)
        at java.lang.Thread.run(Thread.java:619)

"IconOverlayTracker Timer" prio=6 tid=0x04bbc400 nid=0xca4 in Object.wait() [0x06e3f000..0x06e3fb14]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.util.TimerThread.mainLoop(Timer.java:483)
        - locked <0x13e35710> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"Timer-2" prio=6 tid=0x04bc7c00 nid=0xf40 in Object.wait() [0x06d3f000..0x06d3fb94]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.util.TimerThread.mainLoop(Timer.java:483)
        - locked <0x13e35790> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"TextBufferScavenger" prio=6 tid=0x048cb800 nid=0x498 in Object.wait() [0x0693f000..0x0693fd14]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
        - locked <0x13a1ccd8> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
        at oracle.ide.model.TextNode$FacadeBufferReference$PollingThread.run(TextNode.java:1886)

"Native Directory Watcher" prio=2 tid=0x03928c00 nid=0xdc8 runnable [0x059cf000..0x059cfa14]
   java.lang.Thread.State: RUNNABLE
        at oracle.ide.natives.NativeHandler.enterWatcherThread(Native Method)
        at oracle.ide.natives.NativeHandler$2.run(NativeHandler.java:252)
        at java.lang.Thread.run(Thread.java:619)

"Swing-Shell" daemon prio=6 tid=0x049fb800 nid=0xd70 waiting on condition [0x05acf000..0x05acfa94]
   java.lang.Thread.State: WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x130ec738> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1925)
        at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:358)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:946)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:906)
        at sun.awt.shell.Win32ShellFolderManager2$ComInvoker$3.run(Win32ShellFolderManager2.java:458)
        at java.lang.Thread.run(Thread.java:619)

"IconOverlayTracker Timer" prio=6 tid=0x0457a400 nid=0xee8 in Object.wait() [0x058cf000..0x058cfb94]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.util.TimerThread.mainLoop(Timer.java:483)
        - locked <0x1300fca0> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"IconOverlayTracker Timer" prio=6 tid=0x0482dc00 nid=0xc2c in Object.wait() [0x056cf000..0x056cfc14]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.util.TimerThread.mainLoop(Timer.java:483)
        - locked <0x1300f728> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:462)

"Meter Updater" prio=6 tid=0x04497800 nid=0xb04 waiting on condition [0x055cf000..0x055cfd14]
   java.lang.Thread.State: TIMED_WAITING (sleeping)
        at java.lang.Thread.sleep(Native Method)
        at elephant.insider.view.impl.MeterUpdater$Updater.run(MeterUpdater.java:131)
        at java.lang.Thread.run(Thread.java:619)

"Meter Dispatcher" prio=6 tid=0x04497000 nid=0xbb0 waiting on condition [0x054cf000..0x054cfd94]
   java.lang.Thread.State: TIMED_WAITING (sleeping)
        at java.lang.Thread.sleep(Native Method)
        at elephant.insider.view.impl.MeterUpdater$Dispatcher.run(MeterUpdater.java:282)
        at java.lang.Thread.run(Thread.java:619)

"Adapter Monitor" prio=6 tid=0x0455f400 nid=0xc5c waiting on condition [0x053cf000..0x053cfa14]
   java.lang.Thread.State: TIMED_WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x12dd0ca0> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:198)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:1963)
        at java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:395)
        at elephant.insider.server.monitor.impl.AdapterMonitorImpl$Monitor.run(AdapterMonitorImpl.java:247)
        at java.lang.Thread.run(Thread.java:619)

"TimerQueue" daemon prio=6 tid=0x03b25400 nid=0x854 in Object.wait() [0x0446f000..0x0446fb14]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at javax.swing.TimerQueue.run(TimerQueue.java:236)
        - locked <0x1281d380> (a javax.swing.TimerQueue)
        at java.lang.Thread.run(Thread.java:619)

"AWT-EventQueue-0" prio=6 tid=0x03ab8800 nid=0xea4 runnable [0x042bf000..0x042bfb94]
   java.lang.Thread.State: RUNNABLE
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at oracle.net.ns.Packet.receive(Unknown Source)
        at oracle.net.ns.DataPacket.receive(Unknown Source)
        at oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)
        at oracle.net.ns.NetInputStream.read(Unknown Source)
        at oracle.net.ns.NetInputStream.read(Unknown Source)
        at oracle.net.ns.NetInputStream.read(Unknown Source)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1099)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:478)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
        - locked <0x104f5820> (a oracle.jdbc.driver.T4CPreparedStatement)
        - locked <0x140ce730> (a oracle.jdbc.driver.T4CConnection)
        at oracle.dbtools.raptor.insight.InsightableOracleDatabase.fetch(InsightableOracleDatabase.java:512)
        at oracle.dbtools.raptor.insight.CompletionInsight.getInsightData(CompletionInsight.java:501)
        at oracle.javatools.editor.insight.AbstractInsight.showInsight(AbstractInsight.java:781)
        at oracle.javatools.editor.insight.AbstractInsight.showInsight(AbstractInsight.java:706)
        at oracle.javatools.editor.insight.AbstractInsight.actionPerformed(AbstractInsight.java:501)
        at javax.swing.Timer.fireActionPerformed(Timer.java:271)
        at javax.swing.Timer$DoPostEvent.run(Timer.java:201)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

"AWT-Windows" daemon prio=6 tid=0x03ab2000 nid=0xfd0 runnable [0x040bf000..0x040bfc94]
   java.lang.Thread.State: RUNNABLE
        at sun.awt.windows.WToolkit.eventLoop(Native Method)
        at sun.awt.windows.WToolkit.run(WToolkit.java:290)
        at java.lang.Thread.run(Thread.java:619)

"AWT-Shutdown" prio=6 tid=0x03aac800 nid=0xbec in Object.wait() [0x03fbf000..0x03fbfd14]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259)
        - locked <0x127b9a78> (a java.lang.Object)
        at java.lang.Thread.run(Thread.java:619)

"Java2D Disposer" daemon prio=6 tid=0x03aaac00 nid=0x618 in Object.wait() [0x03ebf000..0x03ebfd94]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
        - locked <0x1281d5c8> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
        at sun.java2d.Disposer.run(Disposer.java:125)
        at java.lang.Thread.run(Thread.java:619)

"Low Memory Detector" daemon prio=6 tid=0x00ea0400 nid=0x478 runnable [0x00000000..0x00000000]
   java.lang.Thread.State: RUNNABLE

"CompilerThread0" daemon prio=6 tid=0x00e9b000 nid=0xf2c waiting on condition [0x00000000..0x035bf7bc]
   java.lang.Thread.State: RUNNABLE

"Attach Listener" daemon prio=6 tid=0x00e99c00 nid=0xadc runnable [0x00000000..0x00000000]
   java.lang.Thread.State: RUNNABLE

"Signal Dispatcher" daemon prio=6 tid=0x00e98c00 nid=0xf3c waiting on condition [0x00000000..0x00000000]
   java.lang.Thread.State: RUNNABLE

"Finalizer" daemon prio=8 tid=0x00e89800 nid=0x1d8 in Object.wait() [0x032bf000..0x032bfc94]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
        - locked <0x12780298> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
        at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

"Reference Handler" daemon prio=6 tid=0x00e85400 nid=0xdf8 in Object.wait() [0x031bf000..0x031bfd14]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:485)
        at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)
        - locked <0x12780320> (a java.lang.ref.Reference$Lock)

"main" prio=6 tid=0x00926400 nid=0xf80 waiting on condition [0x00000000..0x0012fb3c]
   java.lang.Thread.State: RUNNABLE

"VM Thread" prio=6 tid=0x00e82400 nid=0x1e0 runnable

"VM Periodic Task Thread" prio=6 tid=0x00eb3800 nid=0xef8 waiting on condition

JNI global references: 2245

Heap
def new generation   total 4928K, used 2478K [0x10020000, 0x10570000, 0x12780000)
  eden space 4416K,  49% used [0x10020000, 0x10246f00, 0x10470000)
  from space 512K,  53% used [0x104f0000, 0x105349b0, 0x10570000)
  to   space 512K,   0% used [0x10470000, 0x10470000, 0x104f0000)
tenured generation   total 64456K, used 53602K [0x12780000, 0x16672000, 0x30020000)
   the space 64456K,  83% used [0x12780000, 0x15bd8b60, 0x15bd8c00, 0x16672000)
compacting perm gen  total 44032K, used 43441K [0x30020000, 0x32b20000, 0x38020000)
   the space 44032K,  98% used [0x30020000, 0x32a8c5d0, 0x32a8c600, 0x32b20000)
No shared spaces configured.
  • 1. Re: Consistent Hang
    499310 Journeyer
    Currently Being Moderated
    Does not looks like that there is a deadlock.
    The GUI Thread ("AWT-EventQueue-0") is waiting for a JDBC operation to complete.
    This is happening from the code insight.

    Try these :
    - ensure that the connection is not busy when you type in the worksheet. Close any results grids / datatab you have open.
    - if this does not help, switch off the code insight.

    Let me know what happens after this.

    -Raghu
  • 2. Re: Consistent Hang
    Jim Smith Expert
    Currently Being Moderated
    This turned out to be a database problem after all.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points