[MDEV-29755]  Last_SQL_Error "node has dropped from cluster" is misleading and should be removed Created: 2022-10-10  Updated: 2023-05-02

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.5.16
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Rick Pizzi Assignee: Unassigned
Resolution: Unresolved Votes: 4
Labels: None


 Description   

When a galera node is also an async replication replica, and it encounters a replication error (e.g. a duplicate key), the Last_SQL_Error in "show slave status" output is populated with "Node has dropped from cluster", which is misleading.

Node has not dropped from cluster. It's the cluster that has dropped from upstream replication.

I believe that this error should be removed completely and the actual replication error should be reflected in the Last_SQL_Error field of "show slave status", in other words the behaviour should not be changed regardless if the replica is a galera node or not.

Thanks,
Rick


Generated at Thu Feb 08 10:11:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.