PDDODataRemoval is failing with error message: duplicate key violates unique constraint "ds_raw_
|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.|
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:
- NetBackup Appliances 126.96.36.199, 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.
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