This discussion is archived
3 Replies Latest reply: Dec 17, 2013 6:11 AM by Jeff Smith SQLDev PM RSS

Error/bug Sqldeveloper 4 EA3 hangs every second day

KarstenH-dk Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 ACE Moderator
    Currently Being Moderated

    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.

Legend

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