This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Sep 26, 2012 1:55 PM by fmercury RSS

3.1EA1 File browser bug?

fmercury Newbie
Currently Being Moderated
When I load the Files browser/viewer, it seems to hang when expanding various folder that previously were handled without a problem. I just get the loading... text but nothing ever happens. At this point, the only way for me to load files is via just using File/Open... Is anyone else experiencing this?
  • 1. Re: 3.1EA1 File browser bug?
    Gary Graham Expert
    Currently Being Moderated
    Hi,

    Doing a quick compare of the Files view in 3.0.04.34 and 3.1.05.97, opening folders containing only a few files is quick. Opening a folder containing over 2400 files (directly owned by the folder, not other sub-folders) took 10+ seconds on both versions. Perhaps EA1 was a bit slower, but nothing surprising. Using File|Open is much faster on both versions, as expected. Does this happen right after launching SQL Developer, or only after using it for some time? For example, if Task Manager shows high Mem Usage/VM Size for the sqldeveloper.exe there is probably lots of paging occurring on the system.

    What version are you comparing the performance against? If you run it from the command line are there any error messages? If it is hanging (no CPU activity/no disk activity), try Ctrl-Break from the command line and post the full thread dumps for us to review.

    Regards,
    Gary
    SQL Developer Team
  • 2. Re: 3.1EA1 File browser bug?
    fmercury Newbie
    Currently Being Moderated
    In my case, I'm just trying to open a folder with a few (< 10) files, but it is nested a few folders deep. I don't know if that enters into it at all. This happens any time I'm using SQL-Developer - can be right away, can be after using it for a while - doesn't seem to care. When I look at how much memory it's using right now (as I am trying it again), I see it's using 658,392K of memory, which is a bit much. :/ I'm running on Windows 7 Professional SP1 32-bit. Intel i7, 4 GB memory (only 2.91 GB usable).

    Essentially, I'm just comparing performance against the previous version. The file browser seemed to run okay, although there were occasionally some folders it didn't see - I haven't seen that with the EA1 release, though - it just doesn't load the folders.

    I'm not running through the command line, but even when I hit control break, it doesn't crash. I did notice that usually when it expands a folder successfully, the animation at the bottom of the screen (the block going left and right) is going. When it locks up, there is no animation - the application keeps working (more or less).

    Hopefully that helps!
  • 3. Re: 3.1EA1 File browser bug?
    Gary Graham Expert
    Currently Being Moderated
    Well, I haven't tried Win7, but on WinXP SP3 I used the File viewer to walk down about 10 levels starting at C:\Documents and Settings without problems. Unless this is generally reproducible on Win7, the best way to investigate would be for you to provide a thread dump at the point it hangs. If you have the chance, please...

    1) Open a command prompt window. Be sure its property for screen buffer height is large, at least 500 lines.
    2) Change directory to ...\sqldeveloper\sqldeveloper\bin
    3) Run sqldeveloper.exe
    4) When the File viewer hangs, return to the command prompt window and do a Ctrl-Break
    5) Copy the full thread dump and paste back here.

    Additional note: if you happen to use the download of 3.1 EA1 that comes without a JDK and installed your own, please be aware we recommend staying with the latest jdk1.6.0_xx version and avoid jdk1.7.0.

    Thanks in advance,
    Gary
  • 4. Re: 3.1EA1 File browser bug?
    fmercury Newbie
    Currently Being Moderated
    Gary,
    Thanks for the info on running it from the command line - I hadn't done that before. Here is the dump:
    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation. All rights reserved.

    H:\>c:

    C:\>cd program files\sqldeveloper3.1

    C:\Program Files\sqldeveloper3.1>cd sqldeveloper\bin

    C:\Program Files\sqldeveloper3.1\sqldeveloper\bin>sqldeveloper
    Registered TimesTen
    Exception in thread "IconOverlayTracker Timer" java.lang.OutOfMemoryError: Java heap space
    at java.util.Arrays.copyOf(Arrays.java:2882)
    at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)
    at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)
    at java.lang.StringBuffer.append(StringBuffer.java:224)
    at org.tmatesoft.svn.core.SVNErrorMessage.getFullMessage(SVNErrorMessage.java:257)
    at org.tmatesoft.svn.core.internal.wc.SVNErrorManager.error(SVNErrorManager.java:58)
    at org.tmatesoft.svn.core.internal.wc.admin.SVNAdminAreaFactory.open(SVNAdminAreaFactory.java:163)
    at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.doOpen(SVNWCAccess.java:364)
    at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess.java:272)
    at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess.java:265)
    at org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess.java:261)
    at org.tmatesoft.svn.core.wc.SVNStatusClient.doStatus(SVNStatusClient.java:316)
    at org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java:296)
    at org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java:278)
    at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getStatus(AbstractJhlClientAdapter.java:480)
    at org.tigris.subversion.svnclientadapter.svnkit.SvnKitClientAdapter.getStatus(SvnKitClientAdapter.java:141)
    at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getStatus(AbstractJhlClientAdapter.java:466)
    at oracle.jdevimpl.vcs.svn.SVNURLInfoCacheSimpleStrategy.getURLInfo(SVNURLInfoCacheSimpleStrategy.java:79)
    at oracle.jdevimpl.vcs.svn.SVNURLInfoCache.getPropStatus(SVNURLInfoCache.java:59)
    at oracle.jdevimpl.vcs.svn.SVNStatusResolver.getStatus(SVNStatusResolver.java:159)
    at oracle.jdevimpl.vcs.svn.SVNStatusResolver.populateStatuses(SVNStatusResolver.java:82)
    at oracle.jdevimpl.vcs.generic.GenericClient$2.getImpl(GenericClient.java:531)
    at oracle.jdeveloper.vcs.spi.VCSStatusCache.getValuesImpl(VCSStatusCache.java:31)
    at oracle.jdeveloper.vcs.spi.VCSURLBasedCache.getValues(VCSURLBasedCache.java:107)
    at oracle.jdeveloper.vcs.spi.VCSStatusCache.get(VCSStatusCache.java:63)
    at oracle.jdeveloper.vcs.spi.VCSOverlayItemProducer.getOverlayItems(VCSOverlayItemProducer.java:63)
    at oracle.jdeveloper.vcs.spi.VCSNodeOverlayTracker.getOverlays(VCSNodeOverlayTracker.java:288)
    at oracle.ide.explorer.IconOverlayTracker.processPendingNodes(IconOverlayTracker.java:574)
    at oracle.ide.explorer.IconOverlayTracker.access$1400(IconOverlayTracker.java:69)
    at oracle.ide.explorer.IconOverlayTracker$7.run(IconOverlayTracker.java:487)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)
    Exception in thread "AWT-EventQueue-0" java.lang.IllegalStateException: Timer already cancelled.
    at java.util.Timer.sched(Timer.java:354)
    at java.util.Timer.schedule(Timer.java:170)
    at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.updateVisibleNodes(IconOverlayTracker.java:802)
    at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.access$3000(IconOverlayTracker.java:713)
    at oracle.ide.explorer.IconOverlayTracker$NodeWatcher$NodeUserListener.treeExpanded(IconOverlayTracker.java:969)
    at javax.swing.JTree.fireTreeExpanded(JTree.java:2666)
    at javax.swing.JTree.setExpandedState(JTree.java:3427)
    at javax.swing.JTree.expandPath(JTree.java:2163)
    at javax.swing.plaf.basic.BasicTreeUI.toggleExpandState(BasicTreeUI.java:2209)
    at javax.swing.plaf.basic.BasicTreeUI.handleExpandControlClick(BasicTreeUI.java:2196)
    at javax.swing.plaf.basic.BasicTreeUI.checkForClickInExpandControl(BasicTreeUI.java:2154)
    at com.jgoodies.looks.plastic.PlasticTreeUI.access$900(PlasticTreeUI.java:120)
    at com.jgoodies.looks.plastic.PlasticTreeUI$MouseHandler.mousePressed(PlasticTreeUI.java:276)
    at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
    at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
    at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
    at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
    at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:262)
    at java.awt.Component.processMouseEvent(Component.java:6131)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
    at oracle.ideimpl.explorer.CustomTree.processMouseEvent(CustomTree.java:220)
    at java.awt.Component.processEvent(Component.java:5899)
    at java.awt.Container.processEvent(Container.java:2023)
    at java.awt.Component.dispatchEventImpl(Component.java:4501)
    at java.awt.Container.dispatchEventImpl(Container.java:2081)
    at java.awt.Component.dispatchEvent(Component.java:4331)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4301)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3962)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3895)
    at java.awt.Container.dispatchEventImpl(Container.java:2067)
    at java.awt.Window.dispatchEventImpl(Window.java:2458)
    at java.awt.Component.dispatchEvent(Component.java:4331)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
    java.lang.IllegalStateException: Timer already cancelled.
    at java.util.Timer.sched(Timer.java:354)
    at java.util.Timer.schedule(Timer.java:170)
    at oracle.ide.explorer.IconOverlayTracker._scheduleUpdateTask(IconOverlayTracker.java:498)
    at oracle.ide.explorer.IconOverlayTracker.scheduleUpdateTask(IconOverlayTracker.java:449)
    at oracle.ide.explorer.IconOverlayTracker.repaintConsumerOverlays(IconOverlayTracker.java:432)
    at oracle.ide.explorer.IconOverlayTracker.access$000(IconOverlayTracker.java:69)
    at oracle.ide.explorer.IconOverlayTracker$2.stateChanged(IconOverlayTracker.java:114)
    at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.setVisibleNodes(IconOverlayTracker.java:843)
    at oracle.ide.explorer.IconOverlayTracker$NodeWatcher.access$2800(IconOverlayTracker.java:713)
    at oracle.ide.explorer.IconOverlayTracker$NodeWatcher$4.run(IconOverlayTracker.java:818)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
    2011-11-04 10:57:04
    Full thread dump Java HotSpot(TM) Client VM (11.0-b16 mixed mode):

    "AWT-EventQueue-0" prio=6 tid=0x06cb3800 nid=0x1fcc in Object.wait() [0x063ff000..0x063ff9e8]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.lang.Object.wait(Object.java:485)
    at java.awt.EventQueue.getNextEvent(EventQueue.java:479)
    - locked <0x121a84c8> (a java.awt.EventQueue)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:236)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

    "Timer-2" daemon prio=6 tid=0x06cb2c00 nid=0x246c in Object.wait() [0x09e5f000..0x09e5fae8]
    java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.util.TimerThread.mainLoop(Timer.java:509)
    - locked <0x13d2f710> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "IconOverlayTracker Timer" prio=6 tid=0x06cb4800 nid=0x1f9c in Object.wait() [0x0c4bf000..0x0c4bfc68]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.lang.Object.wait(Object.java:485)
    at java.util.TimerThread.mainLoop(Timer.java:483)
    - locked <0x13a6f288> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "Swing-Shell" daemon prio=6 tid=0x06cb2400 nid=0x18f8 waiting on condition [0x0b90f000..0x0b90fae8]
    java.lang.Thread.State: WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for <0x134e2bb0> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
    at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1925)
    at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:358)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at sun.awt.shell.Win32ShellFolderManager2$ComInvoker$3.run(Win32ShellFolderManager2.java:458)
    at java.lang.Thread.run(Thread.java:619)

    "WaitCursor-Timer" prio=6 tid=0x06cb2000 nid=0x124c in Object.wait() [0x09aff000..0x09affb68]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.lang.Object.wait(Object.java:485)
    at java.util.TimerThread.mainLoop(Timer.java:483)
    - locked <0x134b8a58> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "Native Directory Watcher" prio=2 tid=0x06cb1400 nid=0xdf8 runnable [0x088ef000..0x088efbe8]
    java.lang.Thread.State: RUNNABLE
    at oracle.ide.natives.NativeHandler.enterWatcherThread(Native Method)
    at oracle.ide.natives.NativeHandler$2.run(NativeHandler.java:252)
    at java.lang.Thread.run(Thread.java:619)

    "BaseTreeExplorer.NodeOpeningExecutor" prio=6 tid=0x06cb1000 nid=0x13e4 waiting on condition [0x098ff000..0x098ffc68]
    java.lang.Thread.State: WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for <0x1321b690> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
    at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1925)
    at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:358)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at java.lang.Thread.run(Thread.java:619)

    "pool-2-thread-1" prio=6 tid=0x06cb0800 nid=0x1ed0 waiting on condition [0x097ff000..0x097ffce8]
    java.lang.Thread.State: WAITING (parking)
    at sun.misc.Unsafe.park(Native Method)
    - parking to wait for <0x13218fd8> (a java.util.concurrent.SynchronousQueue$TransferStack)
    at java.util.concurrent.locks.LockSupport.park(LockSupport.java:158)
    at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:422)
    at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:323)
    at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:857)
    at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:947)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
    at java.lang.Thread.run(Thread.java:619)

    "Scheduler" daemon prio=6 tid=0x06cb0400 nid=0x1fc8 in Object.wait() [0x095ef000..0x095efd68]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.lang.Object.wait(Object.java:485)
    at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)
    - locked <0x132189d8> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
    at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:444)

    "Thread-9" daemon prio=6 tid=0x06caf000 nid=0x1360 in Object.wait() [0x08def000..0x08def9e8]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x130612b8> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
    - locked <0x130612b8> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
    at org.tmatesoft.svn.core.javahl.SVNClientImplTracker.run(SVNClientImplTracker.java:65)
    at java.lang.Thread.run(Thread.java:619)

    "Thread-7" daemon prio=6 tid=0x06caf800 nid=0x1cd8 runnable [0x08eef000..0x08eefae8]
    java.lang.Thread.State: RUNNABLE
    at sun.print.Win32PrintServiceLookup.notifyPrinterChange(Native Method)
    at sun.print.Win32PrintServiceLookup.access$100(Win32PrintServiceLookup.java:32)
    at sun.print.Win32PrintServiceLookup$PrinterChangeListener.run(Win32PrintServiceLookup.java:302)

    "ChangeSetService" prio=2 tid=0x06cadc00 nid=0x214 in Object.wait() [0x08c0f000..0x08c0fbe8]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x1291aa28> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
    at java.lang.Object.wait(Object.java:485)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:178)
    - locked <0x1291aa28> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:199)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$200(ChangeSetService.java:56)
    at oracle.jdevimpl.vcs.changeset.ChangeSetService$2.run(ChangeSetService.java:138)
    at java.lang.Thread.run(Thread.java:619)

    "TimerQueue" daemon prio=6 tid=0x06caec00 nid=0xd40 in Object.wait() [0x087ef000..0x087efc68]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at javax.swing.TimerQueue.run(TimerQueue.java:236)
    - locked <0x12ea6780> (a javax.swing.TimerQueue)
    at java.lang.Thread.run(Thread.java:619)

    "TimedCache-Timer" daemon prio=6 tid=0x04cad000 nid=0x22e4 in Object.wait() [0x06aff000..0x06affa68]
    java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x12224ce8> (a java.util.TaskQueue)
    at java.util.TimerThread.mainLoop(Timer.java:509)
    - locked <0x12224ce8> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "JarIndex Timer" daemon prio=6 tid=0x04c94800 nid=0x11cc in Object.wait() [0x069ff000..0x069ffae8]
    java.lang.Thread.State: TIMED_WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.util.TimerThread.mainLoop(Timer.java:509)
    - locked <0x121a8418> (a java.util.TaskQueue)
    at java.util.TimerThread.run(Timer.java:462)

    "AWT-Windows" daemon prio=6 tid=0x04c74c00 nid=0x13dc runnable [0x0546f000..0x0546fc68]
    java.lang.Thread.State: RUNNABLE
    at sun.awt.windows.WToolkit.eventLoop(Native Method)
    at sun.awt.windows.WToolkit.run(WToolkit.java:291)
    at java.lang.Thread.run(Thread.java:619)

    "AWT-Shutdown" prio=6 tid=0x04c73c00 nid=0x265c in Object.wait() [0x0536f000..0x0536fce8]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    - waiting on <0x121a8620> (a java.lang.Object)
    at java.lang.Object.wait(Object.java:485)
    at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259)
    - locked <0x121a8620> (a java.lang.Object)
    at java.lang.Thread.run(Thread.java:619)

    "Java2D Disposer" daemon prio=10 tid=0x04c69400 nid=0x17dc in Object.wait() [0x0526f000..0x0526fd68]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
    - locked <0x121a86b0> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
    at sun.java2d.Disposer.run(Disposer.java:125)
    at java.lang.Thread.run(Thread.java:619)

    "Low Memory Detector" daemon prio=6 tid=0x01f00800 nid=0x1664 runnable [0x00000000..0x00000000]
    java.lang.Thread.State: RUNNABLE

    "CompilerThread0" daemon prio=10 tid=0x01efcc00 nid=0x15f4 waiting on condition [0x00000000..0x048af790]
    java.lang.Thread.State: RUNNABLE

    "Attach Listener" daemon prio=10 tid=0x01efbc00 nid=0x1af4 runnable [0x00000000..0x00000000]
    java.lang.Thread.State: RUNNABLE

    "Signal Dispatcher" daemon prio=10 tid=0x01ef3000 nid=0x1388 waiting on condition [0x00000000..0x00000000]
    java.lang.Thread.State: RUNNABLE

    "Finalizer" daemon prio=8 tid=0x01edc800 nid=0x118c in Object.wait() [0x045af000..0x045afc68]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
    - locked <0x12140298> (a java.lang.ref.ReferenceQueue$Lock)
    at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
    at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

    "Reference Handler" daemon prio=10 tid=0x01edb000 nid=0x2178 in Object.wait() [0x044af000..0x044afce8]
    java.lang.Thread.State: WAITING (on object monitor)
    at java.lang.Object.wait(Native Method)
    at java.lang.Object.wait(Object.java:485)
    at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)
    - locked <0x12140320> (a java.lang.ref.Reference$Lock)

    "main" prio=6 tid=0x01feb000 nid=0x24f8 waiting on condition [0x00000000..0x0012fab0]
    java.lang.Thread.State: RUNNABLE

    "VM Thread" prio=10 tid=0x01ed7c00 nid=0x2380 runnable

    "VM Periodic Task Thread" prio=10 tid=0x01f01800 nid=0x1464 waiting on condition

    JNI global references: 2757

    Heap
    def new generation total 45376K, used 4688K [0x0f010000, 0x12140000, 0x12140000)
    eden space 40384K, 11% used [0x0f010000, 0x0f4a4108, 0x11780000)
    from space 4992K, 0% used [0x11780000, 0x11780000, 0x11c60000)
    to space 4992K, 0% used [0x11c60000, 0x11c60000, 0x12140000)
    tenured generation total 604992K, used 336131K [0x12140000, 0x37010000, 0x37010000)
    the space 604992K, 55% used [0x12140000, 0x26980ed8, 0x26981000, 0x37010000)
    compacting perm gen total 57088K, used 56897K [0x37010000, 0x3a7d0000, 0x3f010000)
    the space 57088K, 99% used [0x37010000, 0x3a7a0568, 0x3a7a0600, 0x3a7d0000)
    No shared spaces configured.
  • 5. Re: 3.1EA1 File browser bug?
    Gary Graham Expert
    Currently Being Moderated
    Well, I'm not an expert at reading thread dumps, but there are no blocked threads and any waiting threads don't seem to be waiting on (fighting over) the same resources. However, even before the dump, we see a java.lang.OutOfMemoryError in IconOverlayTracker.

    Are you actively using the Subversion extension for version control? If not, I'm not sure why SVN stuff is showing up in that stack trace. Are you using File viewer to look at things in a Subversion workspace? Strange.

    Anyway, as a workaround, you might try increasing the JVM memory limit in your ...\sqldeveloper\ide\bin\ide.conf file from its default of 640M, perhaps to 1024M if you have plenty of real memory on your system:
    AddVMOption  -Xmx1024M
    Hope this helps, and maybe someone else can explain the stack trace better.

    -Gary
  • 6. Re: 3.1EA1 File browser bug?
    fmercury Newbie
    Currently Being Moderated
    I am using Subversion although I was not able to set up the repository connections yet. The folders I'm trying to get into are part of repositories. I'll try increasing the memory, but I'm surprised at how much memory SQL Developer is using as it is. Maybe that's just a function of it being in Java... don't know.
  • 7. Re: 3.1EA1 File browser bug?
    fmercury Newbie
    Currently Being Moderated
    I did increase the amount of memory SQL Developer can allocate, but after I drill down one folder, it uses it all and then I can't load the file. I'm certain at this point that there is some kind of a problem with the TortoiseSVN 1.7.1 install. I tried to uninstall and downgrade, as well as downgrade my SQL Developer, but that did not seem to work. Tortoise SVN 1.7.1 must have put some drivers or something on my machine that I now can't downgrade from.

    Anyways, I do find SQL Developer hitting 1 GB of memory just to access the files that are part of a SVN repository. Can you check what is going on in the SQL Developer code when it hits these folders? My workaround for now is to copy out the files and put them in a non-repository folder so that I can work with them in SQL Developer.
  • 8. Re: 3.1EA1 File browser bug?
    Gary Graham Expert
    Currently Being Moderated
    Very interesting. I recall trying some version of TortoiseSVN a couple of years ago, but I uninstalled it after I noticed Windows Explorer (WinXP SP3) performance degrade horribly after the install. Do you feel that file browsing/searching using Windows Explorer works as well with any version of TortoiseSVN installed as without? If the 1.7.1 version does indeed still impair Explorer, then I'm inclined to place all the blame on TortoiseSVN and not bother with further investigation of SQL Developer.

    Furthermore, searching for Tortoise on this forum, I see a complaint about 1.7 crashing SQL Developer and not being certified:
    SQL Developer and Tortoise SVN 1.7

    Apparently users have had success with 1.6. Is that what you downgraded to?

    -Gary
  • 9. Re: 3.1EA1 File browser bug?
    fmercury Newbie
    Currently Being Moderated
    Windows Explorer seems to work fine with 1.7.1, which has had a lot of bug fixes applied to it, I think. 1.6.x is what I tried to downgrade to, but things didn't quite work. I had just received a new machine (to complicate things further, I guess) so, I installed the latest versions of all the software. Downgrading all the software does not seem to work as I had the exact same issues with SQL Developer 3.0.x and TortoiseSVN 1.6.x, which I did not have on my old machine when it was running those versions (and not attempted to upgrade).

    Bottom line, I think it is certainly worth adding the new TortoiseSVN to your testing machines to see how that goes as it is the mainstream release of that software.
  • 10. Re: 3.1EA1 File browser bug?
    41138 Newbie
    Currently Being Moderated
    I have also observed this behavior and I think it is related to certain 'illegal' file names. If a folder starts with a % sign you will get the observed behavior and the SQL Developer file explorer will stall.
    For example, Microsoft OneNotes will create a folder named %HOMEDRIVE% where it caches shared notebooks. If I rename it to HOMEDRIVE I can open the folder with the SQL Developer File Browser. Perhaps there are additional usch illegal characters. In general, I find the file browsing on which all the SVN functionality is based very problematic (working with SQL Developer 3.1 release)
  • 11. Re: 3.1EA1 File browser bug?
    940345 Newbie
    Currently Being Moderated
    At our company we have the exact same problem as fmercury. When we try to use File browser of SQL Developer to browse versioned directories, it hangs with "loading..." message. We also get out of memory exception no matter how much memory we allocate to JVM.

    We are using:
    SQL Developer 3.1.07,
    Subversion 1.7.4,
    TortoiseSVN 1.7.6.

    Any idea when SQL Developer will be certified to work with Subversion 1.7?
  • 12. Re: 3.1EA1 File browser bug?
    Gary Graham Expert
    Currently Being Moderated
    Hi,

    The current SQL Developer infrastructure is based on JDeveloper 11.1.1.4. Scroll down to the Source Control System certifications at this link...
    http://www.oracle.com/technetwork/developer-tools/jdev/index-091111.html

    ...and you will see that no current JDeveloper release certifies SVN 1.7. If and when a future JDeveloper release certifies SVN 1.7, and if and when a future SQL Developer release gets re-based on it, then this issue may or may not go away.

    In fact, bugs have been logged against JDeveloper 11.1.1.4 and 11.1.1.5 for OutOfMemoryException in SVNURLInfoCacheSimpleStrategy.getURLInfo just as in the stack trace above. In all cases the bug behavior could not be reproduced after taking some action. There are various cases depending on the situation. Here is a sampling of comments from a closed JDeveloper bug:
    Problem appears to have been caused by the TorToiseSVN vers. 1.6.16,
    Subversion 1.6.17,  data upgrade to 11.1.1.4 Jdeveloper format. I created a
    new local SVN repository and did another SVN checkout. This time after the
    conversion to 11.1.1.4 data format, I was able to navigate in Jdev without
    the java.lang.OutOfMemoryError: Java heap space errors.
    and
    Deleted my local copy of <the Java> project and re-SVN checked out the whole thing
    again as <the other guy> did above.  This did NOT solve my issue.
    ....
    Removed TortoiseSVN 1.6.99.
    Downloaded and installed TortoiseSVN 1.1.16.
    Rebooted.
    Removed my local SVN directory of project files.
    Created a new local directory of project files.
    SVN Checkout into the new directory.
    
    Error seems to be resolved.
    
    It's not clear exactly what in SVN (or which versions, as <the other guy> is still
    running 1.6.99) is causing this, but it seems to be related to some
    version/corruption issue between jDev and SVN, and it renders jDev unusable.
    Regards,
    Gary
  • 13. Re: 3.1EA1 File browser bug?
    konstantin.gudjev Newbie
    Currently Being Moderated
    Hi Gary,

    1. I have done in SQL Developer TOOLS/Preferences .... and unchecked all boxes for Subversion/General.
    That solved the problem with Files Browsing, but not the issue of opening .sql files.

    2. I have increased memory for VM up to 2048. Same problem.

    3. I have done in SQL Developer Versioning then Configure ... and unchecked Versioning Support for Subverion 11.1.1.4.37.59.48.
    Thus, I removed SQL Developer integrated support for Subversion. It is working now and SQL Developer use only 300 K.

    I think, If you use TortoiseSVN you don't need such a support in SQL Developer.

    Konstantin
  • 14. Re: 3.1EA1 File browser bug?
    konstantin.gudjev Newbie
    Currently Being Moderated
    Hi Gary,

    1. I have done in SQL Developer TOOLS/Preferences .... and unchecked all boxes for Subversion/General.
    That solved the problem with Files Browsing, but not the issue of opening .sql files.

    2. I have increased memory for VM up to 2048. Same problem.

    3. I have done in SQL Developer Versioning then Configure ... and unchecked Versioning Support for Subverion 11.1.1.4.37.59.48.
    Thus, I removed SQL Developer integrated support for Subversion. It is working now and SQL Developer use only 300 K.

    I think, If you use TortoiseSVN you don't need such a support in SQL Developer.

    Konstantin
1 2 Previous Next

Legend

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