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/12 09:59:54 UTC
Re: 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/
-----------------------------------------------------------
(Updated Dec. 12, 2018, 9:59 a.m.)
Review request for ranger, Ankita Sinha, bhavik patel, Gautam Borad, Haihui Xu, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Nitin Galave, Pradeep Agrawal, Ramesh Mani, Sailaja Polavarapu, 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 (updated)
-----
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/2/
Changes: https://reviews.apache.org/r/69549/diff/1-2/
Testing
-------
Testing done with all supported db flavours
Thanks,
Akash Pawale
Re: Review Request 69549: RANGER-2234 : Cannot add or update a child
row, a foreign key constraint fails when installing ranger-admin
Posted by Velmurugan Periasamy <vp...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/69549/#review212220
-----------------------------------------------------------
Ship it!
Ship It!
- Velmurugan Periasamy
On Dec. 12, 2018, 9:59 a.m., Akash Pawale wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/69549/
> -----------------------------------------------------------
>
> (Updated Dec. 12, 2018, 9:59 a.m.)
>
>
> Review request for ranger, Ankita Sinha, bhavik patel, Gautam Borad, Haihui Xu, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Nitin Galave, Pradeep Agrawal, Ramesh Mani, Sailaja Polavarapu, 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/2/
>
>
> Testing
> -------
>
> Testing done with all supported db flavours
>
>
> Thanks,
>
> Akash Pawale
>
>