Purging corrupt action pack data from repository, actionslib and DB

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

Hello,

We missed to upgrade our repository form 5.5.2.191 to higher version when we upgraded our NAC all the way to 6.7.0.576. Due to this somewhere we encountered some issue that we now have some corrupt action packs, in our RA  database, nexus repository and actionslib on NAC with "*.tmp" and we want to get rid of same.

• Repository directories :
  
  • $CARA_HOME/sonatype-work/nexus/storage/nolio-actions/default_actions_group
  • $CARA_HOME/sonatype-work/nexus/storage/nolio-actions/.nexus/attributes/default_actions_group
• NAC directory :
  • $CARA_HOME/actionslib
• Database table
  • ACTION_PACKS

Can you suggest how to clean the same?

Environment

Release : 6.X

Component : CA RELEASE AUTOMATION REPOSITORY

Resolution

Pre-requisites

1. Take a snapshot/backup of your DB
2. Take snapshot or backup of Nexus repository and NAC
3. Make sure that no process/deployments/test run is running on CA RA system

Solution

Cleaning corrupt data on actionslib and Nexus repository

1. 1. Stop the NAC server
   2. On the NAC server in actionslib directory remove all the files with *.tmp
   3. Start the NAC sever and let it be up and running.
   4. As a startup sequence of NAC server the repository should be synched with NAC actionslib and the missing *.tmp file will be removed from repository
   5. Validate the repository and actionslib directory on NAC

Cleaning corrupt data from DB (compatible for SQL/Oracle)

1. • Validation Query: The query below to check the corrupted action_pack entries in DB with *.tmp name & file name.

select * from action_packs where name like '%.tmp' and file_name like '%.tmp';

• • Delete query: The query below will delete corrupt records from DB.

delete from action_packs where name like '%.tmp' and file_name like '%.tmp'

Rollback

In case of any failure, the backup of DB, NAC and Repository need to be restored and please contact Technical Support.

Additional Information

Related Article

• Standalone Artifactory upgrade from 5.5 to 6.7