MySQL autopkgtest regressed in Focal release pocket

[Balint Reczey]

http://autopkgtest.ubuntu.com/packages/m/mysql-8.0/focal/amd64
https://objectstorage.prodstack4-5.canonical.com/v1/AUTH_77e2ada1e7a84929a74ba3b87153c0ac/autopkgtest-focal/focal/amd64/m/mysql-8.0/20200211_122839_60bab@/log.gz

...

 63%] main.events_1 [ fail ]
        Test ended at 2020-02-11 12:06:00

CURRENT_TEST: main.events_1
mysqltest: At line 69: Query 'ALTER EVENT event_starts_test ON SCHEDULE AT '2020-02-02 20:00:02'' failed.
ERROR 1589 (HY000): Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was not changed. Specify a time in the future.

The result from queries just before the failure was:
drop event if exists event1;
Warnings:
Note 1305 Event event1 does not exist
create event event1 on schedule every 15 minute starts now() ends date_add(now(), interval 5 hour) DO begin end;
alter event event1 rename to event2 enable;
alter event event2 disable;
alter event event2 enable;
alter event event2 on completion not preserve;
alter event event2 on schedule every 1 year on completion preserve rename to event3 comment "new comment" do begin select 1; end__
alter event event3 rename to event2;
drop event event2;
create event event2 on schedule every 2 second starts now() ends date_add(now(), interval 5 hour) comment "some" DO begin end;
drop event event2;
CREATE EVENT event_starts_test ON SCHEDULE EVERY 10 SECOND COMMENT "" DO SELECT 1;
SELECT interval_field, interval_value, event_definition FROM information_schema.events WHERE event_name='event_starts_test';
INTERVAL_FIELD INTERVAL_VALUE EVENT_DEFINITION
SECOND 10 SELECT 1
SELECT execute_at IS NULL, starts IS NULL, ends IS NULL, event_comment FROM information_schema.events WHERE event_schema='events_test' AND event_name='event_starts_test';
execute_at IS NULL starts IS NULL ends IS NULL EVENT_COMMENT
1 0 1
safe_process[25029]: Child process: 25030, exit: 1

 - the logfile can be found in '/tmp/tmp.YL1y5O4jCj/var/log/main.events_1/events_1.log'

...

[Balint Reczey (rbalint)]

It holds back shadow from migrating.

[Eduardo Barretto (ebarretto)]

This is the same as bug #1862364

[Rafael David Tinoco (rafaeldtinoco)]

I have just uploaded mysql-8.0_8.0.19-0ubuntu3 containing fixes for the 2020 year in mysql tests. I'll flag this as Fix Committed and Fix Released manually as only LP: #1862364 was referred in that changelog.

[Rafael David Tinoco (rafaeldtinoco)]

Related bugs:

https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1862364
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1859100

[Rafael David Tinoco (rafaeldtinoco)]

Ah, nm, this is a duplicate =o).