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

mariabackup restore from columnstore db

    XMLWordPrintable

Details

    Description

      I used mariabackup to backup non-columnstore dbs from from a mariadb 10.1 host that also runs columnstore using --databases-exclude=<columnstore db list>

      After restore, db runs fine but with 10s of errors:
      2020-07-08 5:37:35 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/libcalmysql.so' (errno: 0, libddlpackageproc.so.1: cannot open shared object file: No such file or directory)
      2020-07-08 5:37:35 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/libcalmysql.so' (errno: 0, libddlpackageproc.so.1: cannot open shared object file: No such file or directory)
      2020-07-08 5:37:35 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/is_columnstore_tables.so' (errno: 0, libddlpackageproc.so.1: cannot open shared object file: No such file or directory)
      2020-07-08 5:37:35 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/is_columnstore_columns.so' (errno: 0, libddlpackageproc.so.1: cannot open shared object file: No such file or directory)
      2020-07-08 5:37:35 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/is_columnstore_extents.so' (errno: 0, libddlpackageproc.so.1: cannot open shared object file: No such file or directory)
      2020-07-08 5:37:35 0 [ERROR] mysqld: Can't open shared library '/usr/lib64/mysql/plugin/is_columnstore_files.so' (errno: 0, libddlpackageproc.so.1: cannot open shared object file: No such file or directory)
      2020-07-08 5:37:39 0 [ERROR] Can't open shared library 'libcalmysql.so' (errno: 0, libddlpackageproc.so.1: cannot open shared object file: No such file or directory)

      How can I completely remove columnstore related information from restore dbs to remove these errors?
      Note: There is no columnstore or InfiniDB related plugin on the restored db.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dhillonarvi@gmail.com Arvinder Singh
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.