4 Replies Latest reply on Mar 18, 2019 8:18 PM by thatJeffSmith-Oracle

    SQL Developer 18.4 on Linux

    Ran.R.

      Hi,

       

      I have used the SD 17.4 on the same Linux machine (Oracle Linux 7 on VMWare) with minimum problems.

       

      the SD 18.4 however is having serious problems from starting to closing or using after long idle.

       

      for a while it did work fine, but lately it has problem starting which I handle by renaming the "system18.4.0.376.1900" directory to recreate it.

      or problem when closing it - it does not respond to that and instead it get unresponsive.

      or after a long idle (few hours or the next day) I start using it but after few actions it get unresponsive and I need to forcibly close it

      and reopen (and then the system18.4.0.376.1900 get corrupted and SD is not starting).

       

      seems like there are problems with the "system18.4.0.376.1900" directory - a very sensitive one

       

      I need to work so I will fall back to the SD17.4. but this issues should be addressed.

       

      I got a message from ABRT has detected 1 problem(s). For more info run: abrt-cli list --since 1552295884 , which is:

       

      :/usr/java/jdk1.8.0_201-amd64/lib/dt.jar

      -Dsun.java2d.noddraw=true

      -XX:CompileCommand=quiet

      -XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot

      -Dnetbeans.home=../../ide/bin/../../netbeans/platform/

      -Dnetbeans.logger.console=true -Dexcluded.modules=org.eclipse.osgi

      -Dide.cluster.dirs=../../ide/bin/../../netbeans/fcpbridge/:../../ide/bin/../../netbeans/ide/:../../ide/bin/../../netbeans/../

      -Xverify:none -Doracle.ide.extension.HooksProcessingMode=LAZY

      -Dorg.eclipse.equinox.simpleconfigurator.configUrl=file:bundles.info

      -Dosgi.bundles.defaultStartLevel=1 -Dosgi.configuration.cascaded=false

      -Dosgi.noShutdown=true -Dorg.osgi.framework.bootdelegation=*

      -Dosgi.parentClassloader=app -Dosgi.locking=none

      -Dosgi.contextClassLoaderParent=app

      -Dosgi.classloader.type=parallel

      -Dosgi.bundlefile.limit=500

      -Dide.feedback-server=ide.us.oracle.com

      -Djavax.xml.transform.TransformerFactory=oracle.ide.xml.switchable.SwitchableTransformerFactory

      -Djavax.xml.stream.XMLInputFactory=com.ctc.wstx.stax.WstxInputFactory

      -Djavax.xml.stream.util.XMLEventAllocator=oracle.ideimpl.xml.stream.XMLEventAllocatorImpl

      -Doracle.ide.reportEDTViolations=bug

      -Doracle.ide.reportEDTViolations.exceptionsfile=../../ide/bin/swing-thread-violations.conf -Xms128M -Xmx800M

      -Doracle.ide.IdeFrameworkCommandLineOptions=-clean,-console,-debugmode,-migrate,-migrate:,-nomigrate,-nonag,-nondebugmode,-noreopen,-nosplash,-role:,-su

      -Dide.update.usage.servers=https://www.oracle.com/webfolder/technetwork/sqldeveloper/usage.xml

      -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Dsun.java2d.ddoffscreen=false

      -Dwindows.shell.font.languages= -Doracle.ide.startup.features=sqldeveloper

      -Doracle.ide.osgi.boot.api.OJStartupHook=oracle.dbtools.raptor.startup.HomeSupport

      -Doracle.jdbc.mapDateToTimestamp=false -Doracle.jdbc.autoCommitSpecCompliant=false

      -Doracle.jdbc.useFetchSizeWithLongColumn=true -Dsun.locale.formatasdefault=true

      -Dorg.netbeans.CLIHandler.server=false

      -Doracle.xdkjava.security.resolveEntityDefault=false

      -Dide.AssertTracingDisabled=true

      -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true

      -Djava.util.logging.config.file=logging.conf -Dsqldev.debug=false

      -Dsqldev.onsd=true

      '-Dide.conf=\"/opt/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf\"'

      '-Duser.conf=\"/home/oracle/.sqldeveloper/18.4.0/product.conf\"'

      '-Dtool.user.conf=\"/home/oracle/.sqldeveloper/18.4.0/sqldeveloper.conf\"'

      '-Dide.startingcwd=\"/opt/sqldeveloper/sqldeveloper/bin\"' -Xbootclasspath/p:../../ide/bin/../../rdbms/jlib/ojdi.jar -classpath

      ../../ide/bin/../../ide/lib/ide-boot.jar:../../ide/bin/../../netbeans/platform/lib/boot.jar:../../ide/bin/../../netbeans/platform/lib/org-openide-util-ui.jar:

      ../../ide/bin/../../netbeans/platform/lib/org-openide-util.jar:../../ide/bin/../../netbeans/platform/lib/org-openide-util-lookup.jar:

      ../../ide/bin/../../netbeans/platform/lib/org-openide-modules.jar:../../ide/bin/../../ide/lib/fcpboot.jar:../../ide/bin/../../ide/lib/xml-factory.jar:

      ../../ide/bin/../../ide/lib/woodstox-core-asl-4.2.0.jar:../../ide/bin/../../ide/lib/stax2-api-3.1.1.jar:

      ../lib/oracle.sqldeveloper.homesupport.jar oracle.ide.osgi.boot.OracleIdeLauncher

      package:        jdk1.8-1.8.0_201-fcs

      uid:            1001 (oracle)

      count:          1

      Directory:      /var/spool/abrt/ccpp-2019-03-12-09:39:07-18623

       

      The Autoreporting feature is disabled. Please consider enabling it by issuing

      'abrt-auto-reporting enabled' as a user with root privileges

       

      Regards

      Ran

        • 1. Re: SQL Developer 18.4 on Linux
          thatJeffSmith-Oracle

          that redhat notice doesn't give us anything to work on

           

          next time 18.4 is unresponsive, use the jstack in your JDK/bin to get a stack dump on the sql developer process and share that here

          • 2. Re: SQL Developer 18.4 on Linux
            Ran.R.

            I did not took a jstack yet but one thing I could see is that the database connection was closed and the next action needed connection which took 10 minutes

            however next time I wiil take a jstack and post it here. I have also tried to disconnect after a long idle and it also took around 10 minutes.

            • 3. Re: SQL Developer 18.4 on Linux
              Ran.R.

              a jstack thread dump of a SD wait on connection:

               

              Attaching to process ID 1369, please wait...

              Debugger attached successfully.

              Server compiler detected.

              JVM version is 25.201-b09

              Deadlock Detection:

               

              No deadlocks found.

               

              Thread 20532: (state = IN_NATIVE)

              - sun.nio.ch.FileDispatcherImpl.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=39 (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=178 (Compiled frame)

              - oracle.net.ns.NSProtocolNIO.doSocketRead(int) @bci=41, line=544 (Compiled frame)

              - oracle.net.ns.NIOPacket.readHeader() @bci=111, line=234 (Compiled frame)

              - oracle.net.ns.NIOPacket.readPacketFromSocketChannel(boolean) @bci=5, line=174 (Compiled frame)

              - oracle.net.ns.NIOPacket.readFromSocketChannel(boolean, boolean) @bci=22, line=122 (Compiled frame)

              - oracle.net.ns.NIOPacket.readFromSocketChannel(boolean) @bci=3, line=100 (Compiled frame)

              - oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel() @bci=44, line=86 (Compiled frame)

              - oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall() @bci=42, line=762 (Compiled frame)

              - oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1() @bci=1, line=427 (Compiled frame)

              - oracle.jdbc.driver.T4CTTIfun.receive() @bci=21, line=394 (Compiled frame)

              - oracle.jdbc.driver.T4CTTIfun.doRPC() @bci=139, line=255 (Compiled frame)

              - oracle.jdbc.driver.T4CTTIoping.doOPING() @bci=1, line=54 (Compiled frame)

              - oracle.jdbc.driver.T4CConnection.doPingDatabase() @bci=18, line=4970 (Compiled frame)

              - oracle.jdbc.driver.PhysicalConnection.pingDatabase() @bci=20, line=5434 (Compiled frame)

              - oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCConnection$2oracle$1jdbc$1internal$1OracleConnection$$$Proxy.pingDatabase() @bci=4 (Compiled frame)

              - oracle.javatools.db.ora.OracleDatabaseImpl.isConnectionAliveImpl(java.sql.Connection) @bci=11, line=496 (Compiled frame)

              - oracle.javatools.db.AbstractDatabase$AliveTester.run() @bci=57, line=494 (Compiled frame)

              - java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

               

               

              Thread 14393: (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 (Compiled frame)

              - java.util.concurrent.SynchronousQueue$TransferStack.transfer(java.lang.Object, boolean, long) @bci=102, line=362 (Compiled 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 (Compiled frame)

              - java.util.concurrent.ThreadPoolExecutor$Worker.run() @bci=5, line=624 (Compiled frame)

              - java.lang.Thread.run() @bci=11, line=748 (Compiled frame)

               

               

              Thread 9881: (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 (Interpreted frame)

               

               

              Thread 9552: (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 (Interpreted frame)

               

               

              Thread 9482: (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 (Interpreted frame)

               

               

              Thread 22632: (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 (Interpreted frame)

               

               

              Thread 5144: (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 (Interpreted frame)

               

               

              Thread 32751: (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 (Interpreted frame)

               

               

              Thread 30491: (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 (Interpreted frame)

               

               

              Thread 25884: (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 (Interpreted frame)

               

               

              Thread 24896: (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 15504: (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.produceImage() @bci=545, line=247 (Compiled frame)

              - sun.awt.image.InputStreamImageSource.doFetch() @bci=51, line=269 (Interpreted frame)

              - sun.awt.image.ImageFetcher.fetchloop() @bci=33, line=205 (Interpreted frame)

              - sun.awt.image.ImageFetcher.run() @bci=5, line=169 (Interpreted frame)

               

               

              Thread 7778: (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=329 (Interpreted frame)

               

               

              Thread 7776: (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 6501: (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 (Interpreted frame)

               

               

              Thread 4992: (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 4210: (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 4110: (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 4098: (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 (Interpreted frame)

               

               

              Thread 3889: (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 3886: (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 3880: (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 (Interpreted frame)

               

               

              Thread 2330: (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 2180: (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 2177: (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 2159: (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 2136: (state = IN_NATIVE)

              - com.sun.glass.ui.gtk.GtkApplication._runLoop(java.lang.Runnable, boolean) @bci=0 (Interpreted frame)

              - com.sun.glass.ui.gtk.GtkApplication.lambda$null$203(java.lang.Runnable, boolean) @bci=7, line=139 (Interpreted frame)

              - com.sun.glass.ui.gtk.GtkApplication$$Lambda$80.run() @bci=12 (Interpreted frame)

              - java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 2135: (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 (Compiled frame)

               

               

              Thread 2126: (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 (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)

              - 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 2118: (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 2115: (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 2106: (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 1372: (state = BLOCKED)

               

               

              Thread 2068: (state = BLOCKED)

              - java.lang.Object.wait(long) @bci=0 (Interpreted frame)

              - 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 2066: (state = BLOCKED)

              - java.lang.Object.wait(long) @bci=0 (Interpreted frame)

              - java.lang.Object.wait() @bci=2, line=502 (Interpreted frame)

              - java.util.prefs.AbstractPreferences$EventDispatchThread.run() @bci=22, line=1482 (Interpreted frame)

               

               

              Thread 2022: (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 (Compiled frame)

              - oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run() @bci=19, line=548 (Interpreted frame)

               

               

              Thread 2014: (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.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 1626: (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 1548: (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)

              - 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 1538: (state = BLOCKED)

              - java.lang.Thread.sleep(long) @bci=0 (Compiled frame; information may be imprecise)

              - org.eclipse.osgi.internal.baseadaptor.StateManager.run() @bci=9, line=297 (Interpreted frame)

              - java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 1536: (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 (Compiled frame)

              - java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 1495: (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)

              - org.openide.util.lookup.implspi.ActiveQueue$Impl.removeSuper() @bci=2, line=93 (Compiled frame)

              - org.openide.util.lookup.implspi.ActiveQueue$Daemon.run() @bci=10, line=131 (Interpreted frame)

               

               

              Thread 1469: (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.DelayQueue.take() @bci=134, line=223 (Compiled frame)

              - javax.swing.TimerQueue.run() @bci=20, line=174 (Compiled frame)

              - java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 1401: (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 (Compiled frame)

              - oracle.javatools.db.AbstractDatabase.isConnectionAlive() @bci=13, line=376 (Compiled 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=1185 (Compiled frame)

              - oracle.dbtools.raptor.utils.Connections.getConnection(java.lang.String) @bci=3, line=1169 (Compiled frame)

              - oracle.dbtools.worksheet.commands.scriptrunner.task.DBCommandRunnerTask.<init>(oracle.dbtools.worksheet.WorksheetContext, oracle.dbtools.worksheet.commands.scriptrunner.ConsumerManager, java.lang.String, oracle.dbtools.raptor.backgroundTask.IRaptorTaskRunMode, java.lang.String) @bci=211, line=451 (Interpreted frame)

              - oracle.dbtools.worksheet.commands.scriptrunner.task.StatementRunnerTask.<init>(oracle.dbtools.worksheet.WorksheetContext, oracle.dbtools.worksheet.commands.scriptrunner.ConsumerManager, java.lang.String, oracle.dbtools.raptor.backgroundTask.IRaptorTaskRunMode) @bci=9, line=35 (Interpreted frame)

              - oracle.dbtools.worksheet.commands.scriptrunner.StatementRunnerProvider.getTask(oracle.dbtools.worksheet.WorksheetContext, oracle.dbtools.worksheet.commands.scriptrunner.ConsumerManager, java.lang.String, oracle.dbtools.raptor.backgroundTask.IRaptorTaskRunMode) @bci=10, line=38 (Interpreted frame)

              - oracle.dbtools.worksheet.commands.scriptrunner.DBCommandRunnerProvider.doAction(java.lang.String, oracle.dbtools.worksheet.WorksheetContext) @bci=75, line=53 (Interpreted frame)

              - oracle.dbtools.worksheet.editor.Worksheet$WorksheetController.handleEvent(oracle.ide.controller.IdeAction, oracle.ide.Context) @bci=125, line=583 (Interpreted frame)

              - oracle.ide.controller.IdeAction.performAction(oracle.ide.Context) @bci=229, line=663 (Compiled frame)

              - oracle.ide.controller.IdeAction.actionPerformedImpl(java.awt.event.ActionEvent) @bci=67, line=1159 (Interpreted frame)

              - oracle.ide.controller.IdeAction.actionPerformed(java.awt.event.ActionEvent) @bci=2, line=618 (Compiled frame)

              - oracle.ide.ceditor.keymap.IdeKeymapHelper.invokeAction(java.lang.String) @bci=65, line=160 (Compiled frame)

              - oracle.javatools.editor.keys.MultiKeyHandler.keyPressed(java.awt.event.KeyEvent) @bci=147, line=336 (Compiled frame)

              - java.awt.AWTEventMulticaster.keyPressed(java.awt.event.KeyEvent) @bci=8, line=249 (Compiled frame)

              - java.awt.AWTEventMulticaster.keyPressed(java.awt.event.KeyEvent) @bci=8, line=249 (Compiled frame)

              - java.awt.AWTEventMulticaster.keyPressed(java.awt.event.KeyEvent) @bci=8, line=249 (Compiled frame)

              - java.awt.Component.processKeyEvent(java.awt.event.KeyEvent) @bci=52, line=6497 (Compiled frame)

              - javax.swing.JComponent.processKeyEvent(java.awt.event.KeyEvent) @bci=2, line=2832 (Compiled frame)

              - java.awt.Component.processEvent(java.awt.AWTEvent) @bci=121, line=6316 (Compiled frame)

              - java.awt.Container.processEvent(java.awt.AWTEvent) @bci=18, line=2239 (Compiled frame)

              - java.awt.Component.dispatchEventImpl(java.awt.AWTEvent) @bci=589, line=4889 (Compiled frame)

              - java.awt.Container.dispatchEventImpl(java.awt.AWTEvent) @bci=42, line=2297 (Compiled frame)

              - java.awt.Component.dispatchEvent(java.awt.AWTEvent) @bci=2, line=4711 (Compiled frame)

              - java.awt.KeyboardFocusManager.redispatchEvent(java.awt.Component, java.awt.AWTEvent) @bci=7, line=1954 (Compiled frame)

              - java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(java.awt.event.KeyEvent) @bci=63, line=835 (Compiled frame)

              - java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(java.awt.event.KeyEvent) @bci=137, line=1103 (Compiled frame)

              - java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(java.awt.Component, java.awt.AWTEvent) @bci=166, line=974 (Compiled frame)

              - java.awt.DefaultKeyboardFocusManager.dispatchEvent(java.awt.AWTEvent) @bci=1632, line=800 (Compiled frame)

              - java.awt.Component.dispatchEventImpl(java.awt.AWTEvent) @bci=151, line=4760 (Compiled frame)

              - java.awt.Container.dispatchEventImpl(java.awt.AWTEvent) @bci=42, line=2297 (Compiled frame)

              - java.awt.Window.dispatchEventImpl(java.awt.AWTEvent) @bci=19, line=2746 (Compiled frame)

              - java.awt.Component.dispatchEvent(java.awt.AWTEvent) @bci=2, line=4711 (Compiled frame)

              - java.awt.EventQueue.dispatchEventImpl(java.awt.AWTEvent, java.lang.Object) @bci=41, line=760 (Compiled frame)

              - java.awt.EventQueue.access$500(java.awt.EventQueue, java.awt.AWTEvent, java.lang.Object) @bci=3, line=97 (Compiled frame)

              - java.awt.EventQueue$3.run() @bci=32, line=709 (Compiled frame)

              - java.awt.EventQueue$3.run() @bci=1, line=703 (Compiled frame)

              - java.security.AccessController.doPrivileged(java.security.PrivilegedAction, java.security.AccessControlContext) @bci=0 (Compiled frame)

              - java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(java.security.PrivilegedAction, java.security.AccessControlContext, java.security.AccessControlContext) @bci=18, line=74 (Compiled frame)

              - java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(java.security.PrivilegedAction, java.security.AccessControlContext) @bci=6, line=84 (Compiled frame)

              - java.awt.EventQueue$4.run() @bci=11, line=733 (Compiled frame)

              - java.awt.EventQueue$4.run() @bci=1, line=731 (Compiled frame)

              - java.security.AccessController.doPrivileged(java.security.PrivilegedAction, java.security.AccessControlContext) @bci=0 (Compiled frame)

              - java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(java.security.PrivilegedAction, java.security.AccessControlContext, java.security.AccessControlContext) @bci=18, line=74 (Compiled frame)

              - java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent) @bci=73, line=730 (Compiled frame)

              - oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(java.awt.AWTEvent) @bci=68, line=169 (Compiled frame)

              - oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(java.awt.AWTEvent) @bci=6, line=151 (Compiled frame)

              - java.awt.EventDispatchThread.pumpOneEventForFilters(int) @bci=140, line=205 (Compiled frame)

              - java.awt.EventDispatchThread.pumpEventsForFilter(int, java.awt.Conditional, java.awt.EventFilter) @bci=35, line=116 (Compiled frame)

              - java.awt.EventDispatchThread.pumpEventsForHierarchy(int, java.awt.Conditional, java.awt.Component) @bci=11, line=105 (Interpreted frame)

              - java.awt.EventDispatchThread.pumpEvents(int, java.awt.Conditional) @bci=4, line=101 (Interpreted frame)

              - java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional) @bci=3, line=93 (Interpreted frame)

              - java.awt.EventDispatchThread.run() @bci=9, line=82 (Interpreted frame)

               

               

              Thread 1399: (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)

              - sun.awt.AWTAutoShutdown.run() @bci=32, line=295 (Interpreted frame)

              - java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 1397: (state = IN_NATIVE)

              - sun.awt.X11.XToolkit.waitForEvents(long) @bci=0 (Compiled frame; information may be imprecise)

              - sun.awt.X11.XToolkit.run(boolean) @bci=86, line=568 (Compiled frame)

              - sun.awt.X11.XToolkit.run() @bci=5, line=532 (Interpreted frame)

              - java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 1396: (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)

              - sun.java2d.Disposer.run() @bci=3, line=148 (Compiled frame)

              - java.lang.Thread.run() @bci=11, line=748 (Interpreted frame)

               

               

              Thread 1382: (state = BLOCKED)

               

               

              Thread 1380: (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)

              - java.lang.ref.Finalizer$FinalizerThread.run() @bci=36, line=216 (Compiled frame)

               

               

              Thread 1379: (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.lang.ref.Reference.tryHandlePending(boolean) @bci=54, line=191 (Compiled frame)

              - java.lang.ref.Reference$ReferenceHandler.run() @bci=1, line=153 (Compiled frame)

               

              I hope it will help to find the long waits for connection

              I will also have long waits on disconnect of one or all connection and total stuck when closing do you want a jstack on that also?

               

              Regards

              Ran

              • 4. Re: SQL Developer 18.4 on Linux
                thatJeffSmith-Oracle

                We just fixed a bug that looks just like this for 19.1 - so cross your fingers