ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Akash Pawale <akashp1...@gmail.com>
Subject Review Request 69549: RANGER-2234 : Cannot add or update a child row, a foreign key constraint fails when installing ranger-admin
Date Tue, 11 Dec 2018 08:56:13 GMT

-----------------------------------------------------------
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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message