Tuesday, May 9, 2023

MYSQL::Enterprise backup getting failed after cluster dissolve::

ErrorERROR: Unexpected number of rows from MySQL query 'SELECT member_role FROM performance_schema.replication_group_members WHERE member_id=@@server_uuid': got 0, expected == 1.

Anyone experienced this error. MySQL enterprise full backup, differential and incremental backup having this error in the backup log. Please advise any to need to be taken or can we ignore.

=========================================================================

230507 15:35:23 MAIN    INFO: SSL: attempting to use an SSL connection.

230507 15:35:23 MAIN    INFO: Group replication setup detected.

230507 15:35:23 MAIN   ERROR: Unexpected number of rows from MySQL query 'SELECT member_role FROM performance_schema.replication_group_members WHERE member_id=@@server_uuid': got 0, expected == 1.

230507 15:35:23 MAIN WARNING: This backup operation cannot update the backup_history table.

230507 15:35:23 MAIN    INFO: Full Image Backup operation completed successfully.

230507 15:35:23 MAIN    INFO: Backup image created successfully.

230507 15:35:23 MAIN    INFO: Image Path = Z:\DBNAME_PROD_WEEKLY_FULL_BKP\FULL_20230605_220000.img

230507 15:35:23 MAIN    INFO: MySQL binlog position: filename SERVERNAME-bin.001803, position 136791673

230507 15:35:23 MAIN    INFO: GTID_EXECUTED is 08538d8c-ed98-11ea-852d-005056844240:1-1658361,28179efb-72c5-11e4-b496-0050569242d9:1-13995703,29a42f08-7c8e-11ed-969f-005056846111:1-69949262:70421923-70422753,329fcb1a-c0dd-11eb-82b1-005056847352:1-66160,6a6ae23d-183f-11eb-ae83-005056846111:1-114606407:114931406-114935574,ae4d4435-ecbc-11ea-a835-0050568415e0:1-348529,d1f71bf8-c0dd-11eb-82b1-005056847352:1-258121803,d9014b6b-1812-11eb-976b-005056846111:1-292573,dfc8fe40-336a-11ed-a8ea-005056847352:1-48770981

-------------------------------------------------------------

   Parameters Summary         

-------------------------------------------------------------

   Start LSN                  : 13530353956352

   End LSN                    : 13531799802630

-------------------------------------------------------------

mysqlbackup completed OK! with 2 warnings

=========================================================================

Solution:


mysql> SELECT * FROM performance_schema.replication_group_members;

+---------------------------+-----------+-------------+-------------+--------------+-------------+----------------+

| CHANNEL_NAME              | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |

+---------------------------+-----------+-------------+-------------+--------------+-------------+----------------+

| group_replication_applier |           |             |        NULL | OFFLINE      |             |                |

+---------------------------+-----------+-------------+-------------+--------------+-------------+----------------+

1 row in set (0.00 sec)


UNINSTALL PLUGIN GROUP_REPLICATION;

=================================================================

The UNINSTALL PLUGIN GROUP_REPLICATION; command is used in MySQL to uninstall or remove the Group Replication plugin. Group Replication is a MySQL plugin that enables you to create a highly available replication group of MySQL servers. It provides a multi-master replication solution with automatic conflict detection and resolution.

When you execute the UNINSTALL PLUGIN GROUP_REPLICATION; command, it removes the Group Replication plugin from the MySQL server. This means that the server will no longer participate in a Group Replication setup and will not be part of a replication group.

======================================================

mysql> uninstall plugin group_replication;

ERROR 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement

mysql> set global super_read_only=0;

  Query OK, 0 rows affected (0.00 sec)

mysql> uninstall plugin group_replication;

Query OK, 0 rows affected (0.03 sec)

mysql> set global super_read_only=1;

Query OK, 0 rows affected (0.00 sec)

Then backup task started to run successfully.

Here are a few things to keep in mind when using the UNINSTALL PLUGIN GROUP_REPLICATION; command:

  1. Replication Group: Before uninstalling the Group Replication plugin, ensure that the server you're uninstalling from is not an essential member of the replication group. Otherwise, removing the plugin from a member server can disrupt the replication group's functionality.

  2. Backup: Make sure you have a backup of your data or a plan in place to ensure data availability during the uninstallation process. Removing the plugin doesn't affect the data stored on the server, but it's always a good practice to have backups in case of any unexpected issues.

  3. Impact: Uninstalling the Group Replication plugin only affects the specific server where the command is executed. Other servers in the replication group will continue functioning as long as they still have the plugin installed and configured.

No comments:

Post a Comment

MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...