Skip to main content
Solved

Oracle plugin backup is stuck in stopping state.

Arun Das
Forum|alt.badge.img+2

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?

    18 comments

    coolsport00
    Forum|alt.badge.img+20
    • coolsport00
    • Veeam Legend
    • 4145 comments
    • 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
    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Arun Das
    Forum|alt.badge.img+2
    • Arun Das
    • Author
    • Comes here often
    • 35 comments
    • October 10, 2023

    Hi coolsport00,

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

    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    coolsport00
    Forum|alt.badge.img+20
    • coolsport00
    • Veeam Legend
    • 4145 comments
    • 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
    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Arun Das
    Forum|alt.badge.img+2
    • Arun Das
    • Author
    • Comes here often
    • 35 comments
    • October 10, 2023

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

    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Chris.Childerhose
    Forum|alt.badge.img+21
    • Chris.Childerhose
    • Veeam Legend, Veeam Vanguard
    • 8502 comments
    • 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.

    Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
    wolff.mateus
    CarySun
    2 people like this
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Arun Das
    Forum|alt.badge.img+2
    • Arun Das
    • Author
    • Comes here often
    • 35 comments
    • 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.

    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Chris.Childerhose
    Forum|alt.badge.img+21
    • Chris.Childerhose
    • Veeam Legend, Veeam Vanguard
    • 8502 comments
    • 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.

    Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
    wolff.mateus
    CarySun
    2 people like this
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Arun Das
    Forum|alt.badge.img+2
    • Arun Das
    • Author
    • Comes here often
    • 35 comments
    • October 10, 2023

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

    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    coolsport00
    Forum|alt.badge.img+20
    • coolsport00
    • Veeam Legend
    • 4145 comments
    • October 10, 2023

    Keep us posted on the resolution!

    Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00
    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Arun Das
    Forum|alt.badge.img+2
    • Arun Das
    • Author
    • Comes here often
    • 35 comments
    • October 10, 2023

    coolsport00, sure will do.

    Chris.Childerhose
    wolff.mateus
    CarySun
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • wolff.mateus
      wolff.mateus
    • CarySun
      CarySun
    Iams3le
    Forum|alt.badge.img+11
    • Iams3le
    • Veeam Legend
    • 1393 comments
    • 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]
    Chris.Childerhose
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    Arun Das
    Forum|alt.badge.img+2
    • Arun Das
    • Author
    • Comes here often
    • 35 comments
    • 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.

     

    Chris.Childerhose
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    MicoolPaul
    Forum|alt.badge.img+23
    • MicoolPaul
    • 2361 comments
    • 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
    Chris.Childerhose
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    Iams3le
    Forum|alt.badge.img+11
    • Iams3le
    • Veeam Legend
    • 1393 comments
    • 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]
    Chris.Childerhose
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    Arun Das
    Forum|alt.badge.img+2
    • Arun Das
    • Author
    • Comes here often
    • 35 comments
    • Answer
    • 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'
     

    Chris.Childerhose
    Iams3le
    dloseke
    3 people like this
    • Chris.Childerhose
      Chris.Childerhose
    • Iams3le
      Iams3le
    • dloseke
      dloseke
    Chris.Childerhose
    Forum|alt.badge.img+21
    • Chris.Childerhose
    • Veeam Legend, Veeam Vanguard
    • 8502 comments
    • October 12, 2023

    Glad you were able to get it resolved with support.

    Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech
    dloseke
    1 person likes this
    • dloseke
      dloseke
    E
    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?
    Chris.Childerhose
    1 person likes this
    • Chris.Childerhose
      Chris.Childerhose
    Chris.Childerhose
    Forum|alt.badge.img+21
    • Chris.Childerhose
    • Veeam Legend, Veeam Vanguard
    • 8502 comments
    • 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

    Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site – https://just-virtualization.tech

    Comment


    Terms & Conditions