query hanging forever, I'm forced to kill the process

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

query hanging forever, I'm forced to kill the process

Federico Bruni-2
Hi all

I've launched a query that used to work in the past (I track my query
scripts in a git repository and I commit them only after testing them)
and now causes Squirrel to hang forever until I end the process using
kill.

How can I debug it?
I've looked in the log file but cannot see anything suspicious.

Thanks in advance for any pointer
Federico

PS I found this error in the log. No idea if it's related to the
hanging:


2017-06-30 13:20:05,246 [AWT-EventQueue-1] ERROR
net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData -
Unable to load LAF class
(com.jtattoo.plaf.mint.MintLookAndFeel):com.jtattoo.plaf.mint.MintLookAndFeel
java.lang.ClassNotFoundException: com.jtattoo.plaf.mint.MintLookAndFeel
 at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
 at
net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
 at java.lang.Class.forName0(Native Method)
 at java.lang.Class.forName(Class.java:348)
 at
net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.putClass(JTattooLafData.java:82)
 at
net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.initLafMap(JTattooLafData.java:62)
 at
net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.<init>(JTattooLafData.java:49)
 at
net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLookAndFeelController.<init>(JTattooLookAndFeelController.java:92)
 at
net.sourceforge.squirrel_sql.plugins.laf.LAFRegister.installLookAndFeelControllers(LAFRegister.java:461)
 at
net.sourceforge.squirrel_sql.plugins.laf.LAFRegister.<init>(LAFRegister.java:141)
 at
net.sourceforge.squirrel_sql.plugins.laf.LAFPlugin.load(LAFPlugin.java:211)
 at
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugin(PluginManager.java:649)
 at
net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:452)
 at
net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:726)
 at
net.sourceforge.squirrel_sql.client.Application.startup(Application.java:216)
 at net.sourceforge.squirrel_sql.client.Main$2.run(Main.java:118)
 at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
 at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
 at java.awt.EventQueue.access$500(EventQueue.java:97)
 at java.awt.EventQueue$3.run(EventQueue.java:709)
 at java.awt.EventQueue$3.run(EventQueue.java:703)
 at java.security.AccessController.doPrivileged(Native Method)
 at
java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
 at
net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
 at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
 at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
 at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
 at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: query hanging forever, I'm forced to kill the process

Federico Bruni-2
Well, it turns out that what causes the hanging is the "Run all SQLs in
editor" button.
The same SQL which fails using Alt+Shift+Enter works fine if I select
it and type Ctrl+Enter.

My query contains two statements:

SET SCHEMA MYSCHEMA;

SELECT SOMETHING FROM WHATEVER;

I tried reproducing the error using minimal examples, but everything
works fine.

I'll use Ctrl+Enter to avoid the problem.


Il giorno ven 30 giu 2017 alle 18:47, Cosmin Blaga
<[hidden email]> ha scritto:

> The error you posted indicates that something went wrong with the
> look and feel of Squirrel. I doubt it has anything to do with your
> pb, but try setting the default L&F and see if the error appears
> again.
>
> For the query you might try different things. Like refining the
> filter on it, trying to bring less columns in it. Eliminate parts of
> it until you see what causes the blockage. Divide et impera. You can
> also try an analysis on it to see what generates more load (if it's
> Oracle)
>
>
> On 30 Jun 2017 14:58, "Federico Bruni" <[hidden email]> wrote:
>> Hi all
>>
>> I've launched a query that used to work in the past (I track my
>> query scripts in a git repository and I commit them only after
>> testing them) and now causes Squirrel to hang forever until I end
>> the process using kill.
>>
>> How can I debug it?
>> I've looked in the log file but cannot see anything suspicious.
>>
>> Thanks in advance for any pointer
>> Federico
>>
>> PS I found this error in the log. No idea if it's related to the
>> hanging:
>>
>>
>> 2017-06-30 13:20:05,246 [AWT-EventQueue-1] ERROR
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData -
>> Unable to load LAF class
>> (com.jtattoo.plaf.mint.MintLookAndFeel):com.jtattoo.plaf.mint.MintLookAndFeel
>> java.lang.ClassNotFoundException:
>> com.jtattoo.plaf.mint.MintLookAndFeel
>> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>> at
>> net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>> at java.lang.Class.forName0(Native Method)
>> at java.lang.Class.forName(Class.java:348)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.putClass(JTattooLafData.java:82)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.initLafMap(JTattooLafData.java:62)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLafData.<init>(JTattooLafData.java:49)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.jtattoo.JTattooLookAndFeelController.<init>(JTattooLookAndFeelController.java:92)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.LAFRegister.installLookAndFeelControllers(LAFRegister.java:461)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.LAFRegister.<init>(LAFRegister.java:141)
>> at
>> net.sourceforge.squirrel_sql.plugins.laf.LAFPlugin.load(LAFPlugin.java:211)
>> at
>> net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugin(PluginManager.java:649)
>> at
>> net.sourceforge.squirrel_sql.client.plugin.PluginManager.loadPlugins(PluginManager.java:452)
>> at
>> net.sourceforge.squirrel_sql.client.Application.executeStartupTasks(Application.java:726)
>> at
>> net.sourceforge.squirrel_sql.client.Application.startup(Application.java:216)
>> at net.sourceforge.squirrel_sql.client.Main$2.run(Main.java:118)
>> at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
>> at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
>> at java.awt.EventQueue.access$500(EventQueue.java:97)
>> at java.awt.EventQueue$3.run(EventQueue.java:709)
>> at java.awt.EventQueue$3.run(EventQueue.java:703)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at
>> java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
>> at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
>> at
>> net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
>> at
>> java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
>> at
>> java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
>> at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
>> at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
>> at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
>> at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Squirrel-sql-users mailing list
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Loading...