Bug #78472 Test failures when building without performance schema
Submitted: 17 Sep 2015 19:58 Modified: 18 Sep 2015 1:02
Reporter: Justin Tolmer Email Updates:
Status: Verified Impact on me:
None 
Category:Tests Severity:S3 (Non-critical)
Version:5.6.26 OS:CentOS
Assigned to: CPU Architecture:Any

[17 Sep 2015 19:58] Justin Tolmer
Description:
These tests have dependencies on performance schema, but don't check for it in the .test files and so fail when performance schema isn't available.

main.validate_password_plugin
sys_vars.pfs_max_digest_length_basic

main.validate_password_plugin            w1 [ fail ]
        Test ended at 2015-09-17 12:54:24

CURRENT_TEST: main.validate_password_plugin
mysqltest: At line 258: query 'SELECT NAME FROM performance_schema.setup_instruments WHERE NAME LIKE '%validate%'' failed: 1146: Table 'performance_schema.setup
_instruments' doesn't exist

sys_vars.pfs_max_digest_length_basic     w2 [ fail ]
        Test ended at 2015-09-17 12:54:25

<omitted> 

2015-09-17 22:54:22 1184179 [ERROR] /data/users/jtolmer/source/oracle_mysql/sql/mysqld: unknown variable 'performance-schema-max-digest-length=123'
2015-09-17 22:54:22 1184179 [ERROR] Aborting

How to repeat:
cmake -DWITHOUT_PERFSCHEMA_STORAGE_ENGINE=1 -DBUILD_CONFIG=mysql_release
make -j12
cd mysql-test
./mtr --parallel=2 --force main.validate_password_plugin sys_vars.pfs_max_digest_length_basic

Suggested fix:
Refactor the tests or add 
--source include/have_perfschema.inc
to the tests.
[18 Sep 2015 1:02] Miguel Solorzano
Thank you for the bug repot.

[miguel@miguelbr mysql-5.6]$ cd mysql-test                                                                                                 
[miguel@miguelbr mysql-test]$ ./mtr --parallel=2 --force main.validate_password_plugin sys_vars.pfs_max_digest_length_basic                
Logging: ./mtr  --parallel=2 --force main.validate_password_plugin sys_vars.pfs_max_digest_length_basic                                    
2015-09-17 21:58:51 0 [Note] /home/miguel/bugtest/mysql-5.6/sql/mysqld (mysqld 5.6.28) starting as process 17636 ...                       
2015-09-17 21:58:51 17636 [Note] Plugin 'FEDERATED' is disabled.                                                                           
2015-09-17 21:58:51 17636 [Note] Binlog end                                                                                                
2015-09-17 21:58:51 17636 [Note] Shutting down plugin 'CSV'                                                                                
2015-09-17 21:58:51 17636 [Note] Shutting down plugin 'MyISAM'                                                                             
MySQL Version 5.6.28                                                                                                                       
Checking supported features...                                                                                                             
 - SSL connections supported                                                                                                               
Collecting tests...                                                                                                                        
Removing old var directory...                                                                                                              
Creating var directory '/home/miguel/bugtest/mysql-5.6/mysql-test/var'...                                                                  
Installing system database...                                                                                                              

==============================================================================

TEST                                  WORKER RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[2] Using MTR_BUILD_THREAD 301, with reserved ports 13010..13019
main.validate_password_plugin            w2 [ fail ]                  
        Test ended at 2015-09-17 21:59:19