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

main.events_stress or events.events_stress fails with view-protocol

    XMLWordPrintable

Details

    Description

      10.4 f5dceafd

      $ perl ./mtr main.events_stress --view-protocol
       
      main.events_stress                       [ fail ]
              Test ended at 2023-06-11 22:00:09
       
      CURRENT_TEST: main.events_stress
      mysqltest: At line 48: query 'SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS' failed: 1146: Table 'events_test.mysqltest_tmp_v' doesn't exist
       
      The result from queries just before the failure was:
      < snip >
      CREATE TABLE events_test.fill_it3(test_name varchar(20), occur datetime);
      CREATE USER event_user2@localhost;
      CREATE DATABASE events_conn2_db;
      GRANT ALL ON *.* TO event_user2@localhost;
      CREATE USER event_user3@localhost;
      CREATE DATABASE events_conn3_db;
      GRANT ALL ON *.* TO event_user3@localhost;
      connect  conn2,localhost,event_user2,,events_conn2_db;
      "In the second connection we create some events which won't be dropped till the end"
      connect  conn3,localhost,event_user3,,events_conn3_db;
      "In the second connection we create some events which won't be dropped till the end"
      connection default;
      USE events_conn1_test2;
      CREATE EVENT ev_drop1 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
      CREATE EVENT ev_drop2 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
      CREATE EVENT ev_drop3 ON SCHEDULE EVERY 10 MINUTE DISABLE DO SELECT 1;
      USE events_test;
      SELECT COUNT(*) FROM INFORMATION_SCHEMA.EVENTS;
      

      In 11.x the test was relocated to events suite, but the failure remains the same.

      Attachments

        Issue Links

          Activity

            People

              lstartseva Lena Startseva
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.