Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13299

0 rows affected on delete in galera cluster that actually deletes data

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.1.25
    • N/A
    • Galera
    • Seen in multiple environments - a dockerized environment is provided for verification and test

    Description

      I know that writes on multiple galera nodes should be avoided or handled with care, but I've seen that simultanious deletes can result in "0 rows affected" even tough the delete is executed on the cluster and probably as a result of the result, the query is not written to the binary logs (setup to row based replication).

      It seems wrong that a result of a query can be "0 rows affected" and nothing written to binlogs when it actually deletes data - it should result in an error somehow so the application can handle it.

      I've created a simple docker setup with 3 nodes, a bash script to start it up and a bash script to run the query to make it fail...

      https://github.com/anderskvist/galera-debug

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            anderskvist Anders Kvist
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.