2023-05-26 16:55:29 |
Lena Voytek |
bug |
|
|
added bug |
2023-05-26 16:55:41 |
Lena Voytek |
nominated for series |
|
Ubuntu Mantic |
|
2023-05-26 16:55:41 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Mantic) |
|
2023-05-26 16:55:41 |
Lena Voytek |
nominated for series |
|
Ubuntu Jammy |
|
2023-05-26 16:55:41 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Jammy) |
|
2023-05-26 16:55:41 |
Lena Voytek |
nominated for series |
|
Ubuntu Lunar |
|
2023-05-26 16:55:41 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Lunar) |
|
2023-05-26 16:55:41 |
Lena Voytek |
nominated for series |
|
Ubuntu Kinetic |
|
2023-05-26 16:55:41 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Kinetic) |
|
2023-05-26 16:55:41 |
Lena Voytek |
nominated for series |
|
Ubuntu Focal |
|
2023-05-26 16:55:41 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Focal) |
|
2023-05-26 16:55:49 |
Lena Voytek |
mysql-8.0 (Ubuntu Mantic): assignee |
|
Lena Voytek (lvoytek) |
|
2023-05-26 16:55:51 |
Lena Voytek |
mysql-8.0 (Ubuntu Lunar): assignee |
|
Lena Voytek (lvoytek) |
|
2023-05-26 16:55:53 |
Lena Voytek |
mysql-8.0 (Ubuntu Kinetic): assignee |
|
Lena Voytek (lvoytek) |
|
2023-05-26 16:55:54 |
Lena Voytek |
mysql-8.0 (Ubuntu Jammy): assignee |
|
Lena Voytek (lvoytek) |
|
2023-05-26 16:55:56 |
Lena Voytek |
mysql-8.0 (Ubuntu Focal): assignee |
|
Lena Voytek (lvoytek) |
|
2023-05-26 16:56:08 |
Lena Voytek |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=111156 |
|
2023-05-26 16:56:08 |
Lena Voytek |
bug task added |
|
mysql-server |
|
2023-05-26 16:56:21 |
Lena Voytek |
mysql-8.0 (Ubuntu Mantic): status |
New |
In Progress |
|
2023-05-26 17:13:47 |
Lena Voytek |
bug watch added |
|
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1036803 |
|
2023-05-26 17:13:47 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Debian) |
|
2023-05-29 00:31:39 |
Bug Watch Updater |
mysql-8.0 (Debian): status |
Unknown |
New |
|
2023-06-02 14:35:07 |
Bug Watch Updater |
mysql-8.0 (Debian): status |
New |
Fix Released |
|
2023-06-13 16:22:09 |
Lena Voytek |
mysql-8.0 (Ubuntu Mantic): status |
In Progress |
Fix Released |
|
2023-06-14 19:16:36 |
Lena Voytek |
mysql-8.0 (Ubuntu Focal): status |
New |
In Progress |
|
2023-06-14 19:16:39 |
Lena Voytek |
mysql-8.0 (Ubuntu Jammy): status |
New |
In Progress |
|
2023-06-14 19:16:41 |
Lena Voytek |
mysql-8.0 (Ubuntu Kinetic): status |
New |
In Progress |
|
2023-06-14 19:16:43 |
Lena Voytek |
mysql-8.0 (Ubuntu Lunar): status |
New |
In Progress |
|
2023-06-14 19:57:57 |
Lena Voytek |
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 |
[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 |
|
2023-06-16 22:12:59 |
Steve Langasek |
mysql-8.0 (Ubuntu Lunar): status |
In Progress |
Fix Committed |
|
2023-06-16 22:13:01 |
Steve Langasek |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2023-06-16 22:13:06 |
Steve Langasek |
bug |
|
|
added subscriber SRU Verification |
2023-06-16 22:13:15 |
Steve Langasek |
tags |
|
verification-needed verification-needed-lunar |
|
2023-06-16 22:24:13 |
Steve Langasek |
mysql-8.0 (Ubuntu Kinetic): status |
In Progress |
Fix Committed |
|
2023-06-16 22:24:18 |
Steve Langasek |
tags |
verification-needed verification-needed-lunar |
verification-needed verification-needed-kinetic verification-needed-lunar |
|
2023-06-17 03:47:08 |
Ubuntu Archive Robot |
bug |
|
|
added subscriber Steve Langasek |
2023-06-28 10:29:38 |
Robie Basak |
mysql-8.0 (Ubuntu Focal): status |
In Progress |
Fix Committed |
|
2023-06-28 10:29:40 |
Robie Basak |
tags |
verification-needed verification-needed-kinetic verification-needed-lunar |
verification-needed verification-needed-focal verification-needed-kinetic verification-needed-lunar |
|
2023-06-28 10:29:57 |
Robie Basak |
mysql-8.0 (Ubuntu Jammy): status |
In Progress |
Fix Committed |
|
2023-06-28 10:30:01 |
Robie Basak |
tags |
verification-needed verification-needed-focal verification-needed-kinetic verification-needed-lunar |
verification-needed verification-needed-focal verification-needed-jammy verification-needed-kinetic verification-needed-lunar |
|
2023-06-28 14:29:05 |
Lena Voytek |
tags |
verification-needed verification-needed-focal verification-needed-jammy verification-needed-kinetic verification-needed-lunar |
verification-done-kinetic verification-done-lunar verification-needed verification-needed-focal verification-needed-jammy |
|
2023-06-29 21:41:36 |
Lena Voytek |
tags |
verification-done-kinetic verification-done-lunar verification-needed verification-needed-focal verification-needed-jammy |
verification-done verification-done-focal verification-done-jammy verification-done-kinetic verification-done-lunar |
|
2023-07-25 16:31:07 |
Brian Murray |
removed subscriber Ubuntu Stable Release Updates Team |
|
|
|
2023-07-25 16:31:08 |
Launchpad Janitor |
mysql-8.0 (Ubuntu Lunar): status |
Fix Committed |
Fix Released |
|
2023-07-25 16:32:08 |
Launchpad Janitor |
mysql-8.0 (Ubuntu Jammy): status |
Fix Committed |
Fix Released |
|
2023-07-25 16:32:14 |
Launchpad Janitor |
mysql-8.0 (Ubuntu Focal): status |
Fix Committed |
Fix Released |
|
2023-07-25 16:35:54 |
Lena Voytek |
mysql-8.0 (Ubuntu Kinetic): status |
Fix Committed |
Won't Fix |
|