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

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21039 Server fails to start with mysqld_multi with mysqld_safe options

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18863 Galera SST scripts can't read mysqld_multi's [mysqldN] option groups

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20614 Syntax error, and option put in wrong place, in mysqld_multi perl script

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

          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.