[Bug 1862770] Re: MySQL autopkgtest regressed in Focal release pocket

[Rafael David Tinoco]

*** This bug is a duplicate of bug 1862364 ***
    https://bugs.launchpad.net/bugs/1862364

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.

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to shadow in Ubuntu.
https://bugs.launchpad.net/bugs/1862770

Title:
  MySQL autopkgtest regressed in Focal release pocket

Status in mysql-8.0 package in Ubuntu:
  New
Status in shadow package in Ubuntu:
  New

Bug description:
  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'

  ...

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1862770/+subscriptions