Red Gate forums :: View topic - SQL compare stops to compare on 42% (reading dependencies)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL compare stops to compare on 42% (reading dependencies)

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Bertoz



Joined: 21 Mar 2012
Posts: 3
Location: Tenerife

PostPosted: Wed Mar 21, 2012 12:59 pm    Post subject: SQL compare stops to compare on 42% (reading dependencies) Reply with quote

Hi guys...
I do the normal daily comparing but today SQL Compare stops the comparing at the 42%, when it's reading dependencies... and I can't do anything anymore, just kill the process.
Any idea ?

Thank you in advance.

Nick[/img]
_________________
Imagination is more important than knowledge
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Fri Mar 23, 2012 5:17 pm    Post subject: Reply with quote

Hi Nick,

Typically, programs do not just stop working. When Windows shows a "not responding" message, it usually just means there is a long-running function and usually you can just "wait it out". Unfortunately I do not know of an option that will speed this up.

If it never responds after an unreasonable amount of time (depending on the size of the database) , then we can try debugging it to make sure the worker thread reading dependencies has not been aborted for some reason.
Back to top
View user's profile Send private message
Bertoz



Joined: 21 Mar 2012
Posts: 3
Location: Tenerife

PostPosted: Fri Mar 23, 2012 5:45 pm    Post subject: Re: Reply with quote

Hi Brian.
I let the program run for more than 1 hour, and usually the comparing takes less than 10 seconds... I don't know if this amount of time is reasonable, I don't think so.

Anyway the program is working now.
I have no idea what happened that day.
Checking the log, I realized that the night before there was a problem with the process of stats updating of sql server.
I suppose this is in some way related, because the day after, with the stats updating successful, the program restarted to work regularly.
I'd like to understand what happened in order to avoid this problem in the future.
Thank you for your answer.

Nick
_________________
Imagination is more important than knowledge
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Fri Mar 23, 2012 6:40 pm    Post subject: Reply with quote

I guess SQL Server just had a lock on the information schema. Sounds like a possibility from what you've said...
Back to top
View user's profile Send private message
xerxxees



Joined: 17 Apr 2012
Posts: 1

PostPosted: Tue Apr 17, 2012 4:33 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
I guess SQL Server just had a lock on the information schema. Sounds like a possibility from what you've said...


I have a similar issue. When I run SQL Profiler at the same time I see the following command repeating over and over:
SELECT revisions.value AS Revision, scripts.value AS ScriptsLocation, migrations.value AS MigrationScriptsLocation
FROM [cmbs].sys.extended_properties AS revisions
JOIN [cmbs].sys.extended_properties AS migrations
ON migrations.minor_id = revisions.major_id
JOIN [cmbs].sys.extended_properties AS scripts
ON revisions.minor_id = scripts.minor_id
WHERE revisions.name = 'SQLSourceControl Database Revision'
AND migrations.name = 'SQLSourceControl Migration Scripts Location'
AND scripts.name = 'SQLSourceControl Scripts Location';

We have a fair amount of databases of various sizes over the years and they've all run great. A possible difference is that this database is larger then the others and I recently upgraded to SQL Compare 10.

Any ideas why that command would repeat over and over?
Back to top
View user's profile Send private message
Bertoz



Joined: 21 Mar 2012
Posts: 3
Location: Tenerife

PostPosted: Tue Apr 17, 2012 4:42 pm    Post subject: Re: Reply with quote

xerxxees wrote:


Any ideas why that command would repeat over and over?


I don't know why but now I know how... When SQL Compare goes in loop I detach the DB and then I attach it again. Luckily I got problems only with the Test DB...
_________________
Imagination is more important than knowledge
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Tue Apr 17, 2012 5:11 pm    Post subject: Reply with quote

This is a different issue. The stuff the SQL Compare team added for migrations includes a few extended properties in the database. Once SQL Compare determines that database has been processed by SQL Source Control, it continually polls the database.

This doesn't have anything to do with the program locking up during a comparison (I don't think).
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