Item [Backup Job] is locked by running session Backup Job [Agent Backup]

[AlexLeadingEdge]

Hi guys,

Case # 07570067

I have a home user who cannot backup. The backup starts and then fails with the below:

15/01/2025 10:06:43 AM :: Initializing
15/01/2025 10:08:08 AM :: Error: Item [Backup Job REDACTED] is locked by running session Backup Job REDACTED [Agent Backup]
15/01/2025 10:09:58 AM :: Email notification was sent
15/01/2025 10:08:12 AM :: Processing finished with errors at 15/01/2025 10:08:12 AM

They were using an earlier version of Veeam Agent but I've upgraded it to Veeam Agent 6.3.0.177 but no change (I didn't expect this would fix it but I had hoped).

In the past I could use the below commands delete the locks, but this no longer works:

sqlcmd -S (LocalDb)\VeeamEndPoint -d "VeeamBackup" -Q "delete from [Backup.TrackedActions.Leases]"
sqlcmd -S (LocalDb)\VeeamEndPoint -d "VeeamBackup" -Q "delete from [Backup.TrackedActions.LockItems]"
sqlcmd -S (LocalDb)\VeeamEndPoint -d "VeeamBackup" -Q "delete from [Backup.TrackedActions.Locks]"

Any ideas on how to get this up and running again without having to start from scratch?

[Mildur]

Hello Alex

The database type changed between version 5 and 6 (localdb to a SQLite). I assume thats the reason why your command doesn't work anymore.
Please continue with our support team to investigate these locks.

From the error message it looks like two different jobs are configured and run at the same time. Which is theoretically not possible for our free agent (case was opened for our free agent).

Thanks,
Fabian

[AlexLeadingEdge]

Hi Fabian,

I haven't heard from the Veeam Support team, it would be good if someone could give them a nudge.

[Mildur]

Hi Alex

The case was opened for one of our free products. As you may know, we offer support on a best-effort basis for users of our free products, so I am unable to escalate the issue or "give them a nudge".

If you are a service provider and this "home user" is a paying customer of yours, I recommend deploying an end-user or rental license. Our EULA does not permit offering services to third parties using any of our free product offerings; a license is required. This will ensure that you receive guaranteed support responses in accordance with our support policy.

Best,
Fabian


PS:
Please register yourself in our service provider user group if you are a service provider. This gives you access to our hidden service provider sub forums where service provider products are discussed: Apply for the Cloud and Service Providers user group

[AlexLeadingEdge]

Hi Fabian,

Yes, I understand. I don't want to invalidate the licensing or queue jump.

All of our "home users" are all staff of our corporate clients, we help them as a courtesy and it makes our life easier since they often work remotely, so having their home computers in proper order means better security for our corporate clients. This client in particular was the accountant for one of our clients that has VeeamB&R and available Instance licences. Unfortunately I was only informed on Friday that they retired at the end of December, my offsider forgot to let me know, but they remain our client.

I have joined the ProPartner and the Service Providers groups.

[AlexLeadingEdge]

In the end we had two issues, firstly it couldn't start a job while it thought it had a job in progress, so we ended up having to rebuild the Veeam Agent database, and secondly the backup drive was formatted in ExFAT and going from an older version of Veeam Agent (5.x) to the latest (6.3.0.177) as a way of fixing the issue actually added a second issue, as it meant we could no longer use it for backups as ExFAT support was removed in Veeam Agent version 6, so the drive had to be formatted and all backup history for the last three months was lost anyway.

Here is the solution for the issue:

1) Stop VAW service:
Get-Service Veeam* | Stop-Service

2) Create the following Registry entry (please take a backup of the registry first):

Location: HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint Backup
Name: ReCreateDatabase
Type: REG_DWORD
Value: 1

3) Start VAW service:
Get-Service Veeam* | Start-Service

What would be nice is if the job could have been stopped. Apparently there is a command that can be used in the VeeamB&R Console, but isn't available in Veeam Agent. I'm guessing this is just a SQLite command?

In hindsight I would have liked to have tried this, converting the earlier script from SQL to SQLite:

(1) Download and install sqlite-tools:

https://www.sqlite.org/download.html

(2) Open the SQLite CLI:

Code: Select all

sqlite3 VeeamBackup.db

(3) Run these three commands:

Code: Select all

DELETE FROM "Backup.TrackedActions.Leases";
DELETE FROM "Backup.TrackedActions.LockItems";
DELETE FROM "Backup.TrackedActions.Locks";