Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




issue search timeouts

web-app

the issue search errors out alot. is there anything that can be done to improve performace?

timeout errors

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 12/20/2007 9:16:33 AM SOURCE: .Net SqlClient Data Provider TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean) STACKTRACE: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.SetMetaData(SqlMetaDataSet metaData, Boolean moreInfo) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataRead   Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 12/20/2007 9:07:04 AM

SOURCE: .Net SqlClient Data Provider TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean) STACKTRACE: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.SetMetaData(SqlMetaDataSet metaData, Boolean moreInfo) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataRead

Thanks

bleenbleeng
· 1
bleenbleeng
Replies (9)
helpful
0
not helpful

Which version of Gemini are you running?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

version 2.2.6


bleenbleeng
· 1
bleenbleeng
helpful
0
not helpful

Is this an upgrade?

What filter are you running exactly?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

it is an upgrade from 2.0.5 and the filter is a keyword search. but since the key word can apear in any fields everything else is left alone . Thanks for the help

 


bleenbleeng
· 1
bleenbleeng
helpful
0
not helpful

I narrowed down the reason for the delay. I ran a profiler on the server and it shows Gemini doing a search on long description and comments field that slow it down.

I ran the dynamic sql without these fields and the search execute in 10 seconds compare to 127 with them in the query. Is there a way of removing the 2 fields from the dynamic sql

I have the trace file saved if anybody is interested.

 


bleenbleeng
· 1
bleenbleeng
helpful
0
not helpful

Sorry, but are you sure you are 2.2.6 and not 2.2.5 or earlier?

How many issues have you got in the database?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

no worries, I am 100% sure  it is  2.2.6  11/09/2007 files in the bin

 80000 issues which I know effects the timeouts.

I am just trying to optimize this great product.


bleenbleeng
· 1
bleenbleeng
helpful
0
not helpful

Ok, seems odd as we have spent quite a lot of time optimizing 2.2.6 for this.

Would you be able to send us a zipped backup of your database?

How long does it take to timeout?

In the mean time you can set the NHibernate timeout. Add the below to the NHibernate section of the web.config file:

<add key="hibernate.command_timeout" value="0"/>

 

Hope this sorts it out for you and thanks for the good feedback.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks for the help. I am currently researching our ability to send the db because of the info it contains.


bleenbleeng
· 1
bleenbleeng