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

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

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

            Fixed in branch bb-10.4-MDEV-31457-vp

            lstartseva Lena Startseva added a comment - Fixed in branch bb-10.4- MDEV-31457 -vp

            Fixed in fec93e7155393f8807a8006934b774e4166a7290

            lstartseva Lena Startseva added a comment - Fixed in fec93e7155393f8807a8006934b774e4166a7290

            I saw this again for MariaDB 11.4.3 in https://launchpadlibrarian.net/744525170/buildlog_ubuntu-oracular-ppc64el.mariadb_1%3A11.4.3-1~bpo24.10.1~1723861980.82682eb06f0+feature.extend.mtr.to.big_BUILDING.txt.gz

            events.events_stress                     w3 [ fail ]  Found warnings/errors in server log file!
                    Test ended at 2024-08-17 04:06:48
            line
            2024-08-17  4:06:48 1323 [ERROR] Event Scheduler: [root@localhost][events_conn1_test4.conn1_round3_ev46] Table 'events_test.fill_it3' doesn't exist
            ^ Found warnings in /<<PKGBUILDDIR>>/builddir/mysql-test/var/3/log/mysqld.1.err
            ok
            

            otto Otto Kekäläinen added a comment - I saw this again for MariaDB 11.4.3 in https://launchpadlibrarian.net/744525170/buildlog_ubuntu-oracular-ppc64el.mariadb_1%3A11.4.3-1~bpo24.10.1~1723861980.82682eb06f0+feature.extend.mtr.to.big_BUILDING.txt.gz events.events_stress w3 [ fail ] Found warnings/errors in server log file! Test ended at 2024-08-17 04:06:48 line 2024-08-17 4:06:48 1323 [ERROR] Event Scheduler: [root@localhost][events_conn1_test4.conn1_round3_ev46] Table 'events_test.fill_it3' doesn't exist ^ Found warnings in /<<PKGBUILDDIR>>/builddir/mysql-test/var/3/log/mysqld.1.err ok

            People

              lstartseva Lena Startseva
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.