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

Upgrade form Percona XtraDB Cluster 5.7 fails

    XMLWordPrintable

Details

    Description

      I tested upgrading from Percona XtraDB Cluster 5.7 to MariaDB 10.5 head. It fails due to issues in restarting the server. I suspect something is conflicting in the config and that fixing MDEV-19933 (which as had a PR pending for a while) probably sorts this out as well.

      Log https://salsa.debian.org/mariadb-team/mariadb-server/-/jobs/756114:

      Setting up mariadb-server-10.5 (1:10.5.4+maria~sid) ...
       invoke-rc.d: could not determine current runlevel
       Stopping MariaDB database server: mysqld.
       invoke-rc.d: could not determine current runlevel
       Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
       invoke-rc.d: initscript mariadb, action "start" failed.
      

      Steps to reproduce:

      percona-xtradb-5.7 to mariadb-10.5 upgrade:
        stage: upgrade extras
        dependencies:
          - build
        image: debian:buster
        artifacts:
          when: always
          name: "$CI_BUILD_NAME"
          paths:
            - ${WORKING_DIR}/debug
        script:
          - sed -i "s/101/0/g" -i /usr/sbin/policy-rc.d # Enable automatic restarts from maint scripts
          - cd ${WORKING_DIR} # Don't repeat this step, it's just cd ./debian/output
          - apt-get update
          - apt-get install --no-install-recommends --yes gpg gpg-agent dirmngr ca-certificates # Bare minimal (<4MB) for apt-key to work
          - apt-key adv --recv-keys --keyserver hkps://keyserver.ubuntu.com:443 9334A25F8507EFA5
          - echo 'deb https://repo.percona.com/apt/ buster main' > /etc/apt/sources.list.d/mysql.list
          - apt-get update
          - apt-get install -y percona-xtradb-cluster-57
          # Verify installation of MySQL
          - dpkg -l | grep -iE 'maria|mysql|galera'
          - service mysql status
          - mysql --skip-column-names -e "SELECT @@version, @@version_comment"
          - mysql -e "SELECT Host,User,plugin,authentication_string FROM user;" mysql
          - mysql -e "SELECT * FROM plugin;" mysql
          - echo 'SHOW DATABASES;' | mysql
          # Install MariaDB built in this commit
          - sed 's/buster/sid/g' -i /etc/apt/sources.list # Enable next Debian release
          - sed '/sid-updates/d' -i /etc/apt/sources.list # Remove repositories that don't exist for Sid
          - sed '/security/d' -i /etc/apt/sources.list # Remove repositories that don't exist for Sid
          - apt-get update; apt-get install -y apt # Uprade minimal stack first
          - apt-get install -o Dpkg::Options::=--force-confnew -y ./*.deb || true # Allow to proceed so debug artifacts get collected
          # Verify installation of MariaDB built in this commit
          - dpkg -l | grep -iE 'maria|mysql|galera'
          - mariadb --version # Client version
          - service mysql status
          - mkdir -p debug # Ensure dir exists before using it
          - echo 'SHOW DATABASES;' | mariadb # List databases before upgrade are still there
          - mariadb -e "create database test; use test; create table t(a int primary key) engine=innodb; insert into t values (1); select * from t; drop table t; drop database test;" # Test InnoDB works
      

      Attachments

        Issue Links

          Activity

            People

              otto Otto Kekäläinen
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.