| 2020-01-10 00:28:00 |
Rafael David Tinoco |
bug |
|
|
added bug |
| 2020-01-10 00:28:11 |
Rafael David Tinoco |
bug |
|
|
added subscriber Ubuntu Server |
| 2020-01-10 00:28:18 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu): status |
New |
In Progress |
|
| 2020-01-10 00:28:19 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu): importance |
Undecided |
High |
|
| 2020-01-10 00:28:20 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu): assignee |
|
Rafael David Tinoco (rafaeldtinoco) |
|
| 2020-01-10 00:28:37 |
Rafael David Tinoco |
bug |
|
|
added subscriber Robie Basak |
| 2020-01-10 00:30:27 |
Rafael David Tinoco |
description |
During MIR for mysql-router it was discovered that there are some tests, executed during package build time, that are failing:
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
CURRENT_TEST: main.subquery_sj_mat_bka
--- /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/mysql-test/r/subquery_sj_mat_bka.result 2019-09-20 11:30:51.000000000 +0300
+++ /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/builddir/mysql-test/var/9/log/subquery_sj_mat_bka.reject 2020-01-09 19:54:09.659290415 +0300
@@ -12800,10 +12800,10 @@
-> Hash
-> Table scan on <subquery2>
-> Materialize with deduplication
- -> 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)
-> Nested loop inner join (cost=1.21 rows=1)
-> Single-row index lookup on t2 using PRIMARY (pk=t1.pk) (cost=0.26 rows=1)
-> Filter: (t3.col_int_key = t2.col_int) (cost=0.09 rows=1)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s)(failures/attempts): main.subquery_sj_mat_bka(1/3) |
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_sj_mat_bka
--- /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/mysql-test/r/subquery_sj_mat_bka.result 2019-09-20 11:30:51.000000000 +0300
+++ /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/builddir/mysql-test/var/9/log/subquery_sj_mat_bka.reject 2020-01-09 19:54:09.659290415 +0300
@@ -12800,10 +12800,10 @@
-> Hash
-> Table scan on <subquery2>
-> Materialize with deduplication
- -> 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)
-> Nested loop inner join (cost=1.21 rows=1)
-> Single-row index lookup on t2 using PRIMARY (pk=t1.pk) (cost=0.26 rows=1)
-> Filter: (t3.col_int_key = t2.col_int) (cost=0.09 rows=1)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s)(failures/attempts): main.subquery_sj_mat_bka(1/3) |
|
| 2020-01-10 00:53:37 |
Rafael David Tinoco |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=98152 |
|
| 2020-01-10 00:53:37 |
Rafael David Tinoco |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=98107 |
|
| 2020-01-10 04:19:53 |
Rafael David Tinoco |
bug |
|
|
added subscriber Lars Tangvald |
| 2020-01-10 04:21:38 |
Rafael David Tinoco |
bug |
|
|
added subscriber Eduardo dos Santos Barretto |
| 2020-01-11 05:39:25 |
Rafael David Tinoco |
nominated for series |
|
Ubuntu Focal |
|
| 2020-01-11 05:39:25 |
Rafael David Tinoco |
bug task added |
|
mysql-8.0 (Ubuntu Focal) |
|
| 2020-01-11 05:43:02 |
Rafael David Tinoco |
attachment added |
|
mysql-8.0_8.0.18-0ubuntu5.debdiff https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1859100/+attachment/5319197/+files/mysql-8.0_8.0.18-0ubuntu5.debdiff |
|
| 2020-01-11 05:46:56 |
Rafael David Tinoco |
description |
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_sj_mat_bka
--- /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/mysql-test/r/subquery_sj_mat_bka.result 2019-09-20 11:30:51.000000000 +0300
+++ /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/builddir/mysql-test/var/9/log/subquery_sj_mat_bka.reject 2020-01-09 19:54:09.659290415 +0300
@@ -12800,10 +12800,10 @@
-> Hash
-> Table scan on <subquery2>
-> Materialize with deduplication
- -> 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)
-> Nested loop inner join (cost=1.21 rows=1)
-> Single-row index lookup on t2 using PRIMARY (pk=t1.pk) (cost=0.26 rows=1)
-> Filter: (t3.col_int_key = t2.col_int) (cost=0.09 rows=1)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s)(failures/attempts): main.subquery_sj_mat_bka(1/3) |
[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_sj_mat_bka
--- /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/mysql-test/r/subquery_sj_mat_bka.result 2019-09-20 11:30:51.000000000 +0300
+++ /home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/builddir/mysql-test/var/9/log/subquery_sj_mat_bka.reject 2020-01-09 19:54:09.659290415 +0300
@@ -12800,10 +12800,10 @@
-> Hash
-> Table scan on <subquery2>
-> Materialize with deduplication
- -> 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)
-> Nested loop inner join (cost=1.21 rows=1)
-> Single-row index lookup on t2 using PRIMARY (pk=t1.pk) (cost=0.26 rows=1)
-> Filter: (t3.col_int_key = t2.col_int) (cost=0.09 rows=1)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s)(failures/attempts): main.subquery_sj_mat_bka(1/3) |
|
| 2020-01-11 05:47:12 |
Rafael David Tinoco |
bug |
|
|
added subscriber Ubuntu SRU developers |
| 2020-01-11 06:46:42 |
Rafael David Tinoco |
attachment added |
|
mysql-8.0_8.0.18-0ubuntu0.19.10.2.debdiff https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1859100/+attachment/5319201/+files/mysql-8.0_8.0.18-0ubuntu0.19.10.2.debdiff |
|
| 2020-01-11 06:47:43 |
Rafael David Tinoco |
nominated for series |
|
Ubuntu Eoan |
|
| 2020-01-11 06:47:43 |
Rafael David Tinoco |
bug task added |
|
mysql-8.0 (Ubuntu Eoan) |
|
| 2020-01-11 06:47:50 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Eoan): importance |
Undecided |
Critical |
|
| 2020-01-11 06:47:55 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Eoan): status |
New |
In Progress |
|
| 2020-01-11 06:47:57 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Eoan): importance |
Critical |
High |
|
| 2020-01-11 06:47:59 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Eoan): assignee |
|
Rafael David Tinoco (rafaeldtinoco) |
|
| 2020-01-11 08:23:49 |
Ubuntu Foundations Team Bug Bot |
tags |
|
patch |
|
| 2020-01-15 15:11:07 |
Rafael David Tinoco |
bug |
|
|
added subscriber Dimitri John Ledkov |
| 2020-02-13 14:36:56 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Focal): status |
In Progress |
Fix Committed |
|
| 2020-08-14 18:57:33 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Eoan): status |
In Progress |
Fix Committed |
|
| 2020-08-14 18:57:39 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu): status |
Fix Committed |
Fix Released |
|
| 2020-08-14 18:57:42 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Eoan): status |
Fix Committed |
Fix Released |
|
| 2020-08-14 18:57:43 |
Rafael David Tinoco |
mysql-8.0 (Ubuntu Focal): status |
Fix Committed |
Fix Released |
|
