Autopkgtest fails on s390x for 8.0.33

[Lena Voytek]

[Impact]

When running the upstream DEP-8 test on a s390x system, the tests main.subquery_sj_all_bka_nobnl and main.subquery_sj_mat_bka_nobnl fail as of 8.0.33. Both tests fail due to content mismatches through join operations.

Backporting this fix will allow the s390x autopkgtest suite to succeed so mysql-8.0 package updates can migrate.

This is fixed by ignoring the two tests for the time being, and referencing the related upstream bug.

[Test Plan]

The fix can be tested by running autopkgtest on an s390x system. Prior to the fix, the logs would show something like:

[ 86%] main.subquery_sj_all_bka_nobnl w7 [ fail ]
        Test ended at 2023-05-24 15:27:00

CURRENT_TEST: main.subquery_sj_all_bka_nobnl
--- /usr/lib/mysql-test/r/subquery_sj_all_bka_nobnl.result 2023-03-16 20:22:37.000000000 +0300
+++ /tmp/tmp.Pf7H4WvKzH/var/7/log/subquery_sj_all_bka_nobnl.reject 2023-05-24 18:26:59.844163031 +0300
@@ -5895,7 +5895,7 @@
 FROM ot1 LEFT JOIN ot2 ON ot1.a=ot2.a AND ot1.a IN (SELECT a FROM it3)
 LEFT JOIN ot3 ON ot2.a=ot3.a AND ot3.a IN (SELECT a FROM it3);
 EXPLAIN
--> Nested loop left join (cost=48.2 rows=288)
+-> Nested loop left join (cost=48.3 rows=288)
     -> Nested loop left join (cost=11.5 rows=96)
         -> Table scan on ot1 (cost=1.05 rows=8)
         -> Nested loop inner join (cost=4.35 rows=12)

mysqltest: Result content mismatch
...
[ 96%] main.subquery_sj_mat_bka_nobnl w3 [ fail ]
        Test ended at 2023-05-24 15:28:05

CURRENT_TEST: main.subquery_sj_mat_bka_nobnl
--- /usr/lib/mysql-test/r/subquery_sj_mat_bka_nobnl.result 2023-03-16 20:22:37.000000000 +0300
+++ /tmp/tmp.Pf7H4WvKzH/var/3/log/subquery_sj_mat_bka_nobnl.reject 2023-05-24 18:28:05.560167037 +0300
@@ -6121,7 +6121,7 @@
 FROM ot1 LEFT JOIN ot2 ON ot1.a=ot2.a AND ot1.a IN (SELECT a FROM it3)
 LEFT JOIN ot3 ON ot2.a=ot3.a AND ot3.a IN (SELECT a FROM it3);
 EXPLAIN
--> Nested loop left join (cost=48.2 rows=288)
+-> Nested loop left join (cost=48.3 rows=288)
     -> Nested loop left join (cost=11.5 rows=96)
         -> Table scan on ot1 (cost=1.05 rows=8)
         -> Nested loop inner join (cost=4.35 rows=12)

mysqltest: Result content mismatch
...

After the fix, the autopkgtest run succeeds.

[Where problems could occur]

In the future, if actual issues were to show up on any architecture related to these two unit tests, the autopkgtest run would not fail as expected.

[Other Info]

This issue was fixed in mantic through the sync with debian unstable.

[Original Description]

The upstream tests main.subquery_sj_all_bka_nobnl and main.subquery_sj_mat_bka_nobnl now fail as of 8.0.33. Submitted bug report upstream too but they plan on ignoring the issue since the architecture is unsupported there: https://bugs.mysql.com/bug.php?id=111156

[Steve Langasek (vorlon)]

An upload of mysql-8.0 to lunar-proposed has been rejected from the upload queue for the following reason: "reuploading with correct -v option".

[Steve Langasek (vorlon)]

Hello Lena, or anyone else affected,

Accepted mysql-8.0 into lunar-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/mysql-8.0/8.0.33-0ubuntu0.23.04.4 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-lunar to verification-done-lunar. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-lunar. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Steve Langasek (vorlon)]

An upload of mysql-8.0 to kinetic-proposed has been rejected from the upload queue for the following reason: "reupload with -v option".

[Steve Langasek (vorlon)]

An upload of mysql-8.0 to jammy-proposed has been rejected from the upload queue for the following reason: "reuploading with -v".

[Steve Langasek (vorlon)]

Hello Lena, or anyone else affected,

Accepted mysql-8.0 into kinetic-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/mysql-8.0/8.0.33-0ubuntu0.22.10.4 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-kinetic to verification-done-kinetic. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-kinetic. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Steve Langasek (vorlon)]

An upload of mysql-8.0 to focal-proposed has been rejected from the upload queue for the following reason: "reuploading with -v".

[Ubuntu SRU Bot (ubuntu-sru-bot)]

All autopkgtests for the newly accepted mysql-8.0 (8.0.33-0ubuntu0.23.04.4) for lunar have finished running.
The following regressions have been reported in tests triggered by the package:

libreoffice/4:7.5.3-0ubuntu0.23.04.1 (armhf)
slurm-wlm/22.05.8-3 (armhf)

Please visit the excuses page listed below and investigate the failures, proceeding afterwards as per the StableReleaseUpdates policy regarding autopkgtest regressions [1].

https://people.canonical.com/~ubuntu-archive/proposed-migration/lunar/update_excuses.html#mysql-8.0

[1] https://wiki.ubuntu.com/StableReleaseUpdates#Autopkgtest_Regressions

Thank you!

[Ubuntu SRU Bot (ubuntu-sru-bot)]

All autopkgtests for the newly accepted mysql-8.0 (8.0.33-0ubuntu0.22.10.4) for kinetic have finished running.
The following regressions have been reported in tests triggered by the package:

senlin/1:14.0.0-0ubuntu1 (s390x)
sysbench/1.0.20+ds-5 (s390x)

Please visit the excuses page listed below and investigate the failures, proceeding afterwards as per the StableReleaseUpdates policy regarding autopkgtest regressions [1].

https://people.canonical.com/~ubuntu-archive/proposed-migration/kinetic/update_excuses.html#mysql-8.0

[1] https://wiki.ubuntu.com/StableReleaseUpdates#Autopkgtest_Regressions

Thank you!

[Robie Basak (racb)]

Hello Lena, or anyone else affected,

Accepted mysql-8.0 into focal-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/mysql-8.0/8.0.33-0ubuntu0.20.04.4 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-focal to verification-done-focal. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-focal. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Robie Basak (racb)]

Hello Lena, or anyone else affected,

Accepted mysql-8.0 into jammy-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/mysql-8.0/8.0.33-0ubuntu0.22.04.4 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-jammy to verification-done-jammy. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-jammy. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

[Lena Voytek (lvoytek)]

Verified for Kinetic and Lunar as their autopkgtest runs were successful in proposed, see:
https://autopkgtest.ubuntu.com/results/autopkgtest-kinetic/kinetic/s390x/m/mysql-8.0/20230617_061332_0b456@/log.gz
https://autopkgtest.ubuntu.com/results/autopkgtest-lunar/lunar/s390x/m/mysql-8.0/20230617_052032_670ca@/log.gz

Still awaiting results on Jammy and Focal

[Ubuntu SRU Bot (ubuntu-sru-bot)]

All autopkgtests for the newly accepted mysql-8.0 (8.0.33-0ubuntu0.20.04.4) for focal have finished running.
The following regressions have been reported in tests triggered by the package:

cinder/2:16.4.2-0ubuntu2.4 (amd64)
diaspora-installer/0.7.6.1+debian1 (s390x)

Please visit the excuses page listed below and investigate the failures, proceeding afterwards as per the StableReleaseUpdates policy regarding autopkgtest regressions [1].

https://people.canonical.com/~ubuntu-archive/proposed-migration/focal/update_excuses.html#mysql-8.0

[1] https://wiki.ubuntu.com/StableReleaseUpdates#Autopkgtest_Regressions

Thank you!

[Lena Voytek (lvoytek)]

Verified for Focal and Jammy too:
https://autopkgtest.ubuntu.com/results/autopkgtest-jammy/jammy/s390x/m/mysql-8.0/20230629_192157_bca8b@/log.gz
https://autopkgtest.ubuntu.com/results/autopkgtest-focal/focal/s390x/m/mysql-8.0/20230629_201752_24aae@/log.gz

[Brian Murray (brian-murray)]

The verification of the Stable Release Update for mysql-8.0 has completed successfully and the package is now being released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.

[Launchpad Janitor (janitor)]

This bug was fixed in the package mysql-8.0 - 8.0.33-0ubuntu0.23.04.4

---------------
mysql-8.0 (8.0.33-0ubuntu0.23.04.4) lunar; urgency=medium

  * d/t/upstream: Ignore upstream tests due to s390x failure (LP: #2020910)
    Due to slight variation in the optimization of join statements on s390x, a
    few upstream tests fail as they show a cost slightly higher than expected.
    The tests include main.subquery_sj_all_bka_nobnl and
    main.subquery_sj_mat_bka_nobnl

mysql-8.0 (8.0.33-0ubuntu0.23.04.3) lunar; urgency=medium

  * d/p/mysql_secure_installation-remove-root-pw-creation.patch: Fix
    mysql_secure_installation by removing root password creation (LP: #1980466)

 -- Lena Voytek <email address hidden> Wed, 14 Jun 2023 12:37:12 -0700

[Launchpad Janitor (janitor)]

This bug was fixed in the package mysql-8.0 - 8.0.33-0ubuntu0.22.04.4

---------------
mysql-8.0 (8.0.33-0ubuntu0.22.04.4) jammy; urgency=medium

  * d/t/upstream: Ignore upstream tests due to s390x failure (LP: #2020910)
    Due to slight variation in the optimization of join statements on s390x, a
    few upstream tests fail as they show a cost slightly higher than expected.
    The tests include main.subquery_sj_all_bka_nobnl and
    main.subquery_sj_mat_bka_nobnl

mysql-8.0 (8.0.33-0ubuntu0.22.04.3) jammy; urgency=medium

  * d/p/mysql_secure_installation-remove-root-pw-creation.patch: Fix
    mysql_secure_installation by removing root password creation (LP: #1980466)

 -- Lena Voytek <email address hidden> Wed, 14 Jun 2023 12:43:34 -0700

[Launchpad Janitor (janitor)]

This bug was fixed in the package mysql-8.0 - 8.0.33-0ubuntu0.20.04.4

---------------
mysql-8.0 (8.0.33-0ubuntu0.20.04.4) focal; urgency=medium

  * d/t/upstream: Ignore upstream tests due to s390x failure (LP: #2020910)
    Due to slight variation in the optimization of join statements on s390x, a
    few upstream tests fail as they show a cost slightly higher than expected.
    The tests include main.subquery_sj_all_bka_nobnl and
    main.subquery_sj_mat_bka_nobnl

mysql-8.0 (8.0.33-0ubuntu0.20.04.3) focal; urgency=medium

  * d/p/mysql_secure_installation-remove-root-pw-creation.patch: Fix
    mysql_secure_installation by removing root password creation (LP: #1980466)

 -- Lena Voytek <email address hidden> Wed, 14 Jun 2023 12:45:13 -0700

[Lena Voytek (lvoytek)]

Marked kinetic as wont-fix as it was not released in time for its eol