Skip to main content
Delphix

Troubleshooting SQL Server VDBs stuck in the "Stopping virtual database" phase of a refresh or rollback job (KBA8067)

 

KBA

KBA# 8067

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Troubleshooting when SQL Server VDB is stuck in the Stopping virtual database phase of a refresh or rollback job

When running a provision task on a SQL Server VDB such as a refresh, rollback or rewind, one of the first things done to the VDB after validating the VDB is in fact a VDB (as opposed to a non-Delphix database) is to stop the VDB so it can be offlined and dropped off the SQL Server in preparation of removing the Delphix storage and ultimately to provision a new VDB to take its place.

On rare occasions this job can be stuck on the job event tagged as "Stopping virtual database".  Normally, this event takes a few seconds or at most a few minutes.  If you see this event sticking around past an hour then you need to check on the SQL Server to find out what is happening. Usually when this happens it might be stuck when issuing an OFFLINE command (To be continued)

Prerequisites 

text

Resolution

To resolve xyz...

Complete the following procedure to xyz.

  1. step 1
  2. step 2
  3. step 3
    1. substep a
    2. substep b
    3. substep c
  4. step 4
  5. step 5
  6. step 6
  7. step 7
    1. substep a