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

Mariadb backup fails to do a backup

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.11
    • None
    • None
    • None
    • Docker

    Description

      I run the following command daily, it used to work well.

      backup_dir=$(date +'%d_%m_%Y_%H_%M');
      mariabackup --backup --target-dir=/var/lib/mysql_backup/${backup_dir}_full/ --user=root --password=*****
      

      The command start and fails with following errors:

      Warning: skipping '!includedir /etc/mysql/conf.d/' directive as maximum includer                 ecursion level was reached in file /etc/mysql/conf.d/mariadb.cnf at line 1
      Warning: skipping '!includedir /etc/mysql/mysql.conf.d/' directive as maximum in                 cluderecursion level was reached in file /etc/mysql/conf.d/mariadb.cnf at line 2
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      Warning: skipping '!includedir /etc/mysql/conf.d/' directive as maximum includer                 ecursion level was reached in file /etc/mysql/conf.d/mariadb.cnf at line 1
      Warning: skipping '!includedir /etc/mysql/mysql.conf.d/' directive as maximum in                 cluderecursion level was reached in file /etc/mysql/conf.d/mariadb.cnf at line 2
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      mariabackup: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 2 "No such f                 ile or directory")
      [00] 2021-12-12 11:34:51 Connecting to MySQL server host: localhost, user: root,                  password: set, port: 3306, socket: /var/run/mysqld/mysqld.sock
      [00] 2021-12-12 11:34:51 Failed to connect to MySQL server: Access denied for us                 er 'root'@'localhost' (using password: YES).
      

      I use mariadb ver: Ver 15.1 Distrib 10.4.11-MariaDB, for debian-linux-gnu (x86_64)

      Which ever command I run in the shell I always get the above error?

      Attachments

        Activity

          People

            Unassigned Unassigned
            ltoshev Любомир Тошев
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.