PDDODataRemoval is failing with error message: duplicate key violates unique constraint "ds_raw_
|Article:TECH223549|||||Created: 2014-08-05|||||Updated: 2015-03-03|||||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.|
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 ***
date: 2014-May-29 08:15:05 CDT
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:
- Deduplication Appliances 188.8.131.52, 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.
The formal resolution for this issue (ETrack 3525863) is included in the following release:
- NetBackup 50x0 Appliances 1.4.5
Deduplication Appliances 1.4.5 is now available - download and README information can be found via the Related Article linked below.
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.
Apply the appropriate hotfix attached to the Related Article which will remove the duplicates and correct any associated records.
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