package mariadb-server-10.6 (not installed) failed to install/upgrade: new mariadb-server-10.6 package pre-installation script subprocess returned error exit status 1

[Mohamed Amine R'bia]

problem when install mysql or mariadb

ProblemType: Package
DistroRelease: Ubuntu 22.04
Package: mariadb-server-10.6 (not installed)
ProcVersionSignature: Ubuntu 5.15.0-27.28-generic 5.15.30
Uname: Linux 5.15.0-27-generic x86_64
NonfreeKernelModules: zfs zunicode zavl icp zcommon znvpair
ApportVersion: 2.20.11-0ubuntu82
Architecture: amd64
CasperMD5CheckResult: pass
Date: Tue May 3 00:07:14 2022
ErrorMessage: new mariadb-server-10.6 package pre-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2022-04-26 (6 days ago)
InstallationMedia: Ubuntu 22.04 LTS "Jammy Jellyfish" - Release amd64 (20220419)
Python3Details: /usr/bin/python3.10, Python 3.10.4, python3-minimal, 3.10.4-0ubuntu2
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.21.1ubuntu2
 apt 2.4.5
SourcePackage: mariadb-10.6
Title: package mariadb-server-10.6 (not installed) failed to install/upgrade: new mariadb-server-10.6 package pre-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Daniel Black (daniel-black)]

same as #1970671

[Faustin (fauust)]

Same question as for #1970671, this is not a bug...

[Daniel Black (daniel-black)]

You cannot install MariaDB over an existing MySQL-8.0 installation, purge /var/lib/mysql if the data here is no longer relevant and the install will be possible.