How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

app periodically stalls after executing sql for about a minute....

[This topic is migrated from our old forums. The original author name has been removed]

Hi.. I think i only noticed it with 9.1.5 version... Periodically, after clicking on execute, the app would become unresponsive for about 40sec-1min before actually returning to sanity.. Any idea what could be going on here?: you can see a 40 sec wait below... 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 AbstractFacade.getColumn] executing "select user_name()" 14:04:11 [DEBUG pool-3-thread-4 C.?] DefaultEditor22: SybConnection.createStatement() 14:04:11 [DEBUG pool-3-thread-4 B.?] DefaultEditor22: SybStatement.executeQuery("select user_name()") 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='cemr_CurBudgetStatsEOD' 14:04:11 [DEBUG pool-3-thread-4 E.?] RootConnection: SybDatabaseMetaData.getPrimaryKeys("tss_ds_dev2", "dbo", "cemr_CurBudgetStatsEOD") 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 AbstractFacade.getColumn] executing "select user_name()" 14:04:11 [DEBUG pool-3-thread-4 C.?] DefaultEditor22: SybConnection.createStatement() 14:04:11 [DEBUG pool-3-thread-4 B.?] DefaultEditor22: SybStatement.executeQuery("select user_name()") 14:04:11 [DEBUG ExecutorRunner-pool-2-thread-3 N.?] DbConnection='SYBAMR_ETMA_DEV_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='cemr_CurBudgetStatsEOD' Column='%' *14:04:11* [DEBUG pool-3-thread-4 E.?] DefaultEditor22: SybDatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "cemr_CurBudgetStatsEOD", "%") *14:04:50* [DEBUG ExecutorRunner-pool-2-thread-3 AbstractFacade.getColumn] executing "select user_name()" 14:04:50 [DEBUG pool-3-thread-4 C.?] DefaultEditor22: SybConnection.createStatement() 14:04:50 [DEBUG pool-3-thread-4 B.?] DefaultEditor22: SybStatement.executeQuery("select user_name()") Product: DbVisualizer Pro 9.1.5 Build: #2105 (2013/12/16 09:38) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_65 Java Vendor: Sun Microsystems Inc. OS Name: Windows 7 OS Arch: x86 OS Version: 6.1 Edited by: AlexML on Jan 17, 2014 2:14 PM
46 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, What is the effect if you in Tool Properties and in the SQL Commander / Result Sets category, check "Make Result Sets Read-Only" and then re-run the query? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Roger I turned on the +Make Result Sets Read-Only,+ ran a few queries, some at the same time -- no issues found.
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi, Just so I get it, with "no issues found" you mean it runs faster with read-only result sets? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Sorry, i meant runs with no noticable difference.
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, I assume the Schema drop-down in the SQL Commander is empty while you are executing the query? If that is the case what happen if you set it to the appropriate schema and re-run the query? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Roger The schema was set to dbo, i believe..
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Alex, Would be super if you can give it a try having the schema drop-down set along with the debug mode enabled. Please post the output. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
What should the schema mode be set to?
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Alex, The schema should be set to match the schema in which the tables in the query reside. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
98% of the time i login as dbo.. so the schema is set to dbo .. is that ok ? and my debug log is always enabled
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Just happened again. -- 1 min hang.. Schema set to 'dbo' 6:08:44 [DEBUG pool-3-thread-258 C.?] RootConnection: SybConnection.createStatement() 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 16:08:44 [DEBUG pool-3-thread-258 B.?] RootConnection: SybStatement.executeQuery("SELECT 1") 16:08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement() 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 16:08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("SELECT 1") 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()" 16:08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement() 16:08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()") 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 J.execute] Executing... 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 J.setCurrentCatalog] DbConnection='SYBAMR_ETMA_PRD_DS01' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()" 16:08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement() 16:08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()") 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_PRD_DS01' Catalog='null' Schema='dbo' NewSchema='dbo' 16:08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement() 16:08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.execute("select * from nasd_apps_BgPx order by is_valid desc, isnull(upd_date, cre_date) desc") 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()" 16:08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement() 16:08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()") 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()" 16:08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement() 16:08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()") 16:08:44 [DEBUG ExecutorRunner-pool-2-thread-153 N.?] DbConnection='SYBAMR_ETMA_PRD_DS01' Catalog='tss_ds_dev2' Schema='dbo' Table='nasd_apps_BgPx' Column='%' *16:08:44* [DEBUG pool-3-thread-258 E.?] DefaultEditor123: SybDatabaseMetaData.getColumns("tss_ds_dev2", "dbo", "nasd_apps_BgPx", "%") *{color:#ff0000}16:09:45{color}* [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()" 16:09:45 [DEBUG pool-3-thread-259 C.?] DefaultEditor123: SybConnection.createStatement() 16:09:45 [DEBUG pool-3-thread-259 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()")
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, This is a mystery. Do you have your DbVisualizer settings (preference directory) on a remote host? Is the connection to the database over a network that may be slow or unstable? Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Hans This is my .vmoptions file: (my C drive is a solid state drive) +-Xmx1200m+ +-Ddbvis.prefsdir=C:\DEV_APPS_SETTINGS\dbvis+ +-XX:MaxPermSize=192m+ +-Dsun.locale.formatasdefault=true+ Product: DbVisualizer Pro 9.1.6 Build: #2117 (2014/01/26 21:20) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_65 Java Vendor: Sun Microsystems Inc. OS Name: Windows 7 OS Arch: x86 OS Version: 6.1 May be its worth adding more debug lines around those functions that seem to sporadically cause this? Its not really a big issue, just annoying :)
[This reply is migrated from our old forums.]

Re: app periodically stalls after executing sql for about a minute....
Hi Alex, Thanks, so your "prefsdir" location should not be an issue but you didn't answer my question about the database and the network you connect to it over. Good to know it's not a major problem for you. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: app periodically stalls after executing sql for about a minute....
Sorry, I overlooked that. No, network slowness and db performance is not obesrved at all. All other apps are functioning normally...
Comments to this discussion are now closed!
More topics in Support
See all 1318 topics