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

mysql init script should accept arguments

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.2, 5.5.30, 5.5.29-galera
    • 10.0.4, 5.5.32
    • None
    • None
    • Debian, Ubuntu

    Description

      The /etc/init.d/mysql script does not accept any arguments, even though the "service" tool on those platforms does accept arguments/"OPTIONS" these days. This is particularly problematic in the case of Galera, for example, where you may occasionally need to pass --wsrep-cluster-address=gcomm:// to bootstrap a cluster.

      This issue is very easily resolved by replacing this line:

                  /usr/bin/mysqld_safe > /dev/null 2>&1 &

      with this one:

                  /usr/bin/mysqld_safe "${@:2}" > /dev/null 2>&1 &

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4253 service mysql start --wsrep-cluster-address=gcomm:// does not work

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4508 Ubuntu (possible debian) /etc/init.d/mysql problem

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4253 service mysql start --wsrep-cluster-address=gcomm:// does not work

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            primetomas Tomas Gustavsson added a comment -

            I believe MDEV-4253 is the same issue, the analysis there is the same, i.e. mysql init script does not pass on parameters.

            primetomas Tomas Gustavsson added a comment - I believe MDEV-4253 is the same issue, the analysis there is the same, i.e. mysql init script does not pass on parameters.
            primetomas Tomas Gustavsson added a comment -

            Verified that the patch with:

            /usr/bin/mysqld_safe "${@:2}" > /dev/null 2>&1 &

            works fine.
            Now:
            service mysql start --wsrep-cluster-address=gcomm://

            works great.

            primetomas Tomas Gustavsson added a comment - Verified that the patch with: /usr/bin/mysqld_safe "${@:2}" > /dev/null 2>&1 & works fine. Now: service mysql start --wsrep-cluster-address=gcomm:// works great.
            elenst Elena Stepanova added a comment -

            Not really sure who it should belong to, please reassign if needed.

            It's more generic than MDEV-4253 and I also don't see why not to do it in all init scripts rather than Galera only; but I'm inclined to keep MDEV-4253 open too, and assigned to Seppo, so that he'll make the change in the upstream (codership) version of the script and it won't get lost on the next merge if it again comes as a replacement of the old files.

            elenst Elena Stepanova added a comment - Not really sure who it should belong to, please reassign if needed. It's more generic than MDEV-4253 and I also don't see why not to do it in all init scripts rather than Galera only; but I'm inclined to keep MDEV-4253 open too, and assigned to Seppo, so that he'll make the change in the upstream (codership) version of the script and it won't get lost on the next merge if it again comes as a replacement of the old files.
            elenst Elena Stepanova added a comment -

            Raising the priority due to upcoming 5.5.31-galera release, since it should be easy and safe to fix.
            See also MDEV-4253.

            elenst Elena Stepanova added a comment - Raising the priority due to upcoming 5.5.31-galera release, since it should be easy and safe to fix. See also MDEV-4253 .
            danblack Daniel Black added a comment -

            seems to be fixed
            mariadb-galera-server-5.5 5.5.35+maria-1~wheezy

             fgrep safe /etc/init.d/mysql
            		 
             
            		 
            #                    and its wrapper script "mysqld_safe".
            		 
                        /usr/bin/mysqld_safe "${@:2}" > /dev/null 2>&1 &

            danblack Daniel Black added a comment - seems to be fixed mariadb-galera-server-5.5 5.5.35+maria-1~wheezy fgrep safe /etc/init.d/mysql   # and its wrapper script "mysqld_safe". /usr/bin/mysqld_safe "${@:2}" > /dev/null 2>&1 &

            People

              serg Sergei Golubchik
              kolbe Kolbe Kegel (Inactive)
              Votes:
              1 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.