Jenkins job "Sanitize database on prod.cms.va.gov" Inconsistent Clean Builds

[7hunderbird]

User Story or Problem Statement

We will need to dig into why the "Sanitize database on prod.cms.va.gov" job periodically fails 2/3 times.

• http://jenkins.vfs.va.gov/job/cms/job/cms-db-sanitize/

Description or Additional Context

Steps for Implementation

Acceptance Criteria

• Testable_Outcome_X
• Testable_Outcome_Y
• Testable_Outcome_Z
• Requires design review
• Requires accessibility review

[7hunderbird]

While it is annoying to see these alerts in the #cms-notifications channel, this can be a medium to low priority ticket for now because it's a repetative automation task whose purpose is to keep a development copy of the production database up-to-date.

• It sanitizes the data
• Publishes a mysqldump file to S3
• Tugboat uses this to keep in-sync with Prod
• Local developers also use this "dump file" to setup their development environment

If someone comes to us and says "I have this specific bug and think that my data from prod is off or out of sync". In that case we can increase the priority.

[7hunderbird]

This was erroring because of a lock issue from the other jenkins server.

With the other jenkins server turned off the lock issue is gone and this is resolved.