package mariadb-server-core-10.6 1:10.6.11-0ubuntu0.22.04.1 failed to install/upgrade: prøver å skrive over «/usr/bin/my_print_defaults» som også finnes i pakken mariadb-client-core-10.6 1:10.6.9+maria~ubu2004

Bug #1997880 reported by Dag Bjerkeli
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mariadb-10.6 (Ubuntu)
Fix Released
Undecided
Otto Kekäläinen

Bug Description

My Intel-NUC went unresponsive and had to disconnect power to restart. That could have caused the db to fail.

The suggestion for bug report came when I powered the system up again.

ProblemType: Package
DistroRelease: Ubuntu 22.04
Package: mariadb-server-core-10.6 1:10.6.11-0ubuntu0.22.04.1
ProcVersionSignature: Ubuntu 5.15.0-53.59-generic 5.15.64
Uname: Linux 5.15.0-53-generic x86_64
NonfreeKernelModules: nvidia_modeset nvidia
ApportVersion: 2.20.11-0ubuntu82.1
Architecture: amd64
CasperMD5CheckResult: unknown
Date: Thu Nov 24 06:16:38 2022
DuplicateSignature:
 package:mariadb-server-core-10.6:1:10.6.11-0ubuntu0.22.04.1
 Unpacking mariadb-server-core-10.6 (1:10.6.11-0ubuntu0.22.04.1) over (1:10.6.9+maria~ubu2004) ...
 dpkg: error processing archive /var/cache/apt/archives/mariadb-server-core-10.6_1%3a10.6.11-0ubuntu0.22.04.1_amd64.deb (--unpack):
  prøver å skrive over «/usr/bin/my_print_defaults» som også finnes i pakken mariadb-client-core-10.6 1:10.6.9+maria~ubu2004
ErrorMessage: prøver å skrive over «/usr/bin/my_print_defaults» som også finnes i pakken mariadb-client-core-10.6 1:10.6.9+maria~ubu2004
InstallationDate: Installed on 2021-05-10 (563 days ago)
InstallationMedia: Ubuntu 20.04.2.0 LTS "Focal Fossa" - Release amd64 (20210209.1)
Logs.var.log.daemon.log:

Logs.var.log.mysql.error.log:
MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLConf.etc.mysql.mariadb.conf.d.99-enable-encryption.cnf.preset: Error: path was not a regular file.
MySQLVarLibDirListing: ['ddl_recovery-backup.log', 'ib_buffer_pool', 'ibtmp1', 'ibdata1', 'performance_schema', 'multi-master.info', 'aria_log_control', 'sys', 'ddl_recovery.log', 'MOVIES', 'accesslog_check', 'mysql', 'aria_log.00000001', 'mysql_upgrade_info', 'ib_logfile0', 'debian-10.6.flag']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.15.0-53-generic root=UUID=44d491e0-3820-4841-9864-1339621e92bf ro quiet splash pcie_aspm=off vt.handoff=7
Python3Details: /usr/bin/python3.10, Python 3.10.6, python3-minimal, 3.10.6-1~22.04
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.21.1ubuntu2.1
 apt 2.4.8
SourcePackage: mariadb-10.6
Title: package mariadb-server-core-10.6 1:10.6.11-0ubuntu0.22.04.1 failed to install/upgrade: prøver å skrive over «/usr/bin/my_print_defaults» som også finnes i pakken mariadb-client-core-10.6 1:10.6.9+maria~ubu2004
UpgradeStatus: Upgraded to jammy on 2022-08-16 (100 days ago)
modified.conffile..etc.logrotate.d.mysql-server: [deleted]

Revision history for this message
Dag Bjerkeli (dag-e) wrote :
tags: removed: need-duplicate-check
Revision history for this message
Otto Kekäläinen (otto) wrote :

Terminal log says:

```
Preparing to unpack .../mariadb-common_1%3a10.6.11-0ubuntu0.22.04.1_all.deb ...
Unpacking mariadb-common (1:10.6.11-0ubuntu0.22.04.1) over (1:10.6.9+maria~ubu2004) ...
Preparing to unpack .../mariadb-server-core-10.6_1%3a10.6.11-0ubuntu0.22.04.1_amd64.deb ...
Unpacking mariadb-server-core-10.6 (1:10.6.11-0ubuntu0.22.04.1) over (1:10.6.9+maria~ubu2004) ...
dpkg: error processing archive /var/cache/apt/archives/mariadb-server-core-10.6_1%3a10.6.11-0ubuntu0.22.04.1_amd64.deb (--unpack):
 prøver å skrive over «/usr/bin/my_print_defaults» som også finnes i pakken mariadb-client-core-10.6 1:10.6.9+maria~ubu2004
```

The root cause here is that you have packages from MariaDB.org repositories and you mix them with packages from the Ubuntu.com repository (upgrade from 10.6.9+maria~ubu2004 to 10.6.11-0ubuntu0.22.04.1).

That being said it should still survive this scenario of moved files. The odd thing is that my_print_defaults has been in https://github.com/MariaDB/server/blob/10.6/debian/mariadb-client-core-10.6.install since 10.6 series started (https://github.com/MariaDB/server/commit/fc65417e7bcae88f15e1bfcd0ccebf1b06e02fd5) and also in https://salsa.debian.org/mariadb-team/mariadb-server/-/blob/debian/latest/debian/mariadb-client-core-10.6.install since 7 months https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/b2eaeb6c4e84adabf0cd02f876d6b1e27272aca2 and releases in 1:10.6.8-1

Changed in mariadb-10.6 (Ubuntu):
status: New → Confirmed
Revision history for this message
Otto Kekäläinen (otto) wrote :

OK, found it: the fix is not on the ubuntu-22.04 branch, we should cherry-pick it there: https://salsa.debian.org/mariadb-team/mariadb-server/-/blob/ubuntu-22.04/debian/mariadb-client-core-10.6.install

Revision history for this message
Otto Kekäläinen (otto) wrote :
Changed in mariadb-10.6 (Ubuntu):
status: Confirmed → Fix Committed
assignee: nobody → Otto Kekäläinen (otto)
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package mariadb-10.6 - 1:10.6.12-0ubuntu0.22.04.1

---------------
mariadb-10.6 (1:10.6.12-0ubuntu0.22.04.1) jammy-security; urgency=medium

  * New upstream version 10.6.12. Includes fix for a major
    performance/memory consumption issue (MDEV-29988) (LP: #2006882).
  * Move my_print_defaults to MariaDB client core package (LP: #1997880)

 -- Otto Kekäläinen <email address hidden> Thu, 09 Feb 2023 22:57:07 -0800

Changed in mariadb-10.6 (Ubuntu):
status: Fix Committed → Fix Released
To post a comment you must log in.