12 Replies Latest reply on Jun 23, 2016 1:56 PM by Dan Lemkin

    SQL Developer on Mac - Application freezing on exit

    Dan Lemkin

      HI,

      I have recently been experiencing issues with the application failing to stop on a mac client 10.11.5 El Capitan running Java 1.8U91 JDK and 4.1.3 SQLDev

      The app window disappears but the icon stays in the task bar. It fails to close with Force Quit.

      I can't see any process named SQLDeveloper or process ID to permit killing it.

      It is keeping my mac from restarting, and requires a hard restart to clear it.

       

       

      How can I kill an instance of this java App without hard rebooting my machine?

      Is this a known bug? If not, how can I clear all cache and pref files associated with SQLDeveloper for a fresh install. I already updated java JDK and reinstalled SQLDeveloper, but problem persists    

        • 1. Re: SQL Developer on Mac - Application freezing on exit
          thatJeffSmith-Oracle

          no known bugs

           

          go to your home directory, there's a .sqldeveloper folder there

           

          sqldev_mac_home.png

          try renaming the system4.1.3* folder to something else. You'll want to export your connections first.

           

          Jeff

          • 2. Re: SQL Developer on Mac - Application freezing on exit
            Kyle {unique}

            You may be able to find a PID for it by using

            ps -fe | grep -i sql

             

            from a Terminal window.

             

            I get an output like this. Where 50941 is the PID I would use with the kill command

             

              501 50941     1   0 Mon01PM ??         0:00.00 /bin/bash /Applications/SQLDeveloper.app/Contents/MacOS/sqldeveloper.sh
              501 50943 50941   0 Mon01PM ??         0:00.05 bash ./sqldeveloper
              501 54667 50943   0 Mon01PM ??        52:41.72 /Library/Java/JavaVirtualMachines/jdk1.8.0_51.jdk/Contents/Home/bin/java -Xbootclasspath/a:/Library/Java/JavaVirtualMachines/jdk1.8.0_51.jdk/Contents/Home/lib/tools.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_51.jdk/Contents/Home/lib/dt.jar -Djdeveloper.system_http_proxy=DIRECT -Djdeveloper.system_http_non_proxy_hosts= -Dsun.java2d.noddraw=true -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 -Xbootclasspath/p:../../ide/bin/../../rdbms/jlib/ojdi.jar -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/../../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=http://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 -Dide.AssertTracingDisabled=true -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Djava.util.logging.config.file=logging.conf -Dsqldev.debug=false -Dsqldev.onsd=true -Dcom.apple.mrj.application.apple.menu.about.name=SQL_Developer -Dcom.apple.mrj.application.growbox.intrudes=false -Dcom.apple.macos.smallTabs=true -Dapple.laf.useScreenMenuBar=true -Xdock:name=Oracle SQL Developer -Xdock:icon=SQLDeveloperIcons.icns -Xbootclasspath/p:../../rdbms/jlib/ojdi.jar -Dide.conf="/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf" -Duser.conf="/Users/USERNAME/.sqldeveloper/4.1.0/product.conf" -Dtool.user.conf="/Users/USERNAME/.sqldeveloper/4.1.0/sqldeveloper.conf" -Dide.startingcwd="/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin" -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
            

             

            kill -9 50941



            Us Mac user gotta stick together!

            • 3. Re: SQL Developer on Mac - Application freezing on exit
              thatJeffSmith-Oracle

              >>Us Mac user gotta stick together!

              Agreed. a majority of the R&D team devs build and use SQLDev on Macs.

               

              You could try Window > Reset Windows to Factory first - that would be less destructive than renaming the systemX.Y.Z directory

              • 4. Re: Re: SQL Developer on Mac - Application freezing on exit
                Dan Lemkin

                Unfortunately not working....

                I completely uninstalled and deleted all old versions of Java and reinstalled Java. Installed a fresh copy of SQLDev and recreated connections.

                When I launch the app, it loads fine... But all I did was click the About window to get the data below, and then File --> Quit and again, it ends up in a limbo where it is neither running or quit. I can't shutdown Or launch the app again without a hard reset. This has been stable for over a year, until last day or so.. arrrrgh!

                 

                Any additional help would be really appreciated. I am stuck.

                 

                While it was running, I saw it in the active processes and used mac tools to sample process

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

                Sampling process 4424 for 3 seconds with 1 millisecond of run time between samples

                Sampling completed, processing symbols...

                Analysis of sampling java (pid 4424) every 1 millisecond

                Process:        java [4424]

                Path:            /Library/Java/JavaVirtualMachines/jdk1.8.0_91.jdk/Contents/Home/bin/java

                Load Address:    0x10d4cb000

                Identifier:      com.oracle.SQLDeveloper

                Version:        1.0 (1.0)

                Code Type:      X86-64

                Parent Process:  bash [695]

                 

                 

                Date/Time:      2016-06-21 16:35:55.443 -0400

                Launch Time:    2016-06-21 16:34:11.240 -0400

                OS Version:      Mac OS X 10.11.5 (15F34)

                Report Version:  7

                Analysis Tool:  /usr/bin/sample

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

                 

                After I quit the app, it sits in the tray. Force Quit does nothing.

                Screen Shot 2016-06-21 at 8.22.35 PM.png

                 

                When I look for active processes, I don't find them.

                Screen Shot 2016-06-21 at 8.34.09 PM.png

                When I look in activity monitor, I see the app only on energy screen greyed out

                Screen Shot 2016-06-21 at 8.37.31 PM.png

                 

                 

                 

                About

                -----

                Oracle SQL Developer 4.1.3.20

                Version 4.1.3.20

                Build MAIN-20.78

                IDE Version: 12.2.1.0.42.151001.0541

                Product ID: oracle.sqldeveloper

                Product Version: 12.2.0.20.78

                 

                Version

                -------

                Component Version

                ========= =======

                Oracle IDE 4.1.3.20.78

                Java(TM) Platform 1.8.0_92

                Properties

                ----------

                Name Value

                ==== =====

                Extensions

                ----------

                Name Identifier Version Status Registration Time Initialization Time Total Time

                ==== ========== ======= ====== ================= =================== ==========

                • 5. Re: SQL Developer on Mac - Application freezing on exit
                  thatJeffSmith-Oracle

                  you said you installed fresh copies of java and sqldev - but did you delete the appdata folder for 4.1.3? and did you say 'no' to importing settings from an earlier install?

                   

                  something's amiss on your machine...can you get the PID for sqldev before you try to close it, and then after you close it, try a kill -9 on the PID and see if it goes away on your task bar/activity monitor? 

                  • 6. Re: SQL Developer on Mac - Application freezing on exit
                    Dan Lemkin

                    I could have sworn that I completely deleted the .sqldeveloper folder in by home directory.... I copied all my sql out and then deleted it on a previous install but I clearly missed something.

                     

                    I deleted that .sqldeveloper folder out of my home.

                    I searched by \Users\home directory for sqldeveloper and found an additional com.Oracle.sqldeveloper preference record and a few more stragglers

                    I deleted all of those and reinstalled, and crossing fingers - it appears to now be stable.

                     

                    I had created multiple connections using the same creds, so I can execute multiple queries simultaneously. Is this an issue? Is there anything I need to do to perform these parallel executions without conflict?

                    Something got corrupted, just wondering if it was an active action on my part, or just a bizarre issue?

                     

                    thanks for your assistance.

                    dan

                    • 7. Re: SQL Developer on Mac - Application freezing on exit
                      thatJeffSmith-Oracle

                      if you want to run multiple queries concurrently, just open an unshared worksheet

                      • 8. Re: SQL Developer on Mac - Application freezing on exit
                        Dan Lemkin

                        When I open a SQL file, There is a nested tab SQL Worksheet and within that is another tab Worksheet / Query Builder. Each tab requires I associate it with a connection to run. If I choose the same connection, they run sequentially, not concurrently. What am I doing wrong?

                        Screen Shot 2016-06-22 at 11.15.23 AM.png

                        If I associate each query with a different iteration of the connection, they will run concurrently

                        Screen Shot 2016-06-22 at 11.18.27 AM.png

                        • 9. Re: SQL Developer on Mac - Application freezing on exit
                          Gary Graham-Oracle

                          What am I doing wrong?

                          Look closely at the SQL Worksheet's toolbar.  Mouse over the 8th icon in the toolbar (which is only enabled after having selected a connection) to see this tool tip:

                                    Unshared SQL Worksheet (Ctrl+Shift+N)

                           

                          Clicking on that will open another worksheet using the same credentials, but in a new session so nothing is shared and a query running in the first will not block a query running in the initial unshared worksheet (or any additional unshared worksheets you might create):

                          UnsharedWorksheetExample.jpg

                          • 10. Re: SQL Developer on Mac - Application freezing on exit
                            Dan Lemkin

                            Is there anyway to open existing sql queries into the new unshared worksheet? when I open an existing query, it only gives me options of associating with the initial connection, not the unshared worksheet connection CONNECTION__1

                            • 11. Re: SQL Developer on Mac - Application freezing on exit
                              Gary Graham-Oracle

                              No, opening an existing SQL file requires selecting from the list of defined connections.

                               

                              If your requirement is such that explicitly opening an unshared connection (either from an open shared connection worksheet, or from the navigator tree with the preference Database > Worksheet > New Worksheet to use unshared connection) and copy/pasting into it is undesirable,  then your original approach of defining multiple connections with the same credentials is the way to go.

                              1 person found this helpful
                              • 12. Re: SQL Developer on Mac - Application freezing on exit
                                Dan Lemkin

                                Unfortunately.... when I tried to use it today, It did the same thing.... When I close the app, it goes into limbo, neither running nor stopped... or at least the OS thinks it is still running, as it won't relaunch.

                                 

                                I rebooted, ran it. And while the app was running, checked for active PID... which is below.  In Activity monitor there Oracle SQL Developer had PID 4330, bash had ID 569

                                 

                                P1105S123LT3:~ dan$ ps -A | grep SQL

                                  569 ??         0:00.01 /bin/bash /Applications/SQLDeveloper.app/Contents/MacOS/sqldeveloper.sh

                                4330 ??         0:39.13 /Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/bin/java -Xbootclasspath/a:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/lib/tools.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_92.jdk/Contents/Home/lib/dt.jar -Djdeveloper.system_http_proxy=DIRECT -Djdeveloper.system_http_non_proxy_hosts= -Dsun.java2d.noddraw=true -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 -Xbootclasspath/p:../../ide/bin/../../rdbms/jlib/ojdi.jar -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/../../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=http://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 -Dide.AssertTracingDisabled=true -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true -Djava.util.logging.config.file=logging.conf -Dsqldev.debug=false -Dsqldev.onsd=true -Dcom.apple.mrj.application.apple.menu.about.name=SQL_Developer -Dcom.apple.mrj.application.growbox.intrudes=false -Dcom.apple.macos.smallTabs=true -Dapple.laf.useScreenMenuBar=true -Xdock:name=Oracle SQL Developer -Xdock:icon=SQLDeveloperIcons.icns -Xbootclasspath/p:../../rdbms/jlib/ojdi.jar -Dide.conf="/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf" -Duser.conf="/Users/dan/.sqldeveloper/4.1.0/product.conf" -Dtool.user.conf="/Users/dan/.sqldeveloper/4.1.0/sqldeveloper.conf" -Dide.startingcwd="/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin" -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

                                4536 ttys000    0:00.00 grep SQL

                                P1105S123LT3:~ dan$ ps -A | grep SQL

                                4560 ttys000    0:00.00 grep SQL


                                 

                                P1105S123LT3:~ dan$ kill -9 4330

                                -bash: kill: (4330) - No such process

                                P1105S123LT3:~ dan$ kill -9 569

                                -bash: kill: (569) - No such process

                                P1105S123LT3:~ dan$

                                 

                                When I run directly from shell, it launches

                                P1105S123LT3:~ dan$ /Applications/SQLDeveloper.app/Contents/MacOS/sqldeveloper.sh

                                When I kill it from another terminal window :

                                 

                                P1105S123LT3:~ dan$ kill -9 12148

                                The shell from which I launched it returns this:

                                 

                                /Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 1286: 12148 Killed: 9               ${JAVA} "${APP_VM_OPTS[@]}" ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} "${APP_APP_OPTS[@]}"

                                P1105S123LT3:~ dan$

                                P1105S123LT3:~ dan$

                                P1105S123LT3:~ dan$


                                any ideas?