[MDEV-26320] main.selectivity_no_engine fails sometimes with Result content mismatch Created: 2021-08-08  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5.12
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Thomas Deutschmann Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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.

 Comments   
Comment by Efraim Flashner [ 2021-09-29 ]

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

Comment by Marius Bakke [ 2022-09-08 ]

I believe this is a duplicate of MDEV-7761.

Generated at Thu Feb 08 09:44:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.