Details

    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?

      Attachments

        Activity

          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?

          Talaiyan Shayan Talaiyan added a comment - 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?

          People

            jplindst Jan Lindström (Inactive)
            darkain Vincent Milum Jr
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.