Host-based backup of VMware vSphere VMs.
aweiss
Enthusiast
Posts: 33
Liked: never
Joined: Jul 26, 2011 6:22 am
Full Name: Alexandre Weiss
Contact:

Re: SQL won't freeze after v6 upgrade

Post by aweiss »

I confirm it was playing well in v5 !
robertson
Novice
Posts: 5
Liked: never
Joined: Dec 01, 2010 10:30 pm
Full Name: Paul Clarke
Contact:

Re: SQL won't freeze after v6 upgrade

Post by robertson »

I also have a replication job for a server running SQL Server 2008 hosting vcenter and remote veeam database that prior to upgrading the job to V6 the replication would complete ignoring the warning of " Unable to release guest. Details: VSSControl: Failed to freeze guest, wait timeout"
With the V6 job I recieve the same message but the job fails. I have the same situation as wberryment above anyone got any reccomendation on how I should proceed?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL won't freeze after v6 upgrade

Post by foggy »

Just as Anton stated above, this issue was already investigated by our R&D team and will be addressed in a timely manner. Anyway, please open a support case for it. Thanks.
aweiss
Enthusiast
Posts: 33
Liked: never
Joined: Jul 26, 2011 6:22 am
Full Name: Alexandre Weiss
Contact:

Re: SQL won't freeze after v6 upgrade

Post by aweiss »

Hi Guys,
My customer is still running the old veeam server just to run the Veeam DB. Any idea for the release date of the fix. My case # is 5159575
Thks
Alex
Gostev
Chief Product Officer
Posts: 31457
Liked: 6647 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

Hi Alexandre, this would take at least a few weeks minimum. Thanks.
ssinyol
Lurker
Posts: 2
Liked: never
Joined: Jan 26, 2011 7:12 pm
Full Name: Sergi Sinyol
Contact:

Re: SQL won't freeze after v6 upgrade

Post by ssinyol »

Hi,

We have the same problem.

Veeam in a VM, SQL in another VM. Backups were working with v5, we upgraded to v6, and VSS starts to fail in SQL server every time.

It must be something different in v6, because we didn't have any other change.

Thank you,
rct
Enthusiast
Posts: 35
Liked: 1 time
Joined: Sep 29, 2011 6:07 pm
Contact:

Re: SQL won't freeze after v6 upgrade

Post by rct »

Hi,

Veeam and SQL Server Express in a VM.
Working with v5 and with v6 it fails with the same message.

Waiting for this fix :)
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 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. »

Make sure you open a support case to be notified about hotfix availability.
ssinyol
Lurker
Posts: 2
Liked: never
Joined: Jan 26, 2011 7:12 pm
Full Name: Sergi Sinyol
Contact:

Re: SQL won't freeze after v6 upgrade

Post by ssinyol »

I've opened the case 5165361, but I can't get the patch 2.

Can you pass me the link?

Thank you

Sergi
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 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. »

B&R 6.0 Patch 2 is available through our technical support, but this hotfix doesn't address the issue discussed in this thread.
stepfes
Lurker
Posts: 1
Liked: never
Joined: Jan 10, 2012 7:44 am
Full Name: Stefan Blumhagel
Contact:

Re: SQL won't freeze after v6 upgrade

Post by stepfes »

Same here! Since v6 no backup of SQL hosting Veeam DB.

Case: 5165681
notermanjeroen
Lurker
Posts: 1
Liked: never
Joined: Dec 16, 2011 7:45 pm
Full Name: Jeroen Noterman
Contact:

Re: SQL won't freeze after v6 upgrade

Post by notermanjeroen »

Hi,

When I selected "Failover to network mode ..." on the local proxy it was able to backup, replicate and copy the local VM where I installed Veeam v6 and it's SQL Express DB on. When "Failover to network mode ..." was unchecked the jobs failed. Can someone confirm that this workaround works?

Kind regards.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL won't freeze after v6 upgrade

Post by foggy »

Jeroen, according to VBR6 release notes you cannot use virtual backup proxy to backup Veeam server in hot add mode. That's why when you disable failover to Network mode, the job fails. However, this is not connected with the issue discussed in this thread (application-aware processing of SQL server with Veeam database).
stevenrodenburg1
Expert
Posts: 135
Liked: 20 times
Joined: May 31, 2011 9:11 am
Full Name: Steven Rodenburg
Location: Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by stevenrodenburg1 »

Just wanted to add that I'm experiencing the same error. Veeam DB backup *always* worked correctly in V5 but *sometimes* will not freeze in V6. It happens maybe two or three times a week on a SQL VM that is replicated every hour and backed-up once a day. It's not a busy SQL server.
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 »

Guys,

I'm experiencing the same issue wit the "Unable to release guest". I have several other 'identical' servers except for 1 thing. The server that is giving me the error is hosting the Virtual Center Database. I'm wondering if that might be a side effect. I'm going to try and move the Virtual Center Database to a physical server and see if that helps.

Chuck.
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 »

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 »

Hi,

Is their a patch or update for this, just wondering how its progressing?
cheers
A
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 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. »

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: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL won't freeze after v6 upgrade

Post by foggy »

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 »

Applied Patch 3, even rebooted but still same error. :-(
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL won't freeze after v6 upgrade

Post by foggy »

Have you got support team involved?
averylarry
Veteran
Posts: 264
Liked: 30 times
Joined: Mar 22, 2011 7:43 pm
Full Name: Ted
Contact:

Re: SQL won't freeze after v6 upgrade

Post by averylarry »

Sorry Hotgun. The patch did work for me. (Happy dance!)
kurt
Enthusiast
Posts: 71
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 »

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
Chief Product Officer
Posts: 31457
Liked: 6647 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

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: 71
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 »

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
Chief Product Officer
Posts: 31457
Liked: 6647 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

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 »

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
Chief Product Officer
Posts: 31457
Liked: 6647 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

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 »

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
Chief Product Officer
Posts: 31457
Liked: 6647 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

Did you apply patch 3?
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google Feedfetcher, IvanK and 87 guests