[MDEV-21402] sql_safe_updates breaks Galera 4 Created: 2019-12-29  Updated: 2021-04-06  Resolved: 2021-04-06

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.11
Fix Version/s: 10.4.19, 10.5.10

Type: Bug Priority: Major
Reporter: Vincent Milum Jr Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: galera, galera_4, sql_safe_updates
Environment:

FreeBSD mariadb104-server precompiled package


 Description   

Built in Galera 4 cluster management is broken with sql_safe_updates enabled:

2019-12-28  4:00:44 2 [Warning] WSREP: Wsrep_schema::execute_sql() failed, 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
 
SQL: DELETE FROM mysql.wsrep_cluster
 
2019-12-28  4:00:44 2 [Warning] WSREP: Failed to store view

Also, instead of DELETE FROM, shouldn't it be TRUNCATE anyways?

 Comments   
Comment by Shayan Talaiyan [ 2021-04-05 ]

Hello... I've just noticed this error in my logs and came across this bug... Could someone explain what the impact is? Should I disable safe update mode until a fix comes out or is it okay to run with?

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