Skip to main content
sshimpi
Silver ⭐️⭐️⭐️
Dec 29, 2016 3:23 AM UTC

Ranger issue while HDP upgrade

  • Oct 5, 2026 9:30 AM UTC
  • 0 replies
  • 907 views
  • Translate All

ISSUE: While upgrading HDP, Ranger service failed. Below was the error -

Failed to apply patch 020-datamask-policy.sql” with error “Not able to drop table ‘x_datamast_type_’def” Foreign constraints fails Error Code 1217

ERROR:

10878-pic3.png

ROOT CAUSE: Issue was with foreign_key_checks

RESOLUTION:

“SET foreign_key_checks = 0;” in mysql ranger DB and dropped the table manually and re-created and again “SET foreign_key_checks = 1;”