Discussions specific to the VMware vSphere hypervisor
Post Reply
jluce
Enthusiast
Posts: 25
Liked: 3 times
Joined: Jan 14, 2015 2:23 am
Full Name: John Luce
Contact:

Backup snapshot failure with SQL error

Post by jluce » Feb 17, 2017 1:58 pm

We got a unique failure the first time a backup was tried that we had not seen before. Snapshot isolation transaction failed in database VeeamBackup because the object access by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because metadara is not versioned. Basically Veeam created a temp table in a snapshot isolation level transaction and it got changed if I am reading this correctly? Subsequent attempts to backup the VM were successful. Is there something we should do to help this not to occur? We are running Veeam 9.5 Update 1.

Mike Resseler
Veeam Software
Posts: 4974
Liked: 523 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Backup snapshot failure with SQL error

Post by Mike Resseler » Feb 20, 2017 6:44 am

John,

This is the first time I hear from this error. I think it is best that our engineers look at it so could you create a support call, post the case ID (and after that the follow-up) here?

Many thanks
Mike

MMSMicah
Lurker
Posts: 2
Liked: never
Joined: Mar 03, 2017 7:12 pm
Full Name: Micah MacDonald
Contact:

Re: Backup snapshot failure with SQL error

Post by MMSMicah » Mar 03, 2017 7:16 pm

We had this same error last night on one of our backup jobs. The automatic retry was successful and the rest of the jobs ran fine (12 jobs in total). We are on 9.5 update 1 also and this is the first time I have ever seen this.

Mike Resseler
Veeam Software
Posts: 4974
Liked: 523 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Backup snapshot failure with SQL error

Post by Mike Resseler » Mar 08, 2017 7:22 am

Micah,

(Sorry for my late reply). It would be appreciated if you also can log a support call and post the support case ID and follow-up here.

Thanks
Mike

MMSMicah
Lurker
Posts: 2
Liked: never
Joined: Mar 03, 2017 7:12 pm
Full Name: Micah MacDonald
Contact:

Re: Backup snapshot failure with SQL error

Post by MMSMicah » Mar 27, 2017 6:55 pm

Sorry for the long delay folks. I just opened up a ticket with Veeam today so I will keep you posted.

Perseus83
Lurker
Posts: 1
Liked: never
Joined: Jan 13, 2015 2:26 pm
Full Name: Andreas Hagendorf
Contact:

Re: Backup snapshot failure with SQL error

Post by Perseus83 » Sep 07, 2017 11:56 am

And then? Nothing to share after the error was fixed?

OMG I see this behavior at 90% of all technical questions that where asked.

Shame

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

Re: Backup snapshot failure with SQL error

Post by foggy » Sep 07, 2017 1:24 pm

Hi Andreas, unfortunately, users do not often come back to update us on the results of the case investigation, that's why we always ask for the case ID when someone posts about technical issue - at least to be able to track the resolution in the internal case tracking system. I recommend you contacting support directly with this.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 31 guests