3 Replies Latest reply: Dec 17, 2013 8:11 AM by Jeff Smith Sqldev Pm-Oracle RSS

    Error/bug Sqldeveloper 4 EA3 hangs every second day

    KarstenH-dk

      My Sqldeveloper 4 ea4 does not respond on windows 7.

      This hapens every second day - I can't find an obvious reason for this.

      I have to delete/rename system-settings directory .......\Roaming\SQL Developer\system4.0.0.13.30 and re-migrate from an earlier version in order to get it back.

       

      regards Karsten

        • 2. Re: Error/bug Sqldeveloper 4 EA3 hangs every second day
          KarstenH-dk

          Sqldeveloper 4 EA3

          JAVA version 7 update 25 (build 1.7.0_25-b17)

          OS windows 7 Enterprise service pack 1

          Oracle database 11.2.03 and 10.2.0.5.0

           

          debug information:

           

           

          n [0x000000000c7cf000]
             java.lang.Thread.State: TIMED_WAITING (parking)
                  at sun.misc.Unsafe.park(Native Method)
                  - parking to wait for  <0x00000000ce618568> (a java.util.concurrent.lock
          s.AbstractQueuedSynchronizer$ConditionObject)
                  at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226
          )
                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject
          .awaitNanos(AbstractQueuedSynchronizer.java:2082)
                  at java.util.concurrent.DelayQueue.take(DelayQueue.java:220)
                  at javax.swing.TimerQueue.run(TimerQueue.java:171)
                  at java.lang.Thread.run(Thread.java:724)

          "AWT-EventQueue-0" prio=6 tid=0x000000000a6bf000 nid=0x554 waiting for monitor e
          ntry [0x000000000aeec000]
             java.lang.Thread.State: BLOCKED (on object monitor)
                  at oracle.javatools.db.DatabaseFactory.findOrCreateDatabase(DatabaseFact
          ory.java:259)
                  - waiting to lock <0x00000000cfa869f0> (a oracle.jdevimpl.db.adapter.CAC
          onnectionCreator)
                  at oracle.javatools.db.DatabaseFactory.createProviderImpl(DatabaseFactor
          y.java:226)
                  at oracle.javatools.db.DBObjectProviderFactory.createProviderFromFactory
          (DBObjectProviderFactory.java:391)
                  at oracle.javatools.db.DBObjectProviderFactory.findOrCreateProviderFromF
          actory(DBObjectProviderFactory.java:375)
                  - locked <0x00000000cfaf2448> (a oracle.javatools.db.DatabaseFactory)
                  at oracle.javatools.db.DBObjectProviderFactory.findOrCreateProvider(DBOb
          jectProviderFactory.java:311)
                  at oracle.ide.db.model.BaseDBObjectNode.findProvider(BaseDBObjectNode.ja
          va:154)
                  at oracle.ide.db.model.BaseDBObjectTextNode.getProvider(BaseDBObjectText
          Node.java:129)
                  at oracle.dbtools.raptor.navigator.impl.DatabaseSourceNode.getProvider(D
          atabaseSourceNode.java:201)
                  at oracle.ideimpl.db.ceditor.PlSqlBreadcrumbsPlugin.caretUpdate(PlSqlBre
          adcrumbsPlugin.java:98)
                  at javax.swing.text.JTextComponent.fireCaretUpdate(JTextComponent.java:4
          07)
                  at javax.swing.text.JTextComponent$MutableCaretEvent.fire(JTextComponent
          .java:4417)
                  at javax.swing.text.JTextComponent$MutableCaretEvent.stateChanged(JTextC
          omponent.java:4439)
                  at javax.swing.text.DefaultCaret.fireStateChanged(DefaultCaret.java:798)

                  at oracle.javatools.editor.BasicCaret.fireStateChanged(BasicCaret.java:4
          15)
                  at javax.swing.text.DefaultCaret.changeCaretPosition(DefaultCaret.java:1
          273)
                  at javax.swing.text.DefaultCaret.handleSetDot(DefaultCaret.java:1169)
                  at javax.swing.text.DefaultCaret.setDot(DefaultCaret.java:1150)
                  at javax.swing.text.DefaultCaret.setDot(DefaultCaret.java:1047)
                  at oracle.javatools.editor.BasicCaret.setDot(BasicCaret.java:329)
                  at javax.swing.text.JTextComponent.setCaretPosition(JTextComponent.java:
          1680)
                  at oracle.javatools.editor.BasicEditorPane.setCaretPosition(BasicEditorP
          ane.java:1842)
                  at oracle.javatools.editor.BasicEditorPane.setCaretPositionCenter(BasicE
          ditorPane.java:663)
                  at oracle.ide.ceditor.CodeEditor.loadSettings(CodeEditor.java:1552)
                  at com.oracle.jdeveloper.nbwindowsystem.editor.EditorState.applyLayoutIn
          fo(EditorState.java:664)
                  at com.oracle.jdeveloper.nbwindowsystem.editor.EditorState.openEditor(Ed
          itorState.java:321)
                  at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.doLayout(SplitP
          ane.java:580)
                  at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.whenCurrentEdito
          rChanges(NbEditorManager.java:1566)
                  at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.whenCurrentEdito
          rChanges(TabGroup.java:1026)
                  at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.setCurrentTabGro
          upState(TabGroup.java:847)
                  at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.loadLayout(TabGr
          oup.java:1362)
                  at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.loadTabGroup(N
          bEditorContainer.java:948)
                  at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.componentShowi
          ng(NbEditorContainer.java:479)
                  at org.openide.windows.WindowManager.componentShowing(WindowManager.java
          :339)
                  at org.netbeans.core.windows.WindowManagerImpl.componentShowing(WindowMa
          nagerImpl.java:1191)
                  at org.netbeans.core.windows.view.DefaultView.changeGUI(DefaultView.java
          :168)
                  at org.netbeans.core.windows.ViewRequestor.dispatchRequest(ViewRequestor
          .java:275)
                  at org.netbeans.core.windows.ViewRequestor.processRequest(ViewRequestor.
          java:251)
                  at org.netbeans.core.windows.ViewRequestor.postRequest(ViewRequestor.jav
          a:189)
                  at org.netbeans.core.windows.ViewRequestor.scheduleRequest(ViewRequestor
          .java:127)
                  at org.netbeans.core.windows.Central.setModeSelectedTopComponent(Central
          .java:757)
                  at org.netbeans.core.windows.Central.userActivatedTopComponent(Central.j
          ava:1936)
                  at org.netbeans.core.windows.view.DefaultView.userSelectedTab(DefaultVie
          w.java:699)
                  at org.netbeans.core.windows.view.ui.TabbedHandler.stateChanged(TabbedHa
          ndler.java:306)
                  at org.openide.util.ChangeSupport.fireChange(ChangeSupport.java:133)
                  at org.openide.util.ChangeSupport.fireChange(ChangeSupport.java:119)
                  at org.netbeans.core.windows.view.ui.tabcontrol.AbstractTabbedImpl.fireS
          tateChanged(AbstractTabbedImpl.java:520)
                  at org.netbeans.core.windows.view.ui.tabcontrol.TabbedAdapter$1.stateCha
          nged(TabbedAdapter.java:81)
                  at org.openide.util.ChangeSupport.fireChange(ChangeSupport.java:133)
                  at org.openide.util.ChangeSupport.fireChange(ChangeSupport.java:119)
                  at org.netbeans.swing.tabcontrol.plaf.DefaultTabSelectionModel.setSelect
          edIndex(DefaultTabSelectionModel.java:111)
                  at org.netbeans.swing.tabcontrol.plaf.BasicTabDisplayerUI$BasicDisplayer
          MouseListener.performCommand(BasicTabDisplayerUI.java:778)
                  at org.netbeans.swing.tabcontrol.plaf.BasicTabDisplayerUI$BasicDisplayer
          MouseListener.potentialCommand(BasicTabDisplayerUI.java:767)
                  at org.netbeans.swing.tabcontrol.plaf.BasicTabDisplayerUI$BasicDisplayer
          MouseListener.mousePressed(BasicTabDisplayerUI.java:742)
                  at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:27
          9)
                  at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:27
          9)
                  at java.awt.Component.processMouseEvent(Component.java:6502)
                  at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
                  at java.awt.Component.processEvent(Component.java:6270)
                  at java.awt.Container.processEvent(Container.java:2229)
                  at java.awt.Component.dispatchEventImpl(Component.java:4861)
                  at java.awt.Container.dispatchEventImpl(Container.java:2287)
                  at java.awt.Component.dispatchEvent(Component.java:4687)
                  at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832
          )
                  at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4489)

                  at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
                  at java.awt.Container.dispatchEventImpl(Container.java:2273)
                  at java.awt.Window.dispatchEventImpl(Window.java:2719)
                  at java.awt.Component.dispatchEvent(Component.java:4687)
                  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
                  at java.awt.EventQueue.access$200(EventQueue.java:103)
                  at java.awt.EventQueue$3.run(EventQueue.java:694)
                  at java.awt.EventQueue$3.run(EventQueue.java:692)
                  at java.security.AccessController.doPrivileged(Native Method)
                  at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo
          main.java:76)
                  at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo
          main.java:87)
                  at java.awt.EventQueue$4.run(EventQueue.java:708)
                  at java.awt.EventQueue$4.run(EventQueue.java:706)
                  at java.security.AccessController.doPrivileged(Native Method)
                  at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDo
          main.java:76)
                  at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
                  at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQu
          eueWrapper.java:169)
                  at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQue
          ueWrapper.java:151)
                  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
          ad.java:242)
                  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
          java:161)
                  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
          ad.java:150)
                  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

                  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

                  at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

          "AWT-Windows" daemon prio=6 tid=0x000000000a679800 nid=0x41c runnable [0x0000000
          00acef000]
             java.lang.Thread.State: RUNNABLE
                  at sun.awt.windows.WToolkit.eventLoop(Native Method)
                  at sun.awt.windows.WToolkit.run(WToolkit.java:299)
                  at java.lang.Thread.run(Thread.java:724)

          "AWT-Shutdown" prio=6 tid=0x000000000a679000 nid=0x17a0 in Object.wait() [0x0000
          00000abef000]
             java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  - waiting on <0x00000000ce61d738> (a java.lang.Object)
                  at java.lang.Object.wait(Object.java:503)
                  at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:287)
                  - locked <0x00000000ce61d738> (a java.lang.Object)
                  at java.lang.Thread.run(Thread.java:724)

          "Java2D Disposer" daemon prio=10 tid=0x000000000a631000 nid=0x1a8c in Object.wai
          t() [0x000000000aaef000]
             java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  - waiting on <0x00000000cf2e9428> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)
                  - locked <0x00000000cf2e9428> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)
                  at sun.java2d.Disposer.run(Disposer.java:145)
                  at java.lang.Thread.run(Thread.java:724)

          "Service Thread" daemon prio=6 tid=0x0000000008d05800 nid=0x4b4 runnable [0x0000
          000000000000]
             java.lang.Thread.State: RUNNABLE

          "C2 CompilerThread1" daemon prio=10 tid=0x0000000008d05000 nid=0xce8 waiting on
          condition [0x0000000000000000]
             java.lang.Thread.State: RUNNABLE

          "C2 CompilerThread0" daemon prio=10 tid=0x0000000008d00000 nid=0x1248 waiting on
          condition [0x0000000000000000]
             java.lang.Thread.State: RUNNABLE

          "Attach Listener" daemon prio=10 tid=0x0000000008cff000 nid=0x1478 runnable [0x0
          000000000000000]
             java.lang.Thread.State: RUNNABLE

          "Signal Dispatcher" daemon prio=10 tid=0x0000000008cf7800 nid=0xa0c waiting on c
          ondition [0x0000000000000000]
             java.lang.Thread.State: RUNNABLE

          "Finalizer" daemon prio=8 tid=0x00000000022db000 nid=0x2a8 in Object.wait() [0x0
          000000009f1f000]
             java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  - waiting on <0x00000000ce6945b8> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)
                  - locked <0x00000000ce6945b8> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)
                  at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)

          "Reference Handler" daemon prio=10 tid=0x00000000022d2800 nid=0x1424 in Object.w
          ait() [0x0000000009e1f000]
             java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  - waiting on <0x00000000ce64cdf8> (a java.lang.ref.Reference$Lock)
                  at java.lang.Object.wait(Object.java:503)
                  at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:133)
                  - locked <0x00000000ce64cdf8> (a java.lang.ref.Reference$Lock)

          "main" prio=6 tid=0x000000000221b000 nid=0x14d8 waiting on condition [0x00000000
          00000000]
             java.lang.Thread.State: RUNNABLE

          "VM Thread" prio=10 tid=0x0000000008c14000 nid=0x1278 runnable

          "GC task thread#0 (ParallelGC)" prio=6 tid=0x0000000002227800 nid=0x181c runnabl
          e

          "GC task thread#1 (ParallelGC)" prio=6 tid=0x0000000002229000 nid=0x8d4 runnable


          "GC task thread#2 (ParallelGC)" prio=6 tid=0x000000000222b000 nid=0x19f0 runnabl
          e

          "GC task thread#3 (ParallelGC)" prio=6 tid=0x000000000222c800 nid=0xdcc runnable


          "VM Periodic Task Thread" prio=10 tid=0x0000000008d16800 nid=0x1088 waiting on c
          ondition

          JNI global references: 2505

          Heap
          PSYoungGen      total 218176K, used 120681K [0x00000000ef560000, 0x00000000ffa0
          0000, 0x0000000100000000)
            eden space 218112K, 55% used [0x00000000ef560000,0x00000000f6b3a5e8,0x00000000
          fca60000)
            from space 64K, 0% used [0x00000000fca60000,0x00000000fca60000,0x00000000fca70
          000)
            to   space 24384K, 0% used [0x00000000fe230000,0x00000000fe230000,0x00000000ff
          a00000)
          ParOldGen       total 137344K, used 85048K [0x00000000ce000000, 0x00000000d6620
          000, 0x00000000ef560000)
            object space 137344K, 61% used [0x00000000ce000000,0x00000000d330e388,0x000000
          00d6620000)
          PSPermGen       total 155968K, used 82829K [0x00000000be000000, 0x00000000c7850
          000, 0x00000000ce000000)
            object space 155968K, 53% used [0x00000000be000000,0x00000000c30e36c8,0x000000
          00c7850000)

          • 3. Re: Error/bug Sqldeveloper 4 EA3 hangs every second day
            Jeff Smith Sqldev Pm-Oracle

            Your persistence shall be rewarded

             

            I hope!

             

            1. You should be able to fix this in your version by disabling Tools > Code Editor > Display > Show Breadcrumbs

            2. The bug that was causing this hang was fixed for the official release, which was pushed last week.

             

            So if you get the latest release on OTN, you should be able to use this feature AND not have it hang.