Unable to delete transaction log backup

  • 0
  • 1
  • Problem
  • Updated 5 years ago
  • Solved
Has anyone seen the following error before? We have started getting it today

Unable to delete transaction log backup "C:\Program Files\Delphix\DelphixConnector\564d490d-324c-eb3d-ffb5-8a67f2c9dd39-staging-1\ARCHIVE\Genesis_Log_20140722-183012.trn_F7989F42-6DCA-47B1-BE9E-947B6DF57363_787372" for dSource "Genesis". The Delphix Engine will keep trying to delete the backup. Make sure that staging host "PKH-SRV-PPT01.CI.LAB" is up, the Delphix Connector service is started, and the OS credentials for user "cityindex\svc.delphixadmin" are correct.
Photo of Anup Anand

Anup Anand

  • 132 Points 100 badge 2x thumb

Posted 5 years ago

  • 0
  • 1
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,722 Points 2k badge 2x thumb
Official Response
Hi Anup,

This can result from an unusual situation where a transaction log has been deleted from the target environment, but is still registered in the internal metadata on the Delphix Engine.

You can workaround it by just creating an empty file for that path, and the next policy run will find it and clean up the dummy file and the metadata so it can continue okay.

The issue is resolved in 3.2.7 and 4.0.

Best Regards,

Photo of Michael Brown

Michael Brown

  • 1,540 Points 1k badge 2x thumb
Official Response
Hi Anup,

I have seen this before, but it is rare. If you look on your PPT server for the transaction log file given in the error message, I think you'll find that it doesn't exist (because it has already been deleted). If so, then what is occurring is that we deleted the log successfully on a previous retention policy run, but for some reason the exit status of the delete command didn't make it back to the Delphix application stack, so we didn't record the log's deletion in the metadata. So, each time we run retention policy enforcement, we try to delete a log that's already gone.

Versions and later of Delphix Engine are no longer susceptible to this error. 

To get past this error in versions and earlier, simply create an empty file with the same name as the log file we are trying to delete, in the correct folder on the PPT server.