Host-based backup of VMware vSphere VMs.
averylarry
Veteran
Posts: 264
Liked: 30 times
Joined: Mar 22, 2011 7:43 pm
Full Name: Ted
Contact:

SQL won't freeze after v6 upgrade

Post by averylarry »

Just wanted to ask here if I should contact support before bothering them . . .

My SQL server worked fine on v5 -- application aware snapshots etc. It has all the Veeam databases, but it does NOT have the vcenter server, nor any Veeam components. Nothing changed with the SQL server (not even windows updates) since it was working on v5 and now it isn't working.

"Unable to release guest. VSSControl: Failed to freeze guest, wait timeout."

I'm happy to open a support case but didn't want to bother them if it's something trivial.

The windows event log seems to indicate VSS success, but at 1 minute and several seconds. Is there a timeout setting I can change? I've read conflicting accounts on the forums . . .
NightBird
Expert
Posts: 242
Liked: 57 times
Joined: Apr 28, 2009 8:33 am
Location: Strasbourg, FRANCE
Contact:

Re: SQL won't freeze after v6 upgrade

Post by NightBird »

Same problem here. On the SQL Server with Veeam database onboard.

With v5 it works flawless
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. »

Hi Ted,

Based on my previous research it should work, but again I would recommend to involve our support team in investigating this issue.

Thanks!
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 »

Sure -- like I said it was working with v5. This is a change since v6. I'll open a support case.
Davd
Enthusiast
Posts: 44
Liked: 4 times
Joined: Mar 19, 2010 12:36 pm
Full Name: David Hirsman
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Davd »

I have the same problem...With our Veeam 6 backup server I am unable to backup the SQL (where Veeam database is located) with VSS enabled. I also have a Veeam 5 backup server with database on same SQL (as Veeam 6 database) and that one works fine with VSS.

I have an open case with support about this but so far they seem to think that its a problem on our side... Which I don't agree since our Veeam 5 work just fine with exactly same settings.

So its intresting to see that other users are expiriencing this as well... perheps Veeam support can dig a bit deeper then
ZachW
Enthusiast
Posts: 68
Liked: 10 times
Joined: Aug 02, 2011 6:09 pm
Full Name: Zach Weed
Contact:

Re: SQL won't freeze after v6 upgrade

Post by ZachW »

David,

What is your support case number?

-Zach
Davd
Enthusiast
Posts: 44
Liked: 4 times
Joined: Mar 19, 2010 12:36 pm
Full Name: David Hirsman
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Davd »

Support case nr is ID#5157661
Davd
Enthusiast
Posts: 44
Liked: 4 times
Joined: Mar 19, 2010 12:36 pm
Full Name: David Hirsman
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Davd »

I recieved an update from support now where they state following:

"The reason why the job fails during processing of SQL server where Veeam's DB is located is a connectivity loss. Veeam initiates VSS freeze of the SQL DB and all the transaction are being stopped for the short period of time. In that time interval Veeam loses the connection to the DB and that causes job to fail. Backing up of Veeam's DB with VSS freeze is a scenario which is not supposed to be working."

I find this answer quite ridiculos since it works fine in version 5. But maybe its a new feature of version 6...
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. »

David, I have just asked our QC team to try to reproduce this behavior. I will post back once I have more information.
dsrohdy
Lurker
Posts: 1
Liked: never
Joined: Nov 01, 2011 12:46 pm
Full Name: Dustin Rohdy
Contact:

Re: SQL won't freeze after v6 upgrade

Post by dsrohdy »

Just wanted to add that I'm experiencing the same error. Veeam DB backup worked correctly in V5 but will not freeze in V6.
jimmymc
Service Provider
Posts: 34
Liked: 4 times
Joined: Dec 09, 2010 3:06 pm
Contact:

Re: SQL won't freeze after v6 upgrade

Post by jimmymc »

Same issue here - Vitaly, would you like us to log a call with support also, or wait for you to reproduce and work on the issue internally? It's a problem for us as we have lots of important DBs on the same SQL server..

Cheers, James
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. »

James, according to the recent news from our QC team we've managed to reproduce this issue and now are working on possible fixes, but I would suggest to log a support call anyway!
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 guys, after the SAN Direct Access mode not working (waiting for fix) i have the same issue. Veeam db is located on an external SQL server : VSS snap fails with the same error. Gonna open a case through web and reference this post. I also have the same error on SQL not hosting Veeam DB. It was working well in v5
Rgds Alex
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 »

Here's my case number 5159575 Alex
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
I received a fix for Direct San Access and it works great ! Any idea for this VSS fix to come up ? Thanks for your efforts !
Gostev
Chief Product Officer
Posts: 31459
Liked: 6648 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, support will notify you once it is available - currently, I have no timelines to share. Thanks!
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 »

Is this a fairly common issue? I'd expect lots of people to have their Veeam databases on a separate SQL server. Or are there other certain conditions involved . . ?
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 »

Pb is not only on SQL hosting Veeam dB. It seems to be on all SQL. I'll have à check after tonight jobs Alex
Gostev
Chief Product Officer
Posts: 31459
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

I know that the research was already completed, and in fact it does affect SQL hosting Veeam DB only, so it is not very common. Nevertheless, just like any blocking issue reported by customers, it will be addressed in a timely manner. 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 Anton. You are right sorry. Only veeam dB server is affected. Alex
marc.delpouys
Enthusiast
Posts: 90
Liked: never
Joined: Aug 20, 2010 5:06 pm
Full Name: Marc Delpouys
Contact:

Re: SQL won't freeze after v6 upgrade

Post by marc.delpouys »

I've also seen this issue with SQL servers using a clean new install of v6. I've created a Support Request [ID#5158984].

Adding the ESX(i) hosts manually and then editing the job to select the Host and then the VM stopped the issue from happing. But, required that DRS/VMotion not be done on these VM's.
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
My customer had an external server to move Veeam DB to. I followed the post Move Veeam database only to another sql server to move Veeam DB and i am now able to backup my virtual SQL server with success. I have more time to wait for the patch ;) Rgds
Alex
jfolkman
Lurker
Posts: 1
Liked: never
Joined: Dec 13, 2011 8:37 pm
Full Name: Jason Folkman
Contact:

Re: SQL won't freeze after v6 upgrade

Post by jfolkman »

We are having the same problem as well after upgrading to version 5. Ticket ID#5157355

Please fix.

Thanks,

Jason
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 »

Support told me that veeam does not support to have its dB frozen while a backup was running but it was like that since V5 ...
Gostev
Chief Product Officer
Posts: 31459
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

We are planning to change database interaction pattern during VM freeze to make that supported.
ritterbruder
Novice
Posts: 8
Liked: never
Joined: Apr 08, 2011 1:54 pm
Full Name: clark keller
Contact:

Re: SQL won't freeze after v6 upgrade

Post by ritterbruder »

Thanks for the update on this. I experience this as well and am very excited for a fix to come out!
slam
Novice
Posts: 7
Liked: never
Joined: Dec 18, 2010 12:19 am
Full Name: Stephen
Contact:

Re: SQL won't freeze after v6 upgrade

Post by slam »

We have the same issue too, case ID # 5161139. What will we have a fix for this?
Gostev
Chief Product Officer
Posts: 31459
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL won't freeze after v6 upgrade

Post by Gostev »

Hi Stephen, not sure I understand what you are asking.
wberryment
Novice
Posts: 3
Liked: never
Joined: Dec 09, 2011 8:23 pm
Full Name: Wayne
Contact:

Re: SQL won't freeze after v6 upgrade

Post by wberryment »

I'm having the same issue. Veeam Backup and Replicaton installed on the same server as SQL Server 2008.
Worked before upgrade from 5.0 to 6
Open ticket: 5160628
Awaiting a fix.
wayne
wberryment
Novice
Posts: 3
Liked: never
Joined: Dec 09, 2011 8:23 pm
Full Name: Wayne
Contact:

Re: SQL won't freeze after v6 upgrade

Post by wberryment »

I opened a case and they followed up. They are telling me that you can't use Application Aware Processing to backup the server running Veeam Backup and Replication if you have the SQL database which Veeam is writing to on that same server. You will get a "Unable to release guest. Error: VSS Control: Failed to freeze guest wait timeout". I have other databases on this SQL server besides Veeams and I can't get a complete backup of that server unless I do SQL backups, and turn off Application Aware Processing in the job. All I'm saying that this wasn't going on in Version 5. I was told that it wasn't supposed to have worked in Version 5 either.
Wayne
Post Reply

Who is online

Users browsing this forum: No registered users and 93 guests