Discussions specific to the VMware vSphere hypervisor
ccitrano
Influencer
Posts: 18
Liked: never
Joined: May 24, 2011 9:28 pm
Full Name: Chuck Citrano
Contact:

Re: SQL won't freeze after v6 upgrade

Post by ccitrano » Feb 09, 2012 3:44 pm

All,

Having the Virtual Center Database on a Virtual SQL Server was the issue for me. I moved the VC database to a physical server and the backup ran cleanly. This kind of makes sense when you think it through.

Chuck.

scoobymagic
Lurker
Posts: 1
Liked: never
Joined: Feb 15, 2012 2:14 pm
Contact:

Re: SQL won't freeze after v6 upgrade

Post by scoobymagic » Feb 15, 2012 2:23 pm

Hi,

Is their a patch or update for this, just wondering how its progressing?
cheers
A

Vitaliy S.
Product Manager
Posts: 22301
Liked: 1414 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Vitaliy S. » Feb 15, 2012 9:11 pm

As far as I correctly see it from the internal patch release notes, this issue should be fixed by patch 3.

foggy
Veeam Software
Posts: 17715
Liked: 1481 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL won't freeze after v6 upgrade

Post by foggy » Feb 16, 2012 9:29 am

And patch 3 is already available (see the sticky topic in the main forum).

Hotgun
Lurker
Posts: 1
Liked: never
Joined: Dec 27, 2011 4:02 pm
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Hotgun » Feb 16, 2012 12:55 pm

Applied Patch 3, even rebooted but still same error. :-(

foggy
Veeam Software
Posts: 17715
Liked: 1481 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL won't freeze after v6 upgrade

Post by foggy » Feb 16, 2012 1:57 pm

Have you got support team involved?

averylarry
Expert
Posts: 261
Liked: 28 times
Joined: Mar 22, 2011 7:43 pm
Full Name: Ted
Contact:

Re: SQL won't freeze after v6 upgrade

Post by averylarry » Feb 17, 2012 9:01 pm

Sorry Hotgun. The patch did work for me. (Happy dance!)

kurt
Enthusiast
Posts: 65
Liked: 2 times
Joined: Jul 07, 2010 9:03 pm
Full Name: Robert
Contact:

Re: SQL won't freeze after v6 upgrade

Post by kurt » Feb 23, 2012 2:46 pm

This issue started for me as well after upgrading to v6. I did install patch 3 and it's now showing version 6.0.0.181 64bit but it didn't help. I have veeam set up to retry after 30 minutes and the retry almost always works fine and is successful.

Details:
"Failed to prepare guest for hot backup. Error: VSSControl: Failed to prepare guest for freeze, wait timeout 900 sec Error: VSSControl: Failed to prepare guest for freeze, wait timeout 900 sec"

Gostev
SVP, Product Management
Posts: 24019
Liked: 3254 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev » Feb 23, 2012 4:25 pm

This only means that your issue has nothing to deal with what is discussed in this topic, and has to be investigated separately.

From your description, it sounds like this problem has nothing to deal with Veeam though. Looks like SQL is legitimately unable to freeze itself within 60 seconds, because of being too busy. VSS framework gives all apps a maximum of 60 sec to freeze, and then there is hard stop - to make sure other applications do not stay unavailable for extended period of time because of misbehaving ones. While retry helps probably because most of housekeeping items were already done by SQL during the 1st attempt.

kurt
Enthusiast
Posts: 65
Liked: 2 times
Joined: Jul 07, 2010 9:03 pm
Full Name: Robert
Contact:

Re: SQL won't freeze after v6 upgrade

Post by kurt » Feb 23, 2012 5:17 pm

Gostev wrote:This only means that your issue has nothing to deal with what is discussed in this topic, and has to be investigated separately.

From your description, it sounds like this problem has nothing to deal with Veeam though. Looks like SQL is legitimately unable to freeze itself within 60 seconds, because of being too busy. VSS framework gives all apps a maximum of 60 sec to freeze, and then there is hard stop - to make sure other applications do not stay unavailable for extended period of time because of misbehaving ones. While retry helps probably because most of housekeeping items were already done by SQL during the 1st attempt.
Thanks for the info. Sorry if I thought it was the same issue. I've been backing up my SQL server with veeam 5x for over a year without any issue. This just started after upgrading to v6 so that's why I thought the new version was causing the problem. Is there anything I can check or should I just open a support case?

Gostev
SVP, Product Management
Posts: 24019
Liked: 3254 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev » Feb 24, 2012 5:34 am

Well, may be workload on that SQL has changed (increased). Or some performance issues with infrastructure/storage appeared, making the freeze go slower. One thing we can be sure about: our in-guest VSS component logic has not been changing for a few versions now.

dasherrill
Novice
Posts: 8
Liked: never
Joined: Mar 29, 2010 4:26 pm
Contact:

Re: SQL won't freeze after v6 upgrade

Post by dasherrill » Feb 29, 2012 3:32 am

We are backing up 500+ VMs with veeam. 95% of our SQL server and Exchange servers fail regularly since our upgrade to Veeam 6...all of the issues are VSS related. We have installed each patch and are now on patch 3 with no greater success. We still have Veeam 5 backup servers in our environment. If we take the backup jobs back to Veeam 5 we have good success as we did before the upgrade. If we move the job back to Veeam 6 then we experience a high rate of failures. Veeam support states that we have a resource problem some where in our environment. I really don't see how that is possible when the backups work well under the old version but poorly under the new version. We really could use some help here.

Gostev
SVP, Product Management
Posts: 24019
Liked: 3254 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev » Feb 29, 2012 8:57 am

The only caveat of this theory is that our in-guest VSS coordination process (the one that orchestrates the application freeze) has not been changing for a few versions now...

hms7777
Lurker
Posts: 2
Liked: never
Joined: Jan 26, 2012 10:43 pm
Full Name: David Mulcair
Contact:

Re: SQL won't freeze after v6 upgrade

Post by hms7777 » Mar 02, 2012 5:13 pm

I'm also running into this issue.

We are a smaller shop, and the SQL server in question hosts the Veeam v6 DB, but not the vCenter db.

Anyone have any ideas?

Gostev
SVP, Product Management
Posts: 24019
Liked: 3254 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev » Mar 02, 2012 8:57 pm

Did you apply patch 3?

Post Reply

Who is online

Users browsing this forum: anpa and 28 guests