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.




Search timing out

web-app

Suddenly, for unknown reason searching issues started to report time out errors. I tried to increase time out value in connection string but no luck, it seems that it even does not take that value in account for this operation (like there's some other timeout value). Everything else works normal, sql server does not report any errors (at least not in event log) but search does not work any more, whatever string you enter in search field. Pasting the error report from web page, it's a bit large.

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1948826
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.getMetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +35
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +239
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +203
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +154

[ADOException: could not execute query
[ SELECT distinct this
.issueid as y0, this.revised as y1_ FROM geminiissuesview this left outer join geminiissuecomments comments1 on this.issueid=comments1.IssueID left outer join geminicustomfielddata customfiel2 on this.issueid=customfiel2.IssueID left outer join geminitimetracking timeentrie3 on this.issueid=timeentrie3.IssueID left outer join geminiaffectedversions affectedve6 on this.issueid=affectedve6.IssueID left outer join geminiissueresources resources4 on this.issueid=resources4.IssueID left outer join geminiissuecomponents components5 on this.issueid=components5.IssueID WHERE ((this.visibilitymembertype=2 and :VisibilityFilter.UserID in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = this.visibility)) or (this.visibilitymembertype=3 and :VisibilityFilter.UserID in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = this.visibility))) AND this.projectid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and not this.issuestatusid in (?) and (this.summary like ? or this.longdesc like ? or comments1.comment like ? or customfiel2.fielddata like ?) ORDER BY this.revised desc, this.issueid desc ]
Positional parameters: #0>6 #0>18 #0>21 #0>22 #0>3 #0>17 #0>12 #0>16 #0>9 #0>15 #0>7 #0>19 #0>5 #0>20 #0>4 #0>4 #0>%testing% #0>%testing% #0>%testing% #0>%testing%
[SQL: SELECT distinct this.issueid as y0, this.revised as y1 FROM geminiissuesview this left outer join geminiissuecomments comments1 on this.issueid=comments1.IssueID left outer join geminicustomfielddata customfiel2 on this.issueid=customfiel2.IssueID left outer join geminitimetracking timeentrie3 on this.issueid=timeentrie3.IssueID left outer join geminiaffectedversions affectedve6 on this.issueid=affectedve6.IssueID left outer join geminiissueresources resources4 on this.issueid=resources4.IssueID left outer join geminiissuecomponents components5 on this.issueid=components5.IssueID WHERE ((this.visibilitymembertype=2 and :VisibilityFilter.UserID in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = this.visibility)) or (this.visibilitymembertype=3 and :VisibilityFilter.UserID in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = this.visibility))) AND this.projectid in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and not this.issuestatusid in (?) and (this.summary like ? or this.longdesc like ? or comments1.comment like ? or customfiel2.fielddata like ?) ORDER BY this.revised desc, this.issueid desc]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +248
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +81
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +332
NHibernate.Impl.CriteriaImpl.List(IList results) +41
NHibernate.Impl.CriteriaImpl.List() +35
CounterSoft.Gemini.DataProvider.xc0186e148e957052.x6940d9d755137ae5(IssuesFilterEN x24b748b5be295dcb, Int32[] xbcd492679797b57e, UserEN xfd92dbe2fa4bcb5a, ArrayList x858fc38c4382ab28) +8784
CounterSoft.Gemini.Business.x95da312ae9372c2e.x6940d9d755137ae5(IssuesFilterEN x24b748b5be295dcb, ArrayList x41ed9424bcef4dac) +112
CounterSoft.Gemini.Business.x95da312ae9372c2e.xa91f976c95cc24f6(IssuesFilterEN x24b748b5be295dcb, Int32 x6085dd2d6dae9673, Int32 x870a8f396af517a1, Int32& x42a948eff01be1b6, Int32& x8c5725b36c3fef30, Int32& x93a2c901eb10cf80) +89
..etc
How can we repair this?

thanx,
Vladimir

LePiaf
· 1
LePiaf
Replies (3)
helpful
0
not helpful

Which version of Gemini and SQL?
This should not timeout and should run in less than a second.
Are you able to capture the query and run it via SQL (use SQL profiler)?
Does it only happens on keyword search?

Try setting the timeout to 0:
<property name="command_timeout">0</property>


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Adding that parameter in config solved the problem, it definitely does not respond in second, but I'll investigate further what could cause that kind of delay.
Gemini instance is 3.5.4 (b 2435) and SQL Server is 2005 Std with all service packs (running on different machine).

thanx for (as usual) very fast help :)
Vladimir


LePiaf
· 1
LePiaf
helpful
0
not helpful

You might need to check the growth settings of the database.
If  it is the defualt 10% then this might be the issue, try and re-index the tables.


Mark Wing
· 9108
Mark Wing