3 Replies Latest reply on Oct 22, 2014 11:57 PM by Gary Graham-Oracle

    hanging issue SQL*dev 4.03

    KarstenH-dk

      Hi there

       

      Yesterday my SQL*dev couldn't start and hung when "restoring windows"

      Had to delete entry from C:\Users\.....\AppData\Roaming\SQL Developer\system4.0.3.16.84 and start all over again, loosing my recent connections :-(

       

      OS: windows 7

      Oracle DB 11.2.04

       

      regards Karsten

       

      jstack revealed this:

       

      2014-10-20 10:19:51

      Full thread dump Java HotSpot(TM) 64-Bit Server VM (24.55-b03 mixed mode):

       

      "WaitCursor-Timer" prio=6 tid=0x000000000ee04800 nid=0x1178 in Object.wait() [0x000000001400f000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000d1d13fb8> (a java.util.TaskQueue)

          at java.lang.Object.wait(Object.java:503)

          at java.util.TimerThread.mainLoop(Timer.java:526)

          - locked <0x00000000d1d13fb8> (a java.util.TaskQueue)

          at java.util.TimerThread.run(Timer.java:505)

       

      "Background Parser" prio=6 tid=0x000000000ee03800 nid=0xbf4 waiting on condition [0x0000000013f0f000]

         java.lang.Thread.State: TIMED_WAITING (sleeping)

          at java.lang.Thread.sleep(Native Method)

          at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:142)

          at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)

          at java.lang.Thread.run(Thread.java:745)

       

      "SwingWorker-pool-4-thread-1" daemon prio=6 tid=0x000000000ee03000 nid=0x103c waiting on condition [0x0000000013e0f000]

         java.lang.Thread.State: WAITING (parking)

          at sun.misc.Unsafe.park(Native Method)

          - parking to wait for  <0x00000000d1d14588> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

          at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)

          at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)

          at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)

          at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

          at java.lang.Thread.run(Thread.java:745)

       

      "Thread-11" prio=6 tid=0x000000000edf8800 nid=0xbe8 in Object.wait() [0x000000000b59e000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000d1d22700> (a java.awt.EventQueue$1AWTInvocationLock)

          at java.lang.Object.wait(Object.java:503)

          at java.awt.EventQueue.invokeAndWait(EventQueue.java:1270)

          - locked <0x00000000d1d22700> (a java.awt.EventQueue$1AWTInvocationLock)

          at java.awt.EventQueue.invokeAndWait(EventQueue.java:1251)

          at javax.swing.SwingUtilities.invokeAndWait(SwingUtilities.java:1347)

          at oracle.dbtools.raptor.dialogs.conn.ConnectionInfoPanel.promptForConnection(ConnectionInfoPanel.java:117)

          at oracle.dbtools.raptor.dialogs.conn.ConnectionPrompt.promptForPassword(ConnectionPrompt.java:64)

          at oracle.jdevimpl.db.DBConnAddin$1.promptForPassword(DBConnAddin.java:78)

          at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:366)

          at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:299)

          at oracle.jdevimpl.db.adapter.CAConnectionCreator.createConnectionImpl(CAConnectionCreator.java:66)

          at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:838)

          at oracle.javatools.db.DatabaseFactory.createDatabase(DatabaseFactory.java:282)

          at oracle.jdeveloper.db.DatabaseConnections.getDatabase(DatabaseConnections.java:833)

          - locked <0x00000000d0243df8> (a oracle.jdevimpl.db.adapter.CAConnectionCreator)

          at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.getDatabase(Connections.java:175)

          at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1165)

          at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1139)

          at oracle.dbtools.db.ChameleonConnection.getConnection(ChameleonConnection.java:40)

          at oracle.dbtools.raptor.insight.UsersCache.fillIn(UsersCache.java:46)

          at oracle.dbtools.raptor.insight.CompletionInsight$1.run(CompletionInsight.java:157)

       

      "TextBufferScavenger" prio=6 tid=0x000000000ee01800 nid=0xa68 in Object.wait() [0x000000001285f000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000d1a7e2f8> (a java.lang.ref.ReferenceQueue$Lock)

          at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)

          - locked <0x00000000d1a7e2f8> (a java.lang.ref.ReferenceQueue$Lock)

          at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)

          at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBufferReference.java:145)

       

      "pool-2-thread-1" prio=6 tid=0x000000000ee00800 nid=0xaf0 waiting on condition [0x000000001265f000]

         java.lang.Thread.State: WAITING (parking)

          at sun.misc.Unsafe.park(Native Method)

          - parking to wait for  <0x00000000d174cea0> (a java.util.concurrent.SynchronousQueue$TransferStack)

          at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)

          at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)

          at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:359)

          at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:925)

          at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1068)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

          at java.lang.Thread.run(Thread.java:745)

       

      "Scheduler" daemon prio=6 tid=0x000000000ee00000 nid=0x1060 in Object.wait() [0x000000001255f000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000d175b978> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)

          at java.lang.Object.wait(Object.java:503)

          at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)

          - locked <0x00000000d175b978> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)

          at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:479)

       

      "Thread-8" daemon prio=6 tid=0x000000000edfd000 nid=0x2a0 in Object.wait() [0x000000001128f000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000cf6038d0> (a java.util.LinkedList)

          at java.lang.Object.wait(Object.java:503)

          at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1476)

          - locked <0x00000000cf6038d0> (a java.util.LinkedList)

       

      "Log Poller" prio=2 tid=0x000000000edfc000 nid=0x49c waiting on condition [0x000000001118f000]

         java.lang.Thread.State: WAITING (parking)

          at sun.misc.Unsafe.park(Native Method)

          - parking to wait for  <0x00000000d0127eb8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)

          at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)

          at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2043)

          at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)

          at oracle.ide.log.QueuedLoggingHandler.take(QueuedLoggingHandler.java:60)

          at oracle.ideimpl.log.TabbedLogManager$4.run(TabbedLogManager.java:321)

          at java.lang.Thread.run(Thread.java:745)

       

      "JarIndex Timer" daemon prio=6 tid=0x000000000edfa800 nid=0xd80 in Object.wait() [0x000000000ffbf000]

         java.lang.Thread.State: TIMED_WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000cf414070> (a java.util.TaskQueue)

          at java.util.TimerThread.mainLoop(Timer.java:552)

          - locked <0x00000000cf414070> (a java.util.TaskQueue)

          at java.util.TimerThread.run(Timer.java:505)

       

      "TimedCache-Timer" daemon prio=6 tid=0x000000000edfa000 nid=0x988 in Object.wait() [0x000000000b49f000]

         java.lang.Thread.State: TIMED_WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000cfaea320> (a java.util.TaskQueue)

          at java.util.TimerThread.mainLoop(Timer.java:552)

          - locked <0x00000000cfaea320> (a java.util.TaskQueue)

          at java.util.TimerThread.run(Timer.java:505)

       

      "Framework Event Dispatcher" daemon prio=6 tid=0x000000000b843000 nid=0xd94 in Object.wait() [0x000000000b29f000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000ce9e8118> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)

          at java.lang.Object.wait(Object.java:503)

          at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400)

          - locked <0x00000000ce9e8118> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)

          at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:336)

       

      "State Data Manager" daemon prio=6 tid=0x000000000ba0f000 nid=0xe48 waiting on condition [0x000000000b19f000]

         java.lang.Thread.State: TIMED_WAITING (sleeping)

          at java.lang.Thread.sleep(Native Method)

          at org.eclipse.osgi.internal.baseadaptor.StateManager.run(StateManager.java:297)

          at java.lang.Thread.run(Thread.java:745)

       

      "Framework Active Thread" prio=6 tid=0x000000000b884800 nid=0x690 in Object.wait() [0x000000000b09f000]

         java.lang.Thread.State: TIMED_WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000cf6235e8> (a org.eclipse.osgi.framework.internal.core.Framework)

          at org.eclipse.osgi.framework.internal.core.Framework.run(Framework.java:1863)

          - locked <0x00000000cf6235e8> (a org.eclipse.osgi.framework.internal.core.Framework)

          at java.lang.Thread.run(Thread.java:745)

       

      "Active Reference Queue Daemon" daemon prio=2 tid=0x0000000009fce800 nid=0x440 in Object.wait() [0x000000000a8af000]

         java.lang.Thread.State: TIMED_WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000cf68d8b8> (a java.lang.ref.ReferenceQueue$Lock)

          at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)

          - locked <0x00000000cf68d8b8> (a java.lang.ref.ReferenceQueue$Lock)

          at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.java:180)

          - locked <0x00000000cf68d8b8> (a java.lang.ref.ReferenceQueue$Lock)

       

      "TimerQueue" daemon prio=6 tid=0x0000000009f0a800 nid=0x6f8 waiting on condition [0x000000000c08f000]

         java.lang.Thread.State: TIMED_WAITING (parking)

          at sun.misc.Unsafe.park(Native Method)

          - parking to wait for  <0x00000000ce9c7018> (a java.util.concurrent.locks.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:745)

       

      "AWT-EventQueue-0" prio=6 tid=0x0000000009f08800 nid=0x828 waiting for monitor entry [0x000000000a7aa000]

         java.lang.Thread.State: BLOCKED (on object monitor)

          at oracle.javatools.db.DatabaseFactory.findOrCreateDatabase(DatabaseFactory.java:259)

          - waiting to lock <0x00000000d0243df8> (a oracle.jdevimpl.db.adapter.CAConnectionCreator)

          at oracle.javatools.db.DatabaseFactory.createProviderImpl(DatabaseFactory.java:226)

          at oracle.javatools.db.DBObjectProviderFactory.createProviderFromFactory(DBObjectProviderFactory.java:391)

          at oracle.javatools.db.DBObjectProviderFactory.findOrCreateProviderFromFactory(DBObjectProviderFactory.java:375)

          - locked <0x00000000cfd30c98> (a oracle.javatools.db.DatabaseFactory)

          at oracle.javatools.db.DBObjectProviderFactory.findOrCreateProvider(DBObjectProviderFactory.java:311)

          at oracle.ide.db.model.BaseDBObjectNode.findProvider(BaseDBObjectNode.java:154)

          at oracle.ide.db.model.BaseDBObjectTextNode.getProvider(BaseDBObjectTextNode.java:86)

          at oracle.dbtools.raptor.navigator.impl.DatabaseSourceNode.getProvider(DatabaseSourceNode.java:201)

          at oracle.ideimpl.db.ceditor.PlSqlBreadcrumbsPlugin.caretUpdate(PlSqlBreadcrumbsPlugin.java:114)

          at javax.swing.text.JTextComponent.fireCaretUpdate(JTextComponent.java:407)

          at javax.swing.text.JTextComponent$MutableCaretEvent.fire(JTextComponent.java:4417)

          at javax.swing.text.JTextComponent$MutableCaretEvent.stateChanged(JTextComponent.java:4439)

          at javax.swing.text.DefaultCaret.fireStateChanged(DefaultCaret.java:802)

          at oracle.javatools.editor.BasicCaret.fireStateChanged(BasicCaret.java:415)

          at javax.swing.text.DefaultCaret.changeCaretPosition(DefaultCaret.java:1277)

          at javax.swing.text.DefaultCaret.handleSetDot(DefaultCaret.java:1173)

          at javax.swing.text.DefaultCaret.setDot(DefaultCaret.java:1154)

          at javax.swing.text.DefaultCaret.setDot(DefaultCaret.java:1051)

          at oracle.javatools.editor.BasicCaret.setDot(BasicCaret.java:329)

          at javax.swing.text.JTextComponent.setCaretPosition(JTextComponent.java:1680)

          at oracle.javatools.editor.BasicEditorPane.setCaretPosition(BasicEditorPane.java:1842)

          at oracle.javatools.editor.BasicEditorPane.setCaretPositionCenter(BasicEditorPane.java:663)

          at oracle.ide.ceditor.CodeEditor.loadSettings(CodeEditor.java:1553)

          at com.oracle.jdeveloper.nbwindowsystem.editor.EditorState.applyLayoutInfo(EditorState.java:664)

          at com.oracle.jdeveloper.nbwindowsystem.editor.EditorState.openEditor(EditorState.java:321)

          at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.doLayout(SplitPane.java:580)

          at java.awt.Container.validateTree(Container.java:1688)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validate(Container.java:1623)

          - locked <0x00000000cf777588> (a java.awt.Component$AWTTreeLock)

          at org.netbeans.core.windows.view.ui.DesktopImpl$LayeredLayout.layoutContainer(DesktopImpl.java:535)

          at java.awt.Container.layout(Container.java:1503)

          at java.awt.Container.doLayout(Container.java:1492)

          at java.awt.Container.validateTree(Container.java:1688)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validateTree(Container.java:1697)

          at java.awt.Container.validate(Container.java:1623)

          - locked <0x00000000cf777588> (a java.awt.Component$AWTTreeLock)

          at org.netbeans.core.windows.view.ui.MainWindow.setDesktop(MainWindow.java:633)

          at org.netbeans.core.windows.view.ViewHierarchy.setDesktop(ViewHierarchy.java:814)

          at org.netbeans.core.windows.view.ViewHierarchy.setMainWindowDesktop(ViewHierarchy.java:804)

          at org.netbeans.core.windows.view.ViewHierarchy.updateDesktop(ViewHierarchy.java:697)

          at org.netbeans.core.windows.view.DefaultView.showWindowSystem(DefaultView.java:602)

          at org.netbeans.core.windows.view.DefaultView.windowSystemVisibilityChanged(DefaultView.java:542)

          at org.netbeans.core.windows.view.DefaultView.changeGUI(DefaultView.java:187)

          at org.netbeans.core.windows.ViewRequestor.dispatchRequest(ViewRequestor.java:275)

          at org.netbeans.core.windows.ViewRequestor.processVisibilityRequest(ViewRequestor.java:264)

          at org.netbeans.core.windows.ViewRequestor.postVisibilityRequest(ViewRequestor.java:201)

          at org.netbeans.core.windows.ViewRequestor.scheduleRequest(ViewRequestor.java:121)

          at org.netbeans.core.windows.Central.setVisible(Central.java:140)

          at org.netbeans.core.windows.WindowManagerImpl.setVisible(WindowManagerImpl.java:926)

          at org.netbeans.core.windows.WindowSystemImpl.show(WindowSystemImpl.java:105)

          at org.netbeans.core.GuiRunLevel$InitWinSys.run(GuiRunLevel.java:246)

          at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:312)

          at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)

          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(ProtectionDomain.java:76)

          at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)

          at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

          at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

          at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

          at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

          at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)

          at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)

          at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)

          at java.security.AccessController.doPrivileged(Native Method)

          at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)

          at java.awt.Dialog.show(Dialog.java:1082)

          at java.awt.Component.show(Component.java:1651)

          at java.awt.Component.setVisible(Component.java:1603)

          at java.awt.Window.setVisible(Window.java:1014)

          at java.awt.Dialog.setVisible(Dialog.java:1005)

          at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:400)

          at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:361)

          at oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:55)

          at oracle.dbtools.raptor.dialogs.conn.ConnectionInfoPanel$1.run(ConnectionInfoPanel.java:108)

          at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:302)

          at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)

          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(ProtectionDomain.java:76)

          at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)

          at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

          at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

          at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

          at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

          at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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=0x0000000009f07800 nid=0x834 runnable [0x000000000a5af000]

         java.lang.Thread.State: RUNNABLE

          at sun.awt.windows.WToolkit.eventLoop(Native Method)

          at sun.awt.windows.WToolkit.run(WToolkit.java:307)

          at java.lang.Thread.run(Thread.java:745)

       

      "AWT-Shutdown" prio=6 tid=0x0000000009f07000 nid=0x1b8 in Object.wait() [0x000000000a4af000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000cead8560> (a java.lang.Object)

          at java.lang.Object.wait(Object.java:503)

          at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:296)

          - locked <0x00000000cead8560> (a java.lang.Object)

          at java.lang.Thread.run(Thread.java:745)

       

      "Java2D Disposer" daemon prio=10 tid=0x0000000009f05800 nid=0x11f0 in Object.wait() [0x000000000a3af000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000cf6204b8> (a java.lang.ref.ReferenceQueue$Lock)

          at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)

          - locked <0x00000000cf6204b8> (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:745)

       

      "Service Thread" daemon prio=6 tid=0x00000000085ad800 nid=0x89c runnable [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

      "C2 CompilerThread1" daemon prio=10 tid=0x00000000085ab800 nid=0x2e0 waiting on condition [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

      "C2 CompilerThread0" daemon prio=10 tid=0x00000000085a6800 nid=0xb00 waiting on condition [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

      "Attach Listener" daemon prio=10 tid=0x00000000085a4800 nid=0xe4c waiting on condition [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

      "Signal Dispatcher" daemon prio=10 tid=0x000000000859d000 nid=0x9fc runnable [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

      "Finalizer" daemon prio=8 tid=0x000000000854b800 nid=0x1308 in Object.wait() [0x00000000098af000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000ceb098f8> (a java.lang.ref.ReferenceQueue$Lock)

          at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)

          - locked <0x00000000ceb098f8> (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=0x0000000008542800 nid=0xe5c in Object.wait() [0x00000000097af000]

         java.lang.Thread.State: WAITING (on object monitor)

          at java.lang.Object.wait(Native Method)

          - waiting on <0x00000000ceb09480> (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 <0x00000000ceb09480> (a java.lang.ref.Reference$Lock)

       

      "main" prio=6 tid=0x000000000245c800 nid=0xac4 waiting on condition [0x0000000000000000]

         java.lang.Thread.State: RUNNABLE

       

      "VM Thread" prio=10 tid=0x0000000008541000 nid=0xe58 runnable

       

      "GC task thread#0 (ParallelGC)" prio=6 tid=0x0000000002472800 nid=0xddc runnable

       

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

       

      "GC task thread#2 (ParallelGC)" prio=6 tid=0x0000000002477000 nid=0x134c runnable

       

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

       

      "VM Periodic Task Thread" prio=10 tid=0x00000000085be800 nid=0xaf4 waiting on condition

       

      JNI global references: 925

        • 1. Re: hanging issue SQL*dev 4.03
          Gary Graham-Oracle

          Hi Karsten,

           

          In order to preserve your connection information, it is always best to right-click on the top level node in the Connections view and select the Export Connections... item to make a backup copy.  Or you can can try the -Dide.user.dir trick mentioned toward the end of this discussion: 4.0.3.16.84-x64 - hangs with "Waiting for Editor to initialize" when trying to workaround any user settings issue.

           

          In terms of the full thread dump you provide, we can see the main event thread is waiting on another thread trying to prompt for a connection's password.  Of course, there should be no attempt to restore a connection upon start-up. This is similar to (or exactly the same as?) a bug fixed for 4.0.2 or 4.0.3 (cannot recall which) found in one of the prior 4.0.x releases.  Are you sure you are running 4.0.3 and actually unzipped it into an empty directory?  Never overwrite an existing SQL Developer install!  Perhaps you have encountered a variant of the bug already fixed, but verify that you are running a cleanly installed 4.0.3 first.

           

          Regards,
          Gary

          SQL Developer Team

          • 2. Re: hanging issue SQL*dev 4.03
            KarstenH-dk

            Hi Gary

             

            I am sure I am running 4.0.3 and I did actually unzipped it into an empty directory.

             

            I did save my connections.xml before deleting the installation and pasted it into ......\AppData\Roaming\SQL Developer\system4.0.3.16.84\o.jdeveloper.db.connection.12.1.3.2.41.140908.1359\, so I did not loose my connections, as I claimed, sorry about this.

             

            regards Karsten

            • 3. Re: hanging issue SQL*dev 4.03
              Gary Graham-Oracle

              Karsten,

               

              My memory was a bit off on this.  Although the bug has definitely been fixed...

              • It got fixed on the main code line for the next major release of SQL Developer.
              • The fix was not back-ported to 4.0.3 even though it was available long before the Sep 15th release date.

              You did not mention it, but the bug was logged based on your own original report of it on this forum...

              Sql-developer 4.02.15.21 hangs during startup

               

              Sorry your wait will be longer than it should have been...

              Gary