Discussions related to exporting backups to tape and backing up directly to tape.
Post Reply
TommyB
Expert
Posts: 123
Liked: 16 times
Joined: Aug 28, 2013 9:46 am
Full Name: Thomas Braun
Location: Germany.Europe.Terra.Sol.Milkyway.Localgroup.Virgo
Contact:

Error "Transaction was deadlocked..." - should I worry?

Post by TommyB »

Hi,

every now and then I get the following error message for one or more of the VMs:

"Transaction (Process ID 77) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

Simply re-running the tape backup job picks up the missed backups ans pushes them to tape.

According to my web search, this has something to do with SQL server.

I think this started with V8, can't remember this to be happening with V7

The question is - should I worry about this and contact Veeam support?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Error "Transaction was deadlocked..." - should I worry?

Post by veremin »

The question is - should I worry about this and contact Veeam support?
Even though the issue seems to go away, whenever you retry a job, I'd recommend to contact support team and find out the root cause of this behaviour. Thanks.
cffit
Veteran
Posts: 338
Liked: 35 times
Joined: Jan 20, 2012 2:36 pm
Full Name: Christensen Farms
Contact:

Re: Error "Transaction was deadlocked..." - should I worry?

Post by cffit »

I'm having this issue as well. Did you come up with any resolution?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Error "Transaction was deadlocked..." - should I worry?

Post by veremin »

The OP has never updated the topic with found resolution, neither has he provided a support ticket number. So, it might be worth reaching support team. Thanks.
alanbolte
Veteran
Posts: 635
Liked: 174 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: Error "Transaction was deadlocked..." - should I worry?

Post by alanbolte »

Make sure you're on Update 3 first, several bugs that could cause these errors were fixed in Update 3. A few hotfixes are available for Update 3, but I have seen some deadlock fixes implemented for v9 that have not been backported to v8.
Post Reply

Who is online

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