| 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: | |
| Category: | Tests | Severity: | S3 (Non-critical) |
| Version: | 5.6.26 | OS: | CentOS |
| Assigned to: | CPU Architecture: | Any | |
[18 Sep 2015 1:02]
MySQL Verification Team
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
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.