This discussion is archived
8 Replies Latest reply: Sep 6, 2012 2:39 PM by 950645 RSS

Lockup on table refresh

950645 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    This is still a problem so I am bumping it.
  • 2. Re: Lockup on table refresh
    Gary Graham Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points