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

CREATE INDEX on temporary table breaks replication slaves

Details

    Description

      This is a duplicate of MDEV-14118.

      This is NOT a duplicate of MDEV-9266.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          GerMalaz Gerardo Malazdrewicz created issue -
          GerMalaz Gerardo Malazdrewicz added a comment -

          If you close this one, please reopen MDEV-14118, add 10.3.18 as affected version.

          GerMalaz Gerardo Malazdrewicz added a comment - If you close this one, please reopen MDEV-14118 , add 10.3.18 as affected version.
          GerMalaz Gerardo Malazdrewicz added a comment -

          Despite what MDEV-14118 says, though, this happened:

          Error 'Table 'database.temp_table' doesn't exist' on query. Default database: 'database'. Query: 'ALTER TABLE temp_table ADD index x (id)'

          This a mysql5.5 -> mariadb 10.3.18 -> mariadb 10.3.18, it fails when mariadb is the master but not when mysql is the master.

          GerMalaz Gerardo Malazdrewicz added a comment - Despite what MDEV-14118 says, though, this happened: Error 'Table 'database.temp_table' doesn't exist' on query. Default database: 'database'. Query: 'ALTER TABLE temp_table ADD index x (id)' This a mysql5.5 -> mariadb 10.3.18 -> mariadb 10.3.18, it fails when mariadb is the master but not when mysql is the master.
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Assignee Alice Sherepa [ alice ]
          alice Alice Sherepa added a comment -

          GerMalaz Is the issue still reproducible on your side? I could not repeat it

          alice Alice Sherepa added a comment - GerMalaz Is the issue still reproducible on your side? I could not repeat it
          alice Alice Sherepa made changes -
          Labels need_feedback
          serg Sergei Golubchik made changes -
          Fix Version/s N/A [ 14700 ]
          Resolution Incomplete [ 4 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 103114 ] MariaDB v4 [ 157208 ]

          People

            alice Alice Sherepa
            GerMalaz Gerardo Malazdrewicz
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.