Red Gate forums :: View topic - Timeout when using the Commit Changes Tab
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Timeout when using the Commit Changes Tab

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Lewiethegreat



Joined: 15 Jan 2014
Posts: 2

PostPosted: Wed Jan 15, 2014 6:41 am    Post subject: Timeout when using the Commit Changes Tab Reply with quote

Crying or Very sad 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.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Fri Jan 17, 2014 11:35 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Lewiethegreat



Joined: 15 Jan 2014
Posts: 2

PostPosted: Sun Jan 19, 2014 10:41 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Jan 20, 2014 12:54 pm    Post subject: Reply with quote

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#
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group