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

main.selectivity_no_engine fails sometimes with Result content mismatch

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5.12
    • None
    • Tests
    • None

    Description

      In 10.5.12 I saw test failures for main.selectivity_no_engine:

      main.selectivity_no_engine               w18 [ fail ]
      		 
              Test ended at 2021-08-08 23:42:01
      		 
       
      		 
      CURRENT_TEST: main.selectivity_no_engine
      		 
      --- /var/tmp/portage/dev-db/mariadb-10.5.12/work/mysql/mysql-test/main/selectivity_no_engine.result     2021-08-03 10:29:08.000000000 +0200
      		 
      +++ /var/tmp/portage/dev-db/mariadb-10.5.12/work/mysql/mysql-test/main/selectivity_no_engine.reject     2021-08-08 23:42:01.777747924 +0200
      		 
      @@ -311,8 +311,8 @@
      		 
       EXPLAIN
      		 
       SELECT * FROM t1 AS a NATURAL JOIN t1 AS b;
      		 
       id     select_type     table   type    possible_keys   key     key_len ref     rows    Extra
      		 
      -1      SIMPLE  a       ALL     NULL    NULL    NULL    NULL    5       Using where
      		 
      -1      SIMPLE  b       hash_ALL        NULL    #hash#$hj       612     test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time        5       Using where; Using join buffer (flat, BNLH join)
      		 
      +1      SIMPLE  a       ALL     NULL    NULL    NULL    NULL    4       Using where
      		 
      +1      SIMPLE  b       hash_ALL        NULL    #hash#$hj       612     test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time        4       Using where; Using join buffer (flat, BNLH join)
      		 
       DROP TABLE t1,t2,t3;
      		 
       #
      		 
       # End of the test file
      		 
       
      		 
      mysqltest: Result content mismatch
      		 
       
      		 
       - saving '/var/tmp/portage/dev-db/mariadb-10.5.12/temp/var-tests/18/log/main.selectivity_no_engine/' to '/var/tmp/portage/dev-db/mariadb-10.5.12/temp/var-tests/log/main.selectivity_no_engine/'

      Note that the test is passing when I re-run it manually.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          efraim Efraim Flashner added a comment -

          I ran across this test issue also when running the test suite on 10.5.12 using Guix

          CURRENT_TEST: main.selectivity_no_engine
          safe_process[15680]: parent_pid: 24904
          safe_process[15680]: Started child 15681, terminated: 0
          — /tmp/guix-build-mariadb-10.5.12.drv-0/mariadb-10.5.12/mysql-test/main/selectivity_no_engine.result 1970-01-01 00:00:01.000000000 +0000
          +++ /tmp/guix-build-mariadb-10.5.12.drv-0/mariadb-10.5.12/mysql-test/main/selectivity_no_engine.reject 2021-09-29 07:00:29.224155434 +0000
          @@ -311,8 +311,8 @@
          EXPLAIN
          SELECT * FROM t1 AS a NATURAL JOIN t1 AS b;
          id select_type table type possible_keys key key_len ref rows Extra
          -1 SIMPLE a ALL NULL NULL NULL NULL 5 Using where
          -1 SIMPLE b hash_ALL NULL #hash#$hj 612 test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time 5 Using where; Using join buffer (flat, BNLH join)
          +1 SIMPLE a ALL NULL NULL NULL NULL 4 Using where
          +1 SIMPLE b hash_ALL NULL #hash#$hj 612 test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time 4 Using where; Using join buffer (flat, BNLH join)
          DROP TABLE t1,t2,t3;
          #

          1. End of the test file

          mysqltest: Result content mismatch

          safe_process[15680]: Got signal 17, child_pid: 15681
          safe_process[15680]: Killing child: 15681
          safe_process[15680]: Child exit: 1

          efraim Efraim Flashner added a comment - I ran across this test issue also when running the test suite on 10.5.12 using Guix CURRENT_TEST: main.selectivity_no_engine safe_process [15680] : parent_pid: 24904 safe_process [15680] : Started child 15681, terminated: 0 — /tmp/guix-build-mariadb-10.5.12.drv-0/mariadb-10.5.12/mysql-test/main/selectivity_no_engine.result 1970-01-01 00:00:01.000000000 +0000 +++ /tmp/guix-build-mariadb-10.5.12.drv-0/mariadb-10.5.12/mysql-test/main/selectivity_no_engine.reject 2021-09-29 07:00:29.224155434 +0000 @@ -311,8 +311,8 @@ EXPLAIN SELECT * FROM t1 AS a NATURAL JOIN t1 AS b; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE a ALL NULL NULL NULL NULL 5 Using where -1 SIMPLE b hash_ALL NULL #hash#$hj 612 test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time 5 Using where; Using join buffer (flat, BNLH join) +1 SIMPLE a ALL NULL NULL NULL NULL 4 Using where +1 SIMPLE b hash_ALL NULL #hash#$hj 612 test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time 4 Using where; Using join buffer (flat, BNLH join) DROP TABLE t1,t2,t3; # End of the test file mysqltest: Result content mismatch safe_process [15680] : Got signal 17, child_pid: 15681 safe_process [15680] : Killing child: 15681 safe_process [15680] : Child exit: 1
          mbakke Marius Bakke added a comment -

          I believe this is a duplicate of MDEV-7761.

          mbakke Marius Bakke added a comment - I believe this is a duplicate of MDEV-7761 .

          People

            Unassigned Unassigned
            whissi Thomas Deutschmann
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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