ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "peng.jianhua (JIRA)" <j...@apache.org>
Subject [jira] [Created] (RANGER-1694) Execute 007-updateBlankPolicyName.sql failed in some mysql environment, which will cause ranger-admin start fail.
Date Mon, 17 Jul 2017 08:12:00 GMT
peng.jianhua created RANGER-1694:
------------------------------------

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


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)

Mime
View raw message