Commit changes - timeout [3.4.4.36]

jsreynolds1 · June 14, 2013 4:58PM

Hello,

Latest revision has started being problematic on our larger databases, even ones where there are only a few items selected for SVN. Using TortoiseSVN to the same archive produces no issues.

System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError&#40;SqlException exception, Boolean breakConnection&#41;
   at System.Data.SqlClient.SqlInternalConnection.OnError&#40;SqlException exception, Boolean breakConnection&#41;
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning&#40;TdsParserStateObject stateObj&#41;
   at System.Data.SqlClient.TdsParser.Run&#40;RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj&#41;
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData&#40;&#41;
   at System.Data.SqlClient.SqlDataReader.get_MetaData&#40;&#41;
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader&#40;SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString&#41;
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds&#40;CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async&#41;
   at System.Data.SqlClient.SqlCommand.RunExecuteReader&#40;CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result&#41;
   at System.Data.SqlClient.SqlCommand.RunExecuteReader&#40;CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method&#41;
   at System.Data.SqlClient.SqlCommand.ExecuteReader&#40;CommandBehavior behavior, String method&#41;
   at System.Data.SqlClient.SqlCommand.ExecuteReader&#40;&#41;
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc&#40;IEnumerable`1 , SqlCommand &#41;
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc&#40;ICollection`1 , SqlDateTime &#41;
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb&#40;ICollection`1 , SqlDateTime &#41;
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries&#40;String databaseName&#41;
   at #mlhb.#wJ4c.#jiUc&#40;IBoundDatabase &#41;
   at #mlhb.#wJ4c.#u3.#jy2b&#40;&#41;
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling&#91;T&#93;&#40;Func`1 func&#41;
   at #mlhb.#wJ4c.#xFV&#40;IBoundDatabase &#41;
   at #mlhb.#ny2b.#aQU&#40;ICollection`1 #vfX, DatabaseObjectIdDictionary`1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc&#41;
   at #mlhb.#RLZc.#L8c&#40;SourceControlOperation #oTc, Boolean& #hD3c&#41;
   at #mlhb.#CJ4c.#dRi&#40;IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc&#41;
   at #GWeb.#VXM.#mYM&#91;#NrPb&#93;&#40;IBoundDatabase , Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action &#41;
   at #GWeb.#VXM.#jYM&#40;IBoundDatabase , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector &#41;
   at #GWeb.#4Ec.#7Jc&#40;ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector &#41;
   at #GWeb.#4Ec.#y2.#QB7b&#40;ICancellableOperationStatus &#41;
   at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f&#40;&#41;
   at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker&#40;String featureUsageKey, Action action&#41;
   at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke&#40;&#41;
   at #eEc.#Qlg.Invoke&#40;&#41;
   at #JLc.#PLc.#Jfb.#EJf&#40;&#41;
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do&#40;Action , Predicate`1 , Boolean &#41;
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll&#40;Action action&#41;
   at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll&#40;Action action&#41;
   at #JLc.#PLc.#CTc&#40;ICancellableOperation`1 , Object &#41;

jsreynolds1 · June 14, 2013 5:55PM

Allow me to post my own fix... :-)

I log into the sql server sometimes as a user, the other times as myself (windows auth) which has full server rights.

I'm able to commit using the more restricted user. No idea why, but now I know the fix.

Anu D · June 17, 2013 11:31AM

Thanks for your post.

We are glad that it is working for you now

fredendrix · July 18, 2013 9:28AM

I've got the same error, but unable to fix it...

Someone know where that problem comes from ?

fredendrix · July 18, 2013 10:37AM

Ok, here's a solution that worked for me :

http://www.red-gate.com/MessageBoard/vi ... hp?t=16404

richrjr · August 7, 2013 7:28PM

I added that line to xml but still no luck

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at #FhBc.#d0fd.ExecuteReader()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc(IEnumerable`1 , ISOCSqlCommand )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection`1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection`1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName)
at #mlhb.#wJ4c.#jiUc(IBoundDatabase )
at #mlhb.#wJ4c.#u3.#jy2b()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func`1 func)
at #mlhb.#wJ4c.#xFV(IBoundDatabase )
at #mlhb.#ny2b.#aQU(ICollection`1 #vfX, DatabaseObjectIdDictionary`1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
at #mlhb.#CJ4c.#dRi(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
at #GWeb.#VXM.#mYM[#NrPb](IBoundDatabase , Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
at #GWeb.#VXM.#jYM(IBoundDatabase , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke()
at #eEc.#Qlg.Invoke()
at #JLc.#PLc.#Jfb.#EJf()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean )
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 , Object )

dlbridgeman · August 12, 2013 2:57PM

I have also tried adding that line of xml, and I'm getting the same error.

I am on version 3.4.8.18. I see from the forum that several users were getting this error when they upgraded to 3.1.x, and were able to get commit again when they downgraded to 3.0.x. Do I need to downgrade 4 versions to get this to work again?

dlbridgeman · August 13, 2013 7:49AM

In my case, it turned out the solution was to restart the Vault server, then restart my own SSMS.

Commit changes - timeout [3.4.4.36]

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk