Details
Description
galera.galera_events2 sporadically fails on bb.
10.3.22 9c3eca85141836548214e3c68f256b3868502509 |
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
|