Solved

Oracle plugin backup is stuck in stopping state.

1 year ago
October 10, 2023
18 comments
415 views

Arun Das
Comes here often
35 comments

Hi All,

Anyone faced this issue or any fixes to resolve this. Am using Oracle plugin for Backup on windows VM, these are stuck is stopping state from yesterday.

I tried looking for the Veeam exe agent on VBR as well as agent VM, no process is running, is there a way we can forcibly cancel only these backup’s

We could locate the PID’s of these process, however process does not appear under VBR or the oracle VM Task Manager,

Process: [64 bit], PID: [19652], SessionId: [0], UID: [fc911f7e-ed08-4bb7-be1f-4a3461f23dda] for the SRV03248
Process: [64 bit], PID: [61356], SessionId: [0], UID: [3b69526c-e334-4305-bd33-bcced8fc2944] for the SRV03576
Process: [64 bit], PID: [19724], SessionId: [0], UID: [a941f009-e8b7-475a-8fd2-1388653256b6] for the SRV03709
Process: [64 bit], PID: [61356], SessionId: [0], UID: [3b69526c-e334-4305-bd33-bcced8fc2944] for the SRV03821

Best answer by Arun Das

Hello,

Good day to you All, wanted to share update on this issue.

I worked with support and could remove the ghost entry from Veeam DB with the below query. Jobs which were in stuck stopping state is released. Retriggered backup which is running fine now.

Need to run below query on DB

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '<id of the job>'

Here are the IDs that need to be entered to the Query:

id	job_name
4D3172C0-5392-44BD-BDCA-8A1985AC5716	SRV03709 Oracle backup (nl001.sobr.Oracle1)

So the Query will look like this:

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '4D3172C0-5392-44BD-BDCA-8A1985AC5716'

View original

Did this topic help you find an answer to your question?

+20

coolsport00
Veeam Legend
4155 comments
1 year ago
October 10, 2023

Hi @Arun Das - can you reboot the server the plug in is installed on?

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00

Arun Das
Author
Comes here often
35 comments
1 year ago
October 10, 2023

Hi coolsport00,

I have rebooted the oracle machine, job is still in stuck stopping state.

+20

coolsport00
Veeam Legend
4155 comments
1 year ago
October 10, 2023

You're Backups run on VBR, correct? What about rebooting your VBR server?

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00

Arun Das
Author
Comes here often
35 comments
1 year ago
October 10, 2023

VBR is rebooted as well, still the jobs are showing up in stopping state.

+21

Chris.Childerhose
Veeam Legend, Veeam Vanguard
8521 comments
1 year ago
October 10, 2023

What if you try to disable the Oracle jobs to see if that helps stop them. Never seen this before but also don't use Oracle either.

Arun Das
Author
Comes here often
35 comments
1 year ago
October 10, 2023

Tried disabling the job as well does not get disabled. Killed all the running process, stopped services and rebooted VBR again. does not help. I have opened a support case for this.

+21

Chris.Childerhose
Veeam Legend, Veeam Vanguard
8521 comments
1 year ago
October 10, 2023

Arun Das wrote:

Tried disabling the job as well does not get disabled. Killed all the running process, stopped services and rebooted VBR again. does not help. I have opened a support case for this.

That would be my next suggestion as one of the things you did already should have stopped the jobs. Hopefully support sorts it out and you can share the fix.

Arun Das
Author
Comes here often
35 comments
1 year ago
October 10, 2023

Chris.Childerhose, yes, I will share the fix once done. Thank you.

+20

coolsport00
Veeam Legend
4155 comments
1 year ago
October 10, 2023

Keep us posted on the resolution!

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00

Arun Das
Author
Comes here often
35 comments
1 year ago
October 10, 2023

coolsport00, sure will do.

+11

Iams3le
Veeam Legend
1395 comments
1 year ago
October 10, 2023

Hi @Arun Das,

Have you tried forcing the services stop by terminating the processes. Kindly use this command “taskkill /F /PID <PID>” and specify the PID …

[Microsoft MVP | Veeam Legend (2021 -2025) | VMware vExpert 5x | Cisco Champion 3x | Object First Ace 2x]

Arun Das
Author
Comes here often
35 comments
1 year ago
October 11, 2023

Hi Iams3le,

I cannot kill the process as the PID is not listed under task Manager, or no process shows up with this PID.

+23

MicoolPaul
2362 comments
1 year ago
October 11, 2023

Hi,

this is definitely one for support but I would suspect the reason you’re not seeing any processes (and why it still says stopping after reboots etc) is that the VBR database hasn’t been updated successfully with the new job status

Michael Paul - Opinions are my own and do not necessarily reflect the opinion of Veeam | https://micoolpaul.com | Mastodon: @micoolpaul@masto.nu | Bluesky: @micoolpaul.com

+11

Iams3le
Veeam Legend
1395 comments
1 year ago
October 11, 2023

Arun Das wrote:

Hi Iams3le,

I cannot kill the process as the PID is not listed under task Manager, or no process shows up with this PID.

Just one more tip. How were the PID’s of these process located? Could you double check by using this command “sc queryex ServiceName”. Please replace the service name with the name of the service. If none of these work, I would recommend escalating this issue to the support team as recommended by my peers!

[Microsoft MVP | Veeam Legend (2021 -2025) | VMware vExpert 5x | Cisco Champion 3x | Object First Ace 2x]

Arun Das
Author
Comes here often
35 comments
Answer
1 year ago
October 12, 2023

Hello,

Good day to you All, wanted to share update on this issue.

I worked with support and could remove the ghost entry from Veeam DB with the below query. Jobs which were in stuck stopping state is released. Retriggered backup which is running fine now.

Need to run below query on DB

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '<id of the job>'

Here are the IDs that need to be entered to the Query:

id	job_name
4D3172C0-5392-44BD-BDCA-8A1985AC5716	SRV03709 Oracle backup (nl001.sobr.Oracle1)

So the Query will look like this:

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '4D3172C0-5392-44BD-BDCA-8A1985AC5716'

+21

Chris.Childerhose
Veeam Legend, Veeam Vanguard
8521 comments
1 year ago
October 12, 2023

Glad you were able to get it resolved with support.

edsonfilho.pereira
New Here
3 comments
1 year ago
April 9, 2024

Arun Das wrote:

Hello,

Good day to you All, wanted to share update on this issue.

I worked with support and could remove the ghost entry from Veeam DB with the below query. Jobs which were in stuck stopping state is released. Retriggered backup which is running fine now.

Need to run below query on DB

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '<id of the job>'

Here are the IDs that need to be entered to the Query:

id	job_name
4D3172C0-5392-44BD-BDCA-8A1985AC5716	SRV03709 Oracle backup (nl001.sobr.Oracle1)

So the Query will look like this:

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '4D3172C0-5392-44BD-BDCA-8A1985AC5716'

Hello, how do I get the job ID? Any powershell commands?

+21

Chris.Childerhose
Veeam Legend, Veeam Vanguard
8521 comments
1 year ago
April 9, 2024

edsonfilho.pereira wrote:

Arun Das wrote:

Hello,

Good day to you All, wanted to share update on this issue.

I worked with support and could remove the ghost entry from Veeam DB with the below query. Jobs which were in stuck stopping state is released. Retriggered backup which is running fine now.

Need to run below query on DB

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '<id of the job>'

Here are the IDs that need to be entered to the Query:

id	job_name
4D3172C0-5392-44BD-BDCA-8A1985AC5716	SRV03709 Oracle backup (nl001.sobr.Oracle1)

So the Query will look like this:

Update [dbo].[Backup.Model.JobSessions]
Set [state] = -1
where id = '4D3172C0-5392-44BD-BDCA-8A1985AC5716'

Hello, how do I get the job ID? Any powershell commands?

Try running Get-VBRJob command that should display Job ID - Get-VBRJob - Veeam Backup PowerShell Reference

Comment

Related topics

SNMP Memory using "storage"icon

Community Recap #88

Can we monitor LOAD and MEMORY of AIX servers using SNMP?icon

Synology Hyper Backupicon

Community Recap 07

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded