2 Replies Latest reply on May 19, 2015 12:41 PM by Ognjen Suljagic

    Possible deadlock in 4.0.2 and 4.1

    Ognjen Suljagic

      Ever since SQL developer 4.0.2 - now I have SQL developer 4.1, I have been getting random crashes... Now in 4.1 in the log, I get possible deadlock detected messages.

        • 1. Re: Possible deadlock in 4.0.2 and 4.1
          thatJeffSmith-Oracle

          How about showing us the log with said messages?

          • 2. Re: Possible deadlock in 4.0.2 and 4.1
            Ognjen Suljagic

            Yeah sure thing: (hope it's ok to drop the log in here like this.)

             

            There are 2 messages in the log - number 1 is the problematic one i guess.

             

            Also after a whole day of usage, my SQL developer is at 3.4 GB of RAM... I increased the max memory for SQL Developer to 8 GB

             

            ###################

            NUMBER 1

            ####################

             

            SOURCE: oracle.javatools.buffer.JdkReadWriteLockImplementation$DeadlockScanner

             

            MESSAGE:

            Starvation (possible deadlock) detected:

            Oracle SQL Developer 4.1.0 19.07 (MAIN-19.07)

            New Oracle Java 1.8.0_45-b15

            5627MB free of 7635MB

             

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

            -- Thread Dump

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

             

             

            "brace-matching-pool-1-thread-140" id=4446 WAITING on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@773017f6 owned by "AWT-EventQueue-0" id=15

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

                -  waiting on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@773017f6

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

                at java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:836)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireShared(AbstractQueuedSynchronizer.java:967)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireShared(AbstractQueuedSynchronizer.java:1283)

                at java.util.concurrent.locks.ReentrantReadWriteLock$ReadLock.lock(ReentrantReadWriteLock.java:727)

                at oracle.javatools.buffer.JdkReadWriteLockImplementation.lock(JdkReadWriteLockImplementation.java:202)

                at oracle.javatools.buffer.JdkReadWriteLockImplementation.readLock(JdkReadWriteLockImplementation.java:94)

                at oracle.javatools.buffer.ReadWriteLock.readLock(ReadWriteLock.java:192)

                at oracle.javatools.buffer.AbstractTextBuffer.readLock(AbstractTextBuffer.java:948)

                at oracle.javatools.buffer.ReadTextBufferDecorator.readLock(ReadTextBufferDecorator.java:126)

                at oracle.javatools.editor.plugins.BraceMatchingPlugin$BraceMatchingTask.run(BraceMatchingPlugin.java:617)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)

                at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)

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

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

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

             

                Locked synchronizers:

                - java.util.concurrent.ThreadPoolExecutor$Worker@6c4166e7

             

            "MarkableText" id=4416 TIMED_WAITING on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@773017f6 owned by "AWT-EventQueue-0" id=15

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

                -  waiting on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@773017f6

                at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireSharedNanos(AbstractQueuedSynchronizer.java:1037)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer.tryAcquireSharedNanos(AbstractQueuedSynchronizer.java:1328)

                at java.util.concurrent.locks.ReentrantReadWriteLock$ReadLock.tryLock(ReentrantReadWriteLock.java:871)

                at oracle.javatools.buffer.JdkReadWriteLockImplementation.lock(JdkReadWriteLockImplementation.java:189)

                at oracle.javatools.buffer.JdkReadWriteLockImplementation.readLock(JdkReadWriteLockImplementation.java:94)

                at oracle.javatools.buffer.ReadWriteLock.readLock(ReadWriteLock.java:192)

                at oracle.ide.model.Node.readLock(Node.java:265)

                at oracle.ide.model.TextNode.acquireTextBuffer(TextNode.java:764)

                at oracle.ideimpl.markers.MarkableText.updateTextMarkers(MarkableText.java:138)

                at oracle.ideimpl.markers.MarkableText.access$100(MarkableText.java:60)

                at oracle.ideimpl.markers.MarkableText$TBL$1.run(MarkableText.java:235)

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1425)

                at org.netbeans.modules.openide.util.GlobalLookup.execute(GlobalLookup.java:59)

                at org.openide.util.lookup.Lookups.executeWith(Lookups.java:294)

                at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2038)

             

            "AWT-EventQueue-0" id=15 TIMED_WAITING on java.util.concurrent.locks.ReentrantLock$NonfairSync@79f7f760 owned by "QuickDiffMargin" id=4445

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

                -  waiting on java.util.concurrent.locks.ReentrantLock$NonfairSync@79f7f760

                at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireNanos(AbstractQueuedSynchronizer.java:934)

                at java.util.concurrent.locks.AbstractQueuedSynchronizer.tryAcquireNanos(AbstractQueuedSynchronizer.java:1247)

                at java.util.concurrent.locks.ReentrantLock.tryLock(ReentrantLock.java:442)

                at oracle.dbtools.raptor.utils.Connections.lock(Connections.java:1915)

                at oracle.dbtools.raptor.utils.Connections.lock(Connections.java:1861)

                at oracle.dbtools.raptor.utils.Connections.lock(Connections.java:1848)

                at oracle.dbtools.raptor.navigator.net.DBURLFileSystemHelper.canWrite(DBURLFileSystemHelper.java:81)

                at oracle.dbtools.raptor.navigator.net.DBURLFileSystemHelper.isReadOnly(DBURLFileSystemHelper.java:55)

                at oracle.ideimpl.net.LazyURLFileSystemHelper.isReadOnly(LazyURLFileSystemHelper.java:223)

                at oracle.ide.net.URLFileSystem.isReadOnly(URLFileSystem.java:1040)

                at oracle.ide.model.Node.isReadOnly(Node.java:1314)

                at oracle.ide.model.TextNode.loadTextBuffer(TextNode.java:349)

                at oracle.ide.model.TextNode.revertImpl(TextNode.java:700)

                at oracle.ide.model.Node.revert(Node.java:1238)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.tryRevert(ExternalUpdateTracker.java:307)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.autoReload(ExternalUpdateTracker.java:278)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.access$100(ExternalUpdateTracker.java:48)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker$2.runImpl(ExternalUpdateTracker.java:264)

                at oracle.javatools.util.SwingClosure$1Closure.run(SwingClosure.java:50)

                at oracle.javatools.util.SwingClosure.run(SwingClosure.java:61)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.performReload(ExternalUpdateTracker.java:270)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.reloadBuffers(ExternalUpdateTracker.java:222)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.reloadBuffers(ExternalUpdateTracker.java:194)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.handleChangedNodes(ExternalUpdateTracker.java:146)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker.access$000(ExternalUpdateTracker.java:48)

                at oracle.dbtools.raptor.plsql.ExternalUpdateTracker$1.actionPerformed(ExternalUpdateTracker.java:64)

                at javax.swing.Timer.fireActionPerformed(Timer.java:313)

                at javax.swing.Timer$DoPostEvent.run(Timer.java:245)

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

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

                at java.awt.EventQueue.access$500(EventQueue.java:97)

                at java.awt.EventQueue$3.run(EventQueue.java:709)

                at java.awt.EventQueue$3.run(EventQueue.java:703)

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

                at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)

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

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

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

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

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

                at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

                at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

                at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

                at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

             

                Locked synchronizers:

                - java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@773017f6

             

             

             

            ###################

            NUMBER 2

            ####################

            SOURCE:  oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1

             

            Message:

             

            SEVERE191477810575oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1null at oracle.dbtools.raptor.insight.CompletionInsight.colNamesMatch(CompletionInsight.java:1581)