From dev-return-20150-archive-asf-public=cust-asf.ponee.io@ranger.apache.org Tue Dec 11 09:56:19 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id D01FF180671 for ; Tue, 11 Dec 2018 09:56:18 +0100 (CET) Received: (qmail 1288 invoked by uid 500); 11 Dec 2018 08:56:18 -0000 Mailing-List: contact dev-help@ranger.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ranger.apache.org Delivered-To: mailing list dev@ranger.apache.org Received: (qmail 1273 invoked by uid 99); 11 Dec 2018 08:56:17 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2018 08:56:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id F2FC7180ABC; Tue, 11 Dec 2018 08:56:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.48 X-Spam-Level: *** X-Spam-Status: No, score=3.48 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, FORGED_GMAIL_RCVD=1, FREEMAIL_REPLYTO_END_DIGIT=0.25, HEADER_FROM_DIFFERENT_DOMAINS=0.129, HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, KAM_MANYTO=0.2, NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_MED=-2.3] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id hhY1u0xjMVXo; Tue, 11 Dec 2018 08:56:15 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id AE75F5F643; Tue, 11 Dec 2018 08:56:14 +0000 (UTC) Received: from reviews.apache.org (unknown [10.41.0.12]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 16E7AE0104; Tue, 11 Dec 2018 08:56:14 +0000 (UTC) Received: from reviews-vm2.apache.org (localhost [IPv6:::1]) by reviews.apache.org (ASF Mail Server at reviews-vm2.apache.org) with ESMTP id E4388C4022F; Tue, 11 Dec 2018 08:56:13 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============0936409607699368608==" MIME-Version: 1.0 Subject: Review Request 69549: RANGER-2234 : Cannot add or update a child row, a foreign key constraint fails when installing ranger-admin From: Akash Pawale To: bhavik patel , Nitin Galave , Haihui Xu , Mehul Parikh , Gautam Borad , Velmurugan Periasamy , Pradeep Agrawal , Ankita Sinha , Madhan Neethiraj Cc: Akash Pawale , ranger Date: Tue, 11 Dec 2018 08:56:13 -0000 Message-ID: <20181211085613.19675.95986@reviews-vm2.apache.org> X-ReviewBoard-URL: https://reviews.apache.org/ Auto-Submitted: auto-generated Sender: Akash Pawale X-ReviewGroup: ranger X-Auto-Response-Suppress: DR, RN, OOF, AutoReply X-ReviewRequest-URL: https://reviews.apache.org/r/69549/ X-Sender: Akash Pawale Reply-To: Akash Pawale X-ReviewRequest-Repository: ranger --===============0936409607699368608== MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit ----------------------------------------------------------- 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 --===============0936409607699368608==--