mysql-server FTBFS (focal) because of build tests
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
Fix Released
|
High
|
Rafael David Tinoco | ||
Eoan |
Fix Released
|
High
|
Rafael David Tinoco | ||
Focal |
Fix Released
|
High
|
Rafael David Tinoco |
Bug Description
[Impact]
* mysql-server-8 FTBFS in Eoan and Focal.
[Test Case]
* apt-get source mysql-server
* cd mysql*
* apt-get build-dep .
* dpkg-buildpackage -b -us -uc
[Regression Potential]
* patch is changing a test (executed during binary package generation)
* build is already broken, impact is minimum: its either good and fixes build OR not.
[Other Info]
During MIR for mysql-router it was discovered that there are some tests, executed during package build time, that are failing:
(PROBLEM #1)
CURRENT_TEST: main.events_bugs
mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01 00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290'
AND
(PROBLEM #2)
CURRENT_TEST: main.subquery_
--- /home/rafaeldti
+++ /home/rafaeldti
@@ -12800,10 +12800,10 @@
-> Hash
-> Table scan on <subquery2>
- -> Filter: (t1.col_int_key is not null) (cost=3.40 rows=7)
- -> Filter: (t3.col_int is null) (cost=3.40 rows=7)
- -> Nested loop left join (cost=3.40 rows=7)
- -> Index scan on t1 using col_int_key (cost=0.95 rows=7)
+ -> Filter: (t1.col_int_key is not null) (cost=4.15 rows=7)
+ -> Filter: (t3.col_int is null) (cost=4.15 rows=7)
+ -> Nested loop left join (cost=4.15 rows=7)
+ -> Index scan on t1 using col_int_key (cost=1.70 rows=7)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s)
Changed in mysql-8.0 (Ubuntu): | |
status: | New → In Progress |
importance: | Undecided → High |
assignee: | nobody → Rafael David Tinoco (rafaeldtinoco) |
description: | updated |
tags: | added: patch |
Changed in mysql-8.0 (Ubuntu Eoan): | |
status: | In Progress → Fix Committed |
Changed in mysql-8.0 (Ubuntu): | |
status: | Fix Committed → Fix Released |
Changed in mysql-8.0 (Ubuntu Eoan): | |
status: | Fix Committed → Fix Released |
Changed in mysql-8.0 (Ubuntu Focal): | |
status: | Fix Committed → Fix Released |
PROBLEM #1:
https:/ /bugs.mysql. com/bug. php?id= 98152 /bugs.mysql. com/bug. php?id= 98107
https:/
I think we reached the hard coded date on the test =). That part of the test was created by:
commit c60397ef198 alik@station. <>
Author: anozdrin/
Date: Fri Oct 19 15:57:08 2007
Patch for BUG#31111: --read-only crashes MySQL (events fail to load).
In 2007 =).
Changing 2020-01-01 to 2030-01-01 will likely make the issue to go away.
----
Bug comment says this was already changed in version 8.0.20:
"""
[3 Jan 13:47] Paul Dubois
Posted by developer:
Fixed in 5.6.48, 5.7.30, 8.0.20.
Work was done for test suite. No changelog entry needed.
"""
But they haven't released commits in github for the last two versions (not GA yet): 8.0.19 and 8.0.20. With that, we will have to go with a generic fix, keeping the delta until their upstream fix is available!