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

RESET SLAVE ALL resets `master_ssl_verify_server_cert` to wrong default

    XMLWordPrintable

Details

    • Unexpected results

    Description

      # have_show_slave_status
      		 
      CHANGE MASTER TO master_host='localhost', master_user='root';
      		 
       
      		 
      #=> Yes
      		 
      SELECT Master_SSL_Verify_Server_Cert FROM information_schema.slave_status;
      		 
       
      		 
      RESET SLAVE ALL;
      		 
      CHANGE MASTER TO master_host='localhost', master_user='root';
      		 
       
      		 
      #=> No
      		 
      SELECT Master_SSL_Verify_Server_Cert FROM information_schema.slave_status;

      This is visible from MDEV-38497's patch, which (re)sets the option to the wrong value.
      Named connections are not affected, as they were not in MDEV-38497 either.

      Moreover, the patch also shows it (re)setting master_ssl and master_ssl_verify_server_cert with a literal value rather than the defaults added in MDEV-28302.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38497 RESET SLAVE ALL doesn't remove all slave related configurations

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-28302 Configurable defaults for MASTER_SSL_* settings for CHANGE MASTER

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          split from

          Task - A task that needs to be done. MDEV-38972 Refactor MDEV-37530 and MDEV-28302 to Use Internal Data Structures

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            People

              ParadoxV5 Jimmy Hú
              ParadoxV5 Jimmy Hú
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0.5d Original Estimate - 0.5d
                  0.5d
                  Remaining:
                  Time Spent - 50m Remaining Estimate - 0.5d
                  0.5d
                  Logged:
                  Time Spent - 50m Remaining Estimate - 0.5d
                  50m

                  Git Integration

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