#1042 Application freezes on building output with any/all queries.

Unknown (89)

Using any snapshot version since approximately the 20120422_2001 version, I am no longer able to execute ANY DB2 query.

Every query I run (including very simple select queries from very small tables), results in the application freezing with the status text showing "Building output..." and the 'Cancel' button being grayed out.

Please see attached screenshot and let me know if you need any additional information.

OS is Windows 7 Enterprise 64-bit and Java version is 1.6.0_26-b03. I will try updating to the latest JRE; just realized I'm a bit behind.


  • Anonymous



  • Anonymous

    Sorry, my above comment re: Java version was incorrect.

    I am using the latest 32-bit JRE (version 1.7.0_05-b05, to be exact).

  • Your screenshot shows an error in your log files. Please, can you post the error message in your log file.


  • Anonymous

    Sure, here is the only error in the log file. I also get the same exact error with the 20120422_2001 snapshot version, which functions normally and allows me to run queries:

    2012-08-14 11:11:56,134 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.plugins.firebirdmanager.FirebirdManagerPlugin - FirebirdManagerPlugin: no jaybird driver (version 2 or later) found!

    Please copy the jaybird driver to squirrels lib directory
    to get all the firebirdmanager features.

    (see www.firebirdsql.org)
    java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at net.sourceforge.squirrel_sql.plugins.firebirdmanager.FirebirdManagerPlugin.isJaybird2DriverInstalled(FirebirdManagerPlugin.java:366)
    at net.sourceforge.squirrel_sql.plugins.firebirdmanager.FirebirdManagerPlugin.initialize(FirebirdManagerPlugin.java:163)
    at net.sourceforge.squirrel_sql.client.plugin.PluginManager.initializePlugins(PluginManager.java:576)
    at net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:763)
    at net.sourceforge.squirrel_sql.client.Application.startup(Application.java:222)
    at net.sourceforge.squirrel_sql.client.Main$2.run(Main.java:118)
    at java.awt.event.InvocationEvent.dispatch(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$000(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.awt.EventQueue$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)


  • Anonymous

    I went ahead and disabled some plugins which I do not use, including Firebird/FirebirdManager, and now there are no errors logged.

    However, the application still freezes and I'm unable to run any queries.

    Please see new screenshot here (sorry, I couldn't figure out how to attach it here):


    Thanks much for your help with this.

  • Well, the error in the log is not related to the freeze.
    If you say "freeze" - is it really a freeze, so that you can't use the help menu?

    It would be great, if you can provide a thread dump of the frozen application. This dump will help us to see, what the application is doing.

    There are 2 ways to get a thread dump:
    1) If you can still use the help menu, then you can do a thread dump by "Help - About - Threads" (Sorry, if this is not the 100 percent correct - but at the moment, I don't have access to a SQuirreL instance)
    2) Using JVisualVM- this is a monitoring tool for Java applications available with the JDK Version of Java. So, if you only have installed the JRE Version, this tool is not available. For a screenshot of JVisualVM(the thread dump button), please see http://docs.oracle.com/javase/6/docs/technotes/guides/visualvm/threads.html.

    If you can still use the Help menu of SQuirreL, I would suggest, that you use SQuirreL'S ability to take a thread dump, otherwise you should use JVisualVM. Please, let me know, if you need help to take the thread dump.


  • Anonymous

    To clarify the freeze part, the application window is completely non-responsive. I am unable to click any menus or anything else. I even does not respond to closing it via the red 'X' and I have to kill the process using task manager or similar in order to exit.

    Here is what the thread dump (via VisualVM) looks like:


    Here is what the timeline window looked like after the freeze, if it helps:


    Thanks again for looking into it and please let me know if you need anything else.

  • Thanks, the thread dump is very helpful.
    In my opinion, we should consider, why the thread "AWT-EventQueue-1" is sleeping and why SQLResultExecuterPanel is trying to close a ResultTab - even none is open.
    With this information, i tried to set "Maximum limit of SQL Result Tabs" to the value 1 - and yes, SQuirreL SQL will freeze during executing the first query.

    Please can you check you value for "Maximum limit of SQL Result Tabs" (New Session Properites >> SQL) and if it has the value 1, then change it to a higher value (I dont remember the default, my value was 15).



  • Anonymous

    Ahh, that is great, thanks!

    Indeed, my "Maximum limt (just realized it's a typo, by the way) of SQL Result Tabs" is set to 1 and has always been set to 1 because I only want one result tab.

    I've changed it to 2 and now there is no freeze and the query is executed correctly and returns results in the proper amount of time.

    For what it's worth, I don't notice a second result tab (maybe it's created and destroyed real quick? if it is, I definitely can't tell).

    So for now, as a workaround, I will leave the setting at 2 but if you (or somebody else) can fix the bug in the code (I'm pretty sure it was introduced in a snapshot at the end of April/beginning of May... very shortly after the 20120422 build, which does not have the issue).

    Thanks very much for your help once again!

    • assigned_to: manningr --> wis775
    • milestone: 540459 --> 3.4.0
  • powery

    I have the same issue. Set maximum limit to 2 is a temporary solution. Is there any patch for maximum limit set to 1?

  • Work is still in progress.

  • Gerd Wagner
    Gerd Wagner

    I agree with Johnathan: Was resolved by Bug #1060.

    Closed according to Johathan's review.

  • Gerd Wagner
    Gerd Wagner

    • status: open --> closed-fixed