Search timing out
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.]..etc
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
How can we repair this?
thanx,
Vladimir
LePiaf
· 1 |
|
Friday, September 18, 2009, 11:15:07 AM |