4 Replies Latest reply on Aug 2, 2016 12:12 PM by PaulC

    Upgrade to 4.1.3 no longer displays package body content

    PaulC

      Environment

       

      Oracle 12c/Oracle Linux rel7/sqldeveloper 4.1.3/jdk 1.8.0.66

       

      Problem

       

      I've upgraded Sqldeveloper from 4.0 to 4.1.3, following the installation instruction (moved old directory, unzipped with 1.8 jdk distributed with sqldeveloper).  Following teh upgrade functionality works as before except for packages.  If I try and view a package spec or body, all that is returnedin the package panel is the line "create or replace" and the process hangs.  The SQLDeveloper message panel shows the output below.  Al lother aspects of database working as normal post SQLDeveloper upgrade.

       

      Any help in where to look to debug issue would be gratefully received.

       

      Starvation (possible deadlock) detected:

      Oracle SQL Developer 4.1.3 20.78 (MAIN-20.78)

      Oracle Corporation Java 1.8.0_66-b17

      178MB free of 746MB

       

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

      -- Thread Dump

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

       

       

      "RaptorTask: Usage Data" id=41 RUNNABLE (in native)

          at java.net.SocketInputStream.socketRead0(Native Method)

          at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)

          at java.net.SocketInputStream.read(SocketInputStream.java:170)

          at java.net.SocketInputStream.read(SocketInputStream.java:141)

          at oracle.net.ns.Packet.receive(Packet.java:311)

          at oracle.net.ns.DataPacket.receive(DataPacket.java:105)

          at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)

          at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)

          at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)

          at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)

          at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)

          at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)

          at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:429)

          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)

          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)

          at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)

          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:926)

          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1112)

          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)

          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4846)

          -  locked oracle.jdbc.driver.T4CConnection@576f3212

          at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)

          at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeQuery(Unknown Source)

          at oracle.dbtools.db.DBUtil$10.call(DBUtil.java:653)

          at oracle.dbtools.db.DBUtil$10.call(DBUtil.java:643)

          at oracle.dbtools.db.DBUtil.assertLock(DBUtil.java:1814)

          at oracle.dbtools.db.DBUtil.executeOracleQuery(DBUtil.java:669)

          at oracle.dbtools.db.OracleUtil.executeQuery(OracleUtil.java:100)

          at oracle.dbtools.raptor.navigator.net.DBURLStreamHandlerFactory.fetchSource(DBURLStreamHandlerFactory.java:292)

          at oracle.dbtools.raptor.navigator.net.DBURLFileSystemHelper.createReader(DBURLFileSystemHelper.java:165)

          at oracle.ideimpl.net.LazyURLFileSystemHelper.createReader(LazyURLFileSystemHelper.java:365)

          at oracle.ide.net.URLFileSystem.createReader(URLFileSystem.java:1707)

          at oracle.ide.model.TextNode.createReader(TextNode.java:1099)

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

          at oracle.ide.model.TextNode.openImpl(TextNode.java:537)

          at oracle.ide.db.model.BaseDBObjectTextNode.openImpl(BaseDBObjectTextNode.java:140)

          at oracle.dbtools.raptor.navigator.plsql.PlSqlNode.openImpl(PlSqlNode.java:144)

          at oracle.ide.model.Node.open(Node.java:1045)

          at oracle.ide.model.Node.open(Node.java:992)

          at oracle.ide.model.Node.ensureOpen(Node.java:2417)

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

          at oracle.dbtools.raptor.navigator.plsql.PlSqlNode.parseMembers(PlSqlNode.java:512)

          -  locked oracle.dbtools.raptor.navigator.plsql.PlSqlNode@3456e726

          at oracle.dbtools.raptor.navigator.plsql.PlSqlArguments.listChildren(PlSqlArguments.java:115)

          at oracle.dbtools.raptor.navigator.db.impl.DatabaseObjectTreeNode$LoadTask.doWorkImpl(DatabaseObjectTreeNode.java:82)

          at oracle.dbtools.raptor.navigator.model.NavigatorQueryTask.doWork(NavigatorQueryTask.java:57)

          at oracle.dbtools.raptor.navigator.model.NavigatorQueryTask.doWork(NavigatorQueryTask.java:17)

          at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

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

          at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)

          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:1142)

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

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

       

          Locked synchronizers:

          - java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@50519955

          - java.util.concurrent.ThreadPoolExecutor$Worker@22cc24b0

          - java.util.concurrent.locks.ReentrantLock$NonfairSync@7bcaa59e

       

      "AWT-EventQueue-0" id=13 WAITING on java.util.concurrent.locks.ReentrantReadWriteLock$NonfairSync@50519955 owned by "RaptorTask: Usage Data" id=41

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

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

          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.ide.model.Node.readLock(Node.java:265)

          at oracle.ide.model.Node.runUnderReadLock(Node.java:1651)

          at oracle.ide.model.TextBufferTracker.getTracker(TextBufferTracker.java:114)

          at oracle.ideimpl.markers.MarkableText.init(MarkableText.java:88)

          at oracle.ideimpl.markers.MarkableText.init(MarkableText.java:60)

          at oracle.ideimpl.markers.MarkableNode.<init>(MarkableNode.java:75)

          at oracle.ideimpl.markers.MarkableText.<init>(MarkableText.java:80)

          at oracle.ideimpl.markers.adapters.TextNodeToMarkableAdapterFactory.adaptImpl(TextNodeToMarkableAdapterFactory.java:72)

          at oracle.ideimpl.markers.adapters.TextNodeToMarkableAdapterFactory.adaptImpl(TextNodeToMarkableAdapterFactory.java:44)

          at oracle.ide.adapters.AbstractCachingAdapterFactory.adapt(AbstractCachingAdapterFactory.java:146)

          at oracle.ideimpl.adapters.AdapterManagerImpl.adapt(AdapterManagerImpl.java:116)

          at oracle.ide.markers.Markable$Adapter.adapt(Markable.java:84)

          at oracle.ideimpl.status.markers.StatusMarkerProvider.addStatusIssues(StatusMarkerProvider.java:186)

          at oracle.ideimpl.status.markers.StatusMarkerProvider.viewSelectionChanged(StatusMarkerProvider.java:142)

          at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)

          at oracle.ide.view.ViewDecorator.fireViewSelectionChangedImpl(ViewDecorator.java:69)

          at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)

          at oracle.ide.view.View.updateSelectionImpl0(View.java:442)

          at oracle.ide.view.View.updateSelectionImpl(View.java:427)

          at oracle.ide.view.View.updateSelection(View.java:306)

          at oracle.dbtools.raptor.navigator.core.NavigatorWindow$1$1.run(NavigatorWindow.java:90)

          at oracle.dbtools.raptor.navigator.core.NavigatorWindow$1.viewSelectionChanged(NavigatorWindow.java:96)

          at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)

          at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)

          at oracle.ide.view.View$2.actionPerformed(View.java:349)

          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$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

          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)

       

       

      Thanks

        • 1. Re: Upgrade to 4.1.3 no longer displays package body content

          Ok - so the FIRST thing to do is :

           

          1. use the old version of sql developer you had

          2. connected to the SAME database as the SAME user

          3. tried to view the SAME package body

           

          Post the result?

           

          The most common reason the body won't be displayed is because the user doesn't have the proper privileges.

           

          So that needs to be ruled out first.

          • 2. Re: Upgrade to 4.1.3 no longer displays package body content
            PaulC

            Thanks for the response.

             

            The second step taken was to completely remove sqldeveloper and re install from scratch (including deleting the hidden .sqldeveloper directory).  New connections where established as part of the installation, using the schema owner that owns and compiled the packages.

             

            Using either sqlplus from the o/s command line or the sql panel in sqldeveloper, and logged in as the schema owner, it is possible to view a package body; e.g.

             

            select text

            from all_source

            where name like 'A_PACKAGE_NAME%'

            and type = 'PACKAGE BODY'

             

            However the Package/Triggers option in sqldeveloper continue not to display content.  Which suggests it probably isn't user privileges.

             

            Using the sql that sqldeveloper is trying to run (in either sqlplus or sqldeveloper) shows a differnt problem:-

             

            WITH src AS (SELECT ROWNUM,LINE,TEXT,origin_con_id FROM SYS.Dba_SOURCE

            WHERE TYPE = 'PACKAGE' AND OWNER = 'SSL' AND NAME = 'IC_INTERACTIONS_UTIL')

            SELECT text FROM src, (SELECT max(origin_con_id) max_orig FROM src) 

            WHERE origin_con_id = max_orig

            ORDER BY LINE

             

            then the following error is displayed:-

             

            Error report -

            SQL Error: ORA-12805: parallel query server died unexpectedly

            12805. 00000 -  "parallel query server died unexpectedly"

            *Cause:    A parallel query server died unexpectedly, PMON cleaning

                       up the process.

             

            Is there paramater in release 4.3.1 that isn't used in 4.0 in relation to using the parallel query server that needs amending?

             

            Thanks

            • 3. Re: Upgrade to 4.1.3 no longer displays package body content
              thatJeffSmith-Oracle

              No. I think you have ID the problem...the DB can't service that query. I would raise an SR with MOS. The difference in sqldev 413 vs 4.0 is the jdbc driver, 12.1.0.2

              • 4. Re: Upgrade to 4.1.3 no longer displays package body content
                PaulC

                Thanks.

                 

                House rule that SRs only raised on production systems.

                 

                Can't see anything obvious in incident/trace files to pinpoint real error. Easier to just revert back to 4.0.3.