Skip to Main Content
Forums

Infrastructure Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Solaris 10 Oracle VDI VirtualBox 3.2 USB support

850459Mar 25 2011 — edited Apr 4 2011
Dear folks,

This my first time to the forum, since we are in the progress of deploying 240+ thin clients using Oracle VDI. I was piloting the project in a desktop machines with Sunray 3i. I installed Solaris 10 9/10 and Oracle VDI 3.2.1. However, while I was creating WinXP VM in Virtualbox 3.2 -the one which came with Oracle VDI 3.2- I got that error about being unable to connect to USB proxy server. Eventually this error leads to that all my VMs doesn't support USB redirection. So USB flash disk drive doesn't work in my Sunray 3i. Reading VirtualBox documentation Installing on Solaris hosts , I came across this info "*This does not apply to Solaris 10 hosts due to lack of USB support.*" Is this real?

Does this mean I can't redirect USB hardware to my VMs in the server via Sunray 3i? If this is true, what is the workaround for this problem?

Please advise me. . .

Comments

Glen Conway

No doubt the full thread dump will help a developer to identify the bug in the SQL Developer tool. It may help even more, though, if you provide a more detailed description of what you are doing when the hang occurs.  For example,

1) If I just change a comment in a large package, Ctrl-S works fine on 20.2

2) Back on 19.2.1, another poster reported a hang when changing the package name during the editing process: Unresponsive after changing package name.

So any additional information would help the community help you.

Cheers

TMohamme

Hi Glen,

Some more details about the issue:

1. Not on any particular change in package like name or comment. I see this issue on Save irrespective of the type of changes

2. This issue is not always consistent. Sometimes ctrl+s just works fine.

3. The log is generated when SQL Dev hung up with the issue.

4. I am using Windows 10 OS

Any other info do you think would be helpful?

Glen Conway

Of course, the ideal is to find a reproducible test case.  Given that SQL Developer becomes unresponsive (hangs), killing and restarting it simply clears up whatever is blocking things.

Some possibilities:

1) You are waiting on the database to respond.  In that case SQL Developer should not be using CPU, it is just waiting.

2) You are running into a Java Virtual Machine memory limit. In that case SQL Developer will use lots of CPU as Java garbage collection works to free up memory.

If "the issue is not always consistent", it may be due to other things done earlier in a session that eventually becomes unresponsive. Can the problem occur early in a session, or only after you have done lots of work / have lots of things open within SQL Developer?  I seem to recall that lots of SwingWorker-pool threads may be a sign of waiting on the database, but not really sure.

1 person found this helpful
thatJeffSmith-Oracle

While we're checking to see if the connection is alive, THAT check is hanging...and the save does a compile on the DB connection, which can't happen while the connection is unavailable.

Workaround, reconnect/disconnect before you hit save. We're looking into this further...

TMohamme

Thanks for looking into this.

My other colleagues also reported this issue.

It would be very helpful if you could update us when a fix is available. :-)

To make the workaround you suggested more convenient, is there any keyboard shortcut to reconnect existing connection from worksheet?

Glen Conway

If you and your colleagues are all working / developing against the same database instance, perhaps you should have a DBA check into the health of that database. Maybe there are times when it becomes overloaded, or the dictionary statistics have become stale, or even some server hardware or network issue is manifesting intermittently.

If others start reporting the same issue, then it is much more likely the SQL Developer team will find a bug.

TMohamme

If its a problem with the database, then other connectors like sqlplus, sql workshop (from APEX) all should show issues. But thats not the case. I believe this issue is specific to SQL Developer.

TMohamme

I really think 20.2 isn't stable at all. It freezes very often. Even when I try running a query. The wait time between successful queries is also not too long that it has to connect again. The older version I used was atleast better than 20.2 it froze less often I want to move back to 17.3, But the problem is I am unable to import JSON into 17.3 or export connections into XML in 20.1. Any help? Thanks in advance

2 people found this helpful
thatJeffSmith-Oracle

I can't help with this kind of report. When it freezes, grab a jstack. Then post a new thread here with the conditions/what you were doing, and that jstack.

>>To make the workaround you suggested more convenient, is there any keyboard shortcut to reconnect existing connection from worksheet? -- yes, on the connection tree, find your connection, right-click, reconnect

Glen Conway

I think @"TMohamme" originally posted a jstack for the compilation hang issue.  Somehow it got deleted.  That is how you figured out the problem involved the isAlive check.

I am still curious to know if anyone else will report a similar problem, or additional hang scenarios, and, more importantly, provide some reproducible test cases.

Glen Conway

I think I went from 17.2 to 17.4.  Not sure about 17.3.

Are you still on the same computer where 17.3 was used?  Unless you deleted your old user settings, you may be able to find the connections.xml file in the C:\Users\<yourID>\AppData\Roaming\SQL Developer\system17.3.n.n.n directory structure.

Peter Cunningham

Getting this intermittently just hitting ctrl+enter to execute a query. Have had to switch back temporarily to 19.4.

Also lost shortcut keys I had set up when moving from 19.4 to 20.2.

Rgds,

Peter.

Glen Conway

As @"thatJeffSmith-Oracle" said,

When it freezes, grab a jstack. Then post a new thread here with the conditions/what you were doing, and that jstack.

Which, if you haven't used JSTACK before, means...

1) If you start SQL Developer from sqldeveloper\sqldeveloper\bin directory, it also opens a Cmd window / console.  Go there and do a Ctrl-Break to get full thread dump. Hopefully it all fits in the screen buffer.

or

1) Have a Cmd window already open. Either CD to the Java bin directory or have the Java bin directory in your PATH environment variable.  
2) Run JPS to get the PID of the OracleIdeLauncher process.
3) Run JSTACK pid_value.  If the output if too large to fit into the screen buffer you can redirect it to a file: JSTACK pid_value > mystack.log

Reproducible test cases are important, as is keeping each discussion focused on a specific problem.

Cheers

User_KSUBW

I am also facing similar issue with SQL Developer (Version 20.2.0.175 Build 175.1842). It just freezes randomly i.e. I am not able to identify the steps when it hangs. I am using the SQL developer without the prepackaged JDK.
Java version 1.8.0_251, OS: Win 10 enterprise
JStack when it hangs when selecting a query for execution:
.\jstack.exe -F 20808
Attaching to process ID 20808, please wait...
Debugger attached successfully.
Server compiler detected.
JVM version is 25.251-b08
Deadlock Detection:
No deadlocks found.
Thread 68: (state = IN_VM)
Thread 75: (state = NEW)
Thread 74: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • sun.awt.image.ImageFetcher.nextImage() @bci=69, line=147 (Compiled frame)
  • sun.awt.image.ImageFetcher.fetchloop() @bci=23, line=200 (Interpreted frame)
  • sun.awt.image.ImageFetcher.run() @bci=5, line=169 (Interpreted frame)
    Thread 73: (state = IN_VM)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame; information may be imprecise)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame)
  • oracle.dbtools.arbori.Attribute.unaryFilter(oracle.dbtools.arbori.Predicate, java.lang.String) @bci=205, line=125 (Compiled frame)
  • oracle.dbtools.arbori.IndependentAttribute.initContent(oracle.dbtools.parser.ParseNode, java.util.List, java.util.Map, java.lang.String) @bci=263, line=67 (Compiled frame)
  • oracle.dbtools.arbori.AttributeDefinitions.evalDimensions(oracle.dbtools.parser.Parsed, boolean) @bci=201, line=193 (Compiled frame)
  • oracle.dbtools.arbori.Program._eval(oracle.dbtools.parser.Parsed, java.lang.String) @bci=49, line=1200 (Compiled frame)
  • oracle.dbtools.arbori.Program.eval(oracle.dbtools.parser.Parsed, java.lang.Object) @bci=237, line=1081 (Compiled frame)
  • oracle.dbtools.arbori.Program.eval(oracle.dbtools.parser.Parsed) @bci=6, line=1047 (Compiled frame)
  • oracle.dbtools.raptor.phighlight.SemanticAnalysis.doIt(java.util.List, java.lang.String, oracle.dbtools.parser.ParseNode, int, int, java.util.Set, java.lang.String) @bci=69, line=82 (Compiled frame)
  • oracle.dbtools.raptor.phighlight.HighlightEditorPlugin$3.run() @bci=92, line=478 (Compiled frame)

Thread 63: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • org.openide.util.RequestProcessor$TickTac.obtainFirst() @bci=57, line=2282 (Compiled frame)
  • org.openide.util.RequestProcessor$TickTac.run() @bci=7, line=2258 (Interpreted frame)

Thread 62: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.parkNanos(java.lang.Object, long) @bci=20, line=215 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(long) @bci=78, line=2078 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.poll(long, java.util.concurrent.TimeUnit) @bci=80, line=1120 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.poll(long, java.util.concurrent.TimeUnit) @bci=3, line=809 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=134, line=1073 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

Thread 61: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Compiled frame)
  • java.awt.EventQueue.invokeAndWait(java.lang.Object, java.lang.Runnable) @bci=56, line=1343 (Interpreted frame)
  • java.awt.EventQueue.invokeAndWait(java.lang.Runnable) @bci=4, line=1324 (Interpreted frame)
  • javax.swing.SwingUtilities.invokeAndWait(java.lang.Runnable) @bci=1, line=1353 (Interpreted frame)
  • oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.resetCursor(oracle.dbtools.worksheet.commands.scriptrunner.task.CommandRunnerScope) @bci=32, line=346 (Interpreted frame)
  • oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.doWork() @bci=151, line=246 (Interpreted frame)
  • oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.doWork() @bci=1, line=67 (Interpreted frame)
  • oracle.dbtools.raptor.backgroundTask.RaptorTask.call() @bci=10, line=199 (Compiled frame)
  • java.util.concurrent.FutureTask.run() @bci=42, line=266 (Compiled frame)
  • oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run() @bci=92, line=702 (Compiled frame)
  • java.util.concurrent.Executors$RunnableAdapter.call() @bci=4, line=511 (Compiled frame)
  • java.util.concurrent.FutureTask.run() @bci=42, line=266 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=95, line=1149 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

Thread 60: (state = IN_NATIVE)

  • sun.nio.ch.Iocp.getQueuedCompletionStatus(long, sun.nio.ch.Iocp$CompletionStatus) @bci=0 (Interpreted frame)
  • sun.nio.ch.Iocp.access$300(long, sun.nio.ch.Iocp$CompletionStatus) @bci=2, line=46 (Interpreted frame)
  • sun.nio.ch.Iocp$EventHandlerTask.run() @bci=45, line=333 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)
  • sun.misc.InnocuousThread.run() @bci=20, line=106 (Interpreted frame)

Thread 59: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.parkNanos(java.lang.Object, long) @bci=20, line=215 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(long) @bci=78, line=2078 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take() @bci=124, line=1093 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take() @bci=1, line=809 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

Thread 58: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.BackgroundParser$1.construct() @bci=21, line=160 (Compiled frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

Thread 57: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • org.openide.util.RequestProcessor$Processor.run() @bci=24, line=2002 (Interpreted frame)

Thread 56: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • sun.awt.image.GifFrame.dispose() @bci=26, line=670 (Compiled frame)
  • sun.awt.image.GifImageDecoder.readImage(boolean, int, int) @bci=11, line=458 (Compiled frame)
  • sun.awt.image.GifImageDecoder.produceImage() @bci=484, line=212 (Compiled frame)
  • sun.awt.image.InputStreamImageSource.doFetch() @bci=51, line=269 (Compiled frame)
  • sun.awt.image.ImageFetcher.fetchloop() @bci=33, line=205 (Interpreted frame)
  • sun.awt.image.ImageFetcher.run() @bci=5, line=169 (Interpreted frame)

Thread 55: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Compiled frame)
  • java.util.concurrent.DelayQueue.take() @bci=28, line=211 (Compiled frame)
  • oracle.ide.status.StatusExecutor$StatusQueue.take() @bci=4, line=338 (Interpreted frame)
  • oracle.ide.status.StatusExecutor$StatusQueue.take() @bci=1, line=300 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 54: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.ref.ReferenceQueue.remove(long) @bci=59, line=144 (Compiled frame)
  • java.lang.ref.ReferenceQueue.remove() @bci=2, line=165 (Compiled frame)
  • oracle.ide.util.WeakDataReference$Cleaner.run() @bci=3, line=88 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 53: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.BackgroundParser$1.construct() @bci=21, line=160 (Compiled frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 52: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.ref.ReferenceQueue.remove(long) @bci=59, line=144 (Compiled frame)
  • java.lang.ref.ReferenceQueue.remove() @bci=2, line=165 (Compiled frame)
  • oracle.ide.model.FacadeBufferReference$PollingThread.run() @bci=3, line=145 (Interpreted frame)

Thread 51: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run() @bci=12, line=331 (Interpreted frame)

Thread 50: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Compiled frame)
  • java.util.TimerThread.mainLoop() @bci=28, line=526 (Interpreted frame)
  • java.util.TimerThread.run() @bci=1, line=505 (Interpreted frame)

Thread 49: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.parkNanos(java.lang.Object, long) @bci=20, line=215 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(long) @bci=78, line=2078 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take() @bci=124, line=1093 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take() @bci=1, line=809 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 48: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.structure.arbori.BackgroundParser$1.construct() @bci=21, line=147 (Compiled frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 47: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.BackgroundParser$1.construct() @bci=21, line=160 (Compiled frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 46: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.structure.arbori.BackgroundParser$1.construct()
User_KSUBW

JStack when trying to select version from About dialogue :)
.\jstack.exe -F 15836
Attaching to process ID 15836, please wait...
Debugger attached successfully.
Server compiler detected.
JVM version is 25.251-b08
Deadlock Detection:
No deadlocks found.
Thread 51: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.structure.arbori.BackgroundParser$1.construct() @bci=21, line=147 (Interpreted frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 50: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.BackgroundParser$1.construct() @bci=21, line=160 (Interpreted frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 49: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.structure.arbori.BackgroundParser$1.construct() @bci=21, line=147 (Interpreted frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 47: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Compiled frame)
  • java.util.concurrent.LinkedBlockingQueue.take() @bci=29, line=442 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • sun.awt.shell.Win32ShellFolderManager2$ComInvoker$3.run() @bci=7, line=585 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 46: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.ref.ReferenceQueue.remove(long) @bci=59, line=144 (Compiled frame)
  • java.lang.ref.ReferenceQueue.remove() @bci=2, line=165 (Compiled frame)
  • com.sun.webkit.Disposer.run() @bci=3, line=122 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 45: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.ref.ReferenceQueue.remove(long) @bci=59, line=144 (Compiled frame)
  • java.lang.ref.ReferenceQueue.remove() @bci=2, line=165 (Compiled frame)
  • com.sun.javafx.font.Disposer.run() @bci=3, line=93 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 44: (state = IN_VM)

  • sun.misc.Unsafe.unpark(java.lang.Object) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.unpark(java.lang.Thread) @bci=8, line=141 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.unparkSuccessor(java.util.concurrent.locks.AbstractQueuedSynchronizer$Node) @bci=80, line=662 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.release(int) @bci=26, line=1264 (Compiled frame)
  • java.util.concurrent.locks.ReentrantLock.unlock() @bci=5, line=457 (Compiled frame)
  • java.util.concurrent.LinkedBlockingDeque.offerLast(java.lang.Object) @bci=38, line=364 (Compiled frame)
  • java.util.concurrent.LinkedBlockingDeque.addLast(java.lang.Object) @bci=2, line=334 (Compiled frame)
  • com.sun.glass.ui.InvokeLaterDispatcher.invokeLater(java.lang.Runnable) @bci=5, line=160 (Compiled frame)
  • com.sun.glass.ui.win.WinApplication._invokeLater(java.lang.Runnable) @bci=12, line=340 (Compiled frame)
  • com.sun.glass.ui.Application.invokeLater(java.lang.Runnable) @bci=9, line=481 (Compiled frame)
  • com.sun.javafx.tk.quantum.QuantumToolkit.postPulse() @bci=41, line=481 (Compiled frame)
  • com.sun.javafx.tk.quantum.QuantumToolkit.lambda$runToolkit$12() @bci=1, line=343 (Compiled frame)
  • com.sun.javafx.tk.quantum.QuantumToolkit$$Lambda$96.run() @bci=4 (Compiled frame)

Thread 43: (state = IN_NATIVE)

  • com.sun.glass.ui.win.WinApplication._runLoop(java.lang.Runnable) @bci=0 (Interpreted frame)
  • com.sun.glass.ui.win.WinApplication.lambda$null$4(int, java.lang.Runnable) @bci=8, line=186 (Interpreted frame)
  • com.sun.glass.ui.win.WinApplication$$Lambda$91.run() @bci=12 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 42: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Compiled frame)
  • java.util.concurrent.LinkedBlockingDeque.takeFirst() @bci=22, line=492 (Compiled frame)
  • com.sun.glass.ui.InvokeLaterDispatcher.run() @bci=4, line=108 (Interpreted frame)

Thread 41: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Compiled frame)
  • java.util.concurrent.LinkedBlockingQueue.take() @bci=29, line=442 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • com.sun.javafx.tk.quantum.QuantumRenderer$PipelineRunnable.run() @bci=8, line=125 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 40: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Interpreted frame)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Compiled frame)
  • java.util.concurrent.DelayQueue.take() @bci=28, line=211 (Interpreted frame)
  • oracle.ide.status.StatusExecutor$StatusQueue.take() @bci=4, line=338 (Interpreted frame)
  • oracle.ide.status.StatusExecutor$StatusQueue.take() @bci=1, line=300 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 39: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.ref.ReferenceQueue.remove(long) @bci=59, line=144 (Compiled frame)
  • java.lang.ref.ReferenceQueue.remove() @bci=2, line=165 (Compiled frame)
  • oracle.ide.util.WeakDataReference$Cleaner.run() @bci=3, line=88 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 38: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Interpreted frame)
  • java.util.TimerThread.mainLoop() @bci=28, line=526 (Interpreted frame)
  • java.util.TimerThread.run() @bci=1, line=505 (Interpreted frame)

Thread 37: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(java.util.concurrent.SynchronousQueue$TransferStack$SNode, boolean, long) @bci=144, line=458 (Interpreted frame)
  • java.util.concurrent.SynchronousQueue$TransferStack.transfer(java.lang.Object, boolean, long) @bci=102, line=362 (Interpreted frame)
  • java.util.concurrent.SynchronousQueue.take() @bci=7, line=924 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 36: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Interpreted frame)
  • java.util.TimerThread.mainLoop() @bci=28, line=526 (Interpreted frame)
  • java.util.TimerThread.run() @bci=1, line=505 (Interpreted frame)

Thread 35: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Interpreted frame)
  • java.util.TimerThread.mainLoop() @bci=28, line=526 (Interpreted frame)
  • java.util.TimerThread.run() @bci=1, line=505 (Interpreted frame)

Thread 33: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Interpreted frame)
  • java.util.prefs.AbstractPreferences$EventDispatchThread.run() @bci=22, line=1482 (Interpreted frame)

Thread 32: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Compiled frame)
  • oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(java.util.Collection) @bci=15, line=47 (Interpreted frame)
  • oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run() @bci=19, line=548 (Interpreted frame)

Thread 31: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Interpreted frame)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Interpreted frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Interpreted frame)
  • java.util.concurrent.LinkedBlockingQueue.take() @bci=29, line=442 (Interpreted frame)
  • oracle.ide.log.QueuedLoggingHandler.take() @bci=4, line=60 (Interpreted frame)
  • oracle.ideimpl.log.TabbedLogManager$4.run() @bci=4, line=333 (Interpreted frame)
  • java.lan.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 30: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.TimerThread.mainLoop() @bci=201, line=552 (Interpreted frame)
  • java.util.TimerThread.run() @bci=1, line=505 (Interpreted frame)

Thread 29: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.Object.wait() @bci=2, line=502 (Interpreted frame)
  • org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent() @bci=4, line=400 (Interpreted frame)
  • org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run() @bci=1, line=336 (Interpreted frame)

Thread 28: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Interpreted frame)
  • org.eclipse.osgi.internal.baseadaptor.StateManager.run() @bci=9, line=297 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 27: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • org.eclipse.osgi.framework.internal.core.Framework.run() @bci=15, line=1870 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 26: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • java.lang.ref.ReferenceQueue.remove(long) @bci=59, line=144

Do you have custom syntax highlighting rules? Then, resetting it (or clearing it altogether) might help with the arbori artifact on your stack trace.

User_KSUBW

I have not set custom syntax highlighting rules, this is a stock install i.e just unzipped the zip, pointed to a JDK and thats it.
BTW I cannot install JDK on my laptop(company rules), so I had to zip it from another machine, unzip it on my local desktop.

User_KSUBW

Another freeze, this time here is what i did
SQL developer was left open for some time say around 30 mins
Tried executing a query in an open worksheet - no response
Right clicked the connection for reconnect - Got a dialog that the connection was alive, want to retry - selected yes - nothing happened
Right click on connection and select Open SQL Worksheet - SQL Developer hangs
Here is the jstack
.\jstack.exe -F 25432
Attaching to process ID 25432, please wait...
Debugger attached successfully.
Server compiler detected.
JVM version is 25.251-b08
Deadlock Detection:
No deadlocks found.
Thread 67: (state = BLOCKED)

  • oracle.javatools.db.AbstractDatabase$AliveTester.run() @bci=14, line=478 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)
    Thread 65: (state = BLOCKED)
  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt() @bci=1, line=836 (Interpreted frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireQueued(java.util.concurrent.locks.AbstractQueuedSynchronizer$Node, int) @bci=67, line=870 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.acquire(int) @bci=17, line=1199 (Compiled frame)
  • java.util.concurrent.locks.ReentrantLock$NonfairSync.lock() @bci=21, line=209 (Compiled frame)
  • java.util.concurrent.locks.ReentrantLock.lock() @bci=4, line=285 (Compiled frame)
  • oracle.javatools.db.AbstractDatabase.getConnection(boolean) @bci=8, line=233 (Compiled frame)
  • oracle.dbtools.raptor.utils.Connections$ConnectionInfo.reopenConnection() @bci=32, line=269 (Interpreted frame)
  • oracle.dbtools.raptor.utils.Connections.reopenConnection(java.lang.String) @bci=13, line=1529 (Interpreted frame)
  • oracle.dbtools.raptor.navigator.db.DBViewControllerImpl.reopenConnection(oracle.dbtools.raptor.navigator.db.DatabaseConnection) @bci=192, line=234 (Interpreted frame)
  • oracle.dbtools.raptor.navigator.db.DBViewControllerImpl.lambda$handleEvent$1(oracle.ide.model.Element) @bci=4, line=456 (Interpreted frame)
  • oracle.dbtools.raptor.navigator.db.DBViewControllerImpl$$Lambda$387.run() @bci=4 (Interpreted frame)
  • oracle.dbtools.raptor.navigator.db.DBViewControllerImpl$2.doWork() @bci=4, line=657 (Interpreted frame)
  • oracle.dbtools.raptor.navigator.db.DBViewControllerImpl$2.doWork() @bci=1, line=653 (Interpreted frame)
  • oracle.dbtools.raptor.backgroundTask.RaptorTask.call() @bci=10, line=199 (Interpreted frame)
  • java.util.concurrent.FutureTask.run() @bci=42, line=266 (Compiled frame)
  • oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run() @bci=92, line=702 (Interpreted frame)
  • java.util.concurrent.Executors$RunnableAdapter.call() @bci=4, line=511 (Compiled frame)
  • java.util.concurrent.FutureTask.run() @bci=42, line=266 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=95, line=1149 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)
    Thread 64: (state = BLOCKED)
  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Compiled frame)
  • java.util.concurrent.LinkedBlockingQueue.take() @bci=29, line=442 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

Thread 63: (state = IN_NATIVE)

  • sun.nio.ch.SocketDispatcher.read0(java.io.FileDescriptor, long, int) @bci=0 (Compiled frame; information may be imprecise)
  • sun.nio.ch.SocketDispatcher.read(java.io.FileDescriptor, long, int) @bci=4, line=43 (Compiled frame)
  • sun.nio.ch.IOUtil.readIntoNativeBuffer(java.io.FileDescriptor, java.nio.ByteBuffer, long, sun.nio.ch.NativeDispatcher) @bci=114, line=223 (Compiled frame)
  • sun.nio.ch.IOUtil.read(java.io.FileDescriptor, java.nio.ByteBuffer, long, sun.nio.ch.NativeDispatcher) @bci=48, line=197 (Compiled frame)
  • sun.nio.ch.SocketChannelImpl.read(java.nio.ByteBuffer) @bci=178, line=380 (Compiled frame)
  • oracle.net.nt.TimeoutSocketChannel.read(java.nio.ByteBuffer) @bci=14, line=174 (Compiled frame)
  • oracle.net.ns.NSProtocolNIO.doSocketRead(int) @bci=41, line=557 (Compiled frame)
  • oracle.net.ns.NIOPacket.readHeader() @bci=111, line=260 (Compiled frame)
  • oracle.net.ns.NIOPacket.readPacketFromSocketChannel(boolean) @bci=5, line=192 (Compiled frame)
  • oracle.net.ns.NIOPacket.readFromSocketChannel(boolean, boolean) @bci=22, line=134 (Compiled frame)
  • oracle.net.ns.NIOPacket.readFromSocketChannel(boolean) @bci=3, line=107 (Compiled frame)
  • oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel() @bci=44, line=91 (Compiled frame)
  • oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall() @bci=42, line=764 (Compiled frame)
  • oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1() @bci=1, line=429 (Compiled frame)
  • oracle.jdbc.driver.T4CTTIfun.receive() @bci=21, line=407 (Compiled frame)
  • oracle.jdbc.driver.T4CTTIfun.doRPC() @bci=146, line=268 (Compiled frame)
  • oracle.jdbc.driver.T4CTTIoping.doOPING() @bci=1, line=56 (Interpreted frame)
  • oracle.jdbc.driver.T4CConnection.doPingDatabase() @bci=22, line=5441 (Interpreted frame)
  • oracle.jdbc.driver.PhysicalConnection.pingDatabase() @bci=20, line=5695 (Interpreted frame)
  • oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCConnection$2oracle$1jdbc$1internal$1OracleConnection$$$Proxy.pingDatabase() @bci=4 (Interpreted frame)
  • oracle.javatools.db.ora.OracleDatabaseImpl.isConnectionAliveImpl(java.sql.Connection) @bci=11, line=496 (Interpreted frame)
  • oracle.javatools.db.AbstractDatabase$AliveTester.run() @bci=57, line=494 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

Thread 62: (state = BLOCKED)

  • java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.javatools.db.AbstractDatabase.isConnectionAlive(java.sql.Connection) @bci=118, line=547 (Interpreted frame)
  • oracle.javatools.db.AbstractDatabase.isConnectionAlive() @bci=13, line=376 (Interpreted frame)
  • oracle.javatools.db.AbstractDatabase.getConnection(boolean) @bci=75, line=243 (Compiled frame)
  • oracle.dbtools.raptor.utils.Connections.getConnection(java.lang.String, boolean) @bci=30, line=1182 (Compiled frame)
  • oracle.dbtools.raptor.utils.Connections$1.getConnectionImpl(java.lang.String, boolean) @bci=6, line=938 (Interpreted frame)
  • oracle.dbtools.db.ConnectionResolver.getConnectionImpl(java.lang.String) @bci=3, line=143 (Interpreted frame)
  • oracle.dbtools.db.ConnectionResolver.getConnection(java.lang.String) @bci=4, line=40 (Interpreted frame)
  • oracle.dbtools.db.ChameleonConnection.getConnection(java.lang.String) @bci=10, line=50 (Interpreted frame)
  • oracle.dbtools.raptor.insight.InsightableOracleDatabase.getConnection() @bci=4, line=1324 (Interpreted frame)
  • oracle.dbtools.raptor.insight.InsightableOracleDatabase.getCurrentSchema() @bci=9, line=414 (Interpreted frame)
  • oracle.dbtools.raptor.insight.InsightableOracleDatabase.prepareAllPkgProc(java.lang.String, java.lang.String, java.lang.String) @bci=126, line=540 (Interpreted frame)
  • oracle.dbtools.raptor.insight.CompletionInsight.complete(java.lang.String, java.util.List, oracle.dbtools.parser.plsql.LazyNode, int, int, boolean) @bci=3314, line=926 (Interpreted frame)
  • oracle.dbtools.raptor.insight.CompletionInsight$InsightThread.run() @bci=263, line=557 (Interpreted frame)

Thread 61: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await() @bci=42, line=2039 (Compiled frame)
  • java.util.concurrent.LinkedBlockingQueue.take() @bci=29, line=442 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

Thread 60: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.park(java.lang.Object) @bci=14, line=175 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt() @bci=1, line=836 (Interpreted frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireQueued(java.util.concurrent.locks.AbstractQueuedSynchronizer$Node, int) @bci=67, line=870 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer.acquire(int) @bci=17, line=1199 (Compiled frame)
  • java.util.concurrent.locks.ReentrantLock$NonfairSync.lock() @bci=21, line=209 (Compiled frame)
  • java.util.concurrent.locks.ReentrantLock.lock() @bci=4, line=285 (Compiled frame)
  • oracle.javatools.db.AbstractDatabase.getConnection(boolean) @bci=8, line=233 (Compiled frame)
  • oracle.dbtools.raptor.utils.Connections.getConnection(java.lang.String, boolean) @bci=30, line=1182 (Compiled frame)
  • oracle.dbtools.raptor.utils.Connections.getConnection(java.lang.String) @bci=3, line=1166 (Interpreted frame)
  • oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.initConnection() @bci=8, line=517 (Interpreted frame)
  • oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.doWork() @bci=1, line=224 (Interpreted frame)
  • oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.doWork() @bci=1, line=67 (Interpreted frame)
  • oracle.dbtools.raptor.backgroundTask.RaptorTask.call() @bci=10, line=199 (Interpreted frame)
  • java.util.concurrent.FutureTask.run() @bci=42, line=266 (Compiled frame)
  • oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run() @bci=92, line=702 (Interpreted frame)
  • java.util.concurrent.Executors$RunnableAdapter.call() @bci=4, line=511 (Compiled frame)
  • java.util.concurrent.FutureTask.run() @bci=42, line=266 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=95, line=1149 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 59: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • oracle.dbtools.raptor.plsql.BackgroundParser$1.construct() @bci=21, line=160 (Compiled frame)
  • oracle.dbtools.raptor.utils.NamedSwingWorker$2.run() @bci=8, line=115 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 58: (state = IN_NATIVE)

  • sun.nio.ch.Iocp.getQueuedCompletionStatus(long, sun.nio.ch.Iocp$CompletionStatus) @bci=0 (Interpreted frame)
  • sun.nio.ch.Iocp.access$300(long, sun.nio.ch.Iocp$CompletionStatus) @bci=2, line=46 (Interpreted frame)
  • sun.nio.ch.Iocp$EventHandlerTask.run() @bci=45, line=333 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)
  • sun.misc.InnocuousThread.run() @bci=20, line=106 (Interpreted frame)

Thread 57: (state = BLOCKED)

  • sun.misc.Unsafe.park(boolean, long) @bci=0 (Compiled frame; information may be imprecise)
  • java.util.concurrent.locks.LockSupport.parkNanos(java.lang.Object, long) @bci=20, line=215 (Compiled frame)
  • java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(long) @bci=78, line=2078 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take() @bci=124, line=1093 (Compiled frame)
  • java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take() @bci=1, line=809 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.getTask() @bci=149, line=1074 (Compiled frame)
  • java.util.concurrent.ThreadPoolExecutor.runWorker(java.util.concurrent.ThreadPoolExecutor$Worker) @bci=26, line=1134 (Interpreted frame)
  • java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Interpreted frame)
  • java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

Thread 56: (state = BLOCKED)

  • java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)
  • sun.awt.image.GifFrame.dispose() @bci=26, line=670 (Compiled frame)
  • sun.awt.image.GifImageDecoder.readImage(boolean, int, int) @bci=11, line=458 (Compiled frame)
  • sun.awt.image.GifImageDecoder.produceImage() @bci=484, line=212 (Compiled frame)
  • su
User_WIB03

I'm on Version 20.2.0.175 and have hang/freeze issues.
I have to manually save or copy out my in progress SQL and kill SQL Developer with Task Manager to get going again.
I'll downgrade back to 19.2.

1 person found this helpful
User_KSUBW

I am using 19.4 and 19.2 and both freeze from time to time but are much better than 20.2. I wish Oracle provides an option to forcefully reset the connection manually either connection wise or for all the connections.
BTW trying the disconnect/reconnect option also hangs.

2 people found this helpful
Paavo

Also experienced this on 20.2 and learned the following tricks to overcome:
Typically I get it hanging when doing as follows
while editing plsql pkg body I jump to another sql worksheet to e.g. select
then return to plsql pkg body editing and c-s
--> hangs
so what I do quite often now, is c-a, c-c and paste to safe place, and then do c-s in pkg body editing.
Gotta try new version of sqldev.

1 person found this helpful
wvilela

The freezing is so commom in my machine(windows 10, SQL Developer 20.2 with jre) that after loosing work done, I am using DBeaver and starting to like it

wvilela

I've tried AdoptOpenJDK (build 11.0.7+10) hoping it will solve the problem, bu after some time using SQL Developer it hanged. The file with JSTACK dump added
sqldeveloper_stack.log (37.48 KB)

wvilela

This was a hang using <ctrl+enter> to run a small query

Paavo

Not sure if this helps to isolate the challenge, but when working e.g. via mobile data and the connection up/down speeds drop to very low speeds like less than 1M/1M then I have found Apex Sqlworkshop which is browser based to work best. So could it be that a small hiccup in the speed somehow makes the connection to stall - what I mean that it was already "stalled" and you just notice when "submitting" something to db that it is stalled. Should there be some sort of "keepalive" for the connection?
I am also looking the sqldeveloper sdw which comes now with the ORDS 20.3 as option.
But must say that SqlDeveloper plsql package editor is something I really like, so not going to switch ides.

wvilela

After rollback to version SQLDev 19.2 with java 1.8.0_192 it seems that there is no more freezing, so I hope.

thatJeffSmith-Oracle

This has been fixed for version 20.4

1 person found this helpful
user12001690

@thatjeffsmith-oracle
Is version 20.4 available for download?
Thanks.

thatJeffSmith-Oracle

No, scheduled for release in December.

Suzanne_London

Agreed. It was annoying before, that long running queries couldn't be cancelled. But in 20.2 session hangs when I run a query, when I try to rename a column, sometimes just when I change between worksheets. I open an unshared connection so I can continue working and that one hangs too, then it crashes completely when I try to create another unshared connection

1 person found this helpful
user579428

Still waiting for 20.4, any idea when it will be available?

1 person found this helpful
thatJeffSmith-Oracle

hopefully this week, just waiting on a final legal sign-off (paperwork fun)

1 person found this helpful
Vivek-FA

I just installed 20.4 on centos. Ran a simple query and it hangs. I had to kill the sqldeveloper session. Once I restarted, it appears to work fine.

1 person found this helpful
thatJeffSmith-Oracle

please start a new thread, this isn't related to compiling packages

i've been running queries for weeks on 20.4, no hangs, so we'll need to start at the beginning and figure out what's happening on your machine/install/database

pmarian

Hallo,
I do not want to be the messenger of bad feedback but I have the newest version (20.4) and my SqlDeveloper is still dead-locking sometimes when I try to edit some packages. This is very annoying because there is no way to restore my unsaved work.
Hope it helps
Even the cursor is set on editing.

thatJeffSmith-Oracle

It's fine to be the messenger - please start a new thread, and grab a jstack dump the next time it happens to you and share it

pmarian

Sorry, I am a little confused. What kind of JStack do you mean when I said that the program is dead-locked and not crushed?
By the way, most of the problems comes when I compile my packages.

pmarian

Sorry, I understand now what you mean. Next time, it it happens again, I will create a new thread.
Thank you

1 person found this helpful
User_ZF4UU

Please allow download version 19.2 or a stable one while fixing 20.x

User_ZF4UU

Please allow download version 19.2 or a stable one while fixing 20.x

thatJeffSmith-Oracle

the identified problem was fixed, if someone is seeing this in 20.4, it's a new/different issue, that needs triaged/debugged/logged/fixed - please start a new thread with the supporting information

thatJeffSmith-Oracle

the identified problem was fixed, if someone is seeing this in 20.4, it's a new/different issue, that needs triaged/debugged/logged/fixed - please start a new thread with the supporting information

bbeesley

I also have had this problem incessantly over the course of years. My colleagues do as well. Database health is good. As I search for my next employment, I'm not going anywhere near Oracle systems. Oracle is a dinosaur.

User_DJNU8

I have the same issue. It appears in different situations, couldn't find a pattern. Here is a thread dump. This time i was doing an import of an csv file.

2021-05-11 14:02:06
Full thread dump Java HotSpot(TM) 64-Bit Server VM (25.181-b13 mixed mode):

"RMI TCP Connection(3)-192.168.0.105" #1328 daemon prio=9 os_prio=31 tid=0x00007f92a19c7800 nid=0x1095b runnable [0x0000700135205000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
- locked <0x000000079584f4b0> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:555)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$406/281654609.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x0000000795580fa8> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"RMI TCP Connection(2)-192.168.0.105" #1327 daemon prio=9 os_prio=31 tid=0x00007f929c189800 nid=0x1c78b runnable [0x0000700102edb000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
- locked <0x000000075401a7f0> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:555)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$406/281654609.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x000000075401a9b0> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"JMX server connection timeout 1326" #1326 daemon prio=9 os_prio=31 tid=0x00007f92a6a02800 nid=0x1085f in Object.wait() [0x00007000d0dbe000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at com.sun.jmx.remote.internal.ServerCommunicatorAdmin$Timeout.run(ServerCommunicatorAdmin.java:168)
- locked <0x0000000754012b50> (a [I)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"RMI Scheduler(0)" #1325 daemon prio=9 os_prio=31 tid=0x00007f929c56f000 nid=0x1953b waiting on condition [0x00007000be0af000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x0000000754017440> (a java.util.concurrent.locks.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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"RMI TCP Connection(1)-192.168.0.105" #1324 daemon prio=9 os_prio=31 tid=0x00007f92aa406000 nid=0x2a36f runnable [0x000070007f890000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
- locked <0x00000007540208a8> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:555)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$406/281654609.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x000000075401ab70> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"RMI TCP Accept-0" #1323 daemon prio=9 os_prio=31 tid=0x00007f92a9ce6000 nid=0x29c73 runnable [0x000070006cc88000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:409)
at java.net.ServerSocket.implAccept(ServerSocket.java:545)
at java.net.ServerSocket.accept(ServerSocket.java:513)
at sun.management.jmxremote.LocalRMIServerSocketFactory$1.accept(LocalRMIServerSocketFactory.java:52)
at sun.rmi.transport.tcp.TCPTransport$AcceptLoop.executeAcceptLoop(TCPTransport.java:405)
at sun.rmi.transport.tcp.TCPTransport$AcceptLoop.run(TCPTransport.java:377)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"Attach Listener" #1322 daemon prio=9 os_prio=31 tid=0x00007f92a7fe4000 nid=0x11c3b waiting on condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE

Locked ownable synchronizers:
- None

"RaptorTaskThread41-Import Data" #1280 prio=5 os_prio=31 tid=0x00007f929e643800 nid=0x1ff3f runnable [0x00007001416f9000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.FileDispatcherImpl.read0(Native Method)
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39)
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)
at sun.nio.ch.IOUtil.read(IOUtil.java:197)
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380)
- locked <0x00000007477cd518> (a java.lang.Object)
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:416)
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1119)
at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:267)
at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:199)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:141)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:114)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:98)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:834)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:487)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:577)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:148)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1038)
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9892)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatchFromQueue(OraclePreparedStatement.java:10128)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9977)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9932)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:262)
at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeBatch(Unknown Source)
at oracle.dbtools.raptor.data.writers.ImportGenInsertExec.doInserts(ImportGenInsertExec.java:269)
at oracle.dbtools.raptor.data.writers.ImportGenInsertExec.doImport(ImportGenInsertExec.java:122)
at oracle.dbtools.raptor.data.writers.ImportGenExec.process(ImportGenExec.java:116)
at oracle.dbtools.importer.writers.ImportGenTask$1.doWork(ImportGenTask.java:70)
at oracle.dbtools.importer.writers.ImportGenTask$1.doWork(ImportGenTask.java:59)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x00000007476f9f30> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)
- <0x0000000747d0d470> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)
- <0x0000000753a74418> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"SwingWorker-pool-6-thread-10" #1038 daemon prio=5 os_prio=31 tid=0x00007f92a55ff000 nid=0x17417 waiting on condition [0x00007000a50a3000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-9" #1014 daemon prio=5 os_prio=31 tid=0x00007f929ebef000 nid=0x1dc07 waiting on condition [0x000070012eaf1000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-8" #1013 daemon prio=5 os_prio=31 tid=0x00007f92a6234800 nid=0x1a01b waiting on condition [0x00007001092df000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-7" #1012 daemon prio=5 os_prio=31 tid=0x00007f928c234800 nid=0x1be8b waiting on condition [0x00007000fcad9000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-6" #992 daemon prio=5 os_prio=31 tid=0x00007f929e6f1800 nid=0x10ccf waiting on condition [0x0000700053c7c000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-5" #820 daemon prio=5 os_prio=31 tid=0x00007f928c370000 nid=0xf457 waiting on condition [0x00007000ca9bb000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-4" #734 daemon prio=5 os_prio=31 tid=0x00007f92aa277800 nid=0xb4cf waiting on condition [0x00007000b7cac000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-3" #553 daemon prio=5 os_prio=31 tid=0x00007f92a52b7000 nid=0xb513 waiting on condition [0x00007001286ee000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-2" #551 daemon prio=5 os_prio=31 tid=0x00007f929f104800 nid=0x1f61b waiting on condition [0x00007001222eb000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-1" #549 daemon prio=5 os_prio=31 tid=0x00007f92a57f7800 nid=0x18017 waiting on condition [0x000070011bee8000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"Image Animator 0" #192 daemon prio=3 os_prio=31 tid=0x00007f92a5340800 nid=0x1f007 sleeping[0x000070009eca0000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at sun.awt.image.GifFrame.dispose(GifImageDecoder.java:670)
at sun.awt.image.GifImageDecoder.readImage(GifImageDecoder.java:458)
at sun.awt.image.GifImageDecoder.produceImage(GifImageDecoder.java:212)
at sun.awt.image.InputStreamImageSource.doFetch(InputStreamImageSource.java:269)
at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:205)
at sun.awt.image.ImageFetcher.run(ImageFetcher.java:169)

Locked ownable synchronizers:
- None

"pool-5-thread-1" #133 prio=5 os_prio=31 tid=0x00007f929d0cc000 nid=0xec3 waiting on condition [0x0000700085c94000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074778b398> (a java.util.concurrent.locks.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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"status-0" #121 prio=2 os_prio=31 tid=0x00007f92a67ea000 nid=0x1bb07 waiting on condition [0x0000700115ae5000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074778bc20> (a java.util.concurrent.locks.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.DelayQueue.take(DelayQueue.java:211)
at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:338)
at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:300)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"WeakDataReference polling" #120 prio=1 os_prio=31 tid=0x00007f929e602800 nid=0x1ba07 in Object.wait() [0x000070010f6e2000]
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 <0x0000000747d0c920> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"Background Parser#1" #115 prio=6 os_prio=31 tid=0x00007f929eda3800 nid=0x1c123 waiting on condition [0x00007000f66d6000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160)
at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"TextBufferScavenger" #113 prio=6 os_prio=31 tid=0x00007f92a790d000 nid=0x1fa1b in Object.wait() [0x000070004d879000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.ref.ReferenceQueue

User_DJNU8

I have the same issue. It appears in different situations, couldn't find a pattern. Here is a thread dump. This time i was doing an import of an csv file to a table.

2021-05-11 14:02:06
Full thread dump Java HotSpot(TM) 64-Bit Server VM (25.181-b13 mixed mode):

"RMI TCP Connection(3)-192.168.0.105" #1328 daemon prio=9 os_prio=31 tid=0x00007f92a19c7800 nid=0x1095b runnable [0x0000700135205000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
- locked <0x000000079584f4b0> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:555)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$406/281654609.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x0000000795580fa8> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"RMI TCP Connection(2)-192.168.0.105" #1327 daemon prio=9 os_prio=31 tid=0x00007f929c189800 nid=0x1c78b runnable [0x0000700102edb000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
- locked <0x000000075401a7f0> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:555)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$406/281654609.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x000000075401a9b0> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"JMX server connection timeout 1326" #1326 daemon prio=9 os_prio=31 tid=0x00007f92a6a02800 nid=0x1085f in Object.wait() [0x00007000d0dbe000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at com.sun.jmx.remote.internal.ServerCommunicatorAdmin$Timeout.run(ServerCommunicatorAdmin.java:168)
- locked <0x0000000754012b50> (a [I)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"RMI Scheduler(0)" #1325 daemon prio=9 os_prio=31 tid=0x00007f929c56f000 nid=0x1953b waiting on condition [0x00007000be0af000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x0000000754017440> (a java.util.concurrent.locks.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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"RMI TCP Connection(1)-192.168.0.105" #1324 daemon prio=9 os_prio=31 tid=0x00007f92aa406000 nid=0x2a36f runnable [0x000070007f890000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
- locked <0x00000007540208a8> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:555)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$406/281654609.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x000000075401ab70> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"RMI TCP Accept-0" #1323 daemon prio=9 os_prio=31 tid=0x00007f92a9ce6000 nid=0x29c73 runnable [0x000070006cc88000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:409)
at java.net.ServerSocket.implAccept(ServerSocket.java:545)
at java.net.ServerSocket.accept(ServerSocket.java:513)
at sun.management.jmxremote.LocalRMIServerSocketFactory$1.accept(LocalRMIServerSocketFactory.java:52)
at sun.rmi.transport.tcp.TCPTransport$AcceptLoop.executeAcceptLoop(TCPTransport.java:405)
at sun.rmi.transport.tcp.TCPTransport$AcceptLoop.run(TCPTransport.java:377)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"Attach Listener" #1322 daemon prio=9 os_prio=31 tid=0x00007f92a7fe4000 nid=0x11c3b waiting on condition [0x0000000000000000]
java.lang.Thread.State: RUNNABLE

Locked ownable synchronizers:
- None

"RaptorTaskThread41-Import Data" #1280 prio=5 os_prio=31 tid=0x00007f929e643800 nid=0x1ff3f runnable [0x00007001416f9000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.FileDispatcherImpl.read0(Native Method)
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39)
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)
at sun.nio.ch.IOUtil.read(IOUtil.java:197)
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380)
- locked <0x00000007477cd518> (a java.lang.Object)
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:416)
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1119)
at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:267)
at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:199)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:141)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:114)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:98)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:834)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:487)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:577)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:148)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1038)
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9892)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatchFromQueue(OraclePreparedStatement.java:10128)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9977)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9932)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:262)
at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeBatch(Unknown Source)
at oracle.dbtools.raptor.data.writers.ImportGenInsertExec.doInserts(ImportGenInsertExec.java:269)
at oracle.dbtools.raptor.data.writers.ImportGenInsertExec.doImport(ImportGenInsertExec.java:122)
at oracle.dbtools.raptor.data.writers.ImportGenExec.process(ImportGenExec.java:116)
at oracle.dbtools.importer.writers.ImportGenTask$1.doWork(ImportGenTask.java:70)
at oracle.dbtools.importer.writers.ImportGenTask$1.doWork(ImportGenTask.java:59)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- <0x00000007476f9f30> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)
- <0x0000000747d0d470> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)
- <0x0000000753a74418> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"SwingWorker-pool-6-thread-10" #1038 daemon prio=5 os_prio=31 tid=0x00007f92a55ff000 nid=0x17417 waiting on condition [0x00007000a50a3000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-9" #1014 daemon prio=5 os_prio=31 tid=0x00007f929ebef000 nid=0x1dc07 waiting on condition [0x000070012eaf1000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-8" #1013 daemon prio=5 os_prio=31 tid=0x00007f92a6234800 nid=0x1a01b waiting on condition [0x00007001092df000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-7" #1012 daemon prio=5 os_prio=31 tid=0x00007f928c234800 nid=0x1be8b waiting on condition [0x00007000fcad9000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-6" #992 daemon prio=5 os_prio=31 tid=0x00007f929e6f1800 nid=0x10ccf waiting on condition [0x0000700053c7c000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-5" #820 daemon prio=5 os_prio=31 tid=0x00007f928c370000 nid=0xf457 waiting on condition [0x00007000ca9bb000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-4" #734 daemon prio=5 os_prio=31 tid=0x00007f92aa277800 nid=0xb4cf waiting on condition [0x00007000b7cac000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-3" #553 daemon prio=5 os_prio=31 tid=0x00007f92a52b7000 nid=0xb513 waiting on condition [0x00007001286ee000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-2" #551 daemon prio=5 os_prio=31 tid=0x00007f929f104800 nid=0x1f61b waiting on condition [0x00007001222eb000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"SwingWorker-pool-6-thread-1" #549 daemon prio=5 os_prio=31 tid=0x00007f92a57f7800 nid=0x18017 waiting on condition [0x000070011bee8000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074db2d478> (a java.util.concurrent.locks.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.java:442)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"Image Animator 0" #192 daemon prio=3 os_prio=31 tid=0x00007f92a5340800 nid=0x1f007 sleeping[0x000070009eca0000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at sun.awt.image.GifFrame.dispose(GifImageDecoder.java:670)
at sun.awt.image.GifImageDecoder.readImage(GifImageDecoder.java:458)
at sun.awt.image.GifImageDecoder.produceImage(GifImageDecoder.java:212)
at sun.awt.image.InputStreamImageSource.doFetch(InputStreamImageSource.java:269)
at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:205)
at sun.awt.image.ImageFetcher.run(ImageFetcher.java:169)

Locked ownable synchronizers:
- None

"pool-5-thread-1" #133 prio=5 os_prio=31 tid=0x00007f929d0cc000 nid=0xec3 waiting on condition [0x0000700085c94000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074778b398> (a java.util.concurrent.locks.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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"status-0" #121 prio=2 os_prio=31 tid=0x00007f92a67ea000 nid=0x1bb07 waiting on condition [0x0000700115ae5000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000074778bc20> (a java.util.concurrent.locks.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.DelayQueue.take(DelayQueue.java:211)
at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:338)
at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:300)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"WeakDataReference polling" #120 prio=1 os_prio=31 tid=0x00007f929e602800 nid=0x1ba07 in Object.wait() [0x000070010f6e2000]
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 <0x0000000747d0c920> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"Background Parser#1" #115 prio=6 os_prio=31 tid=0x00007f929eda3800 nid=0x1c123 waiting on condition [0x00007000f66d6000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160)
at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
at java.lang.Thread.run(Thread.java:748)

Locked ownable synchronizers:
- None

"TextBufferScavenger" #113 prio=6 os_prio=31 tid=0x00007f92a790d000 nid=0x1fa1b in Object.wait() [0x000070004d879000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.ref.Ref

thatJeffSmith-Oracle

completely different topic, please start a new thread

User_PO1SE

I believe I was having issues as described in this thread, using SQL Developer 20.2 (on MacOS). It was driving me wild.
I downloaded/installed 20.4.1 and have not had the issue since.
Thanks for fixing this!

A. Olsen

20.4 still does it. I would like to suggest that you add a feature to SQLDeveloper, which saves a temp file with our unsaved changes. This way, after a freeze; having used Task Manager to kill the process, upon relaunch, the program can suggest to re-use some previously edited tekstfiles, with the user's option to resume or ignore such a suggestion. (in other words: "do like Toad").
This might just make the day for someone who has used some time studying a system, but hasn't saved each and every statement into files.

Thanks...

1 person found this helpful
user4484241

many developers complaining that since version 20 it is impossible to work with sqldeveloper.
It hangs inconsistently - sometimes just during typing !
I moved to version 21 - but it is worse !!
I am working with sqldeveloper since version 3 and I like it so much I made all my company use it for years
and since version 20.4 and 21.2 it is TERRIBLE !! keeps hanging inconsistently

1 person found this helpful
Yevon

Sqldeveloper always hang along its history, but is just a design flaw. It tries to minimize database sessions but when database is busy all your work is gone if it is waiting for resources for several minutes. All database operations like compiling packages, altering tables etc should be done in an unshared connection, and finish it afterwards. Another issue with it is session package caching, when you have some chain invalidations your session becomes stale and cannot execute the package until you close the session and you open again.

1 - 50 Next
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 2 2011
Added on Mar 25 2011
#oracle-virtualization, #oracle-vm-server-for-x86, #support
2 comments
286 views