Skip to content
  • Akhila Maddukuri's avatar
    e7fad42a
    Description: · e7fad42a
    Akhila Maddukuri authored
    ```---------:frontmatter
    sys_vars.all_vars fails on Windows 32 and 64 bit on daily trunk commercial
    branch with multiple combinations.
    
    Failure snippet-
    sys_vars.all_vars                        w1 [ fail ]
            Test ended at 2012-08-22 09:20:13
    
    CURRENT_TEST: sys_vars.all_vars
    'diff' is not recognized as an internal or external command,
    operable program or batch file.
    ```
    G:/pb2/test/sb_1-6672625-1345599364.71/mysql-advanced-5.7.0-m10-winx64/mysql-t
    est/suite/sys_vars/r/all_vars.result	2012-08-22 01:05:07.000000000 +0300
    +++
    G:\pb2\test\sb_1-6672625-1345599364.71\mysql-advanced-5.7.0-m10-winx64\mysql-t
    est\suite\sys_vars\r\all_vars.reject	2012-08-22 10:20:13.251978100 +0300
    @@ -12,5 +12,7 @@
     select variable_name as `There should be *no* variables listed below:` from
    t2
     left join t1 on variable_name=test_name where test_name is null ORDER BY
    variable_name;
     There should be *no* variables listed below:
    +LOG_THROTTLE_QUERIES_NOT_USING_INDEXES
    +LOG_THROTTLE_QUERIES_NOT_USING_INDEXES
     drop table t1;
     drop table t2;
    
    mysqltest: Result length mismatch
    
    How to repeat:
    --------------
    Seen on daily trunk commercial.
    
    mysql-test-run.pl  --timer --force --parallel=8 --comment=n_mix_4k_size
    --vardir=var-n_mix --mysqld=--binlog-format=mixed
    --experimental=collections/default.experimental --skip-ndb
    --skip-test-list=collections/disabled-per-push.list
    --mysqld=--innodb-page-size=4k --skip-test=innodb_ignore_builtin
    
    Suggested fix:
    --------------
    The purpose of all_vars.test is to make sure that there are tests for all 
    system variables. In daily trunk commercial it is failing because it could find 
    test for a system variable called log_throttle_queries_not_using_indexes.
    
    In windows platform the test-name is truncated to 
    log_throttle_queries_not_using_indexes_basic.tes 
    Hence all_vars.test couldn't find a .test file for the above variable.
    
    Inorder to get rid of the truncation, suggested fix is to change the name of the 
    test to a smaller name which is log_throttle_qni_basic.test
    
    Also changing the file-name must happen in conjunction with another alias-rewrite:
    
    update t2 set variable_name= replace(variable_name, "_THROTTLE_QUERIES_NOT_USING_INDEXES", 
                                         "_THROTTLE_QNI");
    
    
    e7fad42a
    Description:
    Akhila Maddukuri authored
    ```---------:frontmatter
    sys_vars.all_vars fails on Windows 32 and 64 bit on daily trunk commercial
    branch with multiple combinations.
    
    Failure snippet-
    sys_vars.all_vars                        w1 [ fail ]
            Test ended at 2012-08-22 09:20:13
    
    CURRENT_TEST: sys_vars.all_vars
    'diff' is not recognized as an internal or external command,
    operable program or batch file.
    ```
    G:/pb2/test/sb_1-6672625-1345599364.71/mysql-advanced-5.7.0-m10-winx64/mysql-t
    est/suite/sys_vars/r/all_vars.result	2012-08-22 01:05:07.000000000 +0300
    +++
    G:\pb2\test\sb_1-6672625-1345599364.71\mysql-advanced-5.7.0-m10-winx64\mysql-t
    est\suite\sys_vars\r\all_vars.reject	2012-08-22 10:20:13.251978100 +0300
    @@ -12,5 +12,7 @@
     select variable_name as `There should be *no* variables listed below:` from
    t2
     left join t1 on variable_name=test_name where test_name is null ORDER BY
    variable_name;
     There should be *no* variables listed below:
    +LOG_THROTTLE_QUERIES_NOT_USING_INDEXES
    +LOG_THROTTLE_QUERIES_NOT_USING_INDEXES
     drop table t1;
     drop table t2;
    
    mysqltest: Result length mismatch
    
    How to repeat:
    --------------
    Seen on daily trunk commercial.
    
    mysql-test-run.pl  --timer --force --parallel=8 --comment=n_mix_4k_size
    --vardir=var-n_mix --mysqld=--binlog-format=mixed
    --experimental=collections/default.experimental --skip-ndb
    --skip-test-list=collections/disabled-per-push.list
    --mysqld=--innodb-page-size=4k --skip-test=innodb_ignore_builtin
    
    Suggested fix:
    --------------
    The purpose of all_vars.test is to make sure that there are tests for all 
    system variables. In daily trunk commercial it is failing because it could find 
    test for a system variable called log_throttle_queries_not_using_indexes.
    
    In windows platform the test-name is truncated to 
    log_throttle_queries_not_using_indexes_basic.tes 
    Hence all_vars.test couldn't find a .test file for the above variable.
    
    Inorder to get rid of the truncation, suggested fix is to change the name of the 
    test to a smaller name which is log_throttle_qni_basic.test
    
    Also changing the file-name must happen in conjunction with another alias-rewrite:
    
    update t2 set variable_name= replace(variable_name, "_THROTTLE_QUERIES_NOT_USING_INDEXES", 
                                         "_THROTTLE_QNI");
    
    
Loading