Skip to content

MariaDB clusters will no longer support exclusive locks #5333

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
iceking2nd opened this issue May 19, 2023 · 4 comments
Closed

MariaDB clusters will no longer support exclusive locks #5333

iceking2nd opened this issue May 19, 2023 · 4 comments
Labels
boost Boost related issue bug Undesired behaviour confirmed Bug is confirm by dev team porting required Requires porting to develop resolved A fixed issue
Milestone
v1.2.25

Comments

@iceking2nd
Copy link

iceking2nd commented May 19, 2023 •
edited
Loading

2023/05/19 22:20:39 - CMDPHP ERROR: A DB Cell Failed!, Error: This version of MariaDB doesn't yet support 'GET_LOCK in cluster (WSREP_ON=ON)'
2023/05/19 22:20:39 - CMDPHP SQL Backtrace: (/graph_json.php[159]:rrdtool_function_graph(), /lib/rrd.php[1307]:boost_graph_cache_check(), /lib/boost.php[387]:boost_process_poller_output(), /lib/boost.php[697]:db_fetch_cell(), /lib/database.php[546]:db_fetch_cell_prepared(), /lib/database.php[568]:db_execute_prepared())

MariaDB version: 10.6.13
Cacti version: 1.2.24
@iceking2nd iceking2nd added bug Undesired behaviour unverified Some days we don't have a clue labels May 19, 2023
@TheWitness
Copy link
Member

Yea, I'm aware. It's really Galera. There really may not be a need these days. But I think there is another way.

@TheWitness
Copy link
Member

TheWitness commented May 19, 2023 •
edited
Loading

As an interim, if you are at >= RRDtool 1.5 and set in the GUI that way, you can remove [GET|RELEASE]_LOCK from the code. Just comment out for now.

@TheWitness TheWitness added confirmed Bug is confirm by dev team and removed unverified Some days we don't have a clue labels Jun 3, 2023
@TheWitness TheWitness added this to the v1.2.25 milestone Jun 3, 2023
TheWitness added a commit that referenced this issue Jun 3, 2023
@TheWitness
Fixing #5333 - MariaDB stopped supporting GET_LOCK in cluster
900356a 
MariaDB stopped supporting GET_LOCK in cluster
@TheWitness
Copy link
Member

This should be resolved now.

@TheWitness TheWitness added resolved A fixed issue boost Boost related issue labels Jun 3, 2023
TheWitness added a commit that referenced this issue Jun 3, 2023
@TheWitness
Fix typo in #5333
87c5618
@TheWitness TheWitness added the porting required Requires porting to develop label Jun 4, 2023
netniV pushed a commit that referenced this issue Jun 12, 2023
@TheWitness @netniV
Fixing #5333 - MariaDB stopped supporting GET_LOCK in cluster
f0e840e 
MariaDB stopped supporting GET_LOCK in cluster
@TheWitness
Copy link
Member

Looks like MariaDB has reverted the change for now.

image

and

image

@netniV netniV changed the title MariaDB stopped supporting GET_LOCK in cluster MariaDB clusters will no longer support exclusive locks Sep 3, 2023
@github-actions github-actions bot locked and limited conversation to collaborators Dec 3, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
boost Boost related issue bug Undesired behaviour confirmed Bug is confirm by dev team porting required Requires porting to develop resolved A fixed issue
Projects
None yet
Milestone
v1.2.25
Development

No branches or pull requests
2 participants
@TheWitness @iceking2nd