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

Adding 'port' and 'socket' to primary key in spider tables (install_spider.sql)

    XMLWordPrintable

Details

    Description

      Tables in spider with backend server information (e.g. spider_xa_member) only have host in the primary key.
      That causes problems when a table has two backends with the same host value (but different ports, for example), and the errors it causes can be quite confusing.
      For example, you may get "this xid already exists" due to conflicting entries for two participants of the same XA.
      Adding port/socket to the primary key of these spider tables (in install_spider.sql) should resolve this issue.

      Attachments

        Activity

          People

            ycp Yuchen Pei
            lpacheco Leandro Pacheco (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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