Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.5
-
None
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
- duplicates
-
MDEV-22678 Upgrade from MySQL Community Edition fails with "Plugin 'auth_socket' is not loaded"
- Closed
- is part of
-
MDEV-22322 Percona Server -> Mariadb Upgrades
- Open