[debian-mysql] Review request: Salsa-CI update for MariaDB 10.5 in Debian (and useful also upstream)

[Otto Kekäläinen]

> In preparation for 11.4 LTS quality assurance I am running Salsa-CI on all upstream branches 10.5-11.4 at  https://salsa.debian.org/mariadb-team/mariadb-server/-/pipelines:

Summary of current failures is:

## Lintian

Lintian is failing on all branches (10.5/6/11/11.1/2/3/4/5) on error:
    E: mariadb-server: depends-on-obsolete-package Depends: lsb-base
(>= 3.0-10)".

The fix is to simply remove it, as suggested in
https://github.com/MariaDB/server/pull/2467#issuecomment-1409941202
and https://github.com/MariaDB/server/pull/2501#issuecomment-1449483523

## Autopkgtest

Autopkgtest smoke test is failing on branch 11.4 only with error:
  + dpkg-query -W mariadb-plugin-rocksdb
  dpkg-query: no packages found matching mariadb-plugin-rocksdb

Seems mariadb-plugin-rocksdb is missing from build, so test fails on
RocksDB check. It seems to be missing from build as salsa-ci.yml has
"Release: bullseye", which is from
https://github.com/MariaDB/server/commit/ee68fe327290 that has been
merged on all branches despite commit message stating that the change
was for 10.6 only.

## Piuparts

Piuparts is failing on all branches on:
  Adding 'local diversion of /bin/sync to /bin/sync.distrib.usr-is-merged'
  ln: failed to create symbolic link '/bin/sync': File exists

Upstream probably needs to adapt some usr-is-merged changes done in
Debian in 2023/2024.

## Other upgrade tests

Most of the other upgrade tests seem to be failing on fetching Stretch
and Buster packages, as those repos have been archived. Upgrade tests
should either be updated to use archive.debian.org like done in
downstream Debian packaging and proposed in this thread a year ago in
https://salsa.debian.org/otto/mariadb-server/-/commits/10.5-salsa-ci-2023-04,
or some of those tests could be removed.