[debian-mysql] Bug#1030604: mariadb breaks mariadb-10.6 autopkgtest: Variable 'innodb_compression_algorithm' can't be set to the value of 'lz4'

[Paul Gevers]

Source: mariadb, mariadb-10.6
Control: found -1 mariadb/1:10.11.1-2
Control: found -1 mariadb-10.6/1:10.6.11-2
Severity: serious
Tags: sid bookworm
User: debian-ci at lists.debian.org
Usertags: breaks needs-update

Dear maintainer(s),

With a recent upload of mariadb the autopkgtest of mariadb-10.6 fails in 
testing on amd64 and arm64 when that autopkgtest is run with the binary 
packages of mariadb from unstable. It passes when run with only packages 
from testing. In tabular form:

                        pass            fail
mariadb                from testing    1:10.11.1-2
mariadb-10.6           from testing    1:10.6.11-2
versioned deps [0]     from testing    from unstable
all others             from testing    from testing

I copied some of the output at the bottom of this report.

Currently this regression is blocking the migration of mariadb to 
testing [1]. Due to the nature of this issue, I filed this bug report 
against both packages. Can you please investigate the situation and 
reassign the bug to the right package?

More information about this bug and the reason for filing it can be found on
https://wiki.debian.org/ContinuousIntegration/RegressionEmailInformation

Paul

[0] You can see what packages were added from the second line of the log 
file quoted below. The migration software adds source package from 
unstable to the list if they are needed to install packages from 
mariadb/1:10.11.1-2. I.e. due to versioned dependencies or breaks/conflicts.
[1] https://qa.debian.org/excuses.php?package=mariadb

https://ci.debian.net/data/autopkgtest/testing/amd64/m/mariadb-10.6/31062126/log.gz

+ which systemctl
+ echo Found systemctl, continuing smoke test..
+ mysql
Running test 'smoke'
/usr/bin/systemctl
Found systemctl, continuing smoke test..
+ mysql testdatabase
+ + mysql --batch --skip-column-names --user=testuser 
--password=testpassword testdatabase
echo SELECT bar+1 FROM foo;
+ result=42
+ [ 42 != 42 ]
+ mysql --user=testuser --password=testpassword testdatabase
+ mysql
+ mariadb
ERROR 1231 (42000) at line 1: Variable 'innodb_compression_algorithm' 
can't be set to the value of 'lz4'
autopkgtest [04:36:43]: test smoke

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 495 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20230205/271a02ca/attachment.sig>