[MDEV-27375] upgrade from MariaDB from Ubuntu Focal repo (10.3) to 10.3.22 fails if rocksdb plugin is installed Created: 2021-12-27  Updated: 2023-04-27

Status: Confirmed
Project: MariaDB Server
Component/s: Documentation, Storage Engine - RocksDB, Upgrades
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Timofey Turenko Assignee: Otto Kekäläinen
Resolution: Unresolved Votes: 0
Labels: affects-tests, not-10.5, not-10.6, not-10.7
Environment:

Ubuntu Focal


 Description   

1. install server and rocksdb plugin without configuring any MariaDB repository

sudo apt install mariadb-server mariadb-plugin-rocksdb

2. Remove all MariaDB packages and Galera

sudo apt remove mariadb* galera*

3. Configure 10.4.22 repo

 sudo ./mariadb_repo_setup --apply --mariadb-server-version=10.4.22

4. Try to install server and rocksdb plugin again

sudo apt install mariadb-server mariadb-plugin-rocksdb

Installation fails to to conflict

dpkg: error processing archive /var/cache/apt/archives/mariadb-plugin-rocksdb_1%3a10.4.22+maria~focal_amd64.deb (--unpack):
 
 trying to overwrite '/usr/bin/sst_dump', which is also in package rocksdb-tools 5.17.2-3

At least, it should be documented ("remove rocksdb-tools before upgrade")

 Comments   
Comment by Sergei Golubchik [ 2021-12-28 ]

should be fixed, not documented

Comment by Elena Stepanova [ 2021-12-28 ]

serg

I'm still to double-check it (which is why I've assigned it to myself for now); but my original understanding is that while otto intentionally made MariaDB packaging aware of rocksdb-tools only starting from 10.5 version (see MDEV-14918), the Debian own packaging still pulls it as a dependency even for 10.3.

Why would this intentional discrepancy be in any way beneficial, I don't understand. But now 10.3 and 10.4 are old, hopefully at this point not many users will upgrade from 10.3-from-distro to 10.3/4-from-MariaDB, and anyway cross-grade from distro packages to ours has never been fully supported, certainly not pre-10.5; there was a lot of back-and-forth about it and even some bug reports dismissed on the reason that it's not expected to work. Given all that and remembering how much pain we had fixing rocksdb-tools/sst_dump conflicts even in 10.5+, I would be very hesitant to demand fixing it in 10.3/10.4.

Comment by Elena Stepanova [ 2022-01-24 ]

My vote remains for "don't touch it anymore", but at the end it's Otto's decision, thus assigning.

Generated at Thu Feb 08 09:52:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.