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

mariabackup failed if password is passed via environment variable

Details

    Description

      The mariabackup / Galera SST (via mariabackup) failed if password is passed to it (from the Galera SST script) via MYSQL_PWD environment variable.

      An example of a failure, taken from buildbot logs:

      + sudo mysqld_safe --defaults-extra-file=/home/buildbot/node2.cnf --user=mysql
      		 
      ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (111)
      		 
      + sleep 3
      		 
      210401 02:24:22 mysqld_safe Adding '/usr/lib/x86_64-linux-gnu/libjemalloc.so.1' to LD_PRELOAD for mysqld
      		 
      210401 02:24:22 mysqld_safe Logging to '/var/lib/node2/node2.err'.
      		 
      210401 02:24:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/node2
      		 
      + for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
      		 
      + mysql -uroot -prootpass --port=8302 --protocol=tcp -e 'select * from mgc.t1'
      		 
      ERROR 2013 (HY000): Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 104
      		 
      + sleep 3
      		 
      + for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
      		 
      + mysql -uroot -prootpass --port=8302 --protocol=tcp -e 'select * from mgc.t1'
      		 
      ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (111)
      		 
      + sleep 3

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-31809 Automatic SST user account management

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

          Task - A task that needs to be done. MDEV-25356 SST scripts should use the new mariabackup interface

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            jplindst Jan Lindström (Inactive) added a comment -

            I'm ok with this change, note that before pushing bb results need to be checked!

            jplindst Jan Lindström (Inactive) added a comment - I'm ok with this change, note that before pushing bb results need to be checked!
            wlad Vladislav Vaintroub added a comment -

            there needs to be a solution that does not involve innobackupex, because it won't live forever.

            wlad Vladislav Vaintroub added a comment - there needs to be a solution that does not involve innobackupex, because it won't live forever.
            sysprg Julius Goryavsky added a comment -

            Fixed and merged for the current revision, a solution that does not use innobackupex will be done separately (so as not to block the current development process)

            sysprg Julius Goryavsky added a comment - Fixed and merged for the current revision, a solution that does not use innobackupex will be done separately (so as not to block the current development process)

            People

              sysprg Julius Goryavsky
              sysprg Julius Goryavsky
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.