MySQL master-slave problem Errorno 1519, 1418

Background: The Lord never added monitoring, after a few days just found master and slave has been hanging for several days, show slave status \g; See both SQL and IO processes as no

Detailed error message:

[ERROR] Slave I/o: Relay log write failure:could not queue event from master, error_code:1595

Binlog Card on POS 122

View the SQL statements for the main library binlog and post, showing:

/*!50530 SET @ @SESSION. pseudo_slave_mode=1*/;
/*!50003 SET @[email protected] @COMPLETION_TYPE, completion_type=0*/;
DELIMITER/*!*/;
# at 4
#151022 17:59:23 Server ID end_log_pos 122 CRC32 0xb21fd3a8 Start:binlog v 4, Server v 5.7.6-m16-log created 151022 17 : 59:23
# Warning:this Binlog is either on use or was not closed properly.
BINLOG '
E7movg8kaaaadgaaahoaaaabaaqans43ljytbte2lwxvzwaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
Aaaaaaaaaaaaaaaaaaaaaaaaezgnaagaegaebaqeegaaxgaegggaaaaicagcaaaacgokkioaejub
qnmfsg==
‘/*!*/;
# at 122
#151022 17:59:23 Server ID end_log_pos 153 CRC32 0x4db53c0f Previous-gtids
# [Empty]
# at 153

Workaround: Modify the Binlog and Pos from the library, direct post to 153, after the boot IO process succeeds.

SQL Process error: fault code 1418

Detailed Error:

[ERROR] Slave Sql:error ' This function has none of the deterministic, NO SQL, or READS SQL DATA in its declaration and binary logging is Ena
Bled (you *might* want to use the less safe log_bin_trust_function_creators variable) ' on query. Default database: ' billplatmp '. Query: ' CREATE definer= ' ydhlpay ' @ '% ' F
Unction ' Currval ' (seq_name VARCHAR) RETURNS Int (11)
BEGIN
DECLARE value INTEGER;
SET value = 0;
SELECT Current_value into value
From sequence
WHERE name = Seq_name;
RETURN value;
END ', error_code:1418
2015-10-22t03:23:19.401095z 5 [Warning] slave:this function have none of deterministic, NO SQL, or READS SQL DATA in its D Eclaration and binary logging is enabled (you
*might* want to use the less safe log_bin_trust_function_creators variable) error_code:1418

For query reasons, for no creation of function or stored procedure permissions from the library, the configuration file is incremented:

Log-bin-trust-function-creators=1

Successful after startup

MySQL master-slave problem Errorno 1519, 1418