Squirrel SQL Client window non responsive, seems to hang
|
View:
New views
8 Messages
—
Rating Filter:
Alert me
|
 |
Squirrel SQL Client window non responsive, seems to hang
by squirrel-user
::
Rate this Message:
Using sql squirrel 3.0.2 client and ibm db2 8.2.5 jdbc driver on windows xp, sun jdk1.6.0_14.
Squirrel client seems to hang at times. Clicking on squirrel in task bar brings up only the outline of squirrel window, but not the contents. This happens only some times and there is no predictable sequence of repeating it. Ibm db2 jdbc drivers used are on C: drive. However squirrel configuration is stored on a shared drive. (How to change the default location for all squirrel configuration so that there is no network access by squirrel except to the database server) One more issue, not related to above is that squirrel auto update doesnt work when it is run behind a company firewall. 2009-08-11 14:55:23 Full thread dump Java HotSpot(TM) Client VM (14.0-b16 mixed mode): "SQLParserThread" prio=2 tid=0x04889800 nid=0xb0c in Object.wait() [0x0578f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) - locked <0x10145940> (a net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) "SQLParserThread" prio=2 tid=0x0486c800 nid=0xf10 in Object.wait() [0x0596f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) - locked <0x19350978> (a net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) "SQLParserThread" prio=2 tid=0x030d8c00 nid=0x2c0 in Object.wait() [0x058cf000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) - locked <0x176897e0> (a net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) "SQLParserThread" prio=2 tid=0x036ed400 nid=0xeb4 in Object.wait() [0x0587f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) - locked <0x154a85c8> (a net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) "SQLParserThread" prio=2 tid=0x036ac400 nid=0xd90 in Object.wait() [0x057df000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) - locked <0x14822be8> (a net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) "SQLParserThread" prio=2 tid=0x0366c000 nid=0xe50 in Object.wait() [0x0582f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) - locked <0x142543d8> (a net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) "Swing-Shell" daemon prio=6 tid=0x036e0400 nid=0xe6c waiting on condition [0x03eff000] java.lang.Thread.State: WAITING (parking) at sun.misc.Unsafe.park(Native Method) - parking to wait for <0x142544e8> (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) "Text-Layout" prio=2 tid=0x03649400 nid=0xa14 in Object.wait() [0x0531f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at org.netbeans.editor.view.spi.ViewLayoutQueue.waitForTask(ViewLayoutQueue.java:128) - locked <0x13f29658> (a org.netbeans.editor.view.spi.ViewLayoutQueue) at org.netbeans.editor.view.spi.ViewLayoutQueue$LayoutThread.run(ViewLayoutQueue.java:182) "SQLParserThread" prio=2 tid=0x0362e000 nid=0xa08 in Object.wait() [0x052cf000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) - locked <0x13f29670> (a net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) "Active Reference Queue Daemon" daemon prio=2 tid=0x03677400 nid=0x90c in Object.wait() [0x0527f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) - locked <0x13f29780> (a java.lang.ref.ReferenceQueue$Lock) at org.openide.util.Utilities$ActiveQueue.run(Utilities.java:2442) at java.lang.Thread.run(Thread.java:619) "Thread-8" daemon prio=2 tid=0x036a9000 nid=0x98c in Object.wait() [0x051df000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) - locked <0x13a75b20> (a net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) at java.lang.Thread.run(Thread.java:619) "Thread-7" daemon prio=2 tid=0x036a8000 nid=0x988 runnable [0x0518f000] java.lang.Thread.State: RUNNABLE at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at com.ibm.db2.jcc.a.ab.b(ab.java:193) at com.ibm.db2.jcc.a.ab.c(ab.java:237) at com.ibm.db2.jcc.a.ab.c(ab.java:348) at com.ibm.db2.jcc.a.ab.v(ab.java:1134) at com.ibm.db2.jcc.a.db.a(db.java:38) at com.ibm.db2.jcc.a.t.a(t.java:34) at com.ibm.db2.jcc.a.sb.f(sb.java:142) at com.ibm.db2.jcc.c.qh.m(qh.java:1187) at com.ibm.db2.jcc.c.qh.a(qh.java:1891) at com.ibm.db2.jcc.c.qh.e(qh.java:738) at com.ibm.db2.jcc.c.qh.execute(qh.java:722) - locked <0x13ea32f8> (a com.ibm.db2.jcc.a.b) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:366) at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:210) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:619) "Thread-6" daemon prio=2 tid=0x03661000 nid=0x97c in Object.wait() [0x0513f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) - locked <0x13a75b20> (a net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) at java.lang.Thread.run(Thread.java:619) "Thread-5" daemon prio=2 tid=0x04850c00 nid=0x984 in Object.wait() [0x050ef000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) - locked <0x13a75b20> (a net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) at java.lang.Thread.run(Thread.java:619) "Thread-4" daemon prio=2 tid=0x03223000 nid=0x970 in Object.wait() [0x0509f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) - locked <0x13a75b20> (a net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) at java.lang.Thread.run(Thread.java:619) "Thread-3" daemon prio=2 tid=0x03604400 nid=0x964 in Object.wait() [0x03eaf000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) - locked <0x13a75b20> (a net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) at java.lang.Thread.run(Thread.java:619) "DestroyJavaVM" prio=6 tid=0x003a8c00 nid=0xfac waiting on condition [0x00000000] java.lang.Thread.State: RUNNABLE "TimerQueue" daemon prio=6 tid=0x0377e400 nid=0x4ac in Object.wait() [0x0482f000] java.lang.Thread.State: TIMED_WAITING (on object monitor) at java.lang.Object.wait(Native Method) at javax.swing.TimerQueue.run(TimerQueue.java:236) - locked <0x13d09f80> (a javax.swing.TimerQueue) at java.lang.Thread.run(Thread.java:619) "AWT-EventQueue-1" prio=6 tid=0x0342d800 nid=0x224 waiting for monitor entry [0x0387e000] java.lang.Thread.State: BLOCKED (on object monitor) at com.ibm.db2.jcc.c.fb.getColumns(fb.java:6291) - waiting to lock <0x13ea32f8> (a com.ibm.db2.jcc.a.b) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1791) - locked <0x13ec8298> (a net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1855) - locked <0x13ec8298> (a net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1287) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1265) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:758) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SqlSyntaxHighlightTokenMatcher.isTable(SqlSyntaxHighlightTokenMatcher.java:41) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.matchTable(SQLSyntax.java:960) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.findMatchingTokenID(SQLSyntax.java:877) at net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.parseToken(SQLSyntax.java:342) at org.netbeans.editor.Syntax.nextToken(Syntax.java:173) at org.netbeans.editor.FixLineSyntaxState.fixSyntaxStateInfos(FixLineSyntaxState.java:380) at org.netbeans.editor.FixLineSyntaxState.update(FixLineSyntaxState.java:269) at org.netbeans.editor.BaseDocument.insertUpdate(BaseDocument.java:709) at org.netbeans.editor.BaseDocument.insertString(BaseDocument.java:596) at javax.swing.text.AbstractDocument.replace(AbstractDocument.java:655) at javax.swing.text.JTextComponent.replaceSelection(JTextComponent.java:1351) at javax.swing.JEditorPane.replaceSelection(JEditorPane.java:1208) at javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.handleReaderImport(BasicTextUI.java:2342) at javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.importData(BasicTextUI.java:2483) at javax.swing.TransferHandler.importData(TransferHandler.java:745) at javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.importData(BasicTextUI.java:2420) at javax.swing.TransferHandler$TransferAction.actionPerformed(TransferHandler.java:1655) at javax.swing.text.JTextComponent.invokeAction(JTextComponent.java:1485) at javax.swing.text.JTextComponent.paste(JTextComponent.java:1463) at org.netbeans.editor.BaseKit$PasteAction.actionPerformed(BaseKit.java:1326) at org.netbeans.editor.BaseAction.actionPerformed(BaseAction.java:182) at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636) at javax.swing.JComponent.processKeyBinding(JComponent.java:2851) at javax.swing.JComponent.processKeyBindings(JComponent.java:2886) at javax.swing.JComponent.processKeyEvent(JComponent.java:2814) at java.awt.Component.processEvent(Component.java:6040) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4630) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848) at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:704) at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:969) at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:841) at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:668) at java.awt.Component.dispatchEventImpl(Component.java:4502) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Window.dispatchEventImpl(Window.java:2475) at java.awt.Component.dispatchEvent(Component.java:4460) at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:195) 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) "AWT-Shutdown" prio=6 tid=0x03096800 nid=0x134 in Object.wait() [0x0338f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259) - locked <0x13a76fd8> (a java.lang.Object) at java.lang.Thread.run(Thread.java:619) "AWT-Windows" daemon prio=6 tid=0x02d7f400 nid=0xbc runnable [0x033df000] 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) "Java2D Disposer" daemon prio=10 tid=0x031fb800 nid=0xff4 in Object.wait() [0x0333f000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) - locked <0x13a7cb30> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134) at sun.java2d.Disposer.run(Disposer.java:125) at java.lang.Thread.run(Thread.java:619) "Low Memory Detector" daemon prio=6 tid=0x02d62400 nid=0xfec runnable [0x00000000] java.lang.Thread.State: RUNNABLE "CompilerThread0" daemon prio=10 tid=0x02d5cc00 nid=0xf18 waiting on condition [0x00000000] java.lang.Thread.State: RUNNABLE "Attach Listener" daemon prio=10 tid=0x02d5b000 nid=0xfe0 waiting on condition [0x00000000] java.lang.Thread.State: RUNNABLE "Signal Dispatcher" daemon prio=10 tid=0x02d59c00 nid=0xf4c runnable [0x00000000] java.lang.Thread.State: RUNNABLE "Finalizer" daemon prio=8 tid=0x02d4ac00 nid=0xf1c in Object.wait() [0x02ebf000] java.lang.Thread.State: WAITING (on object monitor) at java.lang.Object.wait(Native Method) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) - locked <0x13a40990> (a java.lang.ref.ReferenceQueue$Lock) at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159) "Reference Handler" daemon prio=10 tid=0x02d46400 nid=0xf84 in Object.wait() [0x02e6f000] 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 <0x13a408b8> (a java.lang.ref.Reference$Lock) "VM Thread" prio=10 tid=0x02d42400 nid=0xf24 runnable "VM Periodic Task Thread" prio=10 tid=0x02d6cc00 nid=0xfe8 waiting on condition JNI global references: 2228 |
|
|
Re: Squirrel SQL Client window non responsive, seems to hang
by KARR, DAVID (ATTCINW)
::
Rate this Message:
> -----Original Message-----
> From: squirrel-user [mailto:imsearchingfor2000-throwit@...] > Sent: Tuesday, August 11, 2009 12:01 PM > To: squirrel-sql-users@... > Subject: [Squirrel-sql-users] Squirrel SQL Client window non > responsive, seems to hang > > > [deleted] > > One more issue, not related to above is that squirrel auto update > doesnt > work when it is run behind a company firewall. Did you try setting the appropriate values in the "Proxy" tab of the "Global Preferences" dialog? ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Squirrel SQL Client window non responsive, seems to hang
by manningr
::
Rate this Message:
There are a few things that I know will produce hangs :
1. The user preferences folder (.squirrel-sql/) is located on a shared drive (you can move the folder to a local drive then update the squirrel-sql.bat file to specify this new location via --user-settings-dir <path to new location> 2. Lines in scripts that have many columns. SQL statements that are very long (> 1000 chars) can slow the editor. (You can easily format these lines by highlighting them and typing Ctrl-Alt-F). 3. Show row counts in the object tree when expanding the tables tree node to see tables with many rows, or expanding the views node to see views that are slow to query. Rob On Tue, Aug 11, 2009 at 3:00 PM, squirrel-user<imsearchingfor2000-throwit@...> wrote: > > Using sql squirrel 3.0.2 client and ibm db2 8.2.5 jdbc driver on windows xp, > sun jdk1.6.0_14. > > Squirrel client seems to hang at times. Clicking on squirrel in task bar > brings up only the outline of squirrel window, but not the contents. This > happens only some times and there is no predictable sequence of repeating > it. Ibm db2 jdbc drivers used are on C: drive. However squirrel > configuration is stored on a shared drive. (How to change the default > location for all squirrel configuration so that there is no network access > by squirrel except to the database server) > > One more issue, not related to above is that squirrel auto update doesnt > work when it is run behind a company firewall. > > 2009-08-11 14:55:23 > Full thread dump Java HotSpot(TM) Client VM (14.0-b16 mixed mode): > > "SQLParserThread" prio=2 tid=0x04889800 nid=0xb0c in Object.wait() > [0x0578f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x10145940> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x0486c800 nid=0xf10 in Object.wait() > [0x0596f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x19350978> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x030d8c00 nid=0x2c0 in Object.wait() > [0x058cf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x176897e0> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x036ed400 nid=0xeb4 in Object.wait() > [0x0587f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x154a85c8> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x036ac400 nid=0xd90 in Object.wait() > [0x057df000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x14822be8> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x0366c000 nid=0xe50 in Object.wait() > [0x0582f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x142543d8> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "Swing-Shell" daemon prio=6 tid=0x036e0400 nid=0xe6c waiting on condition > [0x03eff000] > java.lang.Thread.State: WAITING (parking) > at sun.misc.Unsafe.park(Native Method) > - parking to wait for <0x142544e8> (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) > > "Text-Layout" prio=2 tid=0x03649400 nid=0xa14 in Object.wait() [0x0531f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > org.netbeans.editor.view.spi.ViewLayoutQueue.waitForTask(ViewLayoutQueue.java:128) > - locked <0x13f29658> (a org.netbeans.editor.view.spi.ViewLayoutQueue) > at > org.netbeans.editor.view.spi.ViewLayoutQueue$LayoutThread.run(ViewLayoutQueue.java:182) > > "SQLParserThread" prio=2 tid=0x0362e000 nid=0xa08 in Object.wait() > [0x052cf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x13f29670> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "Active Reference Queue Daemon" daemon prio=2 tid=0x03677400 nid=0x90c in > Object.wait() [0x0527f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) > - locked <0x13f29780> (a java.lang.ref.ReferenceQueue$Lock) > at org.openide.util.Utilities$ActiveQueue.run(Utilities.java:2442) > at java.lang.Thread.run(Thread.java:619) > > "Thread-8" daemon prio=2 tid=0x036a9000 nid=0x98c in Object.wait() > [0x051df000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-7" daemon prio=2 tid=0x036a8000 nid=0x988 runnable [0x0518f000] > java.lang.Thread.State: RUNNABLE > at java.net.SocketInputStream.socketRead0(Native Method) > at java.net.SocketInputStream.read(SocketInputStream.java:129) > at com.ibm.db2.jcc.a.ab.b(ab.java:193) > at com.ibm.db2.jcc.a.ab.c(ab.java:237) > at com.ibm.db2.jcc.a.ab.c(ab.java:348) > at com.ibm.db2.jcc.a.ab.v(ab.java:1134) > at com.ibm.db2.jcc.a.db.a(db.java:38) > at com.ibm.db2.jcc.a.t.a(t.java:34) > at com.ibm.db2.jcc.a.sb.f(sb.java:142) > at com.ibm.db2.jcc.c.qh.m(qh.java:1187) > at com.ibm.db2.jcc.c.qh.a(qh.java:1891) > at com.ibm.db2.jcc.c.qh.e(qh.java:738) > at com.ibm.db2.jcc.c.qh.execute(qh.java:722) > - locked <0x13ea32f8> (a com.ibm.db2.jcc.a.b) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:366) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:210) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) > at java.lang.Thread.run(Thread.java:619) > > "Thread-6" daemon prio=2 tid=0x03661000 nid=0x97c in Object.wait() > [0x0513f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-5" daemon prio=2 tid=0x04850c00 nid=0x984 in Object.wait() > [0x050ef000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-4" daemon prio=2 tid=0x03223000 nid=0x970 in Object.wait() > [0x0509f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-3" daemon prio=2 tid=0x03604400 nid=0x964 in Object.wait() > [0x03eaf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "DestroyJavaVM" prio=6 tid=0x003a8c00 nid=0xfac waiting on condition > [0x00000000] > java.lang.Thread.State: RUNNABLE > > "TimerQueue" daemon prio=6 tid=0x0377e400 nid=0x4ac in Object.wait() > [0x0482f000] > java.lang.Thread.State: TIMED_WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at javax.swing.TimerQueue.run(TimerQueue.java:236) > - locked <0x13d09f80> (a javax.swing.TimerQueue) > at java.lang.Thread.run(Thread.java:619) > > "AWT-EventQueue-1" prio=6 tid=0x0342d800 nid=0x224 waiting for monitor entry > [0x0387e000] > java.lang.Thread.State: BLOCKED (on object monitor) > at com.ibm.db2.jcc.c.fb.getColumns(fb.java:6291) > - waiting to lock <0x13ea32f8> (a com.ibm.db2.jcc.a.b) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1791) > - locked <0x13ec8298> (a > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1855) > - locked <0x13ec8298> (a > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1287) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1265) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:758) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SqlSyntaxHighlightTokenMatcher.isTable(SqlSyntaxHighlightTokenMatcher.java:41) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.matchTable(SQLSyntax.java:960) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.findMatchingTokenID(SQLSyntax.java:877) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.parseToken(SQLSyntax.java:342) > at org.netbeans.editor.Syntax.nextToken(Syntax.java:173) > at > org.netbeans.editor.FixLineSyntaxState.fixSyntaxStateInfos(FixLineSyntaxState.java:380) > at > org.netbeans.editor.FixLineSyntaxState.update(FixLineSyntaxState.java:269) > at org.netbeans.editor.BaseDocument.insertUpdate(BaseDocument.java:709) > at org.netbeans.editor.BaseDocument.insertString(BaseDocument.java:596) > at javax.swing.text.AbstractDocument.replace(AbstractDocument.java:655) > at > javax.swing.text.JTextComponent.replaceSelection(JTextComponent.java:1351) > at javax.swing.JEditorPane.replaceSelection(JEditorPane.java:1208) > at > javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.handleReaderImport(BasicTextUI.java:2342) > at > javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.importData(BasicTextUI.java:2483) > at javax.swing.TransferHandler.importData(TransferHandler.java:745) > at > javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.importData(BasicTextUI.java:2420) > at > javax.swing.TransferHandler$TransferAction.actionPerformed(TransferHandler.java:1655) > at javax.swing.text.JTextComponent.invokeAction(JTextComponent.java:1485) > at javax.swing.text.JTextComponent.paste(JTextComponent.java:1463) > at > org.netbeans.editor.BaseKit$PasteAction.actionPerformed(BaseKit.java:1326) > at org.netbeans.editor.BaseAction.actionPerformed(BaseAction.java:182) > at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636) > at javax.swing.JComponent.processKeyBinding(JComponent.java:2851) > at javax.swing.JComponent.processKeyBindings(JComponent.java:2886) > at javax.swing.JComponent.processKeyEvent(JComponent.java:2814) > at java.awt.Component.processEvent(Component.java:6040) > at java.awt.Container.processEvent(Container.java:2041) > at java.awt.Component.dispatchEventImpl(Component.java:4630) > at java.awt.Container.dispatchEventImpl(Container.java:2099) > at java.awt.Component.dispatchEvent(Component.java:4460) > at > java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848) > at > java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:704) > at > java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:969) > at > java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:841) > at > java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:668) > at java.awt.Component.dispatchEventImpl(Component.java:4502) > at java.awt.Container.dispatchEventImpl(Container.java:2099) > at java.awt.Window.dispatchEventImpl(Window.java:2475) > at java.awt.Component.dispatchEvent(Component.java:4460) > at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) > at > net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:195) > 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) > > "AWT-Shutdown" prio=6 tid=0x03096800 nid=0x134 in Object.wait() [0x0338f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259) > - locked <0x13a76fd8> (a java.lang.Object) > at java.lang.Thread.run(Thread.java:619) > > "AWT-Windows" daemon prio=6 tid=0x02d7f400 nid=0xbc runnable [0x033df000] > 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) > > "Java2D Disposer" daemon prio=10 tid=0x031fb800 nid=0xff4 in Object.wait() > [0x0333f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) > - locked <0x13a7cb30> (a java.lang.ref.ReferenceQueue$Lock) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134) > at sun.java2d.Disposer.run(Disposer.java:125) > at java.lang.Thread.run(Thread.java:619) > > "Low Memory Detector" daemon prio=6 tid=0x02d62400 nid=0xfec runnable > [0x00000000] > java.lang.Thread.State: RUNNABLE > > "CompilerThread0" daemon prio=10 tid=0x02d5cc00 nid=0xf18 waiting on > condition [0x00000000] > java.lang.Thread.State: RUNNABLE > > "Attach Listener" daemon prio=10 tid=0x02d5b000 nid=0xfe0 waiting on > condition [0x00000000] > java.lang.Thread.State: RUNNABLE > > "Signal Dispatcher" daemon prio=10 tid=0x02d59c00 nid=0xf4c runnable > [0x00000000] > java.lang.Thread.State: RUNNABLE > > "Finalizer" daemon prio=8 tid=0x02d4ac00 nid=0xf1c in Object.wait() > [0x02ebf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) > - locked <0x13a40990> (a java.lang.ref.ReferenceQueue$Lock) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134) > at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159) > > "Reference Handler" daemon prio=10 tid=0x02d46400 nid=0xf84 in Object.wait() > [0x02e6f000] > 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 <0x13a408b8> (a java.lang.ref.Reference$Lock) > > "VM Thread" prio=10 tid=0x02d42400 nid=0xf24 runnable > > "VM Periodic Task Thread" prio=10 tid=0x02d6cc00 nid=0xfe8 waiting on > condition > > JNI global references: 2228 > > > -- > View this message in context: http://www.nabble.com/Squirrel-SQL-Client-window-non-responsive%2C-seems-to-hang-tp24923759p24923759.html > Sent from the squirrel-sql-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Squirrel-sql-users mailing list > Squirrel-sql-users@... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Squirrel SQL Client window non responsive, seems to hang
by manningr
::
Rate this Message:
One other thing I noticed in your thread dump - the driver seems to
synchronize access when running queries: > at com.ibm.db2.jcc.c.qh.execute(qh.java:722) > - locked <0x13ea32f8> (a com.ibm.db2.jcc.a.b) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:366) and getting metadata info : > "AWT-EventQueue-1" prio=6 tid=0x0342d800 nid=0x224 waiting for monitor entry > [0x0387e000] > java.lang.Thread.State: BLOCKED (on object monitor) > at com.ibm.db2.jcc.c.fb.getColumns(fb.java:6291) > - waiting to lock <0x13ea32f8> (a com.ibm.db2.jcc.a.b) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1791) > - locked <0x13ec8298> (a > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1855) > - locked <0x13ec8298> (a > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1287) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1265) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:758) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SqlSyntaxHighlightTokenMatcher.isTable(SqlSyntaxHighlightTokenMatcher.java:41) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.matchTable(SQLSyntax.java:960) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.findMatchingTokenID(SQLSyntax.java:877) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.parseToken(SQLSyntax.java:342) > at org.netbeans.editor.Syntax.nextToken(Syntax.java:173) > at > org.netbeans.editor.FixLineSyntaxState.fixSyntaxStateInfos(FixLineSyntaxState.java:380) > at > org.netbeans.editor.FixLineSyntaxState.update(FixLineSyntaxState.java:269) > at org.netbeans.editor.BaseDocument.insertUpdate(BaseDocument.java:709) > at org.netbeans.editor.BaseDocument.insertString(BaseDocument.java:596) > at javax.swing.text.AbstractDocument.replace(AbstractDocument.java:655) > at > javax.swing.text.JTextComponent.replaceSelection(JTextComponent.java:1351) > at javax.swing.JEditorPane.replaceSelection(JEditorPane.java:1208) > at My guess is that you were running a long query, and from the looks of the blocked thread, you pasted something into the editor. shortly after starting the query. Since the work for the editor is done in the event thread (the one that makes the UI reponsive), the UI froze when the event thread entered the driver code that couldn't get the lock while the long-running query was executing. Now, it's fair to say that the UI should never freeze, but it is also hard to predict under which conditions the driver vendor chooses to synchronize metadata lookups and queries. And without that metadata to properly highlight the SQL that was pasted, the editor's highlighting capabilities won't work. If this continues to be a problem, and the table structure doesn't change very often, it may help to turn on schema cacheing via Alias Properties (Right-click on the alias). Column information is cached when this is enabled. Rob On Tue, Aug 11, 2009 at 3:00 PM, squirrel-user<imsearchingfor2000-throwit@...> wrote: > > Using sql squirrel 3.0.2 client and ibm db2 8.2.5 jdbc driver on windows xp, > sun jdk1.6.0_14. > > Squirrel client seems to hang at times. Clicking on squirrel in task bar > brings up only the outline of squirrel window, but not the contents. This > happens only some times and there is no predictable sequence of repeating > it. Ibm db2 jdbc drivers used are on C: drive. However squirrel > configuration is stored on a shared drive. (How to change the default > location for all squirrel configuration so that there is no network access > by squirrel except to the database server) > > One more issue, not related to above is that squirrel auto update doesnt > work when it is run behind a company firewall. > > 2009-08-11 14:55:23 > Full thread dump Java HotSpot(TM) Client VM (14.0-b16 mixed mode): > > "SQLParserThread" prio=2 tid=0x04889800 nid=0xb0c in Object.wait() > [0x0578f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x10145940> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x0486c800 nid=0xf10 in Object.wait() > [0x0596f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x19350978> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x030d8c00 nid=0x2c0 in Object.wait() > [0x058cf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x176897e0> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x036ed400 nid=0xeb4 in Object.wait() > [0x0587f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x154a85c8> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x036ac400 nid=0xd90 in Object.wait() > [0x057df000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x14822be8> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "SQLParserThread" prio=2 tid=0x0366c000 nid=0xe50 in Object.wait() > [0x0582f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x142543d8> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "Swing-Shell" daemon prio=6 tid=0x036e0400 nid=0xe6c waiting on condition > [0x03eff000] > java.lang.Thread.State: WAITING (parking) > at sun.misc.Unsafe.park(Native Method) > - parking to wait for <0x142544e8> (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) > > "Text-Layout" prio=2 tid=0x03649400 nid=0xa14 in Object.wait() [0x0531f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > org.netbeans.editor.view.spi.ViewLayoutQueue.waitForTask(ViewLayoutQueue.java:128) > - locked <0x13f29658> (a org.netbeans.editor.view.spi.ViewLayoutQueue) > at > org.netbeans.editor.view.spi.ViewLayoutQueue$LayoutThread.run(ViewLayoutQueue.java:182) > > "SQLParserThread" prio=2 tid=0x0362e000 nid=0xa08 in Object.wait() > [0x052cf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread.run(ParserThread.java:334) > - locked <0x13f29670> (a > net.sourceforge.squirrel_sql.client.session.parser.kernel.ParserThread) > > "Active Reference Queue Daemon" daemon prio=2 tid=0x03677400 nid=0x90c in > Object.wait() [0x0527f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) > - locked <0x13f29780> (a java.lang.ref.ReferenceQueue$Lock) > at org.openide.util.Utilities$ActiveQueue.run(Utilities.java:2442) > at java.lang.Thread.run(Thread.java:619) > > "Thread-8" daemon prio=2 tid=0x036a9000 nid=0x98c in Object.wait() > [0x051df000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-7" daemon prio=2 tid=0x036a8000 nid=0x988 runnable [0x0518f000] > java.lang.Thread.State: RUNNABLE > at java.net.SocketInputStream.socketRead0(Native Method) > at java.net.SocketInputStream.read(SocketInputStream.java:129) > at com.ibm.db2.jcc.a.ab.b(ab.java:193) > at com.ibm.db2.jcc.a.ab.c(ab.java:237) > at com.ibm.db2.jcc.a.ab.c(ab.java:348) > at com.ibm.db2.jcc.a.ab.v(ab.java:1134) > at com.ibm.db2.jcc.a.db.a(db.java:38) > at com.ibm.db2.jcc.a.t.a(t.java:34) > at com.ibm.db2.jcc.a.sb.f(sb.java:142) > at com.ibm.db2.jcc.c.qh.m(qh.java:1187) > at com.ibm.db2.jcc.c.qh.a(qh.java:1891) > at com.ibm.db2.jcc.c.qh.e(qh.java:738) > at com.ibm.db2.jcc.c.qh.execute(qh.java:722) > - locked <0x13ea32f8> (a com.ibm.db2.jcc.a.b) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:366) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:210) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) > at java.lang.Thread.run(Thread.java:619) > > "Thread-6" daemon prio=2 tid=0x03661000 nid=0x97c in Object.wait() > [0x0513f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-5" daemon prio=2 tid=0x04850c00 nid=0x984 in Object.wait() > [0x050ef000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-4" daemon prio=2 tid=0x03223000 nid=0x970 in Object.wait() > [0x0509f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "Thread-3" daemon prio=2 tid=0x03604400 nid=0x964 in Object.wait() > [0x03eaf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:69) > - locked <0x13a75b20> (a > net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback) > at java.lang.Thread.run(Thread.java:619) > > "DestroyJavaVM" prio=6 tid=0x003a8c00 nid=0xfac waiting on condition > [0x00000000] > java.lang.Thread.State: RUNNABLE > > "TimerQueue" daemon prio=6 tid=0x0377e400 nid=0x4ac in Object.wait() > [0x0482f000] > java.lang.Thread.State: TIMED_WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at javax.swing.TimerQueue.run(TimerQueue.java:236) > - locked <0x13d09f80> (a javax.swing.TimerQueue) > at java.lang.Thread.run(Thread.java:619) > > "AWT-EventQueue-1" prio=6 tid=0x0342d800 nid=0x224 waiting for monitor entry > [0x0387e000] > java.lang.Thread.State: BLOCKED (on object monitor) > at com.ibm.db2.jcc.c.fb.getColumns(fb.java:6291) > - waiting to lock <0x13ea32f8> (a com.ibm.db2.jcc.a.b) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1791) > - locked <0x13ec8298> (a > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1855) > - locked <0x13ec8298> (a > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1287) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1265) > at > net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:758) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SqlSyntaxHighlightTokenMatcher.isTable(SqlSyntaxHighlightTokenMatcher.java:41) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.matchTable(SQLSyntax.java:960) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.findMatchingTokenID(SQLSyntax.java:877) > at > net.sourceforge.squirrel_sql.plugins.syntax.netbeans.SQLSyntax.parseToken(SQLSyntax.java:342) > at org.netbeans.editor.Syntax.nextToken(Syntax.java:173) > at > org.netbeans.editor.FixLineSyntaxState.fixSyntaxStateInfos(FixLineSyntaxState.java:380) > at > org.netbeans.editor.FixLineSyntaxState.update(FixLineSyntaxState.java:269) > at org.netbeans.editor.BaseDocument.insertUpdate(BaseDocument.java:709) > at org.netbeans.editor.BaseDocument.insertString(BaseDocument.java:596) > at javax.swing.text.AbstractDocument.replace(AbstractDocument.java:655) > at > javax.swing.text.JTextComponent.replaceSelection(JTextComponent.java:1351) > at javax.swing.JEditorPane.replaceSelection(JEditorPane.java:1208) > at > javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.handleReaderImport(BasicTextUI.java:2342) > at > javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.importData(BasicTextUI.java:2483) > at javax.swing.TransferHandler.importData(TransferHandler.java:745) > at > javax.swing.plaf.basic.BasicTextUI$TextTransferHandler.importData(BasicTextUI.java:2420) > at > javax.swing.TransferHandler$TransferAction.actionPerformed(TransferHandler.java:1655) > at javax.swing.text.JTextComponent.invokeAction(JTextComponent.java:1485) > at javax.swing.text.JTextComponent.paste(JTextComponent.java:1463) > at > org.netbeans.editor.BaseKit$PasteAction.actionPerformed(BaseKit.java:1326) > at org.netbeans.editor.BaseAction.actionPerformed(BaseAction.java:182) > at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636) > at javax.swing.JComponent.processKeyBinding(JComponent.java:2851) > at javax.swing.JComponent.processKeyBindings(JComponent.java:2886) > at javax.swing.JComponent.processKeyEvent(JComponent.java:2814) > at java.awt.Component.processEvent(Component.java:6040) > at java.awt.Container.processEvent(Container.java:2041) > at java.awt.Component.dispatchEventImpl(Component.java:4630) > at java.awt.Container.dispatchEventImpl(Container.java:2099) > at java.awt.Component.dispatchEvent(Component.java:4460) > at > java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848) > at > java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:704) > at > java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:969) > at > java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:841) > at > java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:668) > at java.awt.Component.dispatchEventImpl(Component.java:4502) > at java.awt.Container.dispatchEventImpl(Container.java:2099) > at java.awt.Window.dispatchEventImpl(Window.java:2475) > at java.awt.Component.dispatchEvent(Component.java:4460) > at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) > at > net.sourceforge.squirrel_sql.client.Application$1.dispatchEvent(Application.java:195) > 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) > > "AWT-Shutdown" prio=6 tid=0x03096800 nid=0x134 in Object.wait() [0x0338f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.Object.wait(Object.java:485) > at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:259) > - locked <0x13a76fd8> (a java.lang.Object) > at java.lang.Thread.run(Thread.java:619) > > "AWT-Windows" daemon prio=6 tid=0x02d7f400 nid=0xbc runnable [0x033df000] > 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) > > "Java2D Disposer" daemon prio=10 tid=0x031fb800 nid=0xff4 in Object.wait() > [0x0333f000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) > - locked <0x13a7cb30> (a java.lang.ref.ReferenceQueue$Lock) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134) > at sun.java2d.Disposer.run(Disposer.java:125) > at java.lang.Thread.run(Thread.java:619) > > "Low Memory Detector" daemon prio=6 tid=0x02d62400 nid=0xfec runnable > [0x00000000] > java.lang.Thread.State: RUNNABLE > > "CompilerThread0" daemon prio=10 tid=0x02d5cc00 nid=0xf18 waiting on > condition [0x00000000] > java.lang.Thread.State: RUNNABLE > > "Attach Listener" daemon prio=10 tid=0x02d5b000 nid=0xfe0 waiting on > condition [0x00000000] > java.lang.Thread.State: RUNNABLE > > "Signal Dispatcher" daemon prio=10 tid=0x02d59c00 nid=0xf4c runnable > [0x00000000] > java.lang.Thread.State: RUNNABLE > > "Finalizer" daemon prio=8 tid=0x02d4ac00 nid=0xf1c in Object.wait() > [0x02ebf000] > java.lang.Thread.State: WAITING (on object monitor) > at java.lang.Object.wait(Native Method) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:118) > - locked <0x13a40990> (a java.lang.ref.ReferenceQueue$Lock) > at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:134) > at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159) > > "Reference Handler" daemon prio=10 tid=0x02d46400 nid=0xf84 in Object.wait() > [0x02e6f000] > 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 <0x13a408b8> (a java.lang.ref.Reference$Lock) > > "VM Thread" prio=10 tid=0x02d42400 nid=0xf24 runnable > > "VM Periodic Task Thread" prio=10 tid=0x02d6cc00 nid=0xfe8 waiting on > condition > > JNI global references: 2228 > > > -- > View this message in context: http://www.nabble.com/Squirrel-SQL-Client-window-non-responsive%2C-seems-to-hang-tp24923759p24923759.html > Sent from the squirrel-sql-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Squirrel-sql-users mailing list > Squirrel-sql-users@... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Squirrel SQL Client window non responsive, seems to hang
by squirrel-user
::
Rate this Message:
Yes I did. I have been trying to update the squirrel since version 2.6.8. It never did successfully so far.
|
|
|
Re: Squirrel SQL Client window non responsive, seems to hang
by squirrel-user
::
Rate this Message:
Rob,
Many many thanks. I did realize that my preferences were on a network location. I did modify the squirrel-sql.bat to have "-Duser.home=c:\squirell-config" kind of setting. Now I realize that --user-settings-dir c:\\squirrel-config is better :) I also noticed that with the -D setting, new invocations of squirrel seem to be using that directory (based on file and folder timestamps inside) Thanks.
|
|
|
Re: Squirrel SQL Client window non responsive, seems to hang
by squirrel-user
::
Rate this Message:
I'll try schema caching. However I'll give a day or two to observe if moving settings to c drive improved/corrected the situation.
Thanks Rob.
|
|
|
Re: Squirrel SQL Client window non responsive, seems to hang
by squirrel-user
::
Rate this Message:
checking the stack trace always shows authentication failure. i made sure few times that my user name and password are correct. some how the app didnt seem to pass them along correctly to the proxy server?
|
| Free embeddable forum powered by Nabble | Forum Help |
