Commit Changes Tab: Lock request time out period exceeded.

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Commit Changes Tab: Lock request time out period exceeded.

Postby sccuser » Fri Jan 25, 2013 4:37 pm

I get this error while trying to load/refresh the commit changes tab in SQL Source Control 3 (latest version: 3.1). Is there a way to increase the time out period?

Code: Select all
System.Data.SqlClient.SqlException: Lock request time out period exceeded.
   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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#qWEc()
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser..ctor(IDatabaseConnection serverConnection, IDatabasePollingSettings databasePollingSettings, Int32 matchCountLimit)
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser..ctor(IDatabaseConnection serverConnection, IDatabasePollingSettings databasePollingSettings)
   at DynamicInjector17754b3bcd5c41b8b82340f616d7df79(Object[] )
   at Ninject.Activation.Providers.StandardProvider.Create(IContext context)
   at Ninject.Activation.Context.Resolve()
   at Ninject.KernelBase.<>c__DisplayClasse.<Resolve>b__a(IBinding binding)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.<CastIterator>d__aa`1.MoveNext()
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at Ninject.ResolutionExtensions.Get[T](IResolutionRoot root, IParameter[] parameters)
   at RedGate.SQLSourceControl.Engine.ObjectFactoryShared.#sZe.#jii()
   at RedGate.SQLSourceControl.Engine.ObjectFactoryShared.#21e[#NrPb](Func`1 )
   at RedGate.SQLSourceControl.Engine.ObjectFactoryShared.Get[T](Arg[] ctorArgs)
   at RedGate.SQLSourceControl.Engine.Diff.ObjectFactory.Get[T](Arg[] args)
   at #mlhb.#ny2b.#jiUc()
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func`1 func)
   at #GWeb.#WXM.#P6Uc(Func`1 )
   at #mlhb.#ny2b.#xFV()
   at #mlhb.#ny2b.#aQU(ICollection`1 #vfX, DatabaseObjectIdDictionary`1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
   at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
   at #mlhb.#ry2b.#zYM(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
   at #GWeb.#VXM.#mYM[#NrPb](Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
   at #GWeb.#VXM.#jYM(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 )
sccuser
 
Posts: 1
Joined: Fri Jan 25, 2013 4:34 pm

Postby eddie davis » Mon Jan 28, 2013 4:37 pm

Hi sccuser,

Thank you for your forum post.

To resolve this problem you could try reducing the polling time of SQL Source Control. You can do this by editing the RedGate_SQLSourceControl_Engine_EngineOptions.xml file in C:\\Users\\<username>\\Appdata\\Local\\Red Gate\\SQL Source Control 3.

Set the trace interval time as follows:

<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>

(you may need to add that line if it's not already there).

Once done, ensure you restart SSMS; also, you will need to perform this change on each PC / for each user.

I hope this helps.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Code in the xml file disappears

Postby jvcampbell » Wed May 15, 2013 2:07 pm

Hi

I tried the suggestion by adding the trace interval line, but when I restart SSMS the line is automatically removed.

How do I get around this?
jvcampbell
 
Posts: 1
Joined: Wed May 15, 2013 12:55 pm
Location: Johannesburg

Postby fredendrix » Thu Jul 18, 2013 2:32 pm

Same problem here. That post describe the same issue, but no more answer... :(

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

Anyone could help please ? :)
fredendrix
 
Posts: 24
Joined: Tue Dec 18, 2012 3:40 pm
Location: Quebec (Canada)

Postby fredendrix » Thu Jul 18, 2013 3:10 pm

Ok, that worked for me :

<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>

Thanks!
fredendrix
 
Posts: 24
Joined: Tue Dec 18, 2012 3:40 pm
Location: Quebec (Canada)


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests