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

Executing replace into select using multiple DB results to deadlock

        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.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    nirbhay_c Nirbhay Choubey
                    Reporter:
                    chandra.kuntal Kuntal Chandra
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: