Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21492

Galera test sporadic failure on galera.galera_events2

    XMLWordPrintable

    Details

      Description

      galera.galera_events2 sporadically fails on bb.

      stdout.log:

      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
      

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            stepan.patryshev Stepan Patryshev
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: