sh-2.05b$ ./mysql-test-run.pl --force Logging: ./mysql-test-run.pl --force MySQL Version 5.0.45 Skipping ndbcluster, mysqld not compiled with ndbcluster Setting mysqld to support SSL connections Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Using IM_PORT = 9312 Using IM_MYSQLD1_PORT = 9313 Using IM_MYSQLD2_PORT = 9314 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database Installing Master Database Installing Slave1 Database Saving snapshot of installed databases ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- alias [ pass ] 140 alter_table-big [ skipped ] Test need 'big-test' option alter_table [ pass ] 1815 analyse [ pass ] 245 analyze [ pass ] 127 ansi [ pass ] 44 archive [ skipped ] Test requires: 'have_archive' archive_gis [ skipped ] Test requires: 'have_archive' auto_increment [ pass ] 622 backup [ pass ] 250 bdb-alter-table-1 [ skipped ] Test requires: 'have_bdb' bdb-alter-table-2 [ skipped ] Test requires: 'have_bdb' bdb-crash [ skipped ] Test requires: 'have_bdb' bdb-deadlock [ skipped ] Test requires: 'have_bdb' bdb [ skipped ] Test requires: 'have_bdb' bdb_cache [ skipped ] Test requires: 'have_bdb' bdb_gis [ skipped ] Test requires: 'have_bdb' bdb_notembedded [ skipped ] Test requires: 'have_bdb' bench_count_distinct [ pass ] 338 bigint [ pass ] 376 binary [ pass ] 226 binlog [ skipped ] Test requires: 'have_bdb' binlog_killed [ pass ] 10278 blackhole [ skipped ] Test requires: 'have_blackhole' bool [ pass ] 91 bootstrap [ pass ] 722 bulk_replace [ pass ] 24 case [ pass ] 204 cast [ pass ] 300 check [ pass ] 21163 client_xml [ pass ] 1261 comments [ pass ] 19 compare [ pass ] 78 compress [ pass ] 73526 connect [ pass ] 5182 consistent_snapshot [ pass ] 49 constraints [ pass ] 114 count_distinct [ pass ] 170 count_distinct2 [ pass ] 14264 count_distinct3 [ pass ] 199387 create [ pass ] 1849 create_not_windows [ pass ] 71 create_select_tmp [ pass ] 197 csv [ skipped ] Test requires: 'have_csv' ctype_big5 [ pass ] 530 ctype_collate [ pass ] 296 ctype_cp1250_ch [ pass ] 105 ctype_cp1251 [ pass ] 89 ctype_cp932 [ pass ] 1783 ctype_cp932_binlog [ pass ] 196 ctype_create [ pass ] 201 ctype_eucjpms [ pass ] 859 ctype_euckr [ pass ] 441 ctype_gb2312 [ pass ] 412 ctype_gbk [ pass ] 457 ctype_hebrew [ pass ] 41 ctype_latin1 [ pass ] 240 ctype_latin1_de [ pass ] 287 ctype_latin2 [ pass ] 130 ctype_latin2_ch [ pass ] 86 ctype_many [ pass ] 845 ctype_mb [ pass ] 91 ctype_recoding [ pass ] 373 ctype_sjis [ pass ] 366 ctype_tis620 [ pass ] 853 ctype_uca [ pass ] 1490 ctype_ucs [ pass ] 1000 ctype_ucs2_def [ pass ] 53 ctype_ucs_binlog [ pass ] 219 ctype_ujis [ pass ] 2127 ctype_utf8 [ pass ] 2463 date_formats [ pass ] 327 default [ pass ] 195 delayed [ pass ] 313 delete [ pass ] 365 derived [ pass ] 17582 dirty_close [ pass ] 38 distinct [ pass ] 942 drop [ pass ] 186 drop_temp_table [ pass ] 113 empty_table [ pass ] 33 endspace [ pass ] 361 error_simulation [ skipped ] Test need debug binaries errors [ pass ] 65 exampledb [ skipped ] Test requires: 'have_exampledb' execution_constants [ pass ] 5058 explain [ pass ] 125 federated [ skipped ] Test requires: 'have_federated_db' federated_archive [ skipped ] Test requires: 'have_archive' federated_bug_13118 [ skipped ] Test requires: 'have_federated_db' fix_priv_tables [ skipped ] Test need MYSQL_FIX_PRIVILEGE_TABLES flush [ pass ] 2578 flush2 [ pass ] 30 flush_block_commit [ pass ] 2066 flush_block_commit_notembedded [ pass ] 1076 flush_read_lock_kill [ skipped ] Test need debug binaries flush_table [ pass ] 141 foreign_key [ pass ] 52 fulltext [ pass ] 682 fulltext2 [ pass ] 5625 fulltext_cache [ pass ] 80 fulltext_distinct [ pass ] 67 fulltext_left_join [ pass ] 183 fulltext_multi [ pass ] 50 fulltext_order_by [ pass ] 178 fulltext_update [ pass ] 30 fulltext_var [ pass ] 40 func_compress [ pass ] 29385 func_concat [ pass ] 167 func_crypt [ pass ] 191 func_date_add [ pass ] 147 func_default [ pass ] 60 func_des_encrypt [ pass ] 37 func_encrypt [ pass ] 176 func_encrypt_nossl [ skipped ] Test requires: 'not_openssl' func_equal [ pass ] 89 func_gconcat [ pass ] 1289 func_group [ pass ] 8268 func_if [ pass ] 155 func_in [ pass ] 22903 func_isnull [ pass ] 61 func_like [ pass ] 183 func_math [ pass ] 384 func_misc [ pass ] 12770 func_op [ pass ] 70 func_regexp [ pass ] 156 func_sapdb [ pass ] 190 func_set [ pass ] 102 func_str [ pass ] 2330 func_system [ pass ] 101 func_test [ pass ] 244 func_time [ pass ] 8022 func_timestamp [ pass ] 52 gcc296 [ pass ] 66 gis-rtree [ pass ] 2618 gis [ pass ] 1101 grant [ pass ] 2266 grant2 [ pass ] 943 grant3 [ pass ] 65 grant_cache [ pass ] 277 greedy_optimizer [ pass ] 1525 group_by [ pass ] 1888 group_min_max [ pass ] 5550 handler [ pass ] 2837 having [ pass ] 520 heap [ pass ] 2266 heap_auto_increment [ pass ] 58 heap_btree [ pass ] 417 heap_hash [ pass ] 481 help [ pass ] 2725 im_daemon_life_cycle [ disabled ] Bug#20294: Instance manager tests fail randomly im_life_cycle [ disabled ] Bug#27851: Instance manager test im_life_cycle fails randomly im_options_set [ disabled ] Bug#20294: Instance manager tests fail randomly im_options_unset [ disabled ] Bug#20294: Instance manager tests fail randomly im_utils [ disabled ] Bug#20294: Instance manager tests fail randomly index_merge [ pass ] 34054 index_merge_bdb [ skipped ] Test requires: 'have_bdb' index_merge_innodb [ pass ] 7320 index_merge_innodb2 [ pass ] 4681 index_merge_ror [ pass ] 50059 index_merge_ror_cpk [ pass ] 40682 information_schema [ pass ] 57914 information_schema_chmod [ pass ] 240 information_schema_db [ pass ] 637 information_schema_inno [ pass ] 129 init_connect [ pass ] 240 init_file [ pass ] 43 innodb-big [ skipped ] Test need 'big-test' option innodb-deadlock [ pass ] 6218 innodb-lock [ pass ] 4128 innodb-replace [ pass ] 71 innodb-ucs2 [ pass ] 1039 innodb [ pass ] 79898 innodb_cache [ pass ] 357 innodb_gis [ pass ] 791 innodb_handler [ pass ] 190 innodb_mysql [ pass ] 79618 innodb_notembedded [ pass ] 95 innodb_timeout_rollback [ pass ] 2869 innodb_unsafe_binlog [ pass ] 51896 insert [ pass ] 9896 insert_notembedded [ pass ] 248 insert_select-binlog [ pass ] 116 insert_select [ pass ] 663 insert_update [ pass ] 2517 join [ pass ] 1636 join_crash [ pass ] 149 join_nested [ pass ] 1513 join_outer [ pass ] 1577 key [ pass ] 671 key_cache [ pass ] 1085 key_diff [ pass ] 62 key_primary [ pass ] 39 keywords [ pass ] 70 kill [ pass ] 25616 limit [ pass ] 139 loaddata [ pass ] 560 loaddata_autocom_innodb [ pass ] 67 loaddata_autocom_ndb [ skipped ] No ndbcluster support lock [ pass ] 223 lock_multi [ pass ] 23544 lock_tables_lost_commit [ pass ] 55 long_tmpdir [ pass ] 31 lowercase_fs_off [ pass ] 99 lowercase_mixed_tmpdir [ pass ] 83 lowercase_table [ pass ] 250 lowercase_table2 [ skipped ] Test requires: 'lowercase2' lowercase_table3 [ skipped ] Test requires: 'lowercase0' lowercase_table_grant [ pass ] 57 lowercase_table_qcache [ pass ] 76 lowercase_view [ pass ] 308 merge [ pass ] 1284 metadata [ pass ] 148 mix_innodb_myisam_binlog [ pass ] 3152 multi_statement [ pass ] 54 multi_update [ pass ] 257041 myisam-blob [ pass ] 21973 myisam [ pass ] 8919 mysql [ fail ] Errors are (from /mnt/disk1/share/usr/local/mysql/mysql-test/var/log/mysqltest-time) : sh: line 1: /dev/null: Permission denied mysqltest: At line 147: command "$MYSQL < $MYSQLTEST_VARDIR/tmp/b19216.tmp >/dev/null" failed (the last lines may be the most important ones) Result from queries before failure can be found in r/mysql.log Stopping All Servers Restoring snapshot of databases Resuming Tests mysql_client_test [ pass ] 177852 mysql_protocols [ pass ] 950 mysql_upgrade [ fail ] Errors are (from /mnt/disk1/share/usr/local/mysql/mysql-test/var/log/mysqltest-time) : mysqltest: At line 15: command "$MYSQL_UPGRADE --skip-verbose 2>&1" failed (the last lines may be the most important ones) Result from queries before failure can be found in r/mysql_upgrade.log Stopping All Servers Restoring snapshot of databases Resuming Tests mysqladmin [ pass ] 402 mysqlbinlog-cp932 [ pass ] 717 mysqlbinlog [ fail ] Errors are (from /mnt/disk1/share/usr/local/mysql/mysql-test/var/log/mysqltest-time) : sh: line 1: /dev/null: Permission denied mysqltest: At line 51: command "$MYSQL_BINLOG --short-form --local-load=$MYSQLTEST_VARDIR/tmp/ $MYSQLTEST_VARDIR/log/master-bin.000002 2> /dev/null" failed (the last lines may be the most important ones) Result from queries before failure can be found in r/mysqlbinlog.log Stopping All Servers Restoring snapshot of databases Resuming Tests mysqlbinlog2 [ pass ] 2933 mysqlcheck [ pass ] 1196 mysqldump-max [ skipped ] Test requires: 'have_archive' mysqldump [ pass ] 22703 mysqlshow [ pass ] 1298 mysqltest [ fail ] Errors are (from /mnt/disk1/share/usr/local/mysql/mysql-test/var/log/mysqltest-time) : sh: line 1: /dev/null: Permission denied mysqltest: At line 918: system command 'echo "hej" > /dev/null' failed (the last lines may be the most important ones) Result from queries before failure can be found in r/mysqltest.log Stopping All Servers Restoring snapshot of databases Resuming Tests ndb_alter_table [ skipped ] No ndbcluster support ndb_alter_table2 [ skipped ] No ndbcluster support ndb_autodiscover [ skipped ] No ndbcluster support ndb_autodiscover2 [ skipped ] No ndbcluster support ndb_autodiscover3 [ skipped ] No ndbcluster support ndb_basic [ skipped ] No ndbcluster support ndb_bitfield [ skipped ] No ndbcluster support ndb_blob [ skipped ] No ndbcluster support ndb_cache [ skipped ] No ndbcluster support ndb_cache2 [ skipped ] No ndbcluster support ndb_cache_multi [ skipped ] No ndbcluster support ndb_cache_multi2 [ skipped ] No ndbcluster support ndb_charset [ skipped ] No ndbcluster support ndb_condition_pushdown [ skipped ] No ndbcluster support ndb_config [ skipped ] No ndbcluster support ndb_database [ skipped ] No ndbcluster support ndb_gis [ skipped ] No ndbcluster support ndb_index [ skipped ] No ndbcluster support ndb_index_ordered [ skipped ] No ndbcluster support ndb_index_unique [ skipped ] No ndbcluster support ndb_insert [ skipped ] No ndbcluster support ndb_limit [ skipped ] No ndbcluster support ndb_load [ skipped ] No ndbcluster support ndb_loaddatalocal [ skipped ] No ndbcluster support ndb_lock [ skipped ] No ndbcluster support ndb_minmax [ skipped ] No ndbcluster support ndb_multi [ skipped ] No ndbcluster support ndb_read_multi_range [ skipped ] No ndbcluster support ndb_rename [ skipped ] No ndbcluster support ndb_replace [ skipped ] No ndbcluster support ndb_restore [ skipped ] No ndbcluster support ndb_restore_print [ skipped ] No ndbcluster support ndb_single_user [ skipped ] No ndbcluster support ndb_subquery [ skipped ] No ndbcluster support ndb_transaction [ skipped ] No ndbcluster support ndb_trigger [ skipped ] No ndbcluster support ndb_truncate [ skipped ] No ndbcluster support ndb_types [ skipped ] No ndbcluster support ndb_update [ skipped ] No ndbcluster support negation_elimination [ pass ] 185 not_embedded_server [ pass ] 40 null [ pass ] 558 null_key [ pass ] 7322 odbc [ pass ] 50 olap [ pass ] 575 openssl_1 [ pass ] 4705 order_by [ pass ] 2945 order_fill_sortbuf [ pass ] 5823 outfile [ pass ] 292 overflow [ pass ] 17 packet [ pass ] 63 perror [ fail ] Errors are (from /mnt/disk1/share/usr/local/mysql/mysql-test/var/log/mysqltest-time) : sh: line 1: /dev/null: Permission denied mysqltest: At line 9: command "$MY_PERROR 150 > /dev/null" failed (the last lines may be the most important ones) Result from queries before failure can be found in r/perror.log Stopping All Servers Restoring snapshot of databases Resuming Tests preload [ pass ] 19668 profiling [ pass ] 1170 ps [ pass ] 5281 ps_10nestset [ pass ] 104 ps_11bugs [ pass ] 245 ps_1general [ pass ] 3828 ps_2myisam [ pass ] 2673 ps_3innodb [ pass ] 3138 ps_4heap [ pass ] 2358 ps_5merge [ pass ] 5203 ps_6bdb [ skipped ] Test requires: 'have_bdb' ps_7ndb [ skipped ] No ndbcluster support ps_grant [ pass ] 179 query_cache [ pass ] 37890 query_cache_merge [ pass ] 4059 query_cache_notembedded [ pass ] 7251 raid [ skipped ] Test requires: 'have_raid' range [ pass ] 3153 read_only [ pass ] 137 rename [ pass ] 235 repair [ pass ] 346 replace [ pass ] 80 rollback [ pass ] 37 round [ pass ] 318 row [ pass ] 350 rowid_order_bdb [ skipped ] Test requires: 'have_bdb' rowid_order_innodb [ pass ] 322 rpl000001 [ pass ] 18506 rpl000002 [ pass ] 253 rpl000004 [ pass ] 210 rpl000005 [ pass ] 197 rpl000006 [ pass ] 181 rpl000008 [ pass ] 184 rpl000009 [ pass ] 636 rpl000010 [ pass ] 148 rpl000011 [ pass ] 182 rpl000012 [ pass ] 268 rpl000013 [ pass ] 230 rpl000015 [ pass ] 153 rpl000017 [ pass ] 112 rpl_EE_error [ pass ] 192 rpl_alter [ pass ] 237 rpl_auto_increment [ pass ] 502 rpl_auto_increment_11932 [ pass ] 221 rpl_change_master [ pass ] 3170 rpl_charset [ pass ] 530 mysql-test-run: WARNING: start_reap_all pid: 5716 mysql-test-run: WARNING: mark_process_dead couldn't find an entry for pid: 5716 rpl_charset_sjis [ pass ] 208 rpl_commit_after_flush [ pass ] 160 rpl_create_database [ pass ] 286 rpl_critical_errors [ pass ] 12 rpl_ddl [ pass ] 4730 rpl_deadlock [ pass ] 27028 rpl_delete_all [ pass ] 195 rpl_do_grant [ pass ] 190 rpl_drop [ pass ] 128 rpl_drop_db [ pass ] 1234 rpl_drop_temp [ pass ] 3123 rpl_dual_pos_advance [ pass ] 264 rpl_empty_master_crash [ pass ] 91 rpl_error_ignored_table [ pass ] 2159 rpl_failed_optimize [ pass ] 1823 rpl_flush_log_loop [ pass ] 10174 rpl_flush_tables [ pass ] 1260 rpl_free_items [ pass ] 3980 rpl_get_lock [ pass ] 4002 rpl_ignore_grant [ pass ] 183 rpl_ignore_revoke [ pass ] 163 rpl_ignore_table [ pass ] 392 rpl_init_slave [ pass ] 1137 rpl_innodb [ pass ] 199 rpl_insert_delayed [ pass ] 188 rpl_insert_id [ pass ] 1124 rpl_insert_ignore [ pass ] 364 rpl_insert_select [ pass ] 163 rpl_known_bugs_detection [ skipped ] Test need debug binaries rpl_loaddata [ pass ] 1388 rpl_loaddata_charset [ pass ] 239 rpl_loaddata_rule_m [ pass ] 138 rpl_loaddata_rule_s [ pass ] 150 rpl_loaddatalocal [ pass ] 13078 rpl_locale [ pass ] 176 rpl_log [ pass ] 407 rpl_log_pos [ pass ] 12255 rpl_many_optimize [ pass ] 1786 rpl_master_pos_wait [ pass ] 2145 rpl_max_relay_size [ pass ] 5034 rpl_misc_functions [ pass ] 724 rpl_multi_delete [ pass ] 199 rpl_multi_delete2 [ pass ] 252 rpl_multi_query [ pass ] 160 rpl_multi_update [ pass ] 218 rpl_multi_update2 [ pass ] 238 rpl_multi_update3 [ pass ] 433 rpl_multi_update4 [ pass ] 186 rpl_mystery22 [ pass ] 3181 rpl_ndb_innodb_trans [ skipped ] No ndbcluster support rpl_openssl [ pass ] 3449 rpl_optimize [ pass ] 141043 rpl_packet [ pass ] 2197 rpl_ps [ pass ] 178 rpl_redirect [ pass ] 169 rpl_relayrotate [ pass ] 20715 rpl_relayspace [ pass ] 2235 rpl_replicate_do [ pass ] 371 rpl_reset_slave [ pass ] 266 rpl_rewrite_db [ pass ] 333 rpl_rotate_logs [ pass ] 750 rpl_server_id1 [ pass ] 2126 rpl_server_id2 [ pass ] 1173 rpl_session_var [ pass ] 239 rpl_set_charset [ pass ] 188 rpl_skip_error [ pass ] 149 rpl_slave_status [ pass ] 191 rpl_sp [ pass ] 877 rpl_sp_effects [ pass ] 509 rpl_sporadic_master [ pass ] 251 rpl_ssl [ pass ] 16022 rpl_start_stop_slave [ pass ] 11963 rpl_temporary [ pass ] 6053 rpl_timezone [ pass ] 422 rpl_trigger [ pass ] 6169 rpl_trunc_temp [ pass ] 3163 rpl_until [ pass ] 8210 rpl_user_variables [ pass ] 704 rpl_variables [ pass ] 120 rpl_view [ pass ] 366 schema [ pass ] 37 select [ pass ] 72052 select_found [ pass ] 655 select_safe [ pass ] 153 show_check [ pass ] 921 skip_grants [ pass ] 153 skip_name_resolve [ pass ] 38 sp-big [ pass ] 2509 sp-code [ skipped ] Test need debug binaries sp-destruct [ pass ] 208 sp-dynamic [ pass ] 412 sp-error [ pass ] 1420 sp-prelocking [ pass ] 502 sp-security [ pass ] 832 sp-threads [ pass ] 2211 sp-ucs2 [ pass ] 58 sp-vars [ pass ] 898 sp [ pass ] 18842 sp_notembedded [ pass ] 2898 sp_stress_case [ pass ] 47003 sp_trans [ pass ] 1778 sp_trans_log [ pass ] 102 sql_mode [ pass ] 304 ssl [ pass ] 73484 ssl_compress [ pass ] 74336 ssl_connect [ pass ] 13824 status [ pass ] 610 strict [ pass ] 1483 strict_autoinc_1myisam [ pass ] 50 strict_autoinc_2innodb [ pass ] 63 strict_autoinc_3heap [ pass ] 56 strict_autoinc_4bdb [ skipped ] Test requires: 'have_bdb' strict_autoinc_5ndb [ skipped ] No ndbcluster support subselect [ pass ] 108768 subselect2 [ pass ] 735 subselect3 [ pass ] 1025 subselect_gis [ pass ] 80 subselect_innodb [ pass ] 729 subselect_notembedded [ pass ] 30 sum_distinct-big [ skipped ] Test need 'big-test' option sum_distinct [ pass ] 6137 symlink [ pass ] 7662 synchronization [ pass ] 490 sysdate_is_now [ pass ] 1026 system_mysql_db [ pass ] 65 system_mysql_db_fix30020 [ fail ] Errors are (from /mnt/disk1/share/usr/local/mysql/mysql-test/var/log/mysqltest-time) : mysqltest: In included file "./include/system_db_struct.inc": At line 10: query 'show create table func' failed: 1146: Table 'test.func' doesn't exist (the last lines may be the most important ones) Result from queries before failure can be found in r/system_mysql_db.log Stopping All Servers Restoring snapshot of databases Resuming Tests system_mysql_db_fix40123 [ skipped ] Test need MYSQL_FIX_PRIVILEGE_TABLES system_mysql_db_refs [ pass ] 177 tablelock [ pass ] 120 temp_table [ pass ] 350 timezone [ pass ] 98 timezone2 [ pass ] 291 timezone3 [ pass ] 69 timezone4 [ pass ] 25 timezone_grant [ pass ] 178 trigger-compat [ pass ] 291 trigger-grant [ pass ] 1300 trigger-trans [ pass ] 234 trigger [ pass ] 7337 truncate [ pass ] 135 type_binary [ pass ] 252 type_bit [ pass ] 624 type_bit_innodb [ pass ] 557 type_blob [ pass ] 894 type_date [ pass ] 273 type_datetime [ pass ] 506 type_decimal [ pass ] 843 type_enum [ pass ] 3930 type_float [ pass ] 534 type_nchar [ pass ] 103 type_newdecimal-big [ skipped ] Test need 'big-test' option type_newdecimal [ pass ] 1107 type_ranges [ pass ] 532 type_set [ pass ] 117 type_time [ pass ] 68 type_timestamp [ pass ] 668 type_uint [ pass ] 24 type_varchar [ pass ] 752 type_year [ pass ] 78 udf [ skipped ] Test requires: 'have_udf_example' union [ pass ] 2228 update [ pass ] 5112 user_limits [ disabled ] Bug#23921 random failure of user_limits.test user_var-binlog [ pass ] 186 user_var [ pass ] 403 varbinary [ pass ] 137 variables-big [ skipped ] Test need 'big-test' option variables [ pass ] 991 view [ pass ] 6414 view_grant [ pass ] 1782 view_query_cache [ pass ] 273 wait_timeout [ pass ] 2255 warnings [ pass ] 476 windows [ skipped ] Test requires: 'true' xa [ pass ] 104 ------------------------------------------------------- Stopping All Servers Failed 6/416 tests, 98.56% were successful. The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://www.mysql.com/doc/en/MySQL_test_suite.html The servers were restarted 103 times Spent 2468.149 seconds actually executing testcases mysql-test-run in default mode: *** Failing the test(s): mysql mysql_upgrade mysqlbinlog mysqltest perror system_mysql_db_fix30020 mysql-test-run: *** ERROR: there were failing test cases sh-2.05b$