|
From: Fritz, L. <Lar...@xy...> - 2020-08-04 15:34:56
|
Yes, the application shortcut is running the .sh file provided without any changes. Guessing I can just add the argument with the desired setting to the shortcut properties, as I don't see it set in the script itself nor can I find it in any of the properties files: -Xmx1024m Larry Fritz Application Engineer | Sensus<https://sensus.com/> | Xylem<http://www.xyleminc.com/> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://www.linkedin.com/company/sensus> | Twitter<https://twitter.com/SensusGlobal> | YouTube<https://www.youtube.com/c/SensusGlobal> | Facebook<https://www.facebook.com/SensusGlobal/> | Instagram<https://www.instagram.com/sensusglobal/> | 3D Tour<https://apps.kaonadn.net/5277329597136896/index.html> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] From: Ferreira, Matt [mailto:Mat...@fi...] Sent: Tuesday, August 4, 2020 10:15 To: Fritz, Larry <Lar...@xy...>; squ...@li... Subject: RE: EXTERNAL: [Squirrel-sql-users] Query fails to execute Are you using the included shell script? My initial thought is that you might need to increase the max memory settings. The default is set to 256: -Xmx256m Depending on how big your query file is, it might be bumping up against that (especially if you've run other stuff and haven't done manual GC) - if you have the memory try going to 512 or 1024 Matthew Ferreira Principal Technology Engineer / Team Lead [cid:image002.png@01D66A49.DCABC5D0] T: +1.978.275.5231 E: mat...@wo...<mailto:mat...@wo...> FIS | Advancing the way the world pays, banks and invests(tm) [cid:image003.png@01D66A49.DCABC5D0]<https://www.facebook.com/FIStoday>[cid:image004.png@01D66A49.DCABC5D0]<https://twitter.com/FISGlobal>[cid:image005.png@01D66A49.DCABC5D0]<https://www.linkedin.com/company/fis> From: Fritz, Larry <Lar...@xy...<mailto:Lar...@xy...>> Sent: Tuesday, August 4, 2020 10:34 AM To: squ...@li...<mailto:squ...@li...> Subject: EXTERNAL: [Squirrel-sql-users] Query fails to execute Using Squirrel-SQL 4.0.0 on Linux Mint 19.3 running inside VirtualBox. Executing a long SQL file containing multiple queries sometimes fails to execute, and I do mean sometimes. It will work one day and not a few days later. And breaking the file into smaller queries, when that is possible, works fine, so it isn't the queries themselves which are problematic. Errors like the following appear in the squirrel-sql.log file whenever the problem occurs, varying only in the numbers. The only "mouse event" involved is clicking the "run all SQLs in editor" button. 2020-08-03 16:02:37,711 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(401,124),absolute(401,123),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError 2020-08-03 16:03:38,117 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(402,121),absolute(402,120),button=1,modifiers=Button1,clickCount=1] on frame0 java.lang.StackOverflowError Each is followed by over 900 lines like " at java.base/java.util.regex.Pattern$<pattern>.match(Pattern.java:<digits>)", for example: at java.base/java.util.regex.Pattern$GroupTail.match(Pattern.java:4863) Using the keyboard shortcut, <shift><ctrl><Enter>, also results in an error: 2020-08-04 09:21:54,697 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.KeyEvent[KEY_PRESSED,keyCode=10,keyText=Enter,keyChar=Enter,modifiers=Alt+Shift,extModifiers=Alt+Shift,keyLocation=KEY_LOCATION_STANDARD,rawCode=36,primaryLevelUnicode=10,scancode=0,extendedKeyCode=0xa] on net.sourceforge.squirrel_sql.fw.gui.SQLCatalogsComboBox[,69,0,167x24,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=0.0,alignmentY=0.0,border=,flags=328,maximumSize=java.awt.Dimension[width=167,height=24],minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=FlexnetDB] java.lang.StackOverflowError I tried searching the lists and bug reports but could not find anything comparable to this problem. Larry Fritz Application Engineer | Sensus<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsensus.com%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939975608&sdata=3UM87W%2B2G2UGTPS0nyOZ1nx0xE7zRgc%2FvYw69jcXTt0%3D&reserved=0> | Xylem<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.xyleminc.com%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939975608&sdata=5%2BtvPxREbnurwd3%2BEAvIpvYFrgYXpKJNF7O%2BwkHMW3I%3D&reserved=0> M: 469-275-6042 Lar...@xy...<mailto:Lar...@xy...> LinkedIn<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fsensus&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939985610&sdata=6vT%2BG%2FHxJFwuSTW2jDwDy6OLxVzmA5%2BX1w3bKi0VdfI%3D&reserved=0> | Twitter<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSensusGlobal&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939995610&sdata=fR7GmrKIR0OWEcqs9uEiT3zhqgL4Ey8n5d%2FKgcnSH9E%3D&reserved=0> | YouTube<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fc%2FSensusGlobal&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504939995610&sdata=F8fUtgiSbYqHLzdgFGLzCf%2FhIWea4D1yFvv%2Ft2UdxG0%3D&reserved=0> | Facebook<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FSensusGlobal%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940005604&sdata=8k3z5VbIrIbdq8r78bJ4cJ%2F7flAjy%2Bkq7GnRy%2FNDwHY%3D&reserved=0> | Instagram<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fsensusglobal%2F&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940005604&sdata=kTaJ6QKLvJAyWwwoM9S7ERtGBUR3EZraZ2b7apLP%2BZM%3D&reserved=0> | 3D Tour<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapps.kaonadn.net%2F5277329597136896%2Findex.html&data=02%7C01%7Cmatt.ferreira%40fisglobal.com%7C73b510b79c094524961a08d8388833dc%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C1%7C637321504940015603&sdata=zFPNS1Cs6Umex3NMtcNPEIEsV24PBsVr%2FB0fC21nyR4%3D&reserved=0> [cid:9C3A8262-A5A5-4BEA-B280-5BCBD77D7A55] The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. |
