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

Create IS.slave_status table as alias for show replica status command

Details

    Description

      Task is to create the new table in Information schema slave_status that will have same fields as command executed by show slave status.
      Additionally add IS.replica_status as an alias for IS.slave_status and separate test(s).

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35693 Replicate_* fields of Show-Slave-Status display truncated

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is part of

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33856 Alternative Replication Lag Representation via Received/Executed Master Binlog Event Timestamps

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-32172 introspect server's replication settings from SQL stored routines

          • Major - Major loss of function.
          • Closed
          split to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34752 Create alias replica_status for INFORMATION_SCHEMA.slave_status

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            anel Anel Husakovic created issue -
            anel Anel Husakovic made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Brandon Nesterenko [ JIRAUSER48702 ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            anel Anel Husakovic made changes -
            Summary Create IS.replica_status table as alias for show replica status command Create IS.slave_status table as alias for show replica status command
            anel Anel Husakovic made changes -
            Description Task is to create the new table in Information schema {{Replica_status}} that will have same fields as command executed by {{show replica status}}.
            		Task is to create the new table in Information schema {{slave_status}} that will have same fields as command executed by {{show replica status}}.
            anel Anel Husakovic made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ] Anel Husakovic [ anel ]
            anel Anel Husakovic made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            anel Anel Husakovic added a comment -

            bnestere if you can please review [PR 3080](https://github.com/MariaDB/server/pull/3080), I think it is ready?

            anel Anel Husakovic added a comment - bnestere if you can please review [PR 3080] ( https://github.com/MariaDB/server/pull/3080 ), I think it is ready?
            anel Anel Husakovic added a comment -

            Addressed Brandon review, thanks bnestere

            anel Anel Husakovic added a comment - Addressed Brandon review, thanks bnestere
            anel Anel Husakovic made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Brandon Nesterenko [ JIRAUSER48702 ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            anel Anel Husakovic added a comment -

            Added request to have IS.replica_status as alias for IS.slave_status and separate test case for alias table in commit 02f5f26ba7e74b.
            PR addressed all reviews and is ready to be reviewed again.

            anel Anel Husakovic added a comment - Added request to have IS.replica_status as alias for IS.slave_status and separate test case for alias table in commit 02f5f26ba7e74b . PR addressed all reviews and is ready to be reviewed again.
            anel Anel Husakovic made changes -
            Description Task is to create the new table in Information schema {{slave_status}} that will have same fields as command executed by {{show replica status}}.
            		Task is to create the new table in Information schema {{slave_status}} that will have same fields as command executed by {{show slave status}}.
            Additionally add {{IS.replica_status}} as an alias for {{IS.slave_status}} and separate test(s).
            bnestere Brandon Nesterenko made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ] Andrei Elkin [ elkin ]
            bnestere Brandon Nesterenko added a comment -

            Reassigned to Elkin for review, as he is already reviewing and involved in the similar MDEV-32172.

            bnestere Brandon Nesterenko added a comment - Reassigned to Elkin for review, as he is already reviewing and involved in the similar MDEV-32172 .
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4 [ 29301 ]
            ralf.gebhardt Ralf Gebhardt added a comment -

            anel, you are mentioning an alias IS.replica_status for IS.slave_status. Would both views be shown with SHOW TABLES?

            ralf.gebhardt Ralf Gebhardt added a comment - anel , you are mentioning an alias IS.replica_status for IS.slave_status. Would both views be shown with SHOW TABLES?
            serg Sergei Golubchik added a comment -

            done as a part of MDEV-33856

            serg Sergei Golubchik added a comment - done as a part of MDEV-33856
            serg Sergei Golubchik made changes -
            Fix Version/s N/A [ 14700 ]
            Assignee Andrei Elkin [ elkin ] Michael Widenius [ monty ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            bnestere Brandon Nesterenko made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.6.0 [ 29839 ]
            Fix Version/s N/A [ 14700 ]
            ParadoxV5 Jimmy Hú made changes -
            ParadoxV5 Jimmy Hú made changes -

            People

              monty Michael Widenius
              anel Anel Husakovic
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.