2 Replies Latest reply: Feb 11, 2009 6:52 AM by Jim Smith RSS

    Consistent Hang

    Jim Smith
      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
          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
            This turned out to be a database problem after all.