You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ranger.apache.org by Akash Pawale <ak...@gmail.com> on 2018/12/11 08:56:13 UTC

Review Request 69549: RANGER-2234 : Cannot add or update a child row, a foreign key constraint fails when installing ranger-admin

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/69549/
-----------------------------------------------------------

Review request for ranger, Ankita Sinha, bhavik patel, Gautam Borad, Haihui Xu, Madhan Neethiraj, Mehul Parikh, Nitin Galave, Pradeep Agrawal, and Velmurugan Periasamy.


Bugs: RANGER-2234
    https://issues.apache.org/jira/browse/RANGER-2234


Repository: ranger


Description
-------

Added functions getXportalUIdByLoginId[ to get x_portal_user.id by x_portal_user.login_id] and getModulesIdByName
and calling this functions while updating child rows to avoid foreign key constraint fails errors


Diffs
-----

  security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql a4fa130 
  security-admin/db/mysql/patches/013-permissionmodel.sql 381bb6f 
  security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql 0949cbd 
  security-admin/db/oracle/patches/013-permissionmodel.sql 4ac7901 
  security-admin/db/oracle/patches/016-updated-schema-for-tag-based-policy.sql 12627f5 
  security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql a0e02e0 
  security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql db8ebc3 
  security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql 522b57b 
  security-admin/db/sqlserver/patches/016-updated-schema-for-tag-based-policy.sql 4b856d7 


Diff: https://reviews.apache.org/r/69549/diff/1/


Testing
-------

Testing done with all supported db flavours


Thanks,

Akash Pawale