Shulou(Shulou.com)05/31 Report--

MySQL5.7 cluster MGR startup report ERROR 3092 (HY000) what to do, for this problem, this article describes in detail the corresponding analysis and solutions, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

MySQL5.7 version of MGR launch Times:

ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.

View the alarm log:

2020-03-04T07:48:58.797180Z 574478 [Warning] Plugin group_replication reported:'[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'2020-03-04T07:48:58.844857Z 574714 [ERROR] Slave SQL for channel 'group_replication_applier': Error' 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)'on query. Default database:'. Query: 'CREATE DEFINER= `root` @ `192.168.187% `FUNCTION `GetDistance` (`lat1` float, `lng1` float, `lat2` float, `lng2` float) RETURNS floatbegin DECLARE earth_padius float DEFAULT 6378.137; DECLARE radLat1 float DEFAULT 0; DECLARE radLat2 float DEFAULT 0; DECLARE a float DEFAULT 0; DECLARE b float DEFAULT 0; DECLARE s float DEFAULT 0 Set radLat1 = Radian (lat1); set radLat2 = Radian (lat2); set a = radLat1-radLat2; set b = Radian (lng1)-Radian (lng2); set s = 2 * Asin (Sqrt (power (sin (a / 2), 2) + cos (radLat1) * cos (radLat2) * power (sin (b / 2), 2)) Set s = s * earth_padius; set s = Round (s * 10000) / 10000; re2020-03-04T07:48:58.844919Z 574714 [Warning] Slave: 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) Error_code: 14182020-03-04T07:48:58.844938Z 574714 [ERROR] Plugin group_replication reported: 'The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.'2020-03-04T07:48:58.844963Z 574714 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'FIRST' position 0.2020-03-04T07:48:58.844984Z 574711 [ERROR] Plugin group_replication reported:' Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.'2020-03-04T07:48:58.845030Z 574711 [ERROR] Plugin group_replication reported:'[GCS] The member is already leaving or joining a group.'2020-03-04T07:48:58.845073Z 574711 [ERROR] Plugin group_replication reported: 'Unable to confirm whether the server has left the group or not. Check performance_schema.replication_group_members to check group membership information.'2020-03-04T07:49:03.586818Z 0 [ERROR] Plugin group_replication reported: 'There was a previous plugin error while the member joined the group. The member will now exit the group.'2020-03-04T07:57:00.047106Z 574478 [Warning] Plugin group_replication reported:'[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'2020-03-04T07:57:01.992027Z 575211 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.

It can be seen from the contents of the monitoring alarm log that the MGR cluster is offline because the function operation does not comply with the specification. The specific log description is as follows:

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you * mi

Ght* want to use the less safe log_bin_trust_function_creators variable) Error_code: 1418

This kind of problem can be solved from two aspects. The first is for the developer to create a standard-compliant function according to the specification; the second is to configure the database parameters to configure log_bin_trust_function_creators to be turned on.

Here, the developer also chose to configure the log_bin_trust_function_creators parameter to be enabled, but on one node, the other node is not enabled, resulting in the above error message on the other node.

The following is part of the process, for reference only:

Mysql > select * from performance_schema.replication_group_members +-+ | CHANNEL_NAME | | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +-- | -group_replication_applier | 48713421-9261-11e9-9799-005056851cf9 | db2 | 3306 | ERROR | + -+ 1 row in set (0.00 sec) mysql > stop group_replication Query OK, 0 rows affected (1.01 sec) mysql > start group_replication;ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.mysql > show variables like'% func%' +-- +-+ | Variable_name | Value | +-+-+ | log_bin_trust_function_creators | OFF | +- -- +-+ 1 row in set (0.01 sec) mysql > set global log_bin_trust_function_creators=1 Query OK, 0 rows affected (0.00 sec) mysql > show variables like'% func%' +-- +-+ | Variable_name | Value | +-+-+ | log_bin_trust_function_creators | ON | +- -- +-+ 1 row in set (0.00 sec) mysql > stop group_replication Query OK, 0 rows affected (0.00 sec) mysql > start group_replication;Query OK, 0 rows affected (2.90 sec) mysql > select * from performance_schema.replication_group_members +-+ | CHANNEL_NAME | | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +-- | -+-+ | group_replication_applier | 2ff8ea98-9128-11e9-91dd-0819a62578bd | db1 | 3306 | ONLINE | | group_replication_applier | 48713421-9261-11e9-9799-005056851cf9 | db2 | 3306 | ONLINE | | group_replication_applier | 9c245a8c-9262-11e9-82d6-005056853a0e | db3 | 3306 | ONLINE | +- -+-- + 3 rows in set (0.00 sec) mysql > about MySQL5.7 Cluster MGR Startup report ERROR 3092 (HY000) the answer to the question of what to do is shared here. I hope the above content can help you to a certain extent, if you still have a lot of doubts to be solved, you can follow the industry information channel to learn more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.