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

package upgrade

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 23.10.0
    • 23.10.2
    • N/A
    • None
    • 2025-1

    Description

      Upgrading just mariadb server related packaged, the upgrade also involved mariadb-plugin-columnstore leaving the mariadb-columnstore old version

      Is expected that all the column store will follow the same version in upgrade or exclude all of them

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          tturenko Timofey Turenko added a comment -

          massimo.disaro could you please describe all the steps to reproduce the problem?

          tturenko Timofey Turenko added a comment - massimo.disaro could you please describe all the steps to reproduce the problem?
          massimo.disaro Massimo added a comment -

          tturenko we have been told the mariadb-plugin-columnstore should have follow the mariadb server version. If you have mariadb-plugin-columnstore installed and you upgrade the mariadb-server packaged the mariadb-plugin-columnstore remain the old one. this is happening with ubuntu packages apt

          massimo.disaro Massimo added a comment - tturenko we have been told the mariadb-plugin-columnstore should have follow the mariadb server version. If you have mariadb-plugin-columnstore installed and you upgrade the mariadb-server packaged the mariadb-plugin-columnstore remain the old one. this is happening with ubuntu packages apt
          massimo.disaro Massimo added a comment -

          julien.fritsch can we reopen this?

          massimo.disaro Massimo added a comment - julien.fritsch can we reopen this?
          massimo.disaro Massimo added a comment -

          the aspect behavior is if CS need to follow the server version and is installed, also that packages should be updated as dependency, otherwise it cause draft

          massimo.disaro Massimo added a comment - the aspect behavior is if CS need to follow the server version and is installed, also that packages should be updated as dependency, otherwise it cause draft
          leonid.fedorov Leonid Fedorov added a comment -

          tturenko AFAIR all the issue was about missing package in proper repo, can we close it?

          leonid.fedorov Leonid Fedorov added a comment - tturenko AFAIR all the issue was about missing package in proper repo, can we close it?
          tturenko Timofey Turenko added a comment -

          massimo.disaro Could you please give the exact scenario: from which version are you trying to upgrade? What is the version after upgrade? Also, what do you mean by "server version" and "columnstore version"?

          The dependency is defined in the package. E.g.:

          $ dpkg -I /var/cache/apt/archives/mariadb-plugin-columnstore_1%3a10.6.20.16-23.10.3+maria~deb12_amd64.deb  | grep Depends
          		 
           Depends: binutils, libjemalloc1 | libjemalloc2, libsnappy1v5 (>= 1.1.9), liblz4-1 (>= 0.0~r130), mariadb-server (= 1:10.6.20.16+maria~deb12), libmariadb3 (= 1:10.6.20.16+maria~deb12), net-tools, python3, procps, libc6 (>= 2.35), libcurl4 (>= 7.16.2), libncurses6 (>= 6), libpcre2-8-0 (>= 10.22), libssl3 (>= 3.0.0), libstdc++6 (>= 12), libtinfo6 (>= 6), libxml2 (>= 2.7.4), zlib1g (>= 1:1.1.4)

          So, if the server is upgraded from, e.g. 10.6.19-15 to 10.6.20-16 the mariadb-plugin-columnstore also will be upgraded to 10.6.20-16. But if the Columnstore package is 10.6.20-16_23.02.2, it won't be upgraded to 10.6.20-16_23.10.3 because apt does not care about anything after 10.6.20-16

          tturenko Timofey Turenko added a comment - massimo.disaro Could you please give the exact scenario: from which version are you trying to upgrade? What is the version after upgrade? Also, what do you mean by "server version" and "columnstore version"? The dependency is defined in the package. E.g.: $ dpkg -I /var/cache/apt/archives/mariadb-plugin-columnstore_1%3a10.6.20.16-23.10.3+maria~deb12_amd64.deb | grep Depends Depends: binutils, libjemalloc1 | libjemalloc2, libsnappy1v5 (>= 1.1.9), liblz4-1 (>= 0.0~r130), mariadb-server (= 1:10.6.20.16+maria~deb12), libmariadb3 (= 1:10.6.20.16+maria~deb12), net-tools, python3, procps, libc6 (>= 2.35), libcurl4 (>= 7.16.2), libncurses6 (>= 6), libpcre2-8-0 (>= 10.22), libssl3 (>= 3.0.0), libstdc++6 (>= 12), libtinfo6 (>= 6), libxml2 (>= 2.7.4), zlib1g (>= 1:1.1.4) So, if the server is upgraded from, e.g. 10.6.19-15 to 10.6.20-16 the mariadb-plugin-columnstore also will be upgraded to 10.6.20-16. But if the Columnstore package is 10.6.20-16_23.02.2, it won't be upgraded to 10.6.20-16_23.10.3 because apt does not care about anything after 10.6.20-16
          allen.herrera Allen Herrera added a comment -

          Not sure where the issue is, i did my best to reproduce from the customer ticket upgrade 10.6.16-11 to 10.6.19-15 on ubuntu 22.04.
          It worked for me, closing the ticket. If reopening, please be very clear what is wrong and steps to reproduce

          Reproduction:

          wget https://raw.githubusercontent.com/mariadb-corporation/mariadb-columnstore-engine/develop/cmapi/scripts/cs_package_manager.sh; chmod +x cs_package_manager.sh;
          		 
          bash cs_package_manager.sh install enterprise 10.6.16-11 --token xxxxxxx
          		 
          mariadb -e "show status like '%Columnstore%';"
          		 
          # | Columnstore_commit_hash | source  |
          		 
          # | Columnstore_version     | 23.10.0 |
          		 
           
          		 
          wget https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup ;chmod +x mariadb_es_repo_setup;  
          ./mariadb_es_repo_setup --token="xxxxxxxxx" --apply --mariadb-server-version="10.6.19-15"
          		 
          apt --installed list | grep -i Maria | grep -i columnstore
          		 
          # mariadb-columnstore-cmapi/now 23.10.0 amd64 [installed,local]
          		 
          # mariadb-plugin-columnstore/now 1:10.6.16.11-23.10.0+maria~ubu2204 amd64 [installed,upgradable to: 1:10.6.19.15-23.10.2+maria~ubu2204]
          		 
          systemctl stop mariadb
          		 
          apt install mariadb-server mariadb-common mariadb-client mariadb-backup
          		 
          # The following packages will be upgraded:
          		 
          #     libmariadb3 mariadb-client-10.6 mariadb-client-core-10.6 mariadb-common mariadb-plugin-columnstore mariadb-server mariadb-server-10.6 mariadb-server-core-10.6
          		 
          Which services should be restarted? 1,2,3,4,5,6
          		 
           
          		 
          mariadb -e "show status like '%Columnstore%';"
          		 
          # +-------------------------+---------+
          		 
          # | Variable_name           | Value   |
          		 
          # +-------------------------+---------+
          		 
          # | Columnstore_commit_hash | source  |
          		 
          # | Columnstore_version     | 23.10.2 |
          		 
          # +-------------------------+---------+
          		 
           
          		 
           
          		 
          #Distro: ubuntu
          		 
          # Version: 22
          		 
          # CPU: x86_64
          		 
          # Repository: enterprise
          		 
          # MariaDB:  11.4.3-1     Columnstore: 23.10.2
          		 
          # MariaDB:  11.4.4-2     Columnstore: 23.10.2
          		 
          # MariaDB:  10.6.9-5     Columnstore: 22.08.4
          		 
          # MariaDB:  10.6.11-6    Columnstore: 22.08.8
          		 
          # MariaDB:  10.6.12-7    Columnstore: 23.02.3
          		 
          # MariaDB:  10.6.12-8    Columnstore: 23.02.3
          		 
          # MariaDB:  10.6.14-9    Columnstore: 23.02.9
          		 
          # MariaDB:  10.6.15-10   Columnstore: 23.10.0
          		 
          # MariaDB:  10.6.16-11   Columnstore: 23.10.0
          		 
          # MariaDB:  10.6.17-12   Columnstore: 23.10.1
          		 
          # MariaDB:  10.6.17-13   Columnstore: 23.10.1
          		 
          # MariaDB:  10.6.18-14   Columnstore: 23.10.2
          		 
          # MariaDB:  10.6.19-15   Columnstore: 23.10.2
          		 
          # MariaDB:  10.6.20-16   Columnstore: 23.10.3

          allen.herrera Allen Herrera added a comment - Not sure where the issue is, i did my best to reproduce from the customer ticket upgrade 10.6.16-11 to 10.6.19-15 on ubuntu 22.04. It worked for me, closing the ticket. If reopening, please be very clear what is wrong and steps to reproduce Reproduction: wget https: //raw.githubusercontent.com/mariadb-corporation/mariadb-columnstore-engine/develop/cmapi/scripts/cs_package_manager.sh; chmod +x cs_package_manager.sh; bash cs_package_manager.sh install enterprise 10.6 . 16 - 11 --token xxxxxxx mariadb -e "show status like '%Columnstore%';" # | Columnstore_commit_hash | source | # | Columnstore_version | 23.10 . 0 |   wget https: //dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup ;chmod +x mariadb_es_repo_setup; ./mariadb_es_repo_setup --token= "xxxxxxxxx" --apply --mariadb-server-version= "10.6.19-15" apt --installed list | grep -i Maria | grep -i columnstore # mariadb-columnstore-cmapi/now 23.10 . 0 amd64 [installed,local] # mariadb-plugin-columnstore/now 1 : 10.6 . 16.11 - 23.10 . 0 +maria~ubu2204 amd64 [installed,upgradable to: 1 : 10.6 . 19.15 - 23.10 . 2 +maria~ubu2204] systemctl stop mariadb apt install mariadb-server mariadb-common mariadb-client mariadb-backup # The following packages will be upgraded: # libmariadb3 mariadb-client- 10.6 mariadb-client-core- 10.6 mariadb-common mariadb-plugin-columnstore mariadb-server mariadb-server- 10.6 mariadb-server-core- 10.6 Which services should be restarted? 1 , 2 , 3 , 4 , 5 , 6   mariadb -e "show status like '%Columnstore%';" # +-------------------------+---------+ # | Variable_name | Value | # +-------------------------+---------+ # | Columnstore_commit_hash | source | # | Columnstore_version | 23.10 . 2 | # +-------------------------+---------+     #Distro: ubuntu # Version: 22 # CPU: x86_64 # Repository: enterprise # MariaDB: 11.4 . 3 - 1 Columnstore: 23.10 . 2 # MariaDB: 11.4 . 4 - 2 Columnstore: 23.10 . 2 # MariaDB: 10.6 . 9 - 5 Columnstore: 22.08 . 4 # MariaDB: 10.6 . 11 - 6 Columnstore: 22.08 . 8 # MariaDB: 10.6 . 12 - 7 Columnstore: 23.02 . 3 # MariaDB: 10.6 . 12 - 8 Columnstore: 23.02 . 3 # MariaDB: 10.6 . 14 - 9 Columnstore: 23.02 . 9 # MariaDB: 10.6 . 15 - 10 Columnstore: 23.10 . 0 # MariaDB: 10.6 . 16 - 11 Columnstore: 23.10 . 0 # MariaDB: 10.6 . 17 - 12 Columnstore: 23.10 . 1 # MariaDB: 10.6 . 17 - 13 Columnstore: 23.10 . 1 # MariaDB: 10.6 . 18 - 14 Columnstore: 23.10 . 2 # MariaDB: 10.6 . 19 - 15 Columnstore: 23.10 . 2 # MariaDB: 10.6 . 20 - 16 Columnstore: 23.10 . 3

          People

            tturenko Timofey Turenko
            massimo.disaro Massimo
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.