Bhavik Patel created RANGER-3587:
------------------------------------
Summary: Failed to apply 046*.sql patch
Key: RANGER-3587
URL: https://issues.apache.org/jira/browse/RANGER-3587
Project: Ranger
Issue Type: Bug
Components: admin
Affects Versions: 2.1.0
Reporter: Bhavik Patel
[JISQL] /usr/java/latest/bin/java -cp
/opt/tusker/ranger-admin/ranger-2.1.0-1-admin/ews/lib/mysql-connector-java-5.1.25.jar:/opt/tusker/ranger-admin/ranger-2.1.0-1-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver mysqlconj -cstring
jdbc:mysql://localhost.visa.com/ranger_admin -u 'rangeradmin' -p '********'
-noheader -trim -c \; -input
/opt/tusker/ranger-admin/ranger-2.1.0-1-admin/db/mysql/patches/046-insert-statename-in-x-ranger-global-state.sql
Error executing: CREATE FUNCTION `getXportalUIdByLoginId`(input_val
VARCHAR(100)) RETURNS int(11) BEGIN DECLARE myid INT; SELECT x_portal_user.id
into myid FROM x_portal_user WHERE x_portal_user.login_id = input_val; RETURN
myid; 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
Note: mysql version is 5.7.35
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
