app periodically stalls after executing sql for about a minute.... : DbVis Software

a

anonymous

started a topic over 10 years ago

[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

Roger Bjärevall

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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.

Roger Bjärevall

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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.

Roger Bjärevall

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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..

Roger Bjärevall

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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?

Roger Bjärevall

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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'

08:44 [DEBUG pool-3-thread-258 C.?] RootConnection: SybConnection.createStatement()
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.isValid] Executing connection validation statement: SELECT 1
08:44 [DEBUG pool-3-thread-258 B.?] RootConnection: SybStatement.executeQuery("SELECT 1")
08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement()
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.isValid] Executing connection validation statement: SELECT 1
08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("SELECT 1")
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()"
08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement()
08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()")
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 J.execute] Executing...
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'
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()"
08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement()
08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()")
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 J.setCurrentSchema] DbConnection='SYBAMR_ETMA_PRD_DS01' Catalog='null' Schema='dbo' NewSchema='dbo'
08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement()
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")
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()"
08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement()
08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()")
08:44 [DEBUG ExecutorRunner-pool-2-thread-153 AbstractFacade.getColumn] executing "select user_name()"
08:44 [DEBUG pool-3-thread-258 C.?] DefaultEditor123: SybConnection.createStatement()
08:44 [DEBUG pool-3-thread-258 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()")
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()"
09:45 [DEBUG pool-3-thread-259 C.?] DefaultEditor123: SybConnection.createStatement()
09:45 [DEBUG pool-3-thread-259 B.?] DefaultEditor123: SybStatement.executeQuery("select user_name()")

Hans Bergsten

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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 :)

Hans Bergsten

said about 10 years ago

[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

a

anonymous

said about 10 years ago

[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...

How can we help you today?

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

anonymous

Roger Bjärevall

anonymous

Roger Bjärevall

anonymous

Roger Bjärevall

anonymous

Roger Bjärevall

anonymous

Roger Bjärevall

anonymous

anonymous

Hans Bergsten

anonymous

Hans Bergsten

anonymous