[MDEV-27202] Critical read error with sync forced mariadb cluster Created: 2021-12-08  Updated: 2021-12-08

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

Type: Bug Priority: Major
Reporter: Oppyjlh Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Debian 10.10



 Description   

Hello,

I'm using 10.5.11-MariaDB on Debian 10.10 with a read-write split router configuration on maxscale.

The mariadb galera cluster nodes have all syncing forced enabled with this parameter:
wsrep_sync_wait=7

That means consistency is enabled on the cluster.

Nevertheless, a critical read error still happens every day in the process of inserting an item and then reading it.

The read fails as if the nodes of the cluster were not synced with the last write.

MariaDB is not finding the just inserted row despite wsrep_sync_wait=7.


Generated at Thu Feb 08 09:51:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.