SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

19.2 hangs while populating object tree in the connection pane.

stomAug 19 2019 — edited Aug 19 2019

Hi,

On SQL Developer 19.2, when I connect to a database, I see the editor window almost immediately but any query I run does not return results. I have tried "select sysdate from dual" also.

On the bottom of the editor, I see activity on the status bar. The "Running:" progress bar shows something is working in the background.

From a different IDE, I see that SQL Dev is trying to execute this query,

SELECT object_type, owner, object_name
  FROM all_objects
 WHERE     object_type IN ('TABLE',
                           'VIEW',
                           'SYNONYM',
                           'PACKAGE',
                           'PROCEDURE',
                           'FUNCTION',
                           'SEQUENCE')
       AND object_name NOT LIKE 'BIN$%'

I also see that my object tree in the connection pane hasn't been populated yet. It still says "Loading". Running the query manually (in a different IDE) returns the resultset immediately.

(After waiting for ~ 20 minutes) If I kill this session (from sqlplus), the object tree is populated and I can use my editor window normally.

I cannot replicate this problem in SQL Dev 19.1. This doesn't happen for every database, only some databases.

Database version:

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

This is happening on Windows 7.

Thread dump:

        at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractP
references.java:1482)
        - locked <0x0000000080824de0> (a java.util.LinkedList)
"ChangeSetService" #36 daemon prio=1 os_prio=-2 tid=0x000000002331f800 nid=0x28e
c in Object.wait() [0x000000002c0ce000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x000000008418fc78> (a oracle.jdevimpl.vcs.changeset.Chang
eSetService)
        at java.lang.Object.wait(Object.java:502)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetS
ervice.java:131)
        - locked <0x000000008418fc78> (a oracle.jdevimpl.vcs.changeset.ChangeSet
Service)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetSer
vice.java:152)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$000(ChangeSetSe
rvice.java:60)
        at oracle.jdevimpl.vcs.changeset.ChangeSetService$1.run(ChangeSetService
.java:99)
        at java.lang.Thread.run(Thread.java:748)
"Scheduler" #35 daemon prio=5 os_prio=0 tid=0x000000002331f000 nid=0x338c in Obj
ect.wait() [0x000000002ad5e000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:502)
        at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(Task
LinkedList.java:47)
        - locked <0x00000000830d8a10> (a oracle.dbtools.raptor.backgroundTask.Ta
skLinkedList)
        at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThrea
d.run(RaptorTaskManager.java:548)
"Log Poller" #34 prio=1 os_prio=-2 tid=0x000000002331e000 nid=0x1b4 waiting on c
ondition [0x000000002911e000]
   java.lang.Thread.State: WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x000000008283f210> (a java.util.concurrent.lock
s.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject
.await(AbstractQueuedSynchronizer.java:2039)
        at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.jav
a:442)
        at oracle.ide.log.QueuedLoggingHandler.take(QueuedLoggingHandler.java:60
)
        at oracle.ideimpl.log.TabbedLogManager$4.run(TabbedLogManager.java:333)
        at java.lang.Thread.run(Thread.java:748)
"Inactive RequestProcessor thread [Was:TimedSoftReference/org.openide.util.Timed
SoftReference]" #32 daemon prio=1 os_prio=-2 tid=0x000000002331d800 nid=0x221c i
n Object.wait() [0x0000000028fdf000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java
:2002)
        - locked <0x00000000828a2590> (a java.lang.Object)
"TimedCache-Timer" #30 daemon prio=5 os_prio=0 tid=0x000000002331a800 nid=0xe00
in Object.wait() [0x000000002884f000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        - waiting on <0x000000008182b778> (a java.util.TaskQueue)
        at java.util.TimerThread.mainLoop(Timer.java:552)
        - locked <0x000000008182b778> (a java.util.TaskQueue)
        at java.util.TimerThread.run(Timer.java:505)
"Framework Event Dispatcher" #26 daemon prio=6 os_prio=0 tid=0x0000000023319800
nid=0x1c60 in Object.wait() [0x0000000026aff000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:502)
        at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextE
vent(EventManager.java:400)
        - locked <0x00000000808798e8> (a org.eclipse.osgi.framework.eventmgr.Eve
ntManager$EventThread)
        at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(Even
tManager.java:336)
"Inactive RequestProcessor thread [Was:Folder recognizer/org.openide.loaders.Fol
derList$ListTask]" #25 daemon prio=1 os_prio=-2 tid=0x0000000023319000 nid=0x353
4 in Object.wait() [0x00000000240bf000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java
:2002)
        - locked <0x0000000080d30f30> (a java.lang.Object)
"State Data Manager" #24 daemon prio=5 os_prio=0 tid=0x0000000023563000 nid=0x1d
24 waiting on condition [0x000000002455e000]
   java.lang.Thread.State: TIMED_WAITING (sleeping)
        at java.lang.Thread.sleep(Native Method)
        at org.eclipse.osgi.internal.baseadaptor.StateManager.run(StateManager.j
ava:297)
        at java.lang.Thread.run(Thread.java:748)
"Framework Active Thread" #23 prio=5 os_prio=0 tid=0x0000000023268000 nid=0x2184
 in Object.wait() [0x000000001d79f000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at org.eclipse.osgi.framework.internal.core.Framework.run(Framework.java
:1870)
        - locked <0x0000000080982260> (a org.eclipse.osgi.framework.internal.cor
e.Framework)
        at java.lang.Thread.run(Thread.java:748)
"Inactive RequestProcessor thread [Was:Folder recognizer/org.openide.loaders.Fol
derList$ListTask]" #22 daemon prio=5 os_prio=0 tid=0x0000000021bbb800 nid=0x6c0
in Object.wait() [0x0000000022c4e000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java
:2002)
        - locked <0x0000000080b8d1c0> (a java.lang.Object)
"RequestProcessor queue manager" #21 daemon prio=5 os_prio=0 tid=0x000000001bd12
800 nid=0x2958 in Object.wait() [0x0000000021b0e000]
   java.lang.Thread.State: TIMED_WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at org.openide.util.RequestProcessor$TickTac.obtainFirst(RequestProcesso
r.java:2282)
        - locked <0x0000000080beedd8> (a java.lang.Class for org.openide.util.Re
questProcessor$TickTac)
        at org.openide.util.RequestProcessor$TickTac.run(RequestProcessor.java:2
258)
"Active Reference Queue Daemon" #19 daemon prio=1 os_prio=-2 tid=0x000000001bcab
800 nid=0x2b78 in Object.wait() [0x000000001d8fe000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
        - locked <0x00000000808ab7b0> (a java.lang.ref.ReferenceQueue$Lock)
        at org.openide.util.lookup.implspi.ActiveQueue$Impl.removeSuper(ActiveQu
eue.java:93)
        at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.ja
va:131)
"TimerQueue" #17 daemon prio=5 os_prio=0 tid=0x000000001ba9a000 nid=0x21f8 runna
ble [0x000000001c34e000]
   java.lang.Thread.State: TIMED_WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x0000000080d63e98> (a java.util.concurrent.lock
s.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215
)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject
.awaitNanos(AbstractQueuedSynchronizer.java:2078)
        at java.util.concurrent.DelayQueue.take(DelayQueue.java:223)
        at javax.swing.TimerQueue.run(TimerQueue.java:174)
        at java.lang.Thread.run(Thread.java:748)
"AWT-EventQueue-0" #16 prio=6 os_prio=0 tid=0x000000001ba2d800 nid=0x101c waitin
g on condition [0x000000001c60f000]
   java.lang.Thread.State: WAITING (parking)
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for  <0x00000000809399a8> (a java.util.concurrent.lock
s.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject
.await(AbstractQueuedSynchronizer.java:2039)
        at java.awt.EventQueue.getNextEvent(EventQueue.java:554)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
ad.java:187)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
java:116)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:105)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
"AWT-Windows" #14 daemon prio=6 os_prio=0 tid=0x000000001ba2b800 nid=0x342c runn
able [0x000000001c47f000]
   java.lang.Thread.State: RUNNABLE
        at sun.awt.windows.WToolkit.eventLoop(Native Method)
        at sun.awt.windows.WToolkit.run(WToolkit.java:315)
        at java.lang.Thread.run(Thread.java:748)
"AWT-Shutdown" #13 prio=5 os_prio=0 tid=0x000000001ba2a800 nid=0x1550 in Object.
wait() [0x000000001c1df000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:502)
        at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:295)
        - locked <0x0000000080d640f8> (a java.lang.Object)
        at java.lang.Thread.run(Thread.java:748)
"Java2D Disposer" #12 daemon prio=10 os_prio=2 tid=0x000000001ba2a000 nid=0x2398
 in Object.wait() [0x0000000007aae000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
        - locked <0x0000000080d33738> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
        at sun.java2d.Disposer.run(Disposer.java:148)
        at java.lang.Thread.run(Thread.java:748)
"Service Thread" #10 daemon prio=9 os_prio=0 tid=0x0000000005f93800 nid=0x18f0 r
unnable [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"C1 CompilerThread3" #9 daemon prio=9 os_prio=2 tid=0x0000000005ef1000 nid=0x34d
c waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"C2 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x0000000005eee800 nid=0x179
8 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"C2 CompilerThread1" #7 daemon prio=9 os_prio=2 tid=0x0000000005eed800 nid=0x17c
4 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"C2 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x0000000005ee7800 nid=0x1b3
0 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x0000000005ee7000 nid=0x230c r
unnable [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x0000000005ee6000 nid=0x195c
 waiting on condition [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"Finalizer" #3 daemon prio=8 os_prio=1 tid=0x0000000004d2b000 nid=0x1748 in Obje
ct.wait() [0x000000000730e000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
        - locked <0x0000000080849af0> (a java.lang.ref.ReferenceQueue$Lock)
        at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
        at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:216)
"Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x0000000004d24000 nid=0x924
 in Object.wait() [0x0000000006f2f000]
   java.lang.Thread.State: WAITING (on object monitor)
        at java.lang.Object.wait(Native Method)
        at java.lang.Object.wait(Object.java:502)
        at java.lang.ref.Reference.tryHandlePending(Reference.java:191)
        - locked <0x00000000802f8448> (a java.lang.ref.Reference$Lock)
        at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:153)
"main" #1 prio=5 os_prio=0 tid=0x000000000248c800 nid=0x20a4 waiting on conditio
n [0x0000000000000000]
   java.lang.Thread.State: RUNNABLE
"VM Thread" os_prio=2 tid=0x0000000004d19000 nid=0x347c runnable
"GC task thread#0 (ParallelGC)" os_prio=0 tid=0x00000000024a3800 nid=0xfdc runna
ble
"GC task thread#1 (ParallelGC)" os_prio=0 tid=0x00000000024a5000 nid=0x3474 runn
able
"GC task thread#2 (ParallelGC)" os_prio=0 tid=0x00000000024a6800 nid=0x37b8 runn
able
"GC task thread#3 (ParallelGC)" os_prio=0 tid=0x00000000024a8800 nid=0x22c4 runn
able
"GC task thread#4 (ParallelGC)" os_prio=0 tid=0x00000000024ab800 nid=0x2c9c runn
able
"GC task thread#5 (ParallelGC)" os_prio=0 tid=0x00000000024ae800 nid=0x1d98 runn
able
"GC task thread#6 (ParallelGC)" os_prio=0 tid=0x00000000024b0000 nid=0x1fc runna
ble
"GC task thread#7 (ParallelGC)" os_prio=0 tid=0x00000000024b1000 nid=0x1890 runn
able
"VM Periodic Task Thread" os_prio=2 tid=0x0000000005faf800 nid=0x1188 waiting on
 condition
JNI global references: 2841
Heap
 PSYoungGen      total 367616K, used 315670K [0x00000000d5580000, 0x00000000f1a8
0000, 0x0000000100000000)
  eden space 327680K, 90% used [0x00000000d5580000,0x00000000e7644198,0x00000000
e9580000)
  from space 39936K, 50% used [0x00000000e9580000,0x00000000ea9019a8,0x00000000e
bc80000)
  to   space 38912K, 0% used [0x00000000ef480000,0x00000000ef480000,0x00000000f1
a80000)
 ParOldGen       total 264704K, used 99572K [0x0000000080000000, 0x0000000090280
000, 0x00000000d5580000)
  object space 264704K, 37% used [0x0000000080000000,0x000000008613d1b8,0x000000
0090280000)
 Metaspace       used 110815K, capacity 119040K, committed 119340K, reserved 115
0976K
  class space    used 15034K, capacity 17649K, committed 17708K, reserved 104857
6K

Thanks!

This post has been answered by stom on Aug 19 2019

Jump to Answer

Added on Aug 19 2019

#sql-developer

3 comments

513 views