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

/usr/sbin/mysqld: unknown variable 'defaults-group-suffix=mysqld1

    XMLWordPrintable

Details

    Description

      I have multiple maria db instance running on a centos 7.7 server (running until last update). After an update, the mysqld_multi did not start anymore (due to a typo that is apparently fixed in code). I updated the code and fixed the typo but one more modification done in the mysqld_multi script prevent the instance to start : the defaults-group-suffix variable.

      Since the update, this variable is added to the start command.

      /usr/bin/mysqld_safe --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --datadir=/var/lib/mysql --server-id=1 --bind-address=0.0.0.0 --max_allowed_packet=64M --log-error=/var/log/mysqld1.log --symbolic-links=0 --defaults-group-suffix=mysqld1
      

      In the error log, I have:

      [ERROR] /usr/sbin/mysqld: unknown variable 'defaults-group-suffix=mysqld1'
      

      The only way to have my instances up, is to comment out the following code:

       if (!$suffix_found)
          {
            $com.= " --defaults-group-suffix=";
            $com.= $groups[$i];
          }
      

      This is not a real good solution

      Thx for helping.

      Attachments

        1. mysqld_multi.sh
          24 kB
          Julius Goryavsky
        2. mysqld_safe.sh
          30 kB
          Julius Goryavsky

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky
              venizia03 Venizia
              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.