PDDODataRemoval is failing with error message: duplicate key violates unique constraint "ds_raw__unique_dirname_basename"

Article:TECH223549  |  Created: 2014-08-05  |  Updated: 2014-09-15  |  Article URL http://www.symantec.com/docs/TECH223549
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution



PDDODataRemoval is failing with error message:
duplicate key violates unique constraint "ds_raw_<ds_id>_unique_dirname_basename"


The following error message can be seen in /Storage/log/PDDODataRemoval.log:
*** Error Message ***
severity: 6
server: 2
source: PDDODataRemoval_PDDODataRemoval
date: 2014-May-29 08:15:05 CDT
[2]pg_query(): Query failed: ERROR: duplicate key violates unique constraint
*** End ***

The value of ds_id in ds_raw_<ds_id>_unique_dirname_basename (2 in the above example) may differ depending on the system and which data selection PDDO is associated with.


This issue affects the following products and versions:

  • NetBackup Appliances, 1.4.4
  • NetBackup PureDisk 6.6.4, 6.6.5


An additional constraint was placed on the database to ensure uniqueness in the database for client and policy (directory name and basename in the database).  The result of the unique contstraint caused PDDODataRemoval to fail when attempting to correct duplicates found in the metabase database.


Symantec Corporation has acknowledged that the above-mentioned issue (ETrack 3525863) is present in the current version(s) of the product(s) mentioned in this article. Symantec Corporation is committed to product quality and satisfied customers. This issue was scheduled to be addressed in the following release:

  • NetBackup 50x0 Appliances 1.4.5

When NetBackup Appiances 1.4.5 is released, please visit the following link for download and README information:

This issue is not scheduled to be resolved in a future release of NetBackup PureDisk.  NetBackup PureDisk 6.6.5 is currently scheduled to be the final release update of the product.

Please note that Symantec Corporation reserves the right to remove any fix from a targeted release if it does not pass quality assurance tests or introduces new risks to overall code stability. Symantec Corporation's plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.

Apply the appropriate hotfix attached to the Related Article which will remove the duplicates and correct any associated records.

Supplemental Materials


PDDODataRemoval Query failed: ERROR: duplicate key violates unique constraint "ds_raw_2_unique_dirname_basename". Requesting change to PDDODataRemoval to query around duplicate basenames.

Article URL http://www.symantec.com/docs/TECH223549

Terms of use for this information are found in Legal Notices