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

Refresh user database fail:[ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

    XMLWordPrintable

Details

    Description

      Hello Team,

      I have taken user database backup in /bd/sybase/mariadb-10.2.15-linux-x86_64 version.

      Trying to load it into /local/data/mariadb-10.3.8-rhel-6-x86_64.

      prepare statement is failing with below error.

      Please advise.

      bash-4.1$ mariabackup --prepare --export --target-dir=/bd/sybase/backup --user=root --socket=/tmp/mysqld.sock --databases=Events --password=Happy1234
      mariabackup based on MariaDB server 10.3.8-MariaDB Linux (x86_64)
      mariabackup: auto-enabling --innodb-file-per-table due to the --export option
      mariabackup: cd to /bd/sybase/backup/
      mariabackup: This target seems to be already prepared.
      mariabackup: using the following InnoDB configuration for recovery:
      mariabackup: innodb_data_home_dir = .
      mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
      mariabackup: innodb_log_group_home_dir = .
      mariabackup: Starting InnoDB instance for recovery.
      mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
      2018-07-12 6:00:13 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2018-07-12 6:00:13 0 [Note] InnoDB: Uses event mutexes
      2018-07-12 6:00:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2018-07-12 6:00:13 0 [Note] InnoDB: Number of pools: 1
      2018-07-12 6:00:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2018-07-12 6:00:13 0 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
      2018-07-12 6:00:13 0 [Note] InnoDB: Completed initialization of buffer pool
      2018-07-12 6:00:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      Last binlog file , position 0
      Prepare export : executing "/local/data/mariadb-10.3.8-rhel-6-x86_64/bin/mariabackup" --mysqld --defaults-file=./backup-my.cnf --defaults-group-suffix= --datadir=. --innodb --innodb-fast-shutdown=0 --innodb_purge_rseg_truncate_frequency=1 --innodb-buffer-pool-size=104857600 --console --log-error= --bootstrap < mariabackup_prepare_for_export.sql
      2018-07-12 6:00:13 0 [Note] mysqld (mysqld 10.3.8-MariaDB) starting as process 4803 ...
      2018-07-12 6:00:13 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)
      2018-07-12 6:00:13 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
      2018-07-12 6:00:13 0 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
      2018-07-12 6:00:13 0 [ERROR] Aborting

      With regards,
      Kiran Kumar

      Attachments

        Activity

          People

            Unassigned Unassigned
            kiranyr85 Kiran
            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.