alera.galera_events2 'innodb'           w1 [ fail ]

        Test ended at 2020-01-12 15:46:05

CURRENT_TEST: galera.galera_events2

mysqltest: At line 69: query 'use events_test' failed: 1049: Unknown database 'events_test'

The result from queries just before the failure was:

< snip >

use events_test;

CREATE USER ev_test@localhost;

GRANT ALL ON events_test.* to ev_test@localhost;

connect  ev_con1,localhost,ev_test,,events_test;

CREATE EVENT one_event ON SCHEDULE EVERY 10 SECOND DO SELECT 123;

Warnings:

Warning	1105	Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it.

SHOW EVENTS;

Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation

events_test	one_event	ev_test@localhost	SYSTEM	RECURRING	NULL	10	#	#	NULL	ENABLED	1	latin1	latin1_swedish_ci	latin1_swedish_ci

SELECT EVENT_CATALOG, EVENT_SCHEMA, EVENT_NAME, DEFINER, EVENT_BODY, EVENT_DEFINITION, EVENT_TYPE, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STATUS,ON_COMPLETION, EVENT_COMMENT FROM INFORMATION_SCHEMA.EVENTS ORDER BY EVENT_SCHEMA, EVENT_NAME;

EVENT_CATALOG	EVENT_SCHEMA	EVENT_NAME	DEFINER	EVENT_BODY	EVENT_DEFINITION	EVENT_TYPE	EXECUTE_AT	INTERVAL_VALUE	INTERVAL_FIELD	STATUS	ON_COMPLETION	EVENT_COMMENT

def	events_test	one_event	ev_test@localhost	SQL	SELECT 123	RECURRING	NULL	10	SECOND	ENABLED	NOT PRESERVE	

ALTER EVENT one_event ON SCHEDULE EVERY 10 SECOND;

"The definer should be ev_test@localhost"

SELECT EVENT_CATALOG, EVENT_SCHEMA, EVENT_NAME, DEFINER, EVENT_BODY, EVENT_DEFINITION, EVENT_TYPE, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STATUS,ON_COMPLETION, EVENT_COMMENT FROM INFORMATION_SCHEMA.EVENTS WHERE EVENT_NAME='one_event';

EVENT_CATALOG	EVENT_SCHEMA	EVENT_NAME	DEFINER	EVENT_BODY	EVENT_DEFINITION	EVENT_TYPE	EXECUTE_AT	INTERVAL_VALUE	INTERVAL_FIELD	STATUS	ON_COMPLETION	EVENT_COMMENT

def	events_test	one_event	ev_test@localhost	SQL	SELECT 123	RECURRING	NULL	10	SECOND	ENABLED	NOT PRESERVE	

connection node_2;

use events_test;

More results from queries before failure can be found in /dev/shm/var/1/log/galera_events2.log

 - saving '/dev/shm/var/1/log/galera.galera_events2-innodb/' to '/dev/shm/var/log/galera.galera_events2-innodb/'

Retrying test galera.galera_events2, attempt(2/3)...

worker[1] > Restart  - not started

worker[1] > Restart  - not started