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

Executing replace into select using multiple DB results to deadlock

    XMLWordPrintable

Details

    Description

      Is replace insert into query using multiple database supported in galera cluster? I'm getting Deadlock message.

      The query works on a single server, but doesn't work in individual node behind galera cluster.

      Query and all details are posted here http://stackoverflow.com/questions/30094558/executing-mysql-replace-into-select-using-multiple-db-results-to-deadlock

      I'm not quite sure if its a bug or due to cluster-level optimistic concurrency control Galera works in this way. I'm done with a workaround but not sure if that is the most optimized solution or not. If it's not an intended behavior then please look into it.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            chandra.kuntal Kuntal Chandra
            Votes:
            1 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.