[
https://issues.apache.org/jira/browse/RANGER-1694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
peng.jianhua resolved RANGER-1694.
----------------------------------
Resolution: Invalid
> Execute 007-updateBlankPolicyName.sql failed in some mysql environment, which
> will cause ranger-admin start fail.
> -----------------------------------------------------------------------------------------------------------------
>
> Key: RANGER-1694
> URL: https://issues.apache.org/jira/browse/RANGER-1694
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Reporter: peng.jianhua
> Assignee: peng.jianhua
> Labels: patch
>
> Environment:
> mysql Ver 14.14 Distrib 5.5.35, for linux2.6 (x86_64).
> There are following error when installed ranger admin.
> Error executing: CREATE FUNCTION `getTempPolicyCount`(assetId bigint, resId
> bigint) RETURNS int(11) BEGIN DECLARE tempPolicyCount int default 1; DECLARE
> dbResourceId bigint; DECLARE exitLoop int DEFAULT FALSE; DECLARE policyList
> CURSOR FOR SELECT id from x_resource where asset_id = assetId; DECLARE
> CONTINUE HANDLER FOR NOT FOUND SET exitLoop = true; OPEN policyList;
> readPolicy : LOOP FETCH policyList into dbResourceId; IF exitLoop
> THEN set tempPolicyCount = tempPolicyCount + 1;
> LEAVE readPolicy; END IF; IF (resId = dbResourceId) THEN
> LEAVE readPolicy; END IF; set tempPolicyCount =
> tempPolicyCount + 1; END LOOP; CLOSE policyList; RETURN tempPolicyCount; END
> java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or
> READS SQL DATA in its declaration and binary logging is enabled (you *might*
> want to use the less safe log_bin_trust_function_creators variable)
> SQLException : SQL state: HY000 java.sql.SQLException: This function has none
> of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary
> logging is enabled (you *might* want to use the less safe
> log_bin_trust_function_creators variable) ErrorCode: 1418
> Lots of tables are not created in ranger db after installed ranger admin. So
> start ranger admin fail.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
