Hi, looks like dev-db/percona-server-5.6.26.74.0 test suite requires dev-python/mysql-python: Completed: Failed 9/3383 tests, 99.73% were successful. Failing test(s): innodb.percona_changed_page_bmp_flush innodb_stress.innodb_stress_blob innodb_stress.innodb_stress innodb_stress.innodb_stress_blob_nocompress innodb_stress.innodb_stress_crash innodb_stress.innodb_stress_crash_blob innodb_stress.innodb_stress_crash_blob_nocompress innodb_stress.innodb_stress_crash_nocompress innodb_stress.innodb_stress_nocompress innodb_stress.innodb_stress w1 [ fail ] Test ended at 2015-09-21 13:51:24 CURRENT_TEST: innodb_stress.innodb_stress Traceback (most recent call last): File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 3, in <module> import MySQLdb ImportError: No module named MySQLdb mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/1/run/mysqld.1.pid 0 1000 2 10 root 127.0.0.1 10131 test 0 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/1/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 Retrying test innodb_stress.innodb_stress_blob, attempt(2/3)... sys_vars.innodb_compression_pad_pct_max_basic w3 [ pass ] 8 sys_vars.innodb_concurrency_tickets_basic w3 [ pass ] 6 sys_vars.innodb_corrupt_table_action_basic w3 [ pass ] 4 sys_vars.innodb_data_file_path_basic w3 [ pass ] 2 sys_vars.innodb_data_home_dir_basic w3 [ pass ] 3 sys_vars.innodb_disable_sort_file_cache_basic w3 [ pass ] 8 sys_vars.innodb_doublewrite_basic w3 [ pass ] 3 sys_vars.innodb_empty_free_list_algorithm_basic w3 [ pass ] 2 innodb_stress.innodb_stress_blob w1 [ retry-fail ] Test ended at 2015-09-21 13:51:28 CURRENT_TEST: innodb_stress.innodb_stress_blob Traceback (most recent call last): File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 3, in <module> import MySQLdb ImportError: No module named MySQLdb mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/1/run/mysqld.1.pid 0 1000 2 10 root 127.0.0.1 10131 test 1 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/1/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 Retrying test innodb_stress.innodb_stress_blob_nocompress, attempt(2/3)... innodb_stress.innodb_stress_blob_nocompress w1 [ retry-fail ] Test ended at 2015-09-21 13:51:30 CURRENT_TEST: innodb_stress.innodb_stress_blob_nocompress Traceback (most recent call last): File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 3, in <module> import MySQLdb ImportError: No module named MySQLdb mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/1/run/mysqld.1.pid 0 1000 2 10 root 127.0.0.1 10131 test 1 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/1/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 Retrying test innodb_stress.innodb_stress_crash, attempt(2/3)... innodb_stress.innodb_stress_crash_blob w1 [ retry-fail ] Test ended at 2015-09-21 13:51:32 CURRENT_TEST: innodb_stress.innodb_stress_crash_blob Traceback (most recent call last): File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 3, in <module> import MySQLdb ImportError: No module named MySQLdb mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/1/run/mysqld.1.pid 10 1000 2 0 root 127.0.0.1 10131 test 1 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/1/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 Retrying test innodb_stress.innodb_stress_crash_blob_nocompress, attempt(2/3)... innodb_stress.innodb_stress_crash_nocompress w3 [ fail ] Test ended at 2015-09-21 13:51:34 CURRENT_TEST: innodb_stress.innodb_stress_crash_nocompress Traceback (most recent call last): File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 3, in <module> import MySQLdb ImportError: No module named MySQLdb mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/3/run/mysqld.1.pid 10 1000 2 0 root 127.0.0.1 10151 test 0 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/3/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 Retrying test innodb_stress.innodb_stress_nocompress, attempt(2/3)... perfschema.rpl_statements w3 [ pass ] 265 innodb_stress.innodb_stress_nocompress w1 [ retry-fail ] Test ended at 2015-09-21 13:51:37 CURRENT_TEST: innodb_stress.innodb_stress_nocompress Traceback (most recent call last): File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 3, in <module> import MySQLdb ImportError: No module named MySQLdb mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/1/run/mysqld.1.pid 0 1000 2 10 root 127.0.0.1 10131 test 0 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/1/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 However, even with dev-python/mysql-python these tests are still failing: innodb_stress.innodb_stress w2 [ fail ] Test ended at 2015-09-21 15:12:17 CURRENT_TEST: innodb_stress.innodb_stress File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 50 except Exception, e: ^ SyntaxError: invalid syntax mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Retrying test innodb_stress.innodb_stress, attempt(2/3)... innodb_stress.innodb_stress w2 [ retry-fail ] Test ended at 2015-09-21 15:12:18 CURRENT_TEST: innodb_stress.innodb_stress File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 50 except Exception, e: ^ SyntaxError: invalid syntax mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Retrying test innodb_stress.innodb_stress_blob, attempt(2/3)... innodb_stress.innodb_stress_blob_nocompress w2 [ fail ] Test ended at 2015-09-21 15:12:19 CURRENT_TEST: innodb_stress.innodb_stress_blob_nocompress File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 50 except Exception, e: ^ SyntaxError: invalid syntax mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Retrying test innodb_stress.innodb_stress_blob_nocompress, attempt(2/3)... innodb_stress.innodb_stress_blob w4 [ retry-fail ] Test ended at 2015-09-21 15:12:19 CURRENT_TEST: innodb_stress.innodb_stress_blob File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 50 except Exception, e: ^ SyntaxError: invalid syntax mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Retrying test innodb.percona_innodb_kill_idle_trx, attempt(2/3)... innodb_stress.innodb_stress_blob_nocompress w2 [ retry-fail ] Test ended at 2015-09-21 15:12:21 CURRENT_TEST: innodb_stress.innodb_stress_blob_nocompress File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 50 except Exception, e: ^ SyntaxError: invalid syntax mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/2/run/mysqld.1.pid 0 1000 2 10 root 127.0.0.1 10561 test 1 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/2/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 Retrying test innodb_stress.innodb_stress_crash, attempt(2/3)... innodb_stress.innodb_stress_crash_blob w2 [ fail ] Test ended at 2015-09-21 15:12:22 CURRENT_TEST: innodb_stress.innodb_stress_crash_blob File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 50 except Exception, e: ^ SyntaxError: invalid syntax mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed Output from before failure: exec of 'python /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/2/run/mysqld.1.pid 10 1000 2 0 root 127.0.0.1 10561 test 1 4096 /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests/tmp/2/load_generator 0 0 0' failed, error: 256, status: 1, errno: 2 innodb_stress.innodb_stress_crash_blob w2 [ retry-fail ] Test ended at 2015-09-21 15:12:23 CURRENT_TEST: innodb_stress.innodb_stress_crash_blob File "/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/load_generator.py", line 50 except Exception, e: ^ SyntaxError: invalid syntax mysqltest: In included file "./suite/innodb_stress/include/innodb_stress.inc": included from ./suite/innodb_stress/include/innodb_stress.inc at line 83: At line 83: command "$exec" failed [...] Reproducible: Always
This should have been disabled in the ebuild: for t in innodb_stress.innodb_stress \ innodb_stress.innodb_stress_blob innodb_stress.innodb_stress_blob_nocompress \ innodb_stress.innodb_stress_crash innodb_stress.innodb_stress_crash_blob \ innodb_stress.innodb_stress_crash_blob_nocompress innodb_stress.innodb_stress_crash_nocompress \ innodb_stress.innodb_stress_nocompress ; do mysql-multilib_disable_test "$t" "False positives due to python exception syntax" done
Interesting, yes - I see that these tests should be disabled: Total Test time (real) = 1.16 sec * Tests succeeded. * test 'main.mysql_client_test' disabled: 'False positives in Gentoo' * test 'binlog.binlog_statement_insert_delayed' disabled: 'False positives in Gentoo' * test 'main.information_schema' disabled: 'False positives in Gentoo' * test 'main.mysqld--help-notwin' disabled: 'False positives in Gentoo' * test 'binlog.binlog_mysqlbinlog_filter' disabled: 'False positives in Gentoo' * test 'perfschema.binlog_edge_mix' disabled: 'False positives in Gentoo' * test 'perfschema.binlog_edge_stmt' disabled: 'False positives in Gentoo' * test 'funcs_1.is_columns_mysql' disabled: 'False positives in Gentoo' * test 'funcs_1.is_tables_mysql' disabled: 'False positives in Gentoo' * test 'funcs_1.is_triggers' disabled: 'False positives in Gentoo' * test 'main.variables' disabled: 'False positives in Gentoo' * test 'main.myisam' disabled: 'False positives in Gentoo' * test 'main.merge_recover' disabled: 'False positives in Gentoo' * test 'engines/funcs.db_alter_character_set' disabled: 'False positives in Gentoo' * test 'engines/funcs.db_alter_character_set_collate' disabled: 'False positives in Gentoo' * test 'engines/funcs.db_alter_collate_ascii' disabled: 'False positives in Gentoo' * test 'engines/funcs.db_alter_collate_utf8' disabled: 'False positives in Gentoo' * test 'engines/funcs.db_create_character_set' disabled: 'False positives in Gentoo' * test 'engines/funcs.db_create_character_set_collate' disabled: 'False positives in Gentoo' * test 'main.percona_bug1289599' disabled: 'False positives in Gentoo' * test 'main.mysqlhotcopy_archive' disabled: 'False positives in Gentoo' * test 'main.mysqlhotcopy_myisam' disabled: 'False positives in Gentoo' * test 'innodb_stress.innodb_stress' disabled: 'False positives due to python exception syntax' * test 'innodb_stress.innodb_stress_blob' disabled: 'False positives due to python exception syntax' * test 'innodb_stress.innodb_stress_blob_nocompress' disabled: 'False positives due to python exception syntax' * test 'innodb_stress.innodb_stress_crash' disabled: 'False positives due to python exception syntax' * test 'innodb_stress.innodb_stress_crash_blob' disabled: 'False positives due to python exception syntax' * test 'innodb_stress.innodb_stress_crash_blob_nocompress' disabled: 'False positives due to python exception syntax' * test 'innodb_stress.innodb_stress_crash_nocompress' disabled: 'False positives due to python exception syntax' * test 'innodb_stress.innodb_stress_nocompress' disabled: 'False positives due to python exception syntax' But they will be executed (and are passing with Python2.7): [...] sys_vars.innodb_file_format_basic w4 [ pass ] 3 sys_vars.innodb_file_format_check_basic w4 [ pass ] 4 sys_vars.innodb_file_io_threads_basic w4 [ pass ] 4 sys_vars.innodb_flush_log_at_timeout_basic w4 [ pass ] 5 sys_vars.innodb_flush_log_at_trx_commit_basic w4 [ pass ] 5 innodb.percona_log_arch_expire_sec w2 [ pass ] 22997 innodb_stress.innodb_stress_blob w3 [ pass ] 12382 innodb_stress.innodb_stress_blob_nocompress w4 [ pass ] 11286 innodb.percona_log_arch_func w2 [ pass ] 15238 main.backup_locks_binlog_row w1 [ pass ] 27509 innodb_stress.innodb_stress_crash w3 [ pass ] 12485 innodb_stress.innodb_stress_crash_blob w4 [ pass ] 22448 innodb.percona_purge_archived_logs_before w2 [ pass ] 28153 main.backup_locks_binlog_stmt w1 [ pass ] 32327 main.backup_locks_mysqldump w1 [ pass ] 74 innodb_stress.innodb_stress_crash_blob_nocompress w3 [ pass ] 22966 main.backup_safe_binlog_info w1 [ pass ] 1080 main.bug39022 w1 [ pass ] 244 main.commit_1innodb w1 [ pass ] 151 main.create_select_tmp w1 [ pass ] 269 main.flush_block_commit_notembedded w1 [ pass ] 1076 innodb_stress.innodb_stress_crash_nocompress w4 [ pass ] 11534 innodb_stress.innodb_stress_nocompress w3 [ pass ] 425 main.innodb_mysql_lock2 w1 [ pass ] 819 main.partition_innodb_stmt w1 [ pass ] 455 perfschema.relaylog w1 [ pass ] 225 [...]
Looks like "disabled.def" is in the wrong directory: From /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql-abi_x86_64.amd64/mysql-test I called $ perl mysql-test-run.pl --print-testcases --suite=innodb_stress --force \ --vardir="/var/tmp/portage/dev-db/percona-server-5.6.26.74.0/temp/var-tests" \ --testcase-timeout=30 \ --reorder The last output is [innodb_stress.innodb_stress_nocompress] slave_opt= [--innodb_flush_log_at_trx_commit=2, --log_slave_updates=0] path= /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/innodb_stress_nocompress.test rpl_test= 1 need_binlog= 1 force_restart= 1 innodb_test= 1 result_file= /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/r/innodb_stress_nocompress.result name= innodb_stress.innodb_stress_nocompress shortname= innodb_stress_nocompress template_path= suite/rpl/my.cnf criteria= ndb=B suite/rpl/my.cnf --binlog-do-db=test!--innodb-file-per-table!--innodb_flush_log_at_trx_commit=2!--sync_binlog=10~ --innodb_flush_log_at_trx_commit=2!--log_slave_updates=0 force-restart master_opt= [--binlog-do-db=test, --innodb-file-per-table, --sync_binlog=10, --innodb_flush_log_at_trx_commit=2] ...which should be a disabled test. Now I copy /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/disabled.def to /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/disabled.def and re-run the command. New output: [innodb_stress.innodb_stress_nocompress] criteria= ndb=B ~ no-restart shortname= innodb_stress_nocompress disable= 1 path= /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/t/innodb_stress_nocompress.test skip= 1 result_file= /var/tmp/portage/dev-db/percona-server-5.6.26.74.0/work/mysql/mysql-test/suite/innodb_stress/r/innodb_stress_nocompress.result comment= False positives due to python exception syntax name= innodb_stress.innodb_stress_nocompress ...this time the test is disabled as expected! # emerge --info Portage 2.2.20.1 (python 3.4.3-final-0, default/linux/amd64/13.0, gcc-4.9.3, glibc-2.21-r1, 4.2.0-gentoo-r1 x86_64) ================================================================= System uname: Linux-4.2.0-gentoo-r1-x86_64-Intel-R-_Core-TM-_i7-3770K_CPU_@_3.50GHz-with-gentoo-2.2 KiB Mem: 4023224 total, 1904388 free KiB Swap: 1048572 total, 1042760 free Timestamp of repository gentoo: Mon, 21 Sep 2015 16:15:01 +0000 Timestamp of repository poly-c: Mon, 21 Sep 2015 11:54:14 +0000 sh bash 4.3_p42 ld GNU ld (Gentoo 2.25.1 p1.1) 2.25.1 app-shells/bash: 4.3_p42::gentoo dev-java/java-config: 2.2.0::gentoo dev-lang/perl: 5.22.0::gentoo dev-lang/python: 2.7.10::gentoo, 3.4.3::gentoo dev-util/cmake: 3.3.2::gentoo dev-util/pkgconfig: 0.28-r3::gentoo sys-apps/baselayout: 2.2::gentoo sys-apps/openrc: 0.17::gentoo sys-apps/sandbox: 2.8::gentoo sys-devel/autoconf: 2.69-r1::gentoo sys-devel/automake: 1.13.4::gentoo, 1.14.1::gentoo, 1.15::gentoo sys-devel/binutils: 2.25.1-r1::gentoo sys-devel/gcc: 4.9.3::gentoo sys-devel/gcc-config: 1.8::gentoo sys-devel/libtool: 2.4.6-r1::gentoo sys-devel/make: 4.1-r1::gentoo sys-kernel/linux-headers: 4.2::gentoo (virtual/os-headers) sys-libs/glibc: 2.21-r1::gentoo
Fixed in git commit 0dd0a3502b745c0e89e00fd148dffaf217b61bfa Author: Brian Evans <grknight@gentoo.org> Date: Mon Sep 21 12:55:48 2015 -0400 dev-db/percona-server: Correctly skip innodb_stress test suite wrt bug 561024 Package-Manager: portage-2.2.20.1
*** Bug 561654 has been marked as a duplicate of this bug. ***
