Timeout when using the Commit Changes Tab

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

Timeout when using the Commit Changes Tab

Postby Lewiethegreat » Wed Jan 15, 2014 6:41 am

:cry: When ever I try to commit my work I get Timeouts on the Commit Changes tab. I never even get to see what to commit and the error appears before this occurs. I am able to use SQL Compare 10 without any timeout issues.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Lock request time out period exceeded.
Lewiethegreat
 
Posts: 2
Joined: Wed Jan 15, 2014 6:32 am

Postby james.billings » Fri Jan 17, 2014 11:35 am

Hi,
Sorry to hear you're running into this. If it's suddenly started happening then it's possible that one user has a stuck lock on our change-tracking table. The quickest way to fix that is to usually get everyone to restart SSMS, although in some rare cases it seems to require the SQL instance to be restarted instead.

If you've actually been experiencing the problem more and more frequently over time, it may indicate a different issue happening though, so let us know if that's the case.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby Lewiethegreat » Sun Jan 19, 2014 10:41 pm

To resolve it I I did a sp_who2 and determined which locks where occuring. I then killed the locks and the problem has gone away. The locks where on tempdb.
Lewiethegreat
 
Posts: 2
Joined: Wed Jan 15, 2014 6:32 am

Postby james.billings » Mon Jan 20, 2014 12:54 pm

Yep, that'll do it too.
To stop it using tempdb, you can force it to use a database you create specifically for the purpose: http://documentation.red-gate.com/display/SOC3/Logging+changes+to+shared+databases#
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 2 guests