8 Replies Latest reply: Sep 6, 2012 4:39 PM by 950645 RSS

    Lockup on table refresh

    950645
      Hi, I'm having a problem with SQL Developer on a new pc.

      When I refresh a table (with 22 columns) with no or almost no data in it the program stops responding for a considerable amount of time. When I attemp to click anywhere within the window I get the windows can't touch this sound. When I click outside of the window or try to kill it with task manager it will steal the focus back. This makes killing it very difficult (using my computer very difficult).

      I have tried:
      - Restarting
      - Changing to a different install/version of sql developer
      - Changing the jdk from 1.6 u33 to u25
      - Chaning to a sql developer with packaged 1.6 u11
      - Using my old pc, which didn't exibit the same problem.

      Any ideas will be much appreciated.

      Additional info:
      Java(TM) Platform     1.6.0_25
      Oracle IDE     3.1.06.82 (originally using the latest version)
      Versioning Support     3.1.06.82

      awt.toolkit     sun.awt.windows.WToolkit
      class.load.environment     oracle.ide.boot.IdeClassLoadEnvironment
      class.load.log.level     CONFIG
      class.transfer     delegate
      file.encoding     Cp1252
      file.encoding.pkg     sun.io
      file.separator     \
      http.agent     Mozilla/5.0 (Java 1.6.0_25; Windows 7 6.1 amd64; en_NZ) ICEbrowser/v6_1_3
      http.nonProxyHosts     localhost|localhost.localdomain|127.0.0.1|::1|<REMOVED>|<REMOVED>
      http.proxyHost     <REMOVED>
      http.proxyPort     8080
      https.nonProxyHosts     localhost|localhost.localdomain|127.0.0.1|::1|<REMOVED>|<REMOVED>
      https.proxyHost     <REMOVED>
      https.proxyPort     8080
      ice.browser.forcegc     false
      ice.pilots.html4.ignoreNonGenericFonts     true
      ice.pilots.html4.tileOptThreshold     0
      ide.AssertTracingDisabled     true
      ide.bootstrap.start     68756763698185
      ide.build     MAIN-06.82
      ide.conf     C:\development\sqldeveloper3.1\sqldeveloper\bin\sqldeveloper.conf
      ide.config_pathname     C:\development\sqldeveloper3.1\sqldeveloper\bin\sqldeveloper.conf
      ide.debugbuild     false
      ide.devbuild     false
      ide.extension.search.path     sqldeveloper/extensions:jdev/extensions:ide/extensions
      ide.firstrun     true
      ide.java.minversion     1.6.0_04
      ide.launcherProcessId     7156
      ide.main.class     oracle.ide.boot.IdeLauncher
      ide.patches.dir     ide/lib/patches
      ide.pref.dir     C:\Users\<REMOVED>\AppData\Roaming\SQL Developer
      ide.pref.dir.base     C:\Users\<REMOVED>\AppData\Roaming
      ide.product     oracle.sqldeveloper
      ide.shell.enableFileTypeAssociation     C:\development\sqldeveloper3.1\sqldeveloper.exe
      ide.splash.screen     splash.gif
      ide.startingArg0     "C:\development\sqldeveloper3.1\sqldeveloper64.exe"
      ide.startingcwd     C:\development\sqldeveloper3.1
      ide.user.dir     C:\Users\<REMOVED>\AppData\Roaming\SQL Developer
      ide.user.dir.var     IDE_USER_DIR
      ide.vcs.noapplications     true
      ide.work.dir     C:\Users\<REMOVED>\Documents\SQL Developer
      ide.work.dir.base     C:\Users\<REMOVED>\Documents
      ilog.propagatesPropertyEditors     false
      java.awt.graphicsenv     sun.awt.Win32GraphicsEnvironment
      java.awt.printerjob     sun.awt.windows.WPrinterJob
      java.class.path     ..\..\ide\lib\ide-boot.jar
      java.class.version     50.0
      java.endorsed.dirs     C:\Program Files\Java\jdk1.6.0_25\jre\lib\endorsed
      java.ext.dirs     C:\Program Files\Java\jdk1.6.0_25\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
      java.home     C:\Program Files\Java\jdk1.6.0_25\jre
      java.io.tmpdir     T:\Temp\
      java.library.path     C:\development\sqldeveloper3.1;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\Program Files\Bin;C:\LocalApps\bin;C:\Perl\v510\bin;C:\WINDOWS\SYSTEM32\WBEM;K:\PROD\Share\Bin;K:\PROD\WNT\Bin;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\WinZip;C:\Program Files\SlikSvn\bin;K:\PROD\WNT\Oracle11g\Ora112\bin;K:\PROD\WNT\LIB
      java.naming.factory.initial     oracle.javatools.jndi.LocalInitialContextFactory
      java.protocol.handler.pkgs     oracle.jdevimpl.handler
      java.runtime.name     Java(TM) SE Runtime Environment
      java.runtime.version     1.6.0_25-b06
      java.specification.name     Java Platform API Specification
      java.specification.vendor     Sun Microsystems Inc.
      java.specification.version     1.6
      java.util.logging.config.file     logging.conf
      java.vendor     Sun Microsystems Inc.
      java.vendor.url     http://java.sun.com/
      java.vendor.url.bug     http://java.sun.com/cgi-bin/bugreport.cgi
      java.version     1.6.0_25
      java.vm.info     mixed mode
      java.vm.name     Java HotSpot(TM) 64-Bit Server VM
      java.vm.specification.name     Java Virtual Machine Specification
      java.vm.specification.vendor     Sun Microsystems Inc.
      java.vm.specification.version     1.0
      java.vm.vendor     Sun Microsystems Inc.
      java.vm.version     20.0-b11
      jdbc.library     /C:/development/sqldeveloper3.1/jdbc/lib/ojdbc6.jar
      line.separator     \r\n
      log.file.name     C:\development\sqldeveloper3.1\sqldeveloper\extensions\oracle.datamodeler\log\datamodeler.log
      oracle.home     C:\development\sqldeveloper3.1
      oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG     true
      oracle.jdbc.mapDateToTimestamp     false
      oracle.translated.locales     de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW
      oracle.xdkjava.compatibility.version     9.0.4
      orai18n.library     /C:/development/sqldeveloper3.1/jlib/orai18n.jar
      os.arch     amd64
      os.name     Windows 7
      os.version     6.1
      path.separator     ;
      reserved_filenames     con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$
      sqldev.debug     false
      sun.arch.data.model     64
      sun.boot.class.path     C:\Program Files\Java\jdk1.6.0_25\jre\lib\resources.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\rt.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\jce.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.6.0_25\jre\lib\modules\jdk.boot.jar;C:\Program Files\Java\jdk1.6.0_25\jre\classes
      sun.boot.library.path     C:\Program Files\Java\jdk1.6.0_25\jre\bin
      sun.cpu.endian     little
      sun.cpu.isalist     amd64
      sun.desktop     windows
      sun.io.unicode.encoding     UnicodeLittle
      sun.java2d.ddoffscreen     false
      sun.jnu.encoding     Cp1252
      sun.management.compiler     HotSpot 64-Bit Tiered Compilers
      sun.os.patch.level     Service Pack 1
      svnkit.sax.useDefault     true
      user.country     NZ
      user.dir     C:\development\sqldeveloper3.1\sqldeveloper\bin
      user.home     C:\Users\<REMOVED>
      user.language     en
      user.name     <REMOVED>
      user.timezone     Pacific/Auckland
      user.variant
        • 1. Re: Lockup on table refresh
          950645
          This is still a problem so I am bumping it.
          • 2. Re: Lockup on table refresh
            Gary Graham-Oracle
            Hi,

            If the problem here involved a hang rather than just a slow refresh, I would recommend you take a full thread dump...
            https://forums.oracle.com/forums/ann.jspa?annID=1812

            Keep in mind the SQL Developer version you actually list was an Early Adopter release. You should really test using a production release:
            3.1.07.42
            or
            3.2.09.30
            Are any of the 22 columns of the CLOB data type? Is the database remote or local? Do you have privileges to use the DBA views? Is the refresh for the Object Viewer Data tab or for the Worksheet Query Results? All such details may help.

            Regards,
            Gary
            SQL Developer Team
            • 3. Re: Lockup on table refresh
              950645
              My system is currently:
              Java(TM) Platform     1.6.0_25
              Oracle IDE     3.1.07.42
              Versioning Support     3.1.07.42

              The columns are: 9 Number, 1 Number(38,0), 6 Date, 3 Varchar2(10 byte), 1 Varchar(20 byte), 2 Varchar(2000 Char)

              The database is remote on lan and it is my dev database so I can have full privilege to it though I am not logging in via an admin account. The same behaviour is exibited from the admin account.

              Something I have just discovered whilst trying to replicate the behaviour is that it will only happen when on my 24 inch 1920x1080 monitor and not my 17 inch 1280x1024. This coupled with the references in the stack trace would suggest it being a drawing problem.

              Both monitors are running on individual Nvidia Quadro 2000 cards with driver version 8.17.12.7090

              In the neverending loop of stack traces that I'm getting at least the following 3 overflows.

              Exception occurred during event dispatching:
              java.lang.StackOverflowError
              at sun.font.FontManager.getFont2D(Native Method)
              at sun.font.FontDesignMetrics.initMatrixAndMetrics(FontDesignMetrics.java:343)
              at sun.font.FontDesignMetrics.<init>(FontDesignMetrics.java:336)
              at sun.font.FontDesignMetrics.getMetrics(FontDesignMetrics.java:248)
              at sun.swing.SwingUtilities2.getFontMetrics(SwingUtilities2.java:942)
              at javax.swing.JComponent.getFontMetrics(JComponent.java:1599)
              at javax.swing.plaf.basic.BasicProgressBarUI.getPreferredSize(BasicProgressBarUI.java:804)
              at javax.swing.plaf.basic.BasicProgressBarUI.getMinimumSize(BasicProgressBarUI.java:858)
              at javax.swing.JComponent.getMinimumSize(JComponent.java:1714)
              at java.awt.GridBagLayout.GetLayoutInfo(GridBagLayout.java:1094)
              at java.awt.GridBagLayout.getLayoutInfo(GridBagLayout.java:893)
              at java.awt.GridBagLayout.minimumLayoutSize(GridBagLayout.java:727)
              at java.awt.Container.minimumSize(Container.java:1651)
              at java.awt.Container.getMinimumSize(Container.java:1636)
              at javax.swing.JComponent.getMinimumSize(JComponent.java:1716)
              at oracle.dbtools.raptor.backgroundTask.internal.SimpleRaptorTaskUI.createSimpleTaskUI(SimpleRaptorTaskUI.java:348)
              at oracle.dbtools.raptor.backgroundTask.internal.RaptorTaskUI.initGUI(RaptorTaskUI.java:108)
              at oracle.dbtools.raptor.backgroundTask.internal.SimpleRaptorTaskUI.<init>(SimpleRaptorTaskUI.java:58)
              at oracle.dbtools.raptor.backgroundTask.internal.RaptorTaskUI.<init>(RaptorTaskUI.java:36)
              at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:259)
              at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641)
              at java.awt.EventQueue.access$000(EventQueue.java:84)
              at java.awt.EventQueue$1.run(EventQueue.java:602)
              at java.awt.EventQueue$1.run(EventQueue.java:600)
              at java.security.AccessController.doPrivileged(Native Method)
              at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
              at java.awt.EventQueue.dispatchEvent(EventQueue.java:611)
              at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

              Exception occurred during event dispatching:
              java.lang.StackOverflowError
              at java.awt.Component.isShowing(Component.java:1354)
              at java.awt.Component.isShowing(Component.java:1354)
              at java.awt.Component.isShowing(Component.java:1354)
              at java.awt.Component.isShowing(Component.java:1354)
              at java.awt.Component.isShowing(Component.java:1354)
              at java.awt.Component.isShowing(Component.java:1354)
              at java.awt.Component.isShowing(Component.java:1354)
              at oracle.ide.view.View.updateToolbarActions(View.java:374)
              at oracle.ide.view.View.updateVisibleActions(View.java:214)
              at oracle.ide.view.View.updateVisibleActionsImpl(View.java:366)
              at oracle.ide.view.View.updateVisibleActions(View.java:361)
              at oracle.dbtools.raptor.oviewer.table.GridDataEditor.updateActions(GridDataEditor.java:272)
              at oracle.dbtools.raptor.controls.grid.EditableResultSetTable$FetchTaskListener$3.run(EditableResultSetTable.java:861)
              at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641)
              at java.awt.EventQueue.access$000(EventQueue.java:84)
              at java.awt.EventQueue$1.run(EventQueue.java:602)
              at java.awt.EventQueue$1.run(EventQueue.java:600)
              at java.security.AccessController.doPrivileged(Native Method)
              at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
              at java.awt.EventQueue.dispatchEvent(EventQueue.java:611)
              at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
              at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
              at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
              at java.awt.Dialog$1.run(Dialog.java:1046)
              at java.awt.Dialog$3.run(Dialog.java:1098)
              at java.security.AccessController.doPrivileged(Native Method)
              at java.awt.Dialog.show(Dialog.java:1096)

              Exception occurred during event dispatching:
              java.lang.StackOverflowError
              at javax.swing.UIManager.getUI(UIManager.java:980)
              at javax.swing.JPanel.updateUI(JPanel.java:109)
              at javax.swing.JPanel.<init>(JPanel.java:69)
              at javax.swing.JPanel.<init>(JPanel.java:92)
              at javax.swing.JPanel.<init>(JPanel.java:100)
              at oracle.dbtools.raptor.backgroundTask.internal.SimpleRaptorTaskUI.<init>(SimpleRaptorTaskUI.java:56)
              at oracle.dbtools.raptor.backgroundTask.internal.RaptorTaskUI.<init>(RaptorTaskUI.java:36)
              at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$2.run(RaptorTaskManager.java:259)
              at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641)
              at java.awt.EventQueue.access$000(EventQueue.java:84)
              • 4. Re: Lockup on table refresh
                Gary Graham-Oracle
                The only other forum thread I see with both "Nvidia" and "monitor" is this one:
                Re: Display artifacts

                You might try playing with the
                AddVMOption -Dsun.java2d.ddoffscreen=...
                AddVMOption -Dsun.java2d.noddraw=...
                settings in your sqldeveloper.conf file.

                -Gary
                • 5. Re: Lockup on table refresh
                  950645
                  I can also confirm that the problem is happening with the latest version,
                  Java(TM) Platform     1.6.0_33
                  Oracle IDE     3.2.09.30
                  Versioning Support     3.2.09.30

                  If I haven't mentioned this already, this is Windows 7 Enterprise SP-1 x64
                  • 6. Re: Lockup on table refresh
                    950645
                    AddVMOption -Dsun.java2d.ddoffscreen=
                    AddVMOption -Dsun.java2d.noddraw=

                    I changed these two options and the only thing that happened was when ddoffscreen was true moving the window failed to redraw properly making the program unusable. I couldn't get this behaviour to reproduce after the first time however.

                    I'm also getting '_execv() failed, err=2' appear after running the debug version of the program.
                    • 7. Re: Lockup on table refresh
                      Gary Graham-Oracle
                      A couple of quick, general web searches only turned up some old Java bugs with Nvidia not relevant to your case.

                      You say the PC is new, so perhaps you also have the latest Nvidia driver already, but that is something you may want to check on. Otherwise I'm not sure what more to suggest. In terms of debugging this a bit more...

                      1. If you reduce the resolution on the larger monitor, does the problem still reproduce?
                      2. If you change Tools | Preferences | Environment | Look and Feel, does that help?

                      Just guessing, but maybe you'll get lucky.

                      -Gary
                      • 8. Re: Lockup on table refresh
                        950645
                        The problem doesn't happen when the screens are both set to the same resolution. After I tested this I set the resolution back to normal without closing the program and the problem still didn't happen. However, I then restarted sqldeveloper on normal resolution and the problem came back.

                        Something interesting to note is that the time it takes to refresh when at the normal resolution is 1-2 seconds whilst it is almost instant at 1280x1024.

                        I have updated to the latest Nvidia driver.