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

Test Mulitnode Upgrade from 6.x & 22.08 to 23.10.1 (Centos7 & Rocky 8)

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • N/A
    • installation
    • None
    • Multi node upgrade test

    Attachments

      Activity

        susil.behera Susil Behera added a comment -

        I followed the below page to perform upgrade,
        https://mariadb.com/docs/columnstore/service-management/upgrades/enterprise-columnstore/multi-node/from-6-23-10/

        Rocky Linux 8>
        1. 22.08.x -> 23.10.1
        Upgrade successful

        2. 6.x -> 23.10.1
        Upgrade saw the following errors on each node,

        Running transaction
        Preparing : 1/1
        Running scriptlet: MariaDB-shared-10.6.15_10-1.el8.x86_64 1/1
        Running scriptlet: MariaDB-shared-10.6.15_10-1.el8.x86_64 1/12
        Upgrading : MariaDB-shared-10.6.15_10-1.el8.x86_64 1/12
        Running scriptlet: MariaDB-shared-10.6.15_10-1.el8.x86_64 1/12
        Running scriptlet: MariaDB-common-10.6.15_10-1.el8.x86_64 2/12
        Upgrading : MariaDB-common-10.6.15_10-1.el8.x86_64 2/12
        Running scriptlet: MariaDB-common-10.6.15_10-1.el8.x86_64 2/12
        Running scriptlet: MariaDB-client-10.6.15_10-1.el8.x86_64 3/12
        Upgrading : MariaDB-client-10.6.15_10-1.el8.x86_64 3/12
        Running scriptlet: MariaDB-client-10.6.15_10-1.el8.x86_64 3/12
        Running scriptlet: MariaDB-server-10.6.15_10-1.el8.x86_64 4/12
        Upgrading : MariaDB-server-10.6.15_10-1.el8.x86_64 4/12
        Running scriptlet: MariaDB-server-10.6.15_10-1.el8.x86_64 4/12
        Running scriptlet: MariaDB-columnstore-engine-10.6.15_10_23.10.1-1.el8.x86_64 5/12
        ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2)

        Mariab Columnstore uninstall completed

        Upgrading : MariaDB-columnstore-engine-10.6.15_10_23.10.1-1.el8.x86_64 5/12
        Running scriptlet: MariaDB-columnstore-engine-10.6.15_10_23.10.1-1.el8.x86_64 5/12
        checking for engine columnstore...
        columnstore exists
        Populating the engine initial system catalog.
        Failed to start mariadb-columnstore.service: Unit mariadb-columnstore.service is masked.

        First error:
        https://jira.mariadb.org/browse/MCOL-5657
        Second error/failure workaround:
        sudo systemctl unmask mariadb-columnstore

        susil.behera Susil Behera added a comment - I followed the below page to perform upgrade, https://mariadb.com/docs/columnstore/service-management/upgrades/enterprise-columnstore/multi-node/from-6-23-10/ Rocky Linux 8> 1. 22.08.x -> 23.10.1 Upgrade successful 2. 6.x -> 23.10.1 Upgrade saw the following errors on each node, Running transaction Preparing : 1/1 Running scriptlet: MariaDB-shared-10.6.15_10-1.el8.x86_64 1/1 Running scriptlet: MariaDB-shared-10.6.15_10-1.el8.x86_64 1/12 Upgrading : MariaDB-shared-10.6.15_10-1.el8.x86_64 1/12 Running scriptlet: MariaDB-shared-10.6.15_10-1.el8.x86_64 1/12 Running scriptlet: MariaDB-common-10.6.15_10-1.el8.x86_64 2/12 Upgrading : MariaDB-common-10.6.15_10-1.el8.x86_64 2/12 Running scriptlet: MariaDB-common-10.6.15_10-1.el8.x86_64 2/12 Running scriptlet: MariaDB-client-10.6.15_10-1.el8.x86_64 3/12 Upgrading : MariaDB-client-10.6.15_10-1.el8.x86_64 3/12 Running scriptlet: MariaDB-client-10.6.15_10-1.el8.x86_64 3/12 Running scriptlet: MariaDB-server-10.6.15_10-1.el8.x86_64 4/12 Upgrading : MariaDB-server-10.6.15_10-1.el8.x86_64 4/12 Running scriptlet: MariaDB-server-10.6.15_10-1.el8.x86_64 4/12 Running scriptlet: MariaDB-columnstore-engine-10.6.15_10_23.10.1-1.el8.x86_64 5/12 ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock' (2) Mariab Columnstore uninstall completed Upgrading : MariaDB-columnstore-engine-10.6.15_10_23.10.1-1.el8.x86_64 5/12 Running scriptlet: MariaDB-columnstore-engine-10.6.15_10_23.10.1-1.el8.x86_64 5/12 checking for engine columnstore... columnstore exists Populating the engine initial system catalog. Failed to start mariadb-columnstore.service: Unit mariadb-columnstore.service is masked. First error: https://jira.mariadb.org/browse/MCOL-5657 Second error/failure workaround: sudo systemctl unmask mariadb-columnstore
        susil.behera Susil Behera added a comment - - edited

        Rocky Linux 8>
        3. 23.02 -> 23.10.1
        Upgrade successful after switching to cmapi-23.10.1-1 from the included cmapi-23.02.4-1

        susil.behera Susil Behera added a comment - - edited Rocky Linux 8> 3. 23.02 -> 23.10.1 Upgrade successful after switching to cmapi-23.10.1-1 from the included cmapi-23.02.4-1
        susil.behera Susil Behera added a comment -

        CentOS 7>
        4. 22.08.x -> 23.10.1
        Upgrade successful

        5. 6.x -> 23.10.1
        Upgrade saw the errors as in (#2) on each node,

        susil.behera Susil Behera added a comment - CentOS 7> 4. 22.08.x -> 23.10.1 Upgrade successful 5. 6.x -> 23.10.1 Upgrade saw the errors as in (#2) on each node,

        People

          susil.behera Susil Behera
          msnijjar Manjinder Nijjar (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          3 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.