8 Replies Latest reply on Nov 7, 2011 4:23 PM by Barry Mcgillin-Oracle

    Connection is currently busy.  Try again? - stuck

    479921
      I'm in a bind with SQL Developer 3.0.04 in that sometimes my connection attempt just hangs and there's nothing I can do except kill the app via Task Manager. This isn't consistent and even a reboot is necessary to correct things.

      What happens is I select a connection and click on SQL Worksheet (or alt-f10). Nothing further happens and I've tried waiting for minutes. If I try to close SD I get a popup "Connection is currently busy. Try again?". Clicking "Try again" leaves me in this endless hang. "Abort" just aborts the application close, which goes back to the hang. The last option is to use TM and kill the app. Even that causes SD to popup with the same window but at least Windows (XP) comes back and says the app isn't responding and do you really want to kill it.

      This situation never happened with 2.1.1. I'd really like to use 3.0.04 but I can't with this problem continuing to occur. Thx.
        • 1. Re: Connection is currently busy.  Try again? - stuck
          Barry Mcgillin-Oracle
          Hi there,

          Is this windows and are there ghost processes hanging around after you have killed these processes.
          Does SQL Developer work and connect at all? Can you startup from sqldeveloper/sqldeveloper/bin/sqldeveloper.exe and see what is shown in the console?

          Thanks
          Barry
          • 2. Re: Connection is currently busy.  Try again? - stuck
            479921
            This is Windows XP and I can validate there aren't ghost processes hanging around as I just rebooted, fired up SD and had the same problem.

            I killed the above attempt, then ran the .exe as you listed. The console didn't list anything so I issued ctrl-break and got the following:

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

            "IconOverlayTracker Timer" prio=6 tid=0x354fa400 nid=0x12f8 in Object.wait() [0x3855f000..0x3855fc14]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x07a07d00> (a java.util.TaskQueue)
            at java.lang.Object.wait(Object.java:485)
            at java.util.TimerThread.mainLoop(Timer.java:483)
            - locked <0x07a07d00> (a java.util.TaskQueue)
            at java.util.TimerThread.run(Timer.java:462)

            "WaitCursor-Timer" prio=6 tid=0x3559b400 nid=0x1244 in Object.wait() [0x381df000..0x381dfd94]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x079a33a0> (a java.util.TaskQueue)
            at java.lang.Object.wait(Object.java:485)
            at java.util.TimerThread.mainLoop(Timer.java:483)
            - locked <0x079a33a0> (a java.util.TaskQueue)
            at java.util.TimerThread.run(Timer.java:462)

            "BaseTreeExplorer.NodeOpeningExecutor" prio=6 tid=0x3536ac00 nid=0xd38 waiting on condition [0x380df000..0x380dfa94]
            java.lang.Thread.State: WAITING (parking)
            at sun.misc.Unsafe.park(Native Method)
            - parking to wait for <0x0713f280> (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:947)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
            at java.lang.Thread.run(Thread.java:619)

            "pool-2-thread-1" prio=6 tid=0x3538f800 nid=0x940 in Object.wait() [0x37fdf000..0x37fdfb14]
            java.lang.Thread.State: TIMED_WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x07debc10> (a java.io.PipedInputStream)
            at java.io.PipedInputStream.awaitSpace(PipedInputStream.java:257)
            at java.io.PipedInputStream.receive(PipedInputStream.java:215)
            - locked <0x07debc10> (a java.io.PipedInputStream)
            at java.io.PipedOutputStream.write(PipedOutputStream.java:132)
            at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105)
            - locked <0x07debcc8> (a java.io.BufferedOutputStream)
            at java.io.FilterOutputStream.write(FilterOutputStream.java:80)
            at oracle.dbtools.raptor.newscriptrunner.WrapListenBufferOutputStream.write(WrapListenBufferOutputStream.java:149)
            at oracle.dbtools.db.ResultSetFormatter.rset2sqlplus(ResultSetFormatter.java:121)
            at oracle.dbtools.raptor.newscriptrunner.SQL.executeQuery(SQL.java:427)
            at oracle.dbtools.raptor.newscriptrunner.SQL.run(SQL.java:48)
            at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQL(ScriptRunner.java:187)
            at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:127)
            at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:215)
            at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:145)
            at oracle.dbtools.raptor.scriptrunner.utils.ScriptUtils.runAsScript(ScriptUtils.java:114)
            at oracle.dbtools.raptor.scriptrunner.utils.ScriptUtils.runAsScript(ScriptUtils.java:71)
            at oracle.dbtools.raptor.InitializeConnectionListener.runLoginSql(InitializeConnectionListener.java:176)
            at oracle.dbtools.raptor.InitializeConnectionListener.initConnection(InitializeConnectionListener.java:132)
            at oracle.dbtools.raptor.InitializeConnectionListener$1.initializeConnection(InitializeConnectionListener.java:47)
            at oracle.dbtools.raptor.utils.Connections.initializeConnection(Connections.java:1602)
            at oracle.dbtools.raptor.utils.Connections.access$100(Connections.java:71)
            at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.getDatabase(Connections.java:189)
            - locked <0x0719cb10> (a oracle.dbtools.raptor.utils.Connections$ConnectionInfo)
            at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:986)
            at oracle.dbtools.worksheet.editor.OpenWorksheetWizard.open(OpenWorksheetWizard.java:354)
            at oracle.dbtools.worksheet.editor.OpenWorksheetWizard.access$200(OpenWorksheetWizard.java:76)
            at oracle.dbtools.worksheet.editor.OpenWorksheetWizard$2$1.doWork(OpenWorksheetWizard.java:328)
            at oracle.dbtools.worksheet.editor.OpenWorksheetWizard$2$1.doWork(OpenWorksheetWizard.java:324)
            at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
            at java.util.concurrent.FutureTask.run(FutureTask.java:138)
            at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:500)
            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
            at java.util.concurrent.FutureTask.run(FutureTask.java:138)
            at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
            at java.lang.Thread.run(Thread.java:619)

            "Scheduler" daemon prio=6 tid=0x3538f000 nid=0x878 in Object.wait() [0x37edf000..0x37edfb94]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x0713f4b0> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
            at java.lang.Object.wait(Object.java:485)
            at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)
            - locked <0x0713f4b0> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
            at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:429)

            "Thread-8" daemon prio=6 tid=0x354d9400 nid=0x1310 in Object.wait() [0x37ddf000..0x37ddfc14]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x0713f540> (a java.lang.ref.ReferenceQueue$Lock)
            at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
            - locked <0x0713f540> (a java.lang.ref.ReferenceQueue$Lock)
            at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
            at org.tmatesoft.svn.core.javahl.SVNClientImplTracker.run(SVNClientImplTracker.java:65)
            at java.lang.Thread.run(Thread.java:619)

            "Thread-6" daemon prio=6 tid=0x35280800 nid=0xc2c runnable [0x3749f000..0x3749fd14]
            java.lang.Thread.State: RUNNABLE
            at sun.print.Win32PrintServiceLookup.notifyPrinterChange(Native Method)
            at sun.print.Win32PrintServiceLookup.access$100(Win32PrintServiceLookup.java:32)
            at sun.print.Win32PrintServiceLookup$PrinterChangeListener.run(Win32PrintServiceLookup.java:302)

            "ChangeSetService" prio=2 tid=0x3526ac00 nid=0xda8 in Object.wait() [0x3729f000..0x3729fa14]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x06c9fef0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
            at java.lang.Object.wait(Object.java:485)
            at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:178)
            - locked <0x06c9fef0> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
            at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:199)
            at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$200(ChangeSetService.java:56)
            at oracle.jdevimpl.vcs.changeset.ChangeSetService$2.run(ChangeSetService.java:138)
            at java.lang.Thread.run(Thread.java:619)

            "TimerQueue" daemon prio=6 tid=0x35043800 nid=0x9e4 in Object.wait() [0x36f9f000..0x36f9fb14]
            java.lang.Thread.State: TIMED_WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x06bea528> (a javax.swing.TimerQueue)
            at javax.swing.TimerQueue.run(TimerQueue.java:236)
            - locked <0x06bea528> (a javax.swing.TimerQueue)
            at java.lang.Thread.run(Thread.java:619)

            "TimedCache-Timer" daemon prio=6 tid=0x33a90000 nid=0x1764 in Object.wait() [0x346df000..0x346dfc94]
            java.lang.Thread.State: TIMED_WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x06316c70> (a java.util.TaskQueue)
            at java.util.TimerThread.mainLoop(Timer.java:509)
            - locked <0x06316c70> (a java.util.TaskQueue)
            at java.util.TimerThread.run(Timer.java:462)

            "JarIndex Timer" daemon prio=6 tid=0x33a86800 nid=0xac0 in Object.wait() [0x341df000..0x341dfd14]
            java.lang.Thread.State: TIMED_WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x0625b020> (a java.util.TaskQueue)
            at java.util.TimerThread.mainLoop(Timer.java:509)
            - locked <0x0625b020> (a java.util.TaskQueue)
            at java.util.TimerThread.run(Timer.java:462)

            "AWT-EventQueue-0" prio=6 tid=0x33a57400 nid=0x14e8 in Object.wait() [0x33faf000..0x33fafd94]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x0625b0d0> (a java.awt.EventQueue)
            at java.lang.Object.wait(Object.java:485)
            at java.awt.EventQueue.getNextEvent(EventQueue.java:479)
            - locked <0x0625b0d0> (a java.awt.EventQueue)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:236)
            at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
            at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

            "AWT-Windows" daemon prio=6 tid=0x33a1c400 nid=0xc98 runnable [0x33daf000..0x33dafa94]
            java.lang.Thread.State: RUNNABLE
            at sun.awt.windows.WToolkit.eventLoop(Native Method)
            at sun.awt.windows.WToolkit.run(WToolkit.java:291)
            at java.lang.Thread.run(Thread.java:619)

            "AWT-Shutdown" prio=6 tid=0x33a29400 nid=0xf34 in Object.wait() [0x33caf000..0x33cafb14]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x0625b228> (a java.lang.Object)
            at java.lang.Object.wait(Object.java:485)
            at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259)
            - locked <0x0625b228> (a java.lang.Object)
            at java.lang.Thread.run(Thread.java:619)

            "Java2D Disposer" daemon prio=10 tid=0x33a15c00 nid=0x1430 in Object.wait() [0x33baf000..0x33bafb94]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x0625b2b8> (a java.lang.ref.ReferenceQueue$Lock)
            at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
            - locked <0x0625b2b8> (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=0x00f52c00 nid=0x9fc runnable [0x00000000..0x00000000]
            java.lang.Thread.State: RUNNABLE

            "CompilerThread0" daemon prio=10 tid=0x00f4fc00 nid=0x1374 waiting on condition[0x00000000..0x336afa3c]
            java.lang.Thread.State: RUNNABLE

            "Attach Listener" daemon prio=10 tid=0x00f4e400 nid=0xc7c runnable [0x00000000..0x00000000]
            java.lang.Thread.State: RUNNABLE

            "Signal Dispatcher" daemon prio=10 tid=0x00f4d000 nid=0x6c8 waiting on condition [0x00000000..0x00000000]
            java.lang.Thread.State: RUNNABLE

            "Finalizer" daemon prio=8 tid=0x00f3d000 nid=0x15a0 in Object.wait() [0x333af000..0x333afa94]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x061e0298> (a java.lang.ref.ReferenceQueue$Lock)
            at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
            - locked <0x061e0298> (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=10 tid=0x00f38800 nid=0xf1c in Object.wait() [0x332af000..0x332afb14]
            java.lang.Thread.State: WAITING (on object monitor)
            at java.lang.Object.wait(Native Method)
            - waiting on <0x061e0320> (a java.lang.ref.Reference$Lock)
            at java.lang.Object.wait(Object.java:485)
            at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)
            - locked <0x061e0320> (a java.lang.ref.Reference$Lock)

            "main" prio=6 tid=0x00937800 nid=0x1018 waiting on condition [0x00000000..0x0012fae8]
            java.lang.Thread.State: RUNNABLE

            "VM Thread" prio=10 tid=0x00f35000 nid=0xb28 runnable

            "VM Periodic Task Thread" prio=10 tid=0x00f54400 nid=0x1760 waiting on condition

            JNI global references: 2916

            Heap
            def new generation total 9216K, used 1176K [0x030b0000, 0x03aa0000, 0x061e0000)
            eden space 8256K, 12% used [0x030b0000, 0x031b2f08, 0x038c0000)
            from space 960K, 14% used [0x038c0000, 0x038e3428, 0x039b0000)
            to space 960K, 0% used [0x039b0000, 0x039b0000, 0x03aa0000)
            tenured generation total 121024K, used 30598K [0x061e0000, 0x0d810000, 0x2b0b0000)
            the space 121024K, 25% used [0x061e0000, 0x07fc1bd0, 0x07fc1c00, 0x0d810000)
            compacting perm gen total 62208K, used 62069K [0x2b0b0000, 0x2ed70000, 0x330b0000)
            the space 62208K, 99% used [0x2b0b0000, 0x2ed4d600, 0x2ed4d600, 0x2ed70000)
            No shared spaces configured.
            • 3. Re: Connection is currently busy.  Try again? - stuck
              896752
              Same thing happens to me in 3.0.04 when working with MVs
              • 4. Re: Connection is currently busy.  Try again? - stuck
                mwickham-Oracle
                Have you tried applying the patch from Help Check for updates?
                Or are you having the same issue with 3.1?
                • 5. Re: Connection is currently busy.  Try again? - stuck
                  479921
                  I found the problem - my login.sql script was a copy of what I previously used for sqlplus command line. It had a number of "SET" commands that SQL*Worksheet doesn't like but for whatever reason now hangs on under 3.0.

                  I think I'll wait until 3.1 is done with beta before giving it a shot.
                  • 6. Re: Connection is currently busy.  Try again? - stuck
                    Gary Graham-Oracle
                    Hi Dave,

                    Please share which "SET" commands in your login.sql cause SQL Developer 3.0 to hang. After all, without knowing what doesn't work, there is zero chance of fixing it.

                    Comparing 3.0 vs 3.1 EA1 behavior on my old login.sql, I see fewer "SQLPLUS Command Skipped: ..." messages in the 3.1 log versus the 3.0 log, but nothing that results in a hang on either version.

                    Playing around, I did notice that "host vi" does nasty things (whether in login.sql or the worksheet), but presumably your commands don't try to launch any UI's.

                    Thanks in advance for any tips.

                    Regards,
                    Gary
                    SQL Developer Team
                    • 7. Re: Connection is currently busy.  Try again? - stuck
                      479921
                      Unfortunately I can't seem to replicate the issue. I could be that the problem is more with docking/undocking of my laptop and the effects that has on background resources. My docking station is also wireless, so it's not like I'm switching between wired and wireless. I'll update this thread if/when I can replicate this and provide more details.
                      • 8. Re: Connection is currently busy.  Try again? - stuck
                        Barry Mcgillin-Oracle
                        For your login.sql, there is a bug with set pagesize and set linesize right now. If you dont use these in the login.sql there should be no hangs on using this. The bug has been logged