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

sql_log_bin should be SESSION_ONLY

Details

    Attachments

      Issue Links

        is part of

        Task - A task that needs to be done. MDEV-7344 5.5.41 merge

        • Blocker - Blocks development and/or testing work, production could not run.
        • Closed
        links to

        Web Link Bug #67433 - Using SET GLOBAL SQL_LOG_BIN should not be allowed

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova added a comment - 

          5.5.41/5.6.22 version:
          		 
           
          		 
              The global scope for the sql_log_bin system variable has been
          		 
              deprecated, and this variable can now be set with session scope
          		 
              only. The statement SET GLOBAL SQL_LOG_BIN now produces an
          		 
              error. It remains possible to read the global value of
          		 
              sql_log_bin, but you should act now to remove any dependencies
          		 
              on reading this value from your applications, as the ability to
          		 
              do so will be removed in a future MySQL release.

          elenst Elena Stepanova added a comment - 5.5.41/5.6.22 version:   The global scope for the sql_log_bin system variable has been deprecated, and this variable can now be set with session scope only. The statement SET GLOBAL SQL_LOG_BIN now produces an error. It remains possible to read the global value of sql_log_bin, but you should act now to remove any dependencies on reading this value from your applications, as the ability to do so will be removed in a future MySQL release.
          danblack Daniel Black added a comment -

          updated documentation. This should be done as part of the commit process.

          danblack Daniel Black added a comment - updated documentation. This should be done as part of the commit process.

          People

            serg Sergei Golubchik
            nirbhay_c Nirbhay Choubey (Inactive)
            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.