Backup snapshot failure with SQL error

VMware specific discussions

Backup snapshot failure with SQL error

Veeam Logoby jluce » Fri 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.
jluce
Enthusiast
 
Posts: 25
Liked: 3 times
Joined: Wed Jan 14, 2015 2:23 am
Full Name: John Luce

Re: Backup snapshot failure with SQL error

Veeam Logoby Mike Resseler » Mon 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
Mike Resseler
Veeam Software
 
Posts: 3151
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Backup snapshot failure with SQL error

Veeam Logoby MMSMicah » Fri 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.
MMSMicah
Lurker
 
Posts: 2
Liked: never
Joined: Fri Mar 03, 2017 7:12 pm
Full Name: Micah MacDonald

Re: Backup snapshot failure with SQL error

Veeam Logoby Mike Resseler » Wed 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
Mike Resseler
Veeam Software
 
Posts: 3151
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Backup snapshot failure with SQL error

Veeam Logoby MMSMicah » Mon 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.
MMSMicah
Lurker
 
Posts: 2
Liked: never
Joined: Fri Mar 03, 2017 7:12 pm
Full Name: Micah MacDonald


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 7 guests