Skip to main content
Delphix

Error 18210 is Raised in the SQL Server Error Log (KBA6473)

 

KBA

KBA# 6473

Why is Error 18210 Raised in the SQL Server Error Log?

When disabling or deleting a Delphix SQL Server dSource, users will see the following errors raised in their SQL Server error log:

09/03/2020 14:36:30,spid55,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1.
09/03/2020 14:36:30,spid55,Unknown,AsynchronousDiskAction::DoDeleteFile: delete failure on backup device 'C:\Program Files\Delphix\DelphixConnector\564db6eb-cadd-728f-1e49-a87b5416c9db-staging-142\DATA\db\Bogus_5_Data.ndf'. Operating system error (null).
09/03/2020 14:36:30,spid55,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1.
09/03/2020 14:36:30,spid55,Unknown,AsynchronousDiskAction::DoDeleteFile: delete failure on backup device 'C:\Program Files\Delphix\DelphixConnector\564db6eb-cadd-728f-1e49-a87b5416c9db-staging-142\DATA\db\Bogus_4_Data.ndf'. Operating system error (null).
09/03/2020 14:36:30,spid55,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1.
09/03/2020 14:36:30,spid55,Unknown,AsynchronousDiskAction::DoDeleteFile: delete failure on backup device 'C:\Program Files\Delphix\DelphixConnector\564db6eb-cadd-728f-1e49-a87b5416c9db-staging-142\DATA\db\Bogus_1_data.ndf'. Operating system error (null).

In order for Delphix to speedily remove the staging database and its storage from the Windows host, Delphix utilizes the following procedure:

  1. Delphix first applies denyDeletePermissions on the staging database's mounted directory because of following reason:

    When a database is dropped, SQL Server will attempt to clean up all its primary and secondary data files. For large databases, the deletion operation can result in significant network activity as deleting files that have been processed by dlpxzfree (a Delphix utility program used to mark a file as being valid for deletion) will push zeroes to the underlying mount. This I/O is unnecessary because the underlying zvol will be rolled back when the staging database is disabled.

    To prevent the above scenario, place a deny delete ACE on the database files.

  2. Delphix drops the database.
  3. Finally, Delphix unmounts the volumes.

 

Related Articles 

The following articles may provide more information or related information to this article: