COMMAND: [NICE 10] COMMAND: [CD ./pb 1] COMMAND: [CD mysql-5.1-new 0] COMMAND: [CD push-reggie@linux.site-20060124054103.info 0] COMMAND: [CD mysql-5.1.6-alpha-standard 0] COMMAND: [CD mysql-test 0] COMMAND: [PIDFILE var/run/im.pid var/ndbcluster-8344/ndb_1.pid var/ndbcluster-8344/ndb_2.pid var/ndbcluster-8344/ndb_3.pid] COMMAND: [ENV MTR_BUILD_THREAD 5] COMMAND: [SPAWN perl ./mysql-test-run.pl --tmpdir=/tmp/pb-mysql-5.1.6-alpha-standard/ --timer --force] Skipping ndbcluster, mysqld not compiled with ndbcluster Skipping SSL, mysqld not compiled with SSL Using MTR_BUILD_THREAD = 5 Using MASTER_MYPORT = 8320 Using MASTER_MYPORT1 = 8321 Using SLAVE_MYPORT = 8336 Using NDBCLUSTER_PORT = 8344 Using NDBCLUSTER_PORT_SLAVE = 8352 Using IM_MYSQLD1_PORT = 8332 Using IM_MYSQLD2_PORT = 8334 Killing Possible Leftover Processes Removing Stale Files Installing Master Databases Installing Master Databases Installing Slave Databases Installing Slave Databases Installing Slave Databases Creating IM password file (/home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/im.passwd) Installing Im_mysqld_1 Databases Installing Im_mysqld_2 Databases ======================================================= Finding Tests in the 'main' suite Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- alias [ pass ] 337 alter_table [ pass ] 3713 analyse [ pass ] 803 analyze [ pass ] 407 ansi [ pass ] 47 archive [ pass ] 1870 archive_bitfield [ pass ] 654 archive_gis [ pass ] 1124 auto_increment [ pass ] 2143 backup [ pass ] 767 bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb [ skipped ] bdb_cache [ skipped ] bdb_gis [ skipped ] bench_count_distinct [ pass ] 350 bigint [ pass ] 702 binary [ pass ] 399 binlog_row_binlog [ skipped ] binlog_row_blackhole [ skipped ] binlog_row_ctype_cp932 [ skipped ] binlog_row_ctype_ucs [ skipped ] binlog_row_drop_tmp_tbl [ skipped ] binlog_row_innodb_stat [ skipped ] binlog_row_insert_select [ skipped ] binlog_row_mix_innodb_myisam [ skipped ] binlog_stm_binlog [ skipped ] binlog_stm_blackhole [ skipped ] binlog_stm_ctype_cp932 [ pass ] 714 binlog_stm_ctype_ucs [ pass ] 232 binlog_stm_drop_tmp_tbl [ pass ] 209 binlog_stm_innodb_stat [ pass ] 1248 binlog_stm_insert_select [ pass ] 458 binlog_stm_mix_innodb_myisam [ skipped ] bool [ pass ] 184 bulk_replace [ pass ] 117 case [ pass ] 361 cast [ pass ] 396 check [ pass ] 7770 client_xml [ pass ] 603 comments [ pass ] 24 compare [ pass ] 264 compress [ pass ] 37784 connect [ pass ] 5309 consistent_snapshot [ pass ] 44 constraints [ pass ] 308 count_distinct [ pass ] 487 count_distinct2 [ pass ] 6213 count_distinct3 [ pass ] 87809 create [ pass ] 4230 create_select_tmp [ pass ] 305 csv [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 20: query 'INSERT INTO t1 VALUES (9410,9412)' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests ctype_big5 [ pass ] 1097 ctype_collate [ pass ] 578 ctype_cp1250_ch [ pass ] 370 ctype_cp1251 [ pass ] 310 ctype_cp932_binlog_row [ skipped ] ctype_cp932_binlog_stm [ pass ] 143 ctype_create [ pass ] 370 ctype_eucjpms [ pass ] 733 ctype_euckr [ pass ] 789 ctype_gb2312 [ pass ] 559 ctype_gbk [ pass ] 786 ctype_latin1 [ pass ] 452 ctype_latin1_de [ pass ] 728 ctype_latin2 [ pass ] 213 ctype_many [ pass ] 935 ctype_mb [ pass ] 247 ctype_recoding [ pass ] 789 ctype_sjis [ pass ] 457 ctype_tis620 [ pass ] 667 ctype_uca [ pass ] 1087 ctype_ucs [ pass ] 1680 ctype_ujis [ pass ] 1156 ctype_utf8 [ pass ] 2565 date_formats [ pass ] 560 default [ pass ] 194 delayed [ pass ] 6168 delete [ pass ] 697 derived [ pass ] 7972 dirty_close [ pass ] 83 distinct [ pass ] 1754 drop [ pass ] 288 empty_table [ pass ] 52 endspace [ pass ] 531 errors [ pass ] 75 events [ disabled ] Test case instability - infinite locking. To be fixed. exampledb [ skipped ] explain [ pass ] 158 federated [ skipped ] federated_archive [ skipped ] federated_bug_13118 [ skipped ] federated_transactions [ skipped ] flush [ pass ] 701 flush_block_commit [ pass ] 3159 flush_read_lock_kill [ skipped ] flush_table [ pass ] 6354 foreign_key [ pass ] 180 fulltext [ pass ] 1885 fulltext2 [ pass ] 2357 fulltext_cache [ pass ] 226 fulltext_distinct [ pass ] 201 fulltext_left_join [ pass ] 254 fulltext_multi [ pass ] 77 fulltext_order_by [ pass ] 356 fulltext_update [ pass ] 114 fulltext_var [ pass ] 82 func_compress [ pass ] 4430 func_concat [ pass ] 351 func_crypt [ pass ] 69 func_date_add [ pass ] 122 func_default [ pass ] 94 func_des_encrypt [ skipped ] func_encrypt [ skipped ] func_encrypt_nossl [ pass ] 62 func_equal [ pass ] 214 func_gconcat [ pass ] 1762 func_group [ disabled ] Bug #15448 func_if [ pass ] 253 func_in [ pass ] 658 func_isnull [ pass ] 145 func_like [ pass ] 319 func_math [ disabled ] Bug #15448 func_misc [ pass ] 12278 func_op [ pass ] 20 func_regexp [ pass ] 181 func_sapdb [ pass ] 170 func_set [ pass ] 119 func_str [ pass ] 1757 func_system [ pass ] 185 func_test [ pass ] 328 func_time [ pass ] 7782 func_timestamp [ pass ] 65 gcc296 [ pass ] 144 gis-rtree [ pass ] 924 gis [ pass ] 1503 grant [ pass ] 1713 grant2 [ pass ] 513 grant3 [ pass ] 84 grant_cache [ pass ] 417 greedy_optimizer [ pass ] 572 group_by [ pass ] 3462 group_min_max [ disabled ] Bug #15448 handler [ pass ] 3495 having [ pass ] 867 heap [ pass ] 1464 heap_auto_increment [ pass ] 161 heap_btree [ pass ] 462 heap_hash [ pass ] 886 help [ pass ] 558 im_daemon_life_cycle [ pass ] 3164 im_life_cycle [ pass ] 15238 im_options_set [ pass ] 275 im_options_unset [ pass ] 275 im_utils [ pass ] 3109 index_merge [ pass ] 7073 index_merge_bdb [ skipped ] index_merge_innodb [ pass ] 1422 index_merge_innodb2 [ pass ] 1791 index_merge_ror [ pass ] 28786 index_merge_ror_cpk [ pass ] 10655 information_schema [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 41: query 'select * from v1' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests information_schema_db [ pass ] 215 information_schema_inno [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/information_schema_inno.result Tue Jan 24 08:28:00 2006 --- r/information_schema_inno.reject Tue Jan 24 09:00:42 2006 *************** *** 14,19 **** --- 14,20 ---- NULL test t2_ibfk_2 test t2 FOREIGN KEY NULL test PRIMARY test t3 PRIMARY KEY NULL test t3_ibfk_1 test t3 FOREIGN KEY + NULL test PRIMARY test t5 PRIMARY KEY select * from information_schema.KEY_COLUMN_USAGE where TABLE_SCHEMA= "test"; CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME *************** *** 24,27 **** --- 25,29 ---- NULL test PRIMARY NULL test t3 id 1 NULL NULL NULL NULL NULL test t3_ibfk_1 NULL test t3 id 1 1 test t2 t1_id NULL test t3_ibfk_1 NULL test t3 t2_id 2 2 test t2 id + NULL test PRIMARY NULL test t5 id 1 NULL NULL NULL NULL drop table t3, t2, t1; ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests information_schema_part [ skipped ] init_connect [ pass ] 208 init_file [ pass ] 33 innodb-big [ skipped ] innodb-deadlock [ pass ] 6334 innodb-lock [ pass ] 4120 innodb-replace [ pass ] 55 innodb [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 1459: query 'create table t5 (col1 varchar(767) primary key) character set = latin1 engine = innodb' failed: 1050: Table 't5' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests innodb_cache [ pass ] 457 innodb_concurrent [ disabled ] Results are not deterministic, Elliot will fix (BUG#3300) innodb_gis [ pass ] 728 innodb_handler [ pass ] 244 innodb_notembedded [ pass ] 154 insert [ pass ] 4665 insert_select [ pass ] 1149 insert_update [ pass ] 414 join [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 350: query 'create table t4 (y int, c int)' failed: 1050: Table 't4' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests join_crash [ pass ] 389 join_nested [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 781: query 'CREATE VIEW v1 AS SELECT g.groupid groupid, p.goods goods, p.name name, p.shop shop, gp.price price FROM t3 g INNER JOIN t2 p ON g.goodsid = p.goods INNER JOIN t1 gp on p.goods = gp.goods' failed: 1050: Table 'v1' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests join_outer [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 696: query 'CREATE VIEW v1 AS SELECT COALESCE(t2.EMPNUM,t1.EMPNUM) AS EMPNUM, NAME, GRP FROM t2 LEFT OUTER JOIN t1 ON t2.EMPNUM=t1.EMPNUM' failed: 1050: Table 'v1' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests key [ pass ] 2769 key_cache [ pass ] 425 key_diff [ pass ] 91 key_primary [ pass ] 130 keywords [ pass ] 113 kill [ pass ] 4068 limit [ pass ] 202 loaddata [ pass ] 918 lock [ pass ] 465 lock_multi [ pass ] 12481 lock_tables_lost_commit [ pass ] 58 log_tables [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 20: query 'select * from general_log' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests lowercase_table [ pass ] 887 lowercase_table2 [ skipped ] lowercase_table3 [ skipped ] lowercase_table_grant [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/lowercase_table_grant.result Tue Jan 24 08:28:01 2006 --- r/lowercase_table_grant.reject Tue Jan 24 09:03:30 2006 *************** *** 4,23 **** --- 4,27 ---- show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' + GRANT SELECT, UPDATE ON `test`.* TO 'mysqltest_1'@'localhost' GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost' select * from db where user = 'mysqltest_1'; Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv + localhost test mysqltest_1 Y N Y N N N N N N N N N N N N N N N localhost mysqltest mysqltest_1 Y Y Y Y Y Y N Y Y Y Y Y Y Y Y Y Y Y update db set db = 'MYSQLtest' where db = 'mysqltest' and user = 'mysqltest_1' and host = 'localhost'; flush privileges; show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' + GRANT SELECT, UPDATE ON `test`.* TO 'mysqltest_1'@'localhost' GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost' select * from db where user = 'mysqltest_1'; Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv + localhost test mysqltest_1 Y N Y N N N N N N N N N N N N N N N localhost MYSQLtest mysqltest_1 Y Y Y Y Y Y N Y Y Y Y Y Y Y Y Y Y Y delete from db where db = 'MYSQLtest' and user = 'mysqltest_1' and host = 'localhost'; flush privileges; drop user mysqltest_1@localhost; drop database MYSQLtest; ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests lowercase_table_qcache [ pass ] 200 lowercase_view [ pass ] 399 merge [ pass ] 3160 metadata [ pass ] 260 multi_statement [ pass ] 89 multi_update [ pass ] 77254 myisam-blob [ pass ] 13771 myisam [ pass ] 6931 mysql [ pass ] 691 mysql_client_test [ pass ] 33367 mysql_protocols [ pass ] 350 mysqlbinlog [ pass ] 1103 mysqlbinlog2 [ pass ] 1262 mysqlbinlog_base64 [ skipped ] mysqlcheck [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/client/mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'OPTIMIZE TABLE ... ' mysqltest: At line 12: command "$MYSQL_CHECK --all-databases --analyze --optimize" failed (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests mysqldump-max [ pass ] 1254 mysqldump [ pass ] 12393 mysqlshow [ pass ] 434 mysqlslap [ pass ] 9295 mysqltest [ pass ] 38758 ndb_alter_table [ skipped ] ndb_alter_table_row [ skipped ] ndb_alter_table_stm [ skipped ] ndb_autodiscover [ disabled ] Needs to be fixed w.r.t binlog ndb_autodiscover2 [ disabled ] Needs to be fixed w.r.t binlog ndb_basic [ skipped ] ndb_binlog_basic [ disabled ] Results are not deterministic, Tomas will fix ndb_binlog_multi [ skipped ] ndb_bitfield [ skipped ] ndb_blob [ skipped ] ndb_cache [ skipped ] ndb_cache2 [ skipped ] ndb_cache_multi [ skipped ] ndb_cache_multi2 [ skipped ] ndb_charset [ skipped ] ndb_condition_pushdown [ skipped ] ndb_config [ skipped ] ndb_database [ skipped ] ndb_dd_basic [ skipped ] ndb_dd_ddl [ skipped ] ndb_dd_disk2memory [ disabled ] Bug #16466 & 16736 ndb_gis [ skipped ] ndb_index [ skipped ] ndb_index_ordered [ skipped ] ndb_index_unique [ skipped ] ndb_insert [ skipped ] ndb_limit [ skipped ] ndb_lock [ skipped ] ndb_minmax [ skipped ] ndb_multi [ skipped ] ndb_multi_row [ skipped ] ndb_partition_error [ skipped ] ndb_partition_key [ skipped ] ndb_partition_range [ skipped ] ndb_read_multi_range [ skipped ] ndb_replace [ skipped ] ndb_restore [ skipped ] ndb_subquery [ skipped ] ndb_transaction [ skipped ] ndb_truncate [ skipped ] ndb_types [ skipped ] ndb_update [ skipped ] negation_elimination [ pass ] 206 not_embedded_server [ pass ] 27 null [ pass ] 559 null_key [ pass ] 2060 odbc [ pass ] 85 olap [ pass ] 965 openssl_1 [ skipped ] order_by [ pass ] 2775 order_fill_sortbuf [ pass ] 2737 outfile [ pass ] 394 overflow [ pass ] 13 packet [ pass ] 24 partition [ skipped ] partition_02myisam [ skipped ] partition_03ndb [ disabled ] Bug#16385 partition_error [ skipped ] partition_hash [ skipped ] partition_list [ skipped ] partition_mgm_err [ skipped ] partition_order [ skipped ] partition_pruning [ skipped ] partition_range [ skipped ] preload [ pass ] 2646 ps [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 561: query 'execute my_stmt' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests ps_10nestset [ pass ] 245 ps_11bugs [ pass ] 253 ps_1general [ pass ] 2766 ps_2myisam [ pass ] 2600 ps_3innodb [ pass ] 2096 ps_4heap [ pass ] 1437 ps_5merge [ pass ] 3924 ps_6bdb [ skipped ] ps_7ndb [ disabled ] dbug assert in RBR mode when executing test suite ps_grant [ pass ] 372 query_cache [ pass ] 16482 query_cache_merge [ pass ] 14914 query_cache_notembedded [ pass ] 816 raid [ skipped ] range [ pass ] 2492 read_only [ pass ] 415 rename [ pass ] 2295 repair [ pass ] 283 replace [ pass ] 139 rollback [ pass ] 70 row [ pass ] 145 rowid_order_bdb [ skipped ] rowid_order_innodb [ pass ] 202 rpl000002 [ pass ] 927 rpl000004 [ pass ] 735 rpl000005 [ pass ] 447 rpl000006 [ pass ] 342 rpl000008 [ pass ] 526 rpl000009 [ pass ] 1660 rpl000010 [ pass ] 280 rpl000011 [ pass ] 266 rpl000013 [ pass ] 486 rpl000017 [ pass ] 473 rpl000018 [ skipped ] rpl_000012 [ pass ] 856 rpl_000015 [ pass ] 348 rpl_EE_err [ pass ] 359 rpl_LD_INFILE [ pass ] 535 rpl_alter [ pass ] 548 rpl_auto_increment [ pass ] 1180 rpl_bit [ pass ] 500 rpl_bit_npk [ disabled ] Bug #13418 rpl_chain_temp_table [ skipped ] rpl_change_master [ pass ] 3384 rpl_commit_after_flush [ pass ] 392 rpl_create_database [ pass ] 832 rpl_ddl [ disabled ] Bug#15963 SBR does not show "Definer" correctly rpl_deadlock_innodb [ pass ] 25884 rpl_delete_no_where [ pass ] 455 rpl_do_grant [ pass ] 450 rpl_drop [ pass ] 292 rpl_drop_db [ pass ] 7233 rpl_drop_temp [ pass ] 3359 rpl_dual_pos_advance [ pass ] 668 rpl_empty_master_crash [ pass ] 152 rpl_err_ignoredtable [ pass ] 2637 rpl_failed_optimize [ pass ] 2262 rpl_failsafe [ skipped ] rpl_flushlog_loop [ pass ] 10311 rpl_foreign_key_innodb [ pass ] 605 rpl_free_items [ pass ] 1964 rpl_get_lock [ pass ] 983 rpl_heap [ skipped ] rpl_ignore_grant [ pass ] 310 rpl_ignore_revoke [ pass ] 260 rpl_init_slave [ pass ] 1224 rpl_innodb [ pass ] 443 rpl_insert_id [ pass ] 1186 rpl_insert_ignore [ pass ] 633 rpl_insert_select [ pass ] 577 rpl_loaddata [ pass ] 2605 rpl_loaddata2 [ pass ] 459 rpl_loaddata_m [ pass ] 577 rpl_loaddata_s [ pass ] 369 rpl_loaddatalocal [ pass ] 5979 rpl_loadfile [ pass ] 510 rpl_log_pos [ pass ] 12564 rpl_many_optimize [ pass ] 1798 rpl_master_pos_wait [ pass ] 2173 rpl_misc_functions [ pass ] 464 rpl_multi_delete [ pass ] 460 rpl_multi_delete2 [ pass ] 568 rpl_multi_engine [ pass ] 1157 rpl_multi_update [ pass ] 553 rpl_multi_update2 [ pass ] 677 rpl_multi_update3 [ pass ] 1334 rpl_ndb_bank [ skipped ] rpl_ndb_basic [ disabled ] Bug#16228 rpl_ndb_disk [ skipped ] rpl_ndb_idempotent [ skipped ] rpl_ndb_load [ skipped ] rpl_ndb_multi [ skipped ] rpl_ndb_sync [ skipped ] rpl_openssl [ skipped ] rpl_optimize [ pass ] 21226 rpl_ps [ pass ] 429 rpl_redirect [ pass ] 313 rpl_relayrotate [ pass ] 13522 rpl_relayspace [ pass ] 2560 rpl_replicate_do [ pass ] 910 rpl_replicate_ignore_db [ pass ] 519 rpl_rewrt_db [ pass ] 1085 rpl_rotate_logs [ pass ] 2864 rpl_row_001 [ skipped ] rpl_row_4_bytes [ skipped ] rpl_row_NOW [ skipped ] rpl_row_USER [ skipped ] rpl_row_UUID [ skipped ] rpl_row_basic_11bugs [ skipped ] rpl_row_basic_2myisam [ skipped ] rpl_row_basic_3innodb [ skipped ] rpl_row_basic_7ndb [ skipped ] rpl_row_blob_innodb [ skipped ] rpl_row_blob_myisam [ skipped ] rpl_row_charset [ skipped ] rpl_row_create_table [ skipped ] rpl_row_delayed_ins [ skipped ] rpl_row_drop [ skipped ] rpl_row_flsh_tbls [ skipped ] rpl_row_func001 [ skipped ] rpl_row_func002 [ skipped ] rpl_row_func003 [ skipped ] rpl_row_inexist_tbl [ skipped ] rpl_row_log [ skipped ] rpl_row_max_relay_size [ skipped ] rpl_row_multi_update3 [ pass ] 984 rpl_row_mystery22 [ skipped ] rpl_row_reset_slave [ skipped ] rpl_row_sp001 [ skipped ] rpl_row_sp002_innodb [ skipped ] rpl_row_sp003 [ skipped ] rpl_row_sp005 [ skipped ] rpl_row_sp006_InnoDB [ skipped ] rpl_row_sp007_innodb [ skipped ] rpl_row_sp008 [ skipped ] rpl_row_sp009 [ skipped ] rpl_row_sp010 [ skipped ] rpl_row_sp011 [ skipped ] rpl_row_sp012 [ skipped ] rpl_row_stop_middle [ skipped ] rpl_row_stop_middle_update [ skipped ] rpl_row_trig001 [ skipped ] rpl_row_trig002 [ skipped ] rpl_row_trig003 [ skipped ] rpl_row_trig004 [ skipped ] rpl_row_until [ skipped ] rpl_row_view01 [ skipped ] rpl_server_id1 [ pass ] 2277 rpl_server_id2 [ pass ] 1274 rpl_session_var [ pass ] 747 rpl_set_charset [ pass ] 539 rpl_skip_error [ pass ] 332 rpl_slave_status [ pass ] 448 rpl_sp [ disabled ] Bug #16456 rpl_sp004 [ pass ] 1562 rpl_sp_effects [ pass ] 1013 rpl_sporadic_master [ pass ] 780 rpl_start_stop_slave [ pass ] 5244 rpl_stm_000001 [ pass ] 15126 rpl_stm_EE_err2 [ pass ] 709 rpl_stm_charset [ pass ] 1279 rpl_stm_flsh_tbls [ pass ] 1637 rpl_stm_log [ pass ] 913 rpl_stm_max_relay_size [ pass ] 5335 rpl_stm_multi_query [ pass ] 448 rpl_stm_mystery22 [ pass ] 813 rpl_stm_no_op [ pass ] 639 rpl_stm_reset_slave [ pass ] 605 rpl_stm_until [ pass ] 8312 rpl_temporary [ pass ] 5935 rpl_timezone [ pass ] 1018 rpl_trigger [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 99: query 'SELECT trigger_name, definer FROM information_schema.triggers' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests rpl_user_variables [ pass ] 610 rpl_variables [ pass ] 165 rpl_view [ pass ] 498 schema [ pass ] 56 select [ pass ] 40501 select_found [ pass ] 910 select_safe [ pass ] 212 show_check [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/show_check.result Tue Jan 24 08:28:05 2006 --- r/show_check.reject Tue Jan 24 09:24:28 2006 *************** *** 147,160 **** flush tables; show open tables; Database Table In_use Name_locked - mysql general_log 1 0 - mysql slow_log 1 0 create table t1(n int); insert into t1 values (1); show open tables; Database Table In_use Name_locked - mysql general_log 1 0 - mysql slow_log 1 0 test t1 0 0 drop table t1; create table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed; --- 147,156 ---- *************** *** 568,591 **** 1 SHOW OPEN TABLES; Database Table In_use Name_locked ! mysql proc 0 0 test urkunde 0 0 mysql time_zone 0 0 ! mysql db 0 0 test txt1 0 0 ! mysql slow_log 1 0 test tyt2 0 0 - mysql general_log 1 0 - mysql user 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql; Database Table In_use Name_locked - mysql proc 0 0 - mysql time_zone 0 0 mysql db 0 0 ! mysql slow_log 1 0 ! mysql general_log 1 0 mysql user 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql LIKE 'u%'; Database Table In_use Name_locked --- 564,583 ---- 1 SHOW OPEN TABLES; Database Table In_use Name_locked ! mysql db 0 0 test urkunde 0 0 mysql time_zone 0 0 ! mysql user 0 0 test txt1 0 0 ! mysql proc 0 0 test tyt2 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql; Database Table In_use Name_locked mysql db 0 0 ! mysql time_zone 0 0 mysql user 0 0 + mysql proc 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql LIKE 'u%'; Database Table In_use Name_locked *************** *** 598,613 **** mysql time_zone_name 0 0 SHOW OPEN TABLES LIKE '%o%'; Database Table In_use Name_locked - mysql proc 0 0 mysql time_zone 0 0 ! mysql slow_log 1 0 ! mysql general_log 1 0 mysql time_zone_name 0 0 FLUSH TABLES; SHOW OPEN TABLES; Database Table In_use Name_locked - mysql general_log 1 0 - mysql slow_log 1 0 DROP TABLE txt1; DROP TABLE tyt2; DROP TABLE urkunde; --- 590,601 ---- mysql time_zone_name 0 0 SHOW OPEN TABLES LIKE '%o%'; Database Table In_use Name_locked mysql time_zone 0 0 ! mysql proc 0 0 mysql time_zone_name 0 0 FLUSH TABLES; SHOW OPEN TABLES; Database Table In_use Name_locked DROP TABLE txt1; DROP TABLE tyt2; DROP TABLE urkunde; ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests skip_grants [ pass ] 232 skip_name_resolve [ pass ] 20 sp-big [ pass ] 5724 sp-code [ skipped ] sp-destruct [ pass ] 504 sp-dynamic [ pass ] 768 sp-error [ pass ] 1241 sp-goto [ disabled ] GOTO is currently is disabled - will be fixed in the future sp-prelocking [ pass ] 645 sp-security [ pass ] 566 sp-threads [ pass ] 2460 sp-vars [ pass ] 680 sp [ pass ] 10919 sp_notembedded [ pass ] 3986 sp_trans [ pass ] 394 sql_mode [ pass ] 458 ssl [ skipped ] ssl_compress [ skipped ] status [ pass ] 640 strict [ pass ] 1754 subselect [ disabled ] Bug#15706 subselect2 [ pass ] 459 subselect_gis [ pass ] 173 subselect_innodb [ pass ] 618 subselect_notembedded [ pass ] 17 sum_distinct-big [ skipped ] sum_distinct [ pass ] 1445 symlink [ pass ] 1803 synchronization [ pass ] 1063 system_mysql_db [ disabled ] Needs fixing system_mysql_db_fix [ disabled ] Needs fixing system_mysql_db_refs [ pass ] 417 tablelock [ pass ] 287 temp_table [ pass ] 1147 timezone [ skipped ] timezone2 [ pass ] 491 timezone3 [ skipped ] timezone_grant [ pass ] 236 trigger-compat [ pass ] 508 trigger-grant [ pass ] 1162 trigger [ pass ] 5104 truncate [ pass ] 347 type_binary [ pass ] 609 type_bit [ pass ] 1364 type_bit_innodb [ pass ] 400 type_blob [ pass ] 2515 type_date [ pass ] 854 type_datetime [ pass ] 575 type_decimal [ pass ] 1232 type_enum [ pass ] 1095 type_float [ pass ] 877 type_nchar [ pass ] 239 type_newdecimal-big [ skipped ] type_newdecimal [ pass ] 1549 type_ranges [ pass ] 1252 type_set [ pass ] 228 type_time [ pass ] 115 type_timestamp [ pass ] 1494 type_uint [ pass ] 80 type_varchar [ pass ] 1769 type_year [ pass ] 104 union [ pass ] 5512 update [ pass ] 1279 user_limits [ pass ] 2113 user_var-binlog [ pass ] 249 user_var [ pass ] 571 varbinary [ pass ] 173 variables [ pass ] 1482 view [ pass ] 12324 view_grant [ pass ] 2590 view_query_cache [ pass ] 487 wait_timeout [ pass ] 5035 warnings [ pass ] 708 windows [ skipped ] xa [ pass ] 52 xml [ pass ] 76 ------------------------------------------------------- Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Failed 13/379 tests, 96.57% 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 mysql-test-run in default mode: *** Failing the test(s): csv information_schema information_schema_inno innodb join join_nested join_outer log_tables lowercase_table_grant mysqlcheck ps rpl_trigger show_check mysql-test-run: *** ERROR: there where failing test cases COMMAND: [ENV MTR_BUILD_THREAD 5] COMMAND: [SPAWN perl ./mysql-test-run.pl --tmpdir=/tmp/pb-mysql-5.1.6-alpha-standard/ --timer --force --ps-protocol] Skipping ndbcluster, mysqld not compiled with ndbcluster Skipping SSL, mysqld not compiled with SSL Using MTR_BUILD_THREAD = 5 Using MASTER_MYPORT = 8320 Using MASTER_MYPORT1 = 8321 Using SLAVE_MYPORT = 8336 Using NDBCLUSTER_PORT = 8344 Using NDBCLUSTER_PORT_SLAVE = 8352 Using IM_MYSQLD1_PORT = 8332 Using IM_MYSQLD2_PORT = 8334 Killing Possible Leftover Processes Removing Stale Files Installing Master Databases Installing Master Databases Installing Slave Databases Installing Slave Databases Installing Slave Databases Creating IM password file (/home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/im.passwd) Installing Im_mysqld_1 Databases Installing Im_mysqld_2 Databases ======================================================= Finding Tests in the 'main' suite Instance Manager tests are not run with --ps-protocol. Test case 'im_daemon_life_cycle' is skipped. Instance Manager tests are not run with --ps-protocol. Test case 'im_life_cycle' is skipped. Instance Manager tests are not run with --ps-protocol. Test case 'im_options_set' is skipped. Instance Manager tests are not run with --ps-protocol. Test case 'im_options_unset' is skipped. Instance Manager tests are not run with --ps-protocol. Test case 'im_utils' is skipped. Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- alias [ pass ] 387 alter_table [ pass ] 3756 analyse [ pass ] 547 analyze [ pass ] 224 ansi [ pass ] 52 archive [ pass ] 2564 archive_bitfield [ pass ] 571 archive_gis [ pass ] 1031 auto_increment [ pass ] 2030 backup [ pass ] 701 bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb [ skipped ] bdb_cache [ skipped ] bdb_gis [ skipped ] bench_count_distinct [ pass ] 433 bigint [ pass ] 707 binary [ pass ] 429 binlog_row_binlog [ skipped ] binlog_row_blackhole [ skipped ] binlog_row_ctype_cp932 [ skipped ] binlog_row_ctype_ucs [ skipped ] binlog_row_drop_tmp_tbl [ skipped ] binlog_row_innodb_stat [ skipped ] binlog_row_insert_select [ skipped ] binlog_row_mix_innodb_myisam [ skipped ] binlog_stm_binlog [ skipped ] binlog_stm_blackhole [ skipped ] binlog_stm_ctype_cp932 [ pass ] 679 binlog_stm_ctype_ucs [ pass ] 278 binlog_stm_drop_tmp_tbl [ pass ] 196 binlog_stm_innodb_stat [ pass ] 2406 binlog_stm_insert_select [ pass ] 374 binlog_stm_mix_innodb_myisam [ skipped ] bool [ pass ] 140 bulk_replace [ pass ] 110 case [ pass ] 343 cast [ pass ] 386 check [ pass ] 13792 client_xml [ pass ] 678 comments [ pass ] 32 compare [ pass ] 155 compress [ pass ] 38159 connect [ pass ] 5234 consistent_snapshot [ pass ] 47 constraints [ pass ] 322 count_distinct [ pass ] 523 count_distinct2 [ pass ] 12438 count_distinct3 [ pass ] 89074 create [ pass ] 4288 create_select_tmp [ pass ] 279 csv [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 20: query 'INSERT INTO t1 VALUES (9410,9412)' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests ctype_big5 [ pass ] 3090 ctype_collate [ pass ] 483 ctype_cp1250_ch [ pass ] 343 ctype_cp1251 [ pass ] 173 ctype_cp932_binlog_row [ skipped ] ctype_cp932_binlog_stm [ pass ] 141 ctype_create [ pass ] 310 ctype_eucjpms [ pass ] 615 ctype_euckr [ pass ] 638 ctype_gb2312 [ pass ] 599 ctype_gbk [ pass ] 593 ctype_latin1 [ pass ] 313 ctype_latin1_de [ pass ] 769 ctype_latin2 [ pass ] 201 ctype_many [ pass ] 770 ctype_mb [ pass ] 243 ctype_recoding [ pass ] 716 ctype_sjis [ pass ] 531 ctype_tis620 [ pass ] 795 ctype_uca [ pass ] 1368 ctype_ucs [ pass ] 1743 ctype_ujis [ pass ] 1882 ctype_utf8 [ pass ] 3216 date_formats [ pass ] 510 default [ pass ] 136 delayed [ pass ] 6180 delete [ pass ] 719 derived [ pass ] 12252 dirty_close [ pass ] 82 distinct [ pass ] 1687 drop [ pass ] 334 empty_table [ pass ] 64 endspace [ pass ] 639 errors [ pass ] 75 events [ disabled ] Test case instability - infinite locking. To be fixed. exampledb [ skipped ] explain [ pass ] 174 federated [ skipped ] federated_archive [ skipped ] federated_bug_13118 [ skipped ] federated_transactions [ skipped ] flush [ pass ] 684 flush_block_commit [ pass ] 3152 flush_read_lock_kill [ skipped ] flush_table [ pass ] 6448 foreign_key [ pass ] 194 fulltext [ pass ] 1579 fulltext2 [ pass ] 3114 fulltext_cache [ pass ] 235 fulltext_distinct [ pass ] 192 fulltext_left_join [ pass ] 309 fulltext_multi [ pass ] 86 fulltext_order_by [ pass ] 429 fulltext_update [ pass ] 84 fulltext_var [ pass ] 122 func_compress [ pass ] 8526 func_concat [ pass ] 414 func_crypt [ pass ] 134 func_date_add [ pass ] 154 func_default [ pass ] 102 func_des_encrypt [ skipped ] func_encrypt [ skipped ] func_encrypt_nossl [ pass ] 81 func_equal [ pass ] 245 func_gconcat [ pass ] 2174 func_group [ disabled ] Bug #15448 func_if [ pass ] 364 func_in [ pass ] 587 func_isnull [ pass ] 71 func_like [ pass ] 303 func_math [ disabled ] Bug #15448 func_misc [ pass ] 12306 func_op [ pass ] 24 func_regexp [ pass ] 268 func_sapdb [ pass ] 210 func_set [ pass ] 139 func_str [ pass ] 2014 func_system [ pass ] 211 func_test [ pass ] 352 func_time [ pass ] 7947 func_timestamp [ pass ] 78 gcc296 [ pass ] 133 gis-rtree [ pass ] 1301 gis [ pass ] 1550 grant [ pass ] 1914 grant2 [ pass ] 596 grant3 [ pass ] 93 grant_cache [ pass ] 450 greedy_optimizer [ pass ] 649 group_by [ pass ] 3718 group_min_max [ disabled ] Bug #15448 handler [ pass ] 3538 having [ pass ] 861 heap [ pass ] 1957 heap_auto_increment [ pass ] 169 heap_btree [ pass ] 493 heap_hash [ pass ] 670 help [ pass ] 639 im_daemon_life_cycle [ skipped ] im_life_cycle [ skipped ] im_options_set [ skipped ] im_options_unset [ skipped ] im_utils [ skipped ] index_merge [ pass ] 7340 index_merge_bdb [ skipped ] index_merge_innodb [ pass ] 1539 index_merge_innodb2 [ pass ] 2283 index_merge_ror [ pass ] 29701 index_merge_ror_cpk [ pass ] 14611 information_schema [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 41: query 'select * from v1' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests information_schema_db [ pass ] 149 information_schema_inno [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/information_schema_inno.result Tue Jan 24 08:28:00 2006 --- r/information_schema_inno.reject Tue Jan 24 09:36:38 2006 *************** *** 14,19 **** --- 14,20 ---- NULL test t2_ibfk_2 test t2 FOREIGN KEY NULL test PRIMARY test t3 PRIMARY KEY NULL test t3_ibfk_1 test t3 FOREIGN KEY + NULL test PRIMARY test t5 PRIMARY KEY select * from information_schema.KEY_COLUMN_USAGE where TABLE_SCHEMA= "test"; CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME *************** *** 24,27 **** --- 25,29 ---- NULL test PRIMARY NULL test t3 id 1 NULL NULL NULL NULL NULL test t3_ibfk_1 NULL test t3 id 1 1 test t2 t1_id NULL test t3_ibfk_1 NULL test t3 t2_id 2 2 test t2 id + NULL test PRIMARY NULL test t5 id 1 NULL NULL NULL NULL drop table t3, t2, t1; ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests information_schema_part [ skipped ] init_connect [ pass ] 216 init_file [ pass ] 28 innodb-big [ skipped ] innodb-deadlock [ pass ] 6269 innodb-lock [ pass ] 4098 innodb-replace [ pass ] 43 innodb [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 1459: query 'create table t5 (col1 varchar(767) primary key) character set = latin1 engine = innodb' failed: 1050: Table 't5' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests innodb_cache [ pass ] 307 innodb_concurrent [ disabled ] Results are not deterministic, Elliot will fix (BUG#3300) innodb_gis [ pass ] 827 innodb_handler [ pass ] 106 innodb_notembedded [ pass ] 69 insert [ pass ] 7603 insert_select [ pass ] 1464 insert_update [ pass ] 717 join [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 350: query 'create table t4 (y int, c int)' failed: 1050: Table 't4' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests join_crash [ pass ] 329 join_nested [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 781: query 'CREATE VIEW v1 AS SELECT g.groupid groupid, p.goods goods, p.name name, p.shop shop, gp.price price FROM t3 g INNER JOIN t2 p ON g.goodsid = p.goods INNER JOIN t1 gp on p.goods = gp.goods' failed: 1050: Table 'v1' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests join_outer [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 696: query 'CREATE VIEW v1 AS SELECT COALESCE(t2.EMPNUM,t1.EMPNUM) AS EMPNUM, NAME, GRP FROM t2 LEFT OUTER JOIN t1 ON t2.EMPNUM=t1.EMPNUM' failed: 1050: Table 'v1' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests key [ pass ] 2511 key_cache [ pass ] 564 key_diff [ pass ] 99 key_primary [ pass ] 171 keywords [ pass ] 103 kill [ pass ] 4077 limit [ pass ] 239 loaddata [ pass ] 962 lock [ pass ] 512 lock_multi [ pass ] 12432 lock_tables_lost_commit [ pass ] 66 log_tables [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 20: query 'select * from general_log' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests lowercase_table [ pass ] 752 lowercase_table2 [ skipped ] lowercase_table3 [ skipped ] lowercase_table_grant [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/lowercase_table_grant.result Tue Jan 24 08:28:01 2006 --- r/lowercase_table_grant.reject Tue Jan 24 09:39:26 2006 *************** *** 4,23 **** --- 4,27 ---- show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' + GRANT SELECT, UPDATE ON `test`.* TO 'mysqltest_1'@'localhost' GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost' select * from db where user = 'mysqltest_1'; Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv + localhost test mysqltest_1 Y N Y N N N N N N N N N N N N N N N localhost mysqltest mysqltest_1 Y Y Y Y Y Y N Y Y Y Y Y Y Y Y Y Y Y update db set db = 'MYSQLtest' where db = 'mysqltest' and user = 'mysqltest_1' and host = 'localhost'; flush privileges; show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' + GRANT SELECT, UPDATE ON `test`.* TO 'mysqltest_1'@'localhost' GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost' select * from db where user = 'mysqltest_1'; Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv + localhost test mysqltest_1 Y N Y N N N N N N N N N N N N N N N localhost MYSQLtest mysqltest_1 Y Y Y Y Y Y N Y Y Y Y Y Y Y Y Y Y Y delete from db where db = 'MYSQLtest' and user = 'mysqltest_1' and host = 'localhost'; flush privileges; drop user mysqltest_1@localhost; drop database MYSQLtest; ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests lowercase_table_qcache [ pass ] 183 lowercase_view [ pass ] 549 merge [ pass ] 2736 metadata [ pass ] 324 multi_statement [ pass ] 109 multi_update [ pass ] 84998 myisam-blob [ pass ] 13821 myisam [ pass ] 8270 mysql [ pass ] 633 mysql_client_test [ pass ] 33650 mysql_protocols [ pass ] 350 mysqlbinlog [ pass ] 1145 mysqlbinlog2 [ pass ] 1365 mysqlbinlog_base64 [ skipped ] mysqlcheck [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/client/mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'OPTIMIZE TABLE ... ' mysqltest: At line 12: command "$MYSQL_CHECK --all-databases --analyze --optimize" failed (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests mysqldump-max [ pass ] 1228 mysqldump [ pass ] 12144 mysqlshow [ pass ] 425 mysqlslap [ pass ] 9357 mysqltest [ pass ] 38858 ndb_alter_table [ skipped ] ndb_alter_table_row [ skipped ] ndb_alter_table_stm [ skipped ] ndb_autodiscover [ disabled ] Needs to be fixed w.r.t binlog ndb_autodiscover2 [ disabled ] Needs to be fixed w.r.t binlog ndb_basic [ skipped ] ndb_binlog_basic [ disabled ] Results are not deterministic, Tomas will fix ndb_binlog_multi [ skipped ] ndb_bitfield [ skipped ] ndb_blob [ skipped ] ndb_cache [ skipped ] ndb_cache2 [ skipped ] ndb_cache_multi [ skipped ] ndb_cache_multi2 [ skipped ] ndb_charset [ skipped ] ndb_condition_pushdown [ skipped ] ndb_config [ skipped ] ndb_database [ skipped ] ndb_dd_basic [ skipped ] ndb_dd_ddl [ skipped ] ndb_dd_disk2memory [ disabled ] Bug #16466 & 16736 ndb_gis [ skipped ] ndb_index [ skipped ] ndb_index_ordered [ skipped ] ndb_index_unique [ skipped ] ndb_insert [ skipped ] ndb_limit [ skipped ] ndb_lock [ skipped ] ndb_minmax [ skipped ] ndb_multi [ skipped ] ndb_multi_row [ skipped ] ndb_partition_error [ skipped ] ndb_partition_key [ skipped ] ndb_partition_range [ skipped ] ndb_read_multi_range [ skipped ] ndb_replace [ skipped ] ndb_restore [ skipped ] ndb_subquery [ skipped ] ndb_transaction [ skipped ] ndb_truncate [ skipped ] ndb_types [ skipped ] ndb_update [ skipped ] negation_elimination [ pass ] 189 not_embedded_server [ pass ] 26 null [ pass ] 701 null_key [ pass ] 2169 odbc [ pass ] 85 olap [ pass ] 1030 openssl_1 [ skipped ] order_by [ pass ] 3888 order_fill_sortbuf [ pass ] 5214 outfile [ pass ] 468 overflow [ pass ] 14 packet [ pass ] 43 partition [ skipped ] partition_02myisam [ skipped ] partition_03ndb [ disabled ] Bug#16385 partition_error [ skipped ] partition_hash [ skipped ] partition_list [ skipped ] partition_mgm_err [ skipped ] partition_order [ skipped ] partition_pruning [ skipped ] partition_range [ skipped ] preload [ pass ] 2714 ps [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 561: query 'execute my_stmt' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests ps_10nestset [ pass ] 262 ps_11bugs [ pass ] 235 ps_1general [ pass ] 2997 ps_2myisam [ pass ] 2883 ps_3innodb [ pass ] 2603 ps_4heap [ pass ] 1819 ps_5merge [ pass ] 5020 ps_6bdb [ skipped ] ps_7ndb [ disabled ] dbug assert in RBR mode when executing test suite ps_grant [ pass ] 367 query_cache [ pass ] 16195 query_cache_merge [ pass ] 14540 query_cache_notembedded [ pass ] 775 raid [ skipped ] range [ pass ] 2572 read_only [ pass ] 313 rename [ pass ] 2342 repair [ pass ] 428 replace [ pass ] 146 rollback [ pass ] 69 row [ pass ] 185 rowid_order_bdb [ skipped ] rowid_order_innodb [ pass ] 251 rpl000002 [ pass ] 842 rpl000004 [ pass ] 662 rpl000005 [ pass ] 442 rpl000006 [ pass ] 517 rpl000008 [ pass ] 662 rpl000009 [ pass ] 1735 rpl000010 [ pass ] 357 rpl000011 [ pass ] 374 rpl000013 [ pass ] 547 rpl000017 [ pass ] 408 rpl000018 [ skipped ] rpl_000012 [ pass ] 874 rpl_000015 [ pass ] 381 rpl_EE_err [ pass ] 317 rpl_LD_INFILE [ pass ] 521 rpl_alter [ pass ] 574 rpl_auto_increment [ pass ] 1180 rpl_bit [ pass ] 466 rpl_bit_npk [ disabled ] Bug #13418 rpl_chain_temp_table [ skipped ] rpl_change_master [ pass ] 3393 rpl_commit_after_flush [ pass ] 308 rpl_create_database [ pass ] 832 rpl_ddl [ disabled ] Bug#15963 SBR does not show "Definer" correctly rpl_deadlock_innodb [ pass ] 27579 rpl_delete_no_where [ pass ] 413 rpl_do_grant [ pass ] 532 rpl_drop [ pass ] 309 rpl_drop_db [ pass ] 7250 rpl_drop_temp [ pass ] 3385 rpl_dual_pos_advance [ pass ] 708 rpl_empty_master_crash [ pass ] 152 rpl_err_ignoredtable [ pass ] 2628 rpl_failed_optimize [ pass ] 2239 rpl_failsafe [ skipped ] rpl_flushlog_loop [ pass ] 10320 rpl_foreign_key_innodb [ pass ] 622 rpl_free_items [ pass ] 2420 rpl_get_lock [ pass ] 2686 rpl_heap [ skipped ] rpl_ignore_grant [ pass ] 295 rpl_ignore_revoke [ pass ] 286 rpl_init_slave [ pass ] 1237 rpl_innodb [ pass ] 522 rpl_insert_id [ pass ] 1220 rpl_insert_ignore [ pass ] 665 rpl_insert_select [ pass ] 526 rpl_loaddata [ pass ] 2563 rpl_loaddata2 [ pass ] 418 rpl_loaddata_m [ pass ] 609 rpl_loaddata_s [ pass ] 385 rpl_loaddatalocal [ pass ] 10835 rpl_loadfile [ pass ] 543 rpl_log_pos [ pass ] 12546 rpl_many_optimize [ pass ] 1839 rpl_master_pos_wait [ pass ] 2189 rpl_misc_functions [ pass ] 493 rpl_multi_delete [ pass ] 444 rpl_multi_delete2 [ pass ] 418 rpl_multi_engine [ pass ] 1530 rpl_multi_update [ pass ] 534 rpl_multi_update2 [ pass ] 759 rpl_multi_update3 [ pass ] 1325 rpl_ndb_bank [ skipped ] rpl_ndb_basic [ disabled ] Bug#16228 rpl_ndb_disk [ skipped ] rpl_ndb_idempotent [ skipped ] rpl_ndb_load [ skipped ] rpl_ndb_multi [ skipped ] rpl_ndb_sync [ skipped ] rpl_openssl [ skipped ] rpl_optimize [ pass ] 21649 rpl_ps [ pass ] 387 rpl_redirect [ pass ] 363 rpl_relayrotate [ pass ] 17806 rpl_relayspace [ pass ] 2602 rpl_replicate_do [ pass ] 768 rpl_replicate_ignore_db [ pass ] 519 rpl_rewrt_db [ pass ] 1001 rpl_rotate_logs [ pass ] 2929 rpl_row_001 [ skipped ] rpl_row_4_bytes [ skipped ] rpl_row_NOW [ skipped ] rpl_row_USER [ skipped ] rpl_row_UUID [ skipped ] rpl_row_basic_11bugs [ skipped ] rpl_row_basic_2myisam [ skipped ] rpl_row_basic_3innodb [ skipped ] rpl_row_basic_7ndb [ skipped ] rpl_row_blob_innodb [ skipped ] rpl_row_blob_myisam [ skipped ] rpl_row_charset [ skipped ] rpl_row_create_table [ skipped ] rpl_row_delayed_ins [ skipped ] rpl_row_drop [ skipped ] rpl_row_flsh_tbls [ skipped ] rpl_row_func001 [ skipped ] rpl_row_func002 [ skipped ] rpl_row_func003 [ skipped ] rpl_row_inexist_tbl [ skipped ] rpl_row_log [ skipped ] rpl_row_max_relay_size [ skipped ] rpl_row_multi_update3 [ pass ] 1074 rpl_row_mystery22 [ skipped ] rpl_row_reset_slave [ skipped ] rpl_row_sp001 [ skipped ] rpl_row_sp002_innodb [ skipped ] rpl_row_sp003 [ skipped ] rpl_row_sp005 [ skipped ] rpl_row_sp006_InnoDB [ skipped ] rpl_row_sp007_innodb [ skipped ] rpl_row_sp008 [ skipped ] rpl_row_sp009 [ skipped ] rpl_row_sp010 [ skipped ] rpl_row_sp011 [ skipped ] rpl_row_sp012 [ skipped ] rpl_row_stop_middle [ skipped ] rpl_row_stop_middle_update [ skipped ] rpl_row_trig001 [ skipped ] rpl_row_trig002 [ skipped ] rpl_row_trig003 [ skipped ] rpl_row_trig004 [ skipped ] rpl_row_until [ skipped ] rpl_row_view01 [ skipped ] rpl_server_id1 [ pass ] 2276 rpl_server_id2 [ pass ] 1341 rpl_session_var [ pass ] 671 rpl_set_charset [ pass ] 547 rpl_skip_error [ pass ] 372 rpl_slave_status [ pass ] 381 rpl_sp [ disabled ] Bug #16456 rpl_sp004 [ pass ] 1593 rpl_sp_effects [ pass ] 995 rpl_sporadic_master [ pass ] 788 rpl_start_stop_slave [ pass ] 8302 rpl_stm_000001 [ pass ] 17577 rpl_stm_EE_err2 [ pass ] 785 rpl_stm_charset [ pass ] 1338 rpl_stm_flsh_tbls [ pass ] 1699 rpl_stm_log [ pass ] 1047 rpl_stm_max_relay_size [ pass ] 6068 rpl_stm_multi_query [ pass ] 389 rpl_stm_mystery22 [ pass ] 896 rpl_stm_no_op [ pass ] 547 rpl_stm_reset_slave [ pass ] 664 rpl_stm_until [ pass ] 8411 rpl_temporary [ pass ] 6001 rpl_timezone [ pass ] 909 rpl_trigger [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: At line 99: query 'SELECT trigger_name, definer FROM information_schema.triggers' failed: 2013: Lost connection to MySQL server during query (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests rpl_user_variables [ pass ] 552 rpl_variables [ pass ] 223 rpl_view [ pass ] 498 schema [ pass ] 48 select [ pass ] 42853 select_found [ pass ] 1134 select_safe [ pass ] 319 show_check [ fail ] Errors are (from /home/mysqldev/pb/mysql-5.1-new/push-reggie@linux.site-20060124054103.info/mysql-5.1.6-alpha-standard/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/show_check.result Tue Jan 24 08:28:05 2006 --- r/show_check.reject Tue Jan 24 10:01:03 2006 *************** *** 147,160 **** flush tables; show open tables; Database Table In_use Name_locked - mysql general_log 1 0 - mysql slow_log 1 0 create table t1(n int); insert into t1 values (1); show open tables; Database Table In_use Name_locked - mysql general_log 1 0 - mysql slow_log 1 0 test t1 0 0 drop table t1; create table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed; --- 147,156 ---- *************** *** 568,591 **** 1 SHOW OPEN TABLES; Database Table In_use Name_locked ! mysql proc 0 0 test urkunde 0 0 mysql time_zone 0 0 ! mysql db 0 0 test txt1 0 0 ! mysql slow_log 1 0 test tyt2 0 0 - mysql general_log 1 0 - mysql user 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql; Database Table In_use Name_locked - mysql proc 0 0 - mysql time_zone 0 0 mysql db 0 0 ! mysql slow_log 1 0 ! mysql general_log 1 0 mysql user 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql LIKE 'u%'; Database Table In_use Name_locked --- 564,583 ---- 1 SHOW OPEN TABLES; Database Table In_use Name_locked ! mysql db 0 0 test urkunde 0 0 mysql time_zone 0 0 ! mysql user 0 0 test txt1 0 0 ! mysql proc 0 0 test tyt2 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql; Database Table In_use Name_locked mysql db 0 0 ! mysql time_zone 0 0 mysql user 0 0 + mysql proc 0 0 mysql time_zone_name 0 0 SHOW OPEN TABLES FROM mysql LIKE 'u%'; Database Table In_use Name_locked *************** *** 598,613 **** mysql time_zone_name 0 0 SHOW OPEN TABLES LIKE '%o%'; Database Table In_use Name_locked - mysql proc 0 0 mysql time_zone 0 0 ! mysql slow_log 1 0 ! mysql general_log 1 0 mysql time_zone_name 0 0 FLUSH TABLES; SHOW OPEN TABLES; Database Table In_use Name_locked - mysql general_log 1 0 - mysql slow_log 1 0 DROP TABLE txt1; DROP TABLE tyt2; DROP TABLE urkunde; --- 590,601 ---- mysql time_zone_name 0 0 SHOW OPEN TABLES LIKE '%o%'; Database Table In_use Name_locked mysql time_zone 0 0 ! mysql proc 0 0 mysql time_zone_name 0 0 FLUSH TABLES; SHOW OPEN TABLES; Database Table In_use Name_locked DROP TABLE txt1; DROP TABLE tyt2; DROP TABLE urkunde; ------------------------------------------------------- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Resuming Tests skip_grants [ pass ] 231 skip_name_resolve [ pass ] 22 sp-big [ pass ] 6114 sp-code [ skipped ] sp-destruct [ pass ] 526 sp-dynamic [ pass ] 732 sp-error [ pass ] 1430 sp-goto [ disabled ] GOTO is currently is disabled - will be fixed in the future sp-prelocking [ pass ] 665 sp-security [ pass ] 719 sp-threads [ pass ] 2386 sp-vars [ pass ] 778 sp [ pass ] 11427 sp_notembedded [ pass ] 4038 sp_trans [ pass ] 472 sql_mode [ pass ] 495 ssl [ skipped ] ssl_compress [ skipped ] status [ pass ] 566 strict [ pass ] 2051 subselect [ disabled ] Bug#15706 subselect2 [ pass ] 434 subselect_gis [ pass ] 78 subselect_innodb [ pass ] 633 subselect_notembedded [ pass ] 18 sum_distinct-big [ skipped ] sum_distinct [ pass ] 1364 symlink [ pass ] 1769 synchronization [ pass ] 1154 system_mysql_db [ disabled ] Needs fixing system_mysql_db_fix [ disabled ] Needs fixing system_mysql_db_refs [ pass ] 478 tablelock [ pass ] 281 temp_table [ pass ] 1040 timezone [ skipped ] timezone2 [ pass ] 476 timezone3 [ skipped ] timezone_grant [ pass ] 214 trigger-compat [ pass ] 515 trigger-grant [ pass ] 1212 trigger [ pass ] 5420 truncate [ pass ] 309 type_binary [ pass ] 565 type_bit [ pass ] 1305 type_bit_innodb [ pass ] 450 type_blob [ pass ] 2541 type_date [ pass ] 626 type_datetime [ pass ] 540 type_decimal [ pass ] 1333 type_enum [ pass ] 1195 type_float [ pass ] 945 type_nchar [ pass ] 282 type_newdecimal-big [ skipped ] type_newdecimal [ pass ] 1691 type_ranges [ pass ] 1444 type_set [ pass ] 281 type_time [ pass ] 109 type_timestamp [ pass ] 1691 type_uint [ pass ] 62 type_varchar [ pass ] 1786 type_year [ pass ] 123 union [ pass ] 5847 update [ pass ] 1411 user_limits [ pass ] 2115 user_var-binlog [ pass ] 252 user_var [ pass ] 570 varbinary [ pass ] 109 variables [ pass ] 1556 view [ pass ] 12841 view_grant [ pass ] 2590 view_query_cache [ pass ] 466 wait_timeout [ pass ] 5035 warnings [ pass ] 702 windows [ skipped ] xa [ pass ] 72 xml [ pass ] 165 ------------------------------------------------------- Ending Tests Shutting-down MySQL daemon Master(s) shutdown finished Slave(s) shutdown finished Failed 13/374 tests, 96.52% 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 mysql-test-run in ps-protocol mode: *** Failing the test(s): csv information_schema information_schema_inno innodb join join_nested join_outer log_tables lowercase_table_grant mysqlcheck ps rpl_trigger show_check mysql-test-run: *** ERROR: there where failing test cases COMMAND: [QUIT]