Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5684

columstore package can not be removed after minor upgrade

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 23.10.1
    • installation
    • None
    • Debians

    Description

      1. Configure ES repository for 10.6.16-11

      sudo ./mariadb_es_repo_setup --mariadb-server-version=10.6.16-11 --skip-maxscale --skip-tools --token=<enterpriseToken> --apply
      

      2. install all packages

      export  DEBIAN_FRONTEND=noninteractive; sudo -E apt-get -q -o Dpkg::Options::=--force-confold -o Dpkg::Options::=--force-confdef -y --force-yes install  -t "o=MariaDB Enterprise" mariadb-plugin-columnstore mariadb-plugin-cracklib-password-check mariadb-plugin-gssapi-client mariadb-plugin-gssapi-server mariadb-plugin-rocksdb mariadb-plugin-spider mariadb-backup mariadb-plugin-s3 mariadb-client mariadb-common mariadb-server libmariadb-dev libmariadb3 libmariadbclient18 libmysqlclient18 mysql-common
      
      

      3. Configure 10.6.17-12 CI repo

       
      deb      https://<user>:<password>@mdbe-ci-repo.mariadb.net/MariaDBEnterprise/10.6-enterprise-249b7e2a0440ae1eb3ba14c607bdb61393bd464e/apt jammy main
      

      4. Upgrade packages

      export  DEBIAN_FRONTEND=noninteractive; sudo -E apt-get -q -o Dpkg::Options::=--force-confold -o Dpkg::Options::=--force-confdef -y --force-yes install  -t "o=MariaDB Enterprise" mariadb-plugin-columnstore mariadb-plugin-cracklib-password-check mariadb-plugin-gssapi-client mariadb-plugin-gssapi-server mariadb-plugin-rocksdb mariadb-plugin-spider mariadb-backup mariadb-plugin-s3 mariadb-client mariadb-common mariadb-server libmariadb-dev libmariadb3 libmariadbclient18 libmysqlclient18 mysql-common
      
      

      5. Try to remove Mariadb

      sudo apt remove mariadb-*
      

      Removing fails:

      (Reading database ... 81275 files and directories currently installed.)
      Removing libmariadb-dev (1:10.6.17.12+maria~ubu2204) ...
      Removing mariadb-backup (1:10.6.17.12+maria~ubu2204) ...
      Removing mariadb-client (1:10.6.17.12+maria~ubu2204) ...
      Removing mariadb-plugin-columnstore (1:10.6.17.12-23.10.1+maria~ubu2204) ...
       
      MariaDB Columnstore uninstall completed
      Could not execute systemctl:  at /usr/bin/deb-systemd-invoke line 142.
      dpkg: error processing package mariadb-plugin-columnstore (--remove):
       installed mariadb-plugin-columnstore package post-removal script subprocess returned error exit status 1
      dpkg: too many errors, stopping
      Errors were encountered while processing:
       mariadb-plugin-columnstore
      Processing was halted because there were too many errors.
      E: Sub-process /usr/bin/dpkg returned an error code (1)
      
      

      It looks like ` deb-systemd-invoke restart mariadb.service ` in the `postrm ` script fails

      The server start fails due to:

      Mar  8 19:21:58 build mariadbd[27403]: 2024-03-08 19:21:58 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'columnstore_use_import_for_batchinsert=ON'
      Mar  8 19:21:58 build mariadbd[27403]: 2024-03-08 19:21:58 0 [ERROR] Aborting
      

      The file /etc/mysql/mariadb.conf.d/columnstore.cnf exists and contains unsupported variable.

      Attachments

        Activity

          People

            drrtuy Roman
            tturenko Timofey Turenko
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.