[MDEV-31483] Add wsrep_mode to disallow GET_LOCK/RELEASE_LOCK/RELEASE_ALL_LOCKS in cluster Created: 2023-06-15 Updated: 2023-10-25 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Affects Version/s: | 10.6 |
| Fix Version/s: | 10.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Jan Lindström | Assignee: | Jan Lindström |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
As documented on https://mariadb.com/kb/en/mariadb-galera-cluster-known-limitations/ these functions are not supported on a cluster. To disable add new wsrep_mode = WSREP_NO_LOCK_FUNCTIONS and if that is enabled error is generated if user tries to use these functions. |
| Comments |
| Comment by Daniel Black [ 2023-06-16 ] |
|
How about replicating the GET_LOCK through the cluster like in an apply/certification way and make the failed certification release the GET_LOCK on those that acquired it? A wsrep_mode to produce an error just sounds like bad user experience, and as we've seen, there is a use case, so lets support it properly. |