Logging: mysql-test-run.pl --force MySQL Version 5.5.8 Checking supported features... - skipping ndbcluster - skipping SSL, mysqld not compiled with SSL Collecting tests... - adding combinations for binlog - adding combinations for rpl vardir: /mysql/mysql-5.5.8/mysql-test/var Removing old var directory... Creating var directory '/mysql/mysql-5.5.8/mysql-test/var'... Installing system database... Using server port 36156 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped binlog.binlog_multi_engine [ skipped ] No ndbcluster tests(--skip-ndbcluster) sys_vars.ssl_ca_basic [ skipped ] No SSL support sys_vars.ssl_cert_basic [ skipped ] No SSL support sys_vars.ssl_key_basic [ skipped ] No SSL support main.archive-big [ skipped ] Test needs 'big-test' option main.bug46080 [ skipped ] Test needs debug binaries main.count_distinct3 [ skipped ] Test needs 'big-test' option main.crash_commit_before [ skipped ] Test needs debug binaries main.drop_debug [ skipped ] Test needs debug binaries main.error_simulation [ skipped ] Test needs debug binaries main.events_stress [ skipped ] Test needs 'big-test' option main.events_time_zone [ skipped ] Test needs 'big-test' option main.flush_read_lock_kill [ skipped ] Test needs debug binaries main.information_schema-big [ skipped ] Test needs 'big-test' option main.log_tables_debug [ skipped ] Test needs debug binaries main.merge-big [ skipped ] Test needs 'big-test' option main.myisam_crash_before_flush_keys [ skipped ] Test needs debug binaries main.myisam_debug [ skipped ] Test needs debug binaries main.mysqlbinlog_row_big [ skipped ] Test needs 'big-test' option main.partition_sync [ skipped ] Test needs debug binaries main.signal_code [ skipped ] Test needs debug binaries main.sp-code [ skipped ] Test needs debug binaries main.ssl-big [ skipped ] Test needs 'big-test' option main.subselect_debug [ skipped ] Test needs debug binaries main.type_newdecimal-big [ skipped ] Test needs 'big-test' option main.variables-big [ skipped ] Test needs 'big-test' option main.variables_debug [ skipped ] Test needs debug binaries sys_vars.debug_basic [ skipped ] Test needs debug binaries binlog.binlog_incident [ skipped ] Test needs debug binaries binlog.binlog_index [ skipped ] Test needs debug binaries binlog.binlog_killed_simulate [ skipped ] Test needs debug binaries binlog.binlog_row_binlog [ skipped ] Test needs debug binaries binlog.binlog_stm_binlog [ skipped ] Test needs debug binaries binlog.binlog_write_error [ skipped ] Test needs debug binaries federated.federated_debug [ skipped ] Test needs debug binaries rpl.rpl_binlog_corruption [ skipped ] Test needs debug binaries rpl.rpl_bug26395 [ skipped ] Test needs debug binaries rpl.rpl_bug33931 [ skipped ] Test needs debug binaries rpl.rpl_bug41902 [ skipped ] Test needs debug binaries rpl.rpl_get_master_version_and_clock [ skipped ] Test needs debug binaries rpl.rpl_incident [ skipped ] Test needs debug binaries rpl.rpl_init_slave_errors [ skipped ] Test needs debug binaries rpl.rpl_killed_ddl [ skipped ] Test needs debug binaries rpl.rpl_known_bugs_detection [ skipped ] Test needs debug binaries rpl.rpl_loaddata_fatal [ skipped ] Test needs debug binaries rpl.rpl_row_4_bytes [ skipped ] Test needs debug binaries rpl.rpl_show_slave_running [ skipped ] Test needs debug binaries rpl.rpl_slave_load_remove_tmpfile [ skipped ] Test needs debug binaries rpl.rpl_stm_stop_middle_group [ skipped ] Test needs debug binaries rpl.rpl_stop_slave [ skipped ] Test needs debug binaries rpl.rpl_sync [ skipped ] Test needs debug binaries perfschema.tampered_perfschema_table1 [ skipped ] Test needs debug binaries main.alter_table-big [ disabled ] Bug#37248 2010-11-15 mattiasj was not tested main.create-big [ disabled ] Bug#37248 2010-11-15 mattiasj was not tested main.ctype_utf8mb4_ndb [ disabled ] Bug#55799, Bug#51907, disabled by Konstantin 2010-08-06 main.log_tables-big [ disabled ] Bug#48646 2010-11-15 mattiasj report already exists main.lowercase_table3 [ disabled ] Bug#54845 2010-06-30 alik main.lowercase_table3 on Mac OSX main.mysqlhotcopy_archive [ disabled ] Bug#56817 2010-10-21 anitha mysqlhotcopy* fails main.mysqlhotcopy_myisam [ disabled ] Bug#56817 2010-10-21 anitha mysqlhotcopy* fails main.query_cache_28249 [ disabled ] Bug#43861 2009-03-25 main.query_cache_28249 fails sporadically main.read_many_rows_innodb [ disabled ] Bug#37635 2010-11-15 mattiasj report already exists main.sum_distinct-big [ disabled ] Bug#56927 2010-11-15 mattiasj was not tested sys_vars.query_cache_size_basic_32 [ disabled ] Bug#36747: Allocating a large query cache is not deterministic sys_vars.query_cache_size_basic_64 [ disabled ] Bug#36747: Allocating a large query cache is not deterministic sys_vars.transaction_prealloc_size_basic_32 [ disabled ] Bug#36747 sys_vars.transaction_prealloc_size_basic_64 [ disabled ] Bug#36747 binlog.binlog_spurious_ddl_errors [ disabled ] BUG#54195 2010-06-03 alik binlog_spurious_ddl_errors.test fails, thus disabled binlog.binlog_truncate_innodb [ disabled ] BUG#57291 2010-10-20 anitha Originally disabled due to BUG#42643. Product bug fixed, but test changes needed federated.federated_transactions [ disabled ] Bug#29523 Transactions do not work rpl.rpl_failed_optimize [ disabled ] WL#4284: Can't optimize table used by a pending transaction (there is metadata lock on the table). rpl.rpl_log_pos [ disabled ] BUG#55675 2010-09-10 alfranio rpl.rpl_log_pos fails sporadically with error binlog truncated in the middle rpl.rpl_read_only [ disabled ] WL#4284: Setting Read only won't succeed until all metadata locks are released. rpl.rpl_row_create_table [ disabled ] Bug#51574 2010-02-27 andrei failed different way than earlier with bug#45576 rpl.rpl_spec_variables [ disabled ] BUG#47661 2009-10-27 jasonh rpl_spec_variables fails on PB2 hpux federated.federated [ skipped ] Need federated engine federated.federated_archive [ skipped ] Test requires: 'true' federated.federated_bug_13118 [ skipped ] Need federated engine federated.federated_bug_25714 [ skipped ] Need bug25714 test program federated.federated_server [ skipped ] Need federated engine federated.federated_plugin [ skipped ] federated plugin is disabled federated.federated_innodb [ skipped ] Need federated engine perfschema.cnf_option [ pass ] 10 rpl.rpl_plugin_load 'mix' [ pass ] 161 rpl.rpl_plugin_load 'row' [ pass ] 139 rpl.rpl_plugin_load 'stmt' [ pass ] 164 rpl.rpl_semi_sync_event 'mix' [ pass ] 10381 rpl.rpl_semi_sync 'mix' [ pass ] 152778 rpl.rpl_semi_sync_event 'row' [ pass ] 31303 rpl.rpl_semi_sync 'row' [ pass ] 143749 rpl.rpl_semi_sync_event 'stmt' [ pass ] 20400 rpl.rpl_semi_sync 'stmt' [ pass ] 256343 rpl.rpl_udf 'mix' [ skipped ] UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr) rpl.rpl_udf 'row' [ skipped ] UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr) rpl.rpl_udf 'stmt' [ skipped ] UDF requires the environment variable \$UDF_EXAMPLE_LIB to be set (normally done by mtr) rpl.rpl_auto_increment 'mix' [ pass ] 3856 rpl.rpl_auto_increment 'row' [ pass ] 3063 rpl.rpl_auto_increment 'stmt' [ pass ] 2113 rpl.rpl_create_database 'mix' [ pass ] 307 rpl.rpl_create_database 'row' [ pass ] 246 rpl.rpl_create_database 'stmt' [ pass ] 222 rpl.rpl_begin_commit_rollback 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_loaddata_m 'mix' [ pass ] 253 rpl.rpl_row_basic_11bugs 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_timezone 'mix' [ pass ] 294 rpl.rpl_flush_logs 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_sp 'mix' [ pass ] 2445 rpl.rpl_sp_effects 'mix' [ pass ] 360 rpl.rpl_sporadic_master 'mix' [ pass ] 318 rpl.rpl_row_mysqlbinlog 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_packet 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_loaddata_map 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_flushlog_loop 'mix' [ pass ] 564 rpl.rpl_binlog_auto_inc_bug33029 'mix' [ pass ] 84 rpl.rpl_cross_version 'mix' [ pass ] 166 rpl.rpl_binlog_query_filter_rules 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_loaddata_symlink 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_log_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_log 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_invoked_features 'mix' [ pass ] 1062 rpl.rpl_loaddata_s 'mix' [ pass ] 165 rpl.rpl_heartbeat 'mix' [ pass ] 15205 rpl.rpl000011 'mix' [ pass ] 320 rpl.rpl000013 'mix' [ pass ] 7042 rpl.rpl000017 'mix' [ pass ] 92 rpl.rpl_EE_err 'mix' [ pass ] 139 rpl.rpl_LD_INFILE 'mix' [ pass ] 137 rpl.rpl_alter 'mix' [ pass ] 288 rpl.rpl_alter_db 'mix' [ pass ] 186 rpl.rpl_auto_increment_11932 'mix' [ pass ] 255 rpl.rpl_bit 'mix' [ pass ] 240 rpl.rpl_bit_npk 'mix' [ pass ] 1293 rpl.rpl_blackhole 'mix' [ skipped ] Need blackhole engine rpl.rpl_bug31076 'mix' [ pass ] 280 rpl.rpl_change_master 'mix' [ pass ] 589 rpl.rpl_charset 'mix' [ pass ] 353 rpl.rpl_charset_sjis 'mix' [ pass ] 233 rpl.rpl_colSize 'mix' [ pass ] 470 rpl.rpl_conditional_comments 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_create_if_not_exists 'mix' [ pass ] 2744 rpl.rpl_create_tmp_table_if_not_exists 'mix' [ pass ] 201 rpl.rpl_critical_errors 'mix' [ pass ] 1 rpl.rpl_delete_no_where 'mix' [ pass ] 213 rpl.rpl_do_grant 'mix' [ pass ] 16158 rpl.rpl_drop 'mix' [ pass ] 5679 rpl.rpl_drop_db 'mix' [ pass ] 60026 rpl.rpl_drop_if_exists 'mix' [ pass ] 2871 rpl.rpl_drop_view 'mix' [ pass ] 12974 rpl.rpl_empty_master_host 'mix' [ pass ] 7878 rpl.rpl_events 'mix' [ pass ] 10248 rpl.rpl_extraCol_myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_extraColmaster_myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_geometry 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_get_lock 'mix' [ pass ] 14597 rpl.rpl_grant 'mix' [ pass ] 5075 rpl.rpl_heartbeat_ssl 'mix' [ skipped ] Test requires: 'have_ssl' rpl.rpl_idempotency 'mix' [ pass ] 7401 rpl.rpl_insert 'mix' [ pass ] 10476 rpl.rpl_insert_select 'mix' [ pass ] 1428 rpl.rpl_loaddata_charset 'mix' [ pass ] 317 rpl.rpl_loaddata_simple 'mix' [ pass ] 270 rpl.rpl_loaddatalocal 'mix' [ pass ] 3709 rpl.rpl_loadfile 'mix' [ pass ] 410 rpl.rpl_locale 'mix' [ pass ] 153 rpl.rpl_manual_change_index_file 'mix' [ pass ] 586 rpl.rpl_many_optimize 'mix' [ pass ] 677 rpl.rpl_master_pos_wait 'mix' [ pass ] 2121 rpl.rpl_misc_functions 'mix' [ pass ] 189 rpl.rpl_mix_found_rows 'mix' [ pass ] 295 rpl.rpl_mix_insert_delayed 'mix' [ pass ] 3903 rpl.rpl_mixed_bit_pk 'mix' [ pass ] 514 rpl.rpl_mixed_ddl_dml 'mix' [ pass ] 421 rpl.rpl_multi_update 'mix' [ pass ] 237 rpl.rpl_multi_update3 'mix' [ pass ] 458 rpl.rpl_mysql_upgrade 'mix' [ pass ] 2520 rpl.rpl_name_const 'mix' [ pass ] 205 rpl.rpl_nondeterministic_functions 'mix' [ pass ] 265 rpl.rpl_not_null_myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_optimize 'mix' [ pass ] 15843 rpl.rpl_ps 'mix' [ pass ] 256 rpl.rpl_rbr_to_sbr 'mix' [ pass ] 270 rpl.rpl_relay_space_myisam 'mix' [ pass ] 170 rpl.rpl_row_001 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_NOW 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_USER 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_UUID 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_basic_2myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_basic_8partition 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_blob_myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_colSize 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_conflicts 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_delayed_ins 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_drop 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_find_row 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_flsh_tbls 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_func001 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_func002 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_inexist_tbl 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_insert_delayed 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_max_relay_size 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_rec_comp_myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_reset_slave 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_show_relaylog_events 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp001 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp005 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp008 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp009 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp010 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp011 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp012 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_tabledefs_2myisam 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_trig001 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_trig002 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_trig003 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_trunc_temp 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_unsafe_funcs 'mix' [ pass ] 187 rpl.rpl_row_until 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_utf16 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_utf32 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_view01 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_wide_table 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_server_id 'mix' [ pass ] 42 rpl.rpl_server_id1 'mix' [ pass ] 170 rpl.rpl_session_var 'mix' [ pass ] 244 rpl.rpl_set_charset 'mix' [ pass ] 145 rpl.rpl_set_null_myisam 'mix' [ pass ] 463 rpl.rpl_sf 'mix' [ pass ] 20 rpl.rpl_slave_status 'mix' [ pass ] 9372 rpl.rpl_sp004 'mix' [ pass ] 1234 rpl.rpl_ssl 'mix' [ skipped ] Test requires: 'have_ssl' rpl.rpl_ssl1 'mix' [ skipped ] Test requires: 'have_ssl' rpl.rpl_stm_000001 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_EE_err2 'mix' [ pass ] 368 rpl.rpl_stm_auto_increment_bug33029 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_conflicts 'mix' [ pass ] 263 rpl.rpl_stm_flsh_tbls 'mix' [ pass ] 588 rpl.rpl_stm_found_rows 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_insert_delayed 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_loadfile 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_max_relay_size 'mix' [ pass ] 235757 rpl.rpl_stm_mix_show_relaylog_events 'mix' [ pass ] 22087 rpl.rpl_stm_multi_query 'mix' [ pass ] 8961 rpl.rpl_stm_no_op 'mix' [ pass ] 286 rpl.rpl_stm_reset_slave 'mix' [ pass ] 740 rpl.rpl_stm_sql_mode 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_until 'mix' [ pass ] 7575 rpl.rpl_stm_user_variables 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_switch_stm_row_mixed 'mix' [ pass ] 1345 rpl.rpl_temp_table 'mix' [ pass ] 333 rpl.rpl_temporary 'mix' [ pass ] 765 rpl.rpl_tmp_table_and_DDL 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_trunc_temp 'mix' [ pass ] 242 rpl.rpl_truncate_2myisam 'mix' [ pass ] 585 rpl.rpl_user 'mix' [ pass ] 147 rpl.rpl_user_variables 'mix' [ pass ] 1271 rpl.rpl_variables 'mix' [ pass ] 981 rpl.rpl_variables_stm 'mix' [ pass ] 916 rpl.rpl_view 'mix' [ pass ] 539 rpl.rpl_view_multi 'mix' [ pass ] 396 rpl.rpl_server_id2 'mix' [ pass ] 468 rpl.rpl_server_id_ignore 'mix' [ pass ] 1519 rpl.rpl000010 'mix' [ pass ] 153 rpl.rpl_init_slave 'mix' [ pass ] 214 rpl.rpl_typeconv 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_log 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_slow_query_log 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_temporary_errors 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_bug38694 'mix' [ pass ] 118 rpl.rpl_relayspace 'mix' [ pass ] 455 rpl.rpl_multi_delete2 'mix' [ pass ] 189 rpl.rpl_replicate_do 'mix' [ pass ] 280 rpl.rpl_filter_tables_not_exist 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_drop_temp 'mix' [ pass ] 1730 rpl.rpl_multi_update2 'mix' [ pass ] 310 rpl.rpl_ignore_table_update 'mix' [ pass ] 186 rpl.rpl_err_ignoredtable 'mix' [ pass ] 10286 rpl.rpl_ignore_table 'mix' [ pass ] 271 rpl.rpl_rewrt_db 'mix' [ pass ] 447 rpl.rpl_multi_update4 'mix' [ pass ] 267 rpl.rpl_multi_delete 'mix' [ pass ] 255 rpl.rpl_ignore_grant 'mix' [ pass ] 213 rpl.rpl_ignore_revoke 'mix' [ pass ] 183 rpl.rpl_free_items 'mix' [ pass ] 577 rpl.rpl_replicate_ignore_db 'mix' [ pass ] 204 rpl.rpl_report 'mix' [ pass ] 197 rpl.rpl_slave_load_tmpdir_not_exist 'mix' [ pass ] 35 rpl.rpl_concurrency_error 'mix' [ skipped ] Doesn't support --binlog-format='mixed' worker[1] Trying to dump core for [mysqltest - pid: 11820, winpid: 11820] worker[1] Trying to dump core for [mysqld.1 - pid: 11778, winpid: 11778] worker[1] Trying to dump core for [mysqld.2 - pid: 11782, winpid: 11782] rpl.rpl_innodb_bug28430 'mix' [ fail ] timeout after 900 seconds Test ended at 2011-01-25 11:34:39 Test case timeout after 900 seconds == /mysql/mysql-5.5.8/mysql-test/var/log/rpl_innodb_bug28430.log == DECLARE cur_user VARCHAR(255); DECLARE local_uuid VARCHAR(255); DECLARE local_time TIMESTAMP; SET local_time= NOW(); SET cur_user = CURRENT_USER(); SET local_uuid=UUID(); WHILE ins_count > 0 DO INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(), ins_count,'Going to test MBR for MySQL'); SET ins_count = ins_count - 1; END WHILE; SELECT MAX(id) FROM test.byrange_tbl INTO del_count; WHILE del_count > 0 DO DELETE FROM test.byrange_tbl WHERE id = del_count; SET del_count = del_count - 2; END WHILE; END| CALL test.proc_norm(); SELECT count(*) as "Master regular" FROM test.regular_tbl; Master regular 500 == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.2.sock' (111) == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock' (111) - saving '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-mix/' to '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-mix/' - found 'core.11779' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 11831] [New Thread 11826] [New Thread 11825] [New Thread 11803] [New Thread 11796] [New Thread 11795] [New Thread 11794] [New Thread 11793] [New Thread 11790] [New Thread 11789] [New Thread 11788] [New Thread 11787] [New Thread 11786] [New Thread 11785] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.1 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x132158a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 15 (Thread 11785): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x136987b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x136987b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x40fbe0f8, message2=0x40fbe0f0, type=0x40fbe0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 14 (Thread 11786): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x13698830, reset_sig_count=64) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x13698830, reset_sig_count=64) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x421df0f8, message2=0x421df0f0, type=0x421df0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 11787): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x136988b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x136988b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x42be00f8, message2=0x42be00f0, type=0x42be00e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 11788): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x13698930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x13698930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x435e10f8, message2=0x435e10f0, type=0x435e10e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 11789): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x136989b0, reset_sig_count=175) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x136989b0, reset_sig_count=175) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x43fe20f8, message2=0x43fe20f0, type=0x43fe20e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 11790): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x13698a30, reset_sig_count=158) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x13698a30, reset_sig_count=158) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x449e30f8, message2=0x449e30f0, type=0x449e30e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 11793): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x13516a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x13516a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 11794): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x135169a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x135169a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 11795): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x13516aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x13516aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 11796): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x000000000082a131 in fil_flush_file_spaces (purpose=501) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4704 #6 0x0000000000806b59 in buf_flush_buffered_writes () at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:890 #7 0x00000000008083b7 in buf_flush_batch (buf_pool=0x136ad158, flush_type=325768072, min_n=200, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1711 #8 0x00000000008087c0 in buf_flush_list (min_n=200, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1929 #9 0x00000000007c0979 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2798 #10 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #11 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 11803): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 11825): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x00000000008587d7 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /root/downloads/mysql-5.5.8/storage/innobase/log/log0log.c:1514 #6 0x00000000007d784b in trx_commit_complete_for_mysql (trx=0x13284198) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1603 #7 0x000000000079b124 in innobase_commit (hton=, thd= 0x137bb8c0, all=false) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:2745 #8 0x000000000064e622 in ha_commit_one_phase (thd=0x137bb8c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1299 #9 0x000000000064fd5f in ha_commit_trans (thd=0x137bb8c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1237 #10 0x00000000005f3c82 in trans_commit_stmt (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/transaction.cc:272 #11 0x0000000000557bbd in mysql_execute_command (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:4355 #12 0x000000000070ecbc in sp_instr_stmt::exec_core (this=0x13882300, thd=0x0, nextp=0x2) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3162 #13 0x000000000070ee24 in sp_lex_keeper::reset_lex_and_exec_core ( this=0x13882340, thd=0x137bb8c0, nextp=0x47ca89d8, open_tables=false, instr=0x13882300) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2959 #14 0x0000000000714771 in sp_instr_stmt::execute (this=0x13882300, thd=0x137bb8c0, nextp=0x47ca89d8) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3094 #15 0x0000000000712f71 in sp_head::execute (this=0x13803480, thd=0x137bb8c0, merge_da_on_success=true) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:1420 #16 0x0000000000713745 in sp_head::execute_procedure (this=0x13803480, thd=0x137bb8c0, args=0x137bdd98) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2176 #17 0x0000000000557fcc in mysql_execute_command (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:3914 #18 0x000000000055d4be in mysql_parse (thd=0x137bb8c0, rawbuf=0x137c6670 "CALL test.proc_bykey()", length=, parser_state=0x47caac70) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:5496 #19 0x000000000055e4ee in dispatch_command (command=COM_QUERY, thd=0x137bb8c0, packet=, packet_length=22) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1032 #20 0x000000000055e812 in do_command (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #21 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #22 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #23 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #24 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #25 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 11826): #0 0x0000003c1680d91b in read () from /lib64/libpthread.so.0 #1 0x00000000004f4edb in my_real_read (net=0x137c8868, complen=0x47cec050) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:841 #2 0x00000000004f5223 in my_net_read (net=0x39) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:1038 #3 0x000000000055e7c5 in do_command (thd=0x137c8680) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:718 #4 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x137c8680) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #5 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 11831): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d2f06 in inline_mysql_cond_timedwait ( this=, thd=, timeout=0x47d2be80) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:1009 #2 MYSQL_BIN_LOG::wait_for_update_bin_log (this=, thd=, timeout=0x47d2be80) at /root/downloads/mysql-5.5.8/sql/log.cc:5309 #3 0x000000000056fe86 in mysql_binlog_send (thd=0x137fb370, log_ident=0x2aaaab49cd98 "\001", pos=4, flags=0) at /root/downloads/mysql-5.5.8/sql/sql_repl.cc:844 #4 0x000000000055dd4f in dispatch_command (command=COM_BINLOG_DUMP, thd=0x137fb370, packet=0x137fe0f1 "", packet_length=) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1209 #5 0x000000000055e812 in do_command (thd=0x137fb370) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #6 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x137fb370) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #7 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #8 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #9 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #10 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 11779): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x132158a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () - found 'core.11783' (1/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 11830] [New Thread 11829] [New Thread 11808] [New Thread 11807] [New Thread 11806] [New Thread 11805] [New Thread 11802] [New Thread 11801] [New Thread 11800] [New Thread 11799] [New Thread 11798] [New Thread 11797] [New Thread 11783] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #4 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #5 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 14 (Thread 11783): #0 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #1 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #2 0x00000000004f2f31 in mysqld_main (argc=57, argv=0x1e4bdbd8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #3 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #4 0x00000000004eacc9 in _start () Thread 13 (Thread 11797): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x419230f8, message2=0x419230f0, type=0x419230e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 11798): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e9408b0, reset_sig_count=63) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e9408b0, reset_sig_count=63) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x423240f8, message2=0x423240f0, type=0x423240e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 11799): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x42d250f8, message2=0x42d250f0, type=0x42d250e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 11800): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e9409b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e9409b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x437260f8, message2=0x437260f0, type=0x437260e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 11801): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940a30, reset_sig_count=168) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940a30, reset_sig_count=168) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x441270f8, message2=0x441270f0, type=0x441270e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 11802): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940ab0, reset_sig_count=155) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940ab0, reset_sig_count=155) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x44b280f8, message2=0x44b280f0, type=0x44b280e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 11805): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1e7bea40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e7bea40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 11806): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1e7be9c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e7be9c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 11807): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1e7beac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e7beac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 11808): #0 0x0000003c160cd212 in select () from /lib64/libc.so.6 #1 0x000000000086853b in os_thread_sleep (tm=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0thread.c:274 #2 0x00000000007c13b0 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2700 #3 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #4 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 11829): #0 0x0000003c1609a3f1 in nanosleep () from /lib64/libc.so.6 #1 0x0000003c1609a214 in sleep () from /lib64/libc.so.6 #2 0x00000000004ff965 in safe_sleep (thd=0x1ea7b9d0, sec=, thread_killed=0x4ff460 , thread_killed_arg=0x1ea16040) at /root/downloads/mysql-5.5.8/sql/slave.cc:2091 #3 0x0000000000508dd6 in connect_to_master (thd=0x1ea7b9d0, mysql=0x1ea8bd60, mi=0x1ea16040, reconnect=true, suppress_warnings=false) at /root/downloads/mysql-5.5.8/sql/slave.cc:4238 #4 0x0000000000509260 in safe_reconnect (thd=0x1ea7b9d0, mysql=0x1ea8bd60, mi=0x1ea16040, retry_count=0x47e310c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:4281 #5 try_to_reconnect (thd=0x1ea7b9d0, mysql=0x1ea8bd60, mi=0x1ea16040, retry_count=0x47e310c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:2682 #6 0x000000000050a56d in handle_slave_io (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:2937 #7 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #8 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #9 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 11830): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x00000000008587d7 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /root/downloads/mysql-5.5.8/storage/innobase/log/log0log.c:1514 #6 0x00000000007da9bc in trx_prepare_off_kernel (trx=0x1ea75e18) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1889 #7 0x00000000007daa88 in trx_prepare_for_mysql (trx=0x1ea75e18) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1925 #8 0x000000000079b972 in innobase_xa_prepare (hton=, thd=0x1eaa73e0, all=true) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:10082 #9 0x000000000064ff34 in ha_commit_trans (thd=0x1eaa73e0, all=) at /root/downloads/mysql-5.5.8/sql/handler.cc:1220 #10 0x00000000005f3b64 in trans_commit (thd=0x1eaa73e0) at /root/downloads/mysql-5.5.8/sql/transaction.cc:154 #11 0x00000000006e2860 in Xid_log_event::do_apply_event (this=0x2aaab000f1a0, rli=) at /root/downloads/mysql-5.5.8/sql/log_event.cc:5565 #12 0x00000000005014cd in apply_event (ev=0x2aaab000f1a0, thd=, rli=0x1ea17368) at /root/downloads/mysql-5.5.8/sql/log_event.h:1131 #13 apply_event_and_update_pos (ev=0x2aaab000f1a0, thd=, rli=0x1ea17368) at /root/downloads/mysql-5.5.8/sql/slave.cc:2342 #14 0x0000000000503df9 in exec_relay_log_event (thd=0x1eaa73e0, rli=0x1ea17368) at /root/downloads/mysql-5.5.8/sql/slave.cc:2502 #15 0x00000000005054c1 in handle_slave_sql (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:3320 #16 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #17 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #18 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 11809): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #4 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #5 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Retrying test rpl.rpl_innodb_bug28430, attempt(2/3)... worker[1] Trying to dump core for [mysqltest - pid: 11988, winpid: 11988] worker[1] Trying to dump core for [mysqld.1 - pid: 11946, winpid: 11946] worker[1] Trying to dump core for [mysqld.2 - pid: 11950, winpid: 11950] rpl.rpl_innodb_bug28430 'mix' [ retry-fail ] timeout after 900 seconds Test ended at 2011-01-25 11:50:53 Test case timeout after 900 seconds == /mysql/mysql-5.5.8/mysql-test/var/log/rpl_innodb_bug28430.log == SET local_time= NOW(); SET cur_user = CURRENT_USER(); SET local_uuid=UUID(); WHILE ins_count > 0 DO INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(), ins_count,'Going to test MBR for MySQL'); SET ins_count = ins_count - 1; END WHILE; SELECT MAX(id) FROM test.byrange_tbl INTO del_count; WHILE del_count > 0 DO DELETE FROM test.byrange_tbl WHERE id = del_count; SET del_count = del_count - 2; END WHILE; END| CALL test.proc_norm(); SELECT count(*) as "Master regular" FROM test.regular_tbl; Master regular 500 CALL test.proc_bykey(); SELECT count(*) as "Master bykey" FROM test.bykey_tbl; Master bykey 500 == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.2.sock' (111) == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock' (111) - saving '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-mix/' to '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-mix/' - found 'core.11779' (2/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 11831] [New Thread 11826] [New Thread 11825] [New Thread 11803] [New Thread 11796] [New Thread 11795] [New Thread 11794] [New Thread 11793] [New Thread 11790] [New Thread 11789] [New Thread 11788] [New Thread 11787] [New Thread 11786] [New Thread 11785] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.1 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x132158a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 15 (Thread 11785): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x136987b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x136987b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x40fbe0f8, message2=0x40fbe0f0, type=0x40fbe0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 14 (Thread 11786): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x13698830, reset_sig_count=64) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x13698830, reset_sig_count=64) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x421df0f8, message2=0x421df0f0, type=0x421df0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 11787): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x136988b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x136988b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x42be00f8, message2=0x42be00f0, type=0x42be00e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 11788): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x13698930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x13698930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x435e10f8, message2=0x435e10f0, type=0x435e10e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 11789): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x136989b0, reset_sig_count=175) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x136989b0, reset_sig_count=175) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x43fe20f8, message2=0x43fe20f0, type=0x43fe20e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 11790): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x13698a30, reset_sig_count=158) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x13698a30, reset_sig_count=158) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x449e30f8, message2=0x449e30f0, type=0x449e30e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 11793): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x13516a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x13516a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 11794): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x135169a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x135169a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 11795): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x13516aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x13516aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 11796): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x000000000082a131 in fil_flush_file_spaces (purpose=501) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4704 #6 0x0000000000806b59 in buf_flush_buffered_writes () at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:890 #7 0x00000000008083b7 in buf_flush_batch (buf_pool=0x136ad158, flush_type=325768072, min_n=200, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1711 #8 0x00000000008087c0 in buf_flush_list (min_n=200, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1929 #9 0x00000000007c0979 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2798 #10 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #11 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 11803): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 11825): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x00000000008587d7 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /root/downloads/mysql-5.5.8/storage/innobase/log/log0log.c:1514 #6 0x00000000007d784b in trx_commit_complete_for_mysql (trx=0x13284198) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1603 #7 0x000000000079b124 in innobase_commit (hton=, thd= 0x137bb8c0, all=false) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:2745 #8 0x000000000064e622 in ha_commit_one_phase (thd=0x137bb8c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1299 #9 0x000000000064fd5f in ha_commit_trans (thd=0x137bb8c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1237 #10 0x00000000005f3c82 in trans_commit_stmt (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/transaction.cc:272 #11 0x0000000000557bbd in mysql_execute_command (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:4355 #12 0x000000000070ecbc in sp_instr_stmt::exec_core (this=0x13882300, thd=0x0, nextp=0x2) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3162 #13 0x000000000070ee24 in sp_lex_keeper::reset_lex_and_exec_core ( this=0x13882340, thd=0x137bb8c0, nextp=0x47ca89d8, open_tables=false, instr=0x13882300) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2959 #14 0x0000000000714771 in sp_instr_stmt::execute (this=0x13882300, thd=0x137bb8c0, nextp=0x47ca89d8) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3094 #15 0x0000000000712f71 in sp_head::execute (this=0x13803480, thd=0x137bb8c0, merge_da_on_success=true) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:1420 #16 0x0000000000713745 in sp_head::execute_procedure (this=0x13803480, thd=0x137bb8c0, args=0x137bdd98) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2176 #17 0x0000000000557fcc in mysql_execute_command (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:3914 #18 0x000000000055d4be in mysql_parse (thd=0x137bb8c0, rawbuf=0x137c6670 "CALL test.proc_bykey()", length=, parser_state=0x47caac70) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:5496 #19 0x000000000055e4ee in dispatch_command (command=COM_QUERY, thd=0x137bb8c0, packet=, packet_length=22) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1032 #20 0x000000000055e812 in do_command (thd=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #21 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x137bb8c0) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #22 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #23 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #24 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #25 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 11826): #0 0x0000003c1680d91b in read () from /lib64/libpthread.so.0 #1 0x00000000004f4edb in my_real_read (net=0x137c8868, complen=0x47cec050) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:841 #2 0x00000000004f5223 in my_net_read (net=0x39) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:1038 #3 0x000000000055e7c5 in do_command (thd=0x137c8680) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:718 #4 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x137c8680) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #5 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 11831): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d2f06 in inline_mysql_cond_timedwait ( this=, thd=, timeout=0x47d2be80) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:1009 #2 MYSQL_BIN_LOG::wait_for_update_bin_log (this=, thd=, timeout=0x47d2be80) at /root/downloads/mysql-5.5.8/sql/log.cc:5309 #3 0x000000000056fe86 in mysql_binlog_send (thd=0x137fb370, log_ident=0x2aaaab49cd98 "\001", pos=4, flags=0) at /root/downloads/mysql-5.5.8/sql/sql_repl.cc:844 #4 0x000000000055dd4f in dispatch_command (command=COM_BINLOG_DUMP, thd=0x137fb370, packet=0x137fe0f1 "", packet_length=) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1209 #5 0x000000000055e812 in do_command (thd=0x137fb370) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #6 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x137fb370) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #7 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #8 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #9 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #10 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 11779): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x132158a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () - found 'core.11783' (3/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 11830] [New Thread 11829] [New Thread 11808] [New Thread 11807] [New Thread 11806] [New Thread 11805] [New Thread 11802] [New Thread 11801] [New Thread 11800] [New Thread 11799] [New Thread 11798] [New Thread 11797] [New Thread 11783] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #4 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #5 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 14 (Thread 11783): #0 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #1 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #2 0x00000000004f2f31 in mysqld_main (argc=57, argv=0x1e4bdbd8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #3 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #4 0x00000000004eacc9 in _start () Thread 13 (Thread 11797): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x419230f8, message2=0x419230f0, type=0x419230e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 11798): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e9408b0, reset_sig_count=63) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e9408b0, reset_sig_count=63) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x423240f8, message2=0x423240f0, type=0x423240e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 11799): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x42d250f8, message2=0x42d250f0, type=0x42d250e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 11800): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e9409b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e9409b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x437260f8, message2=0x437260f0, type=0x437260e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 11801): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940a30, reset_sig_count=168) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940a30, reset_sig_count=168) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x441270f8, message2=0x441270f0, type=0x441270e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 11802): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1e940ab0, reset_sig_count=155) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1e940ab0, reset_sig_count=155) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x44b280f8, message2=0x44b280f0, type=0x44b280e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 11805): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1e7bea40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e7bea40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 11806): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1e7be9c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e7be9c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 11807): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1e7beac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e7beac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 11808): #0 0x0000003c160cd212 in select () from /lib64/libc.so.6 #1 0x000000000086853b in os_thread_sleep (tm=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0thread.c:274 #2 0x00000000007c13b0 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2700 #3 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #4 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 11829): #0 0x0000003c1609a3f1 in nanosleep () from /lib64/libc.so.6 #1 0x0000003c1609a214 in sleep () from /lib64/libc.so.6 #2 0x00000000004ff965 in safe_sleep (thd=0x1ea7b9d0, sec=, thread_killed=0x4ff460 , thread_killed_arg=0x1ea16040) at /root/downloads/mysql-5.5.8/sql/slave.cc:2091 #3 0x0000000000508dd6 in connect_to_master (thd=0x1ea7b9d0, mysql=0x1ea8bd60, mi=0x1ea16040, reconnect=true, suppress_warnings=false) at /root/downloads/mysql-5.5.8/sql/slave.cc:4238 #4 0x0000000000509260 in safe_reconnect (thd=0x1ea7b9d0, mysql=0x1ea8bd60, mi=0x1ea16040, retry_count=0x47e310c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:4281 #5 try_to_reconnect (thd=0x1ea7b9d0, mysql=0x1ea8bd60, mi=0x1ea16040, retry_count=0x47e310c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:2682 #6 0x000000000050a56d in handle_slave_io (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:2937 #7 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #8 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #9 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 11830): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x00000000008587d7 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /root/downloads/mysql-5.5.8/storage/innobase/log/log0log.c:1514 #6 0x00000000007da9bc in trx_prepare_off_kernel (trx=0x1ea75e18) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1889 #7 0x00000000007daa88 in trx_prepare_for_mysql (trx=0x1ea75e18) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1925 #8 0x000000000079b972 in innobase_xa_prepare (hton=, thd=0x1eaa73e0, all=true) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:10082 #9 0x000000000064ff34 in ha_commit_trans (thd=0x1eaa73e0, all=) at /root/downloads/mysql-5.5.8/sql/handler.cc:1220 #10 0x00000000005f3b64 in trans_commit (thd=0x1eaa73e0) at /root/downloads/mysql-5.5.8/sql/transaction.cc:154 #11 0x00000000006e2860 in Xid_log_event::do_apply_event (this=0x2aaab000f1a0, rli=) at /root/downloads/mysql-5.5.8/sql/log_event.cc:5565 #12 0x00000000005014cd in apply_event (ev=0x2aaab000f1a0, thd=, rli=0x1ea17368) at /root/downloads/mysql-5.5.8/sql/log_event.h:1131 #13 apply_event_and_update_pos (ev=0x2aaab000f1a0, thd=, rli=0x1ea17368) at /root/downloads/mysql-5.5.8/sql/slave.cc:2342 #14 0x0000000000503df9 in exec_relay_log_event (thd=0x1eaa73e0, rli=0x1ea17368) at /root/downloads/mysql-5.5.8/sql/slave.cc:2502 #15 0x00000000005054c1 in handle_slave_sql (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:3320 #16 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #17 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #18 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 11809): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #4 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #5 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Test rpl.rpl_innodb_bug28430 has failed 2 times, no more retries! rpl.rpl_dual_pos_advance 'mix' [ pass ] 1821 rpl.rpl_auto_increment_update_failure 'mix' [ pass ] 3905 rpl.rpl_binlog_grant 'mix' [ pass ] 464 rpl.rpl_commit_after_flush 'mix' [ pass ] 31790 rpl.rpl_ddl 'mix' [ skipped ] This test needs on slave side: InnoDB disabled, default engine: MyISAM rpl.rpl_extraCol_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_extraColmaster_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_foreign_key_innodb 'mix' [ pass ] 20215 rpl.rpl_innodb_bug30888 'mix' [ pass ] 873955 rpl.rpl_innodb_mixed_ddl 'mix' [ pass ] 54403 rpl.rpl_innodb_mixed_dml 'mix' [ pass ] 93266 rpl.rpl_insert_id 'mix' [ pass ] 45998 rpl.rpl_insert_id_pk 'mix' [ pass ] 35680 rpl.rpl_insert_ignore 'mix' [ pass ] 18366 rpl.rpl_loaddata 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_mixed_binlog_max_cache_size 'mix' [ pass ] 78777 rpl.rpl_mixed_drop_create_temp_table 'mix' [ pass ] 806507 rpl.rpl_mixed_implicit_commit_binlog 'mix' [ pass ] 67018 rpl.rpl_mixed_mixing_engines 'mix' [ pass ] 460850 rpl.rpl_multi_engine 'mix' [ pass ] 34797 rpl.rpl_non_direct_mixed_mixing_engines 'mix' [ pass ] 528974 rpl.rpl_non_direct_row_mixing_engines 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_non_direct_stm_mixing_engines 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_not_null_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_relay_space_innodb 'mix' [ pass ] 12889 rpl.rpl_row_basic_3innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_binlog_max_cache_size 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_blob_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_drop_create_temp_table 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_func003 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_idempotency 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_implicit_commit_binlog 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_loaddata_concurrent 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_mixing_engines 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_rec_comp_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp002_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp003 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp006_InnoDB 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_sp007_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_tabledefs_3innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_tbl_metadata 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_row_trig004 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_savepoint 'mix' [ pass ] 23165 rpl.rpl_set_null_innodb 'mix' [ pass ] 33480 rpl.rpl_slave_grp_exec 'mix' [ pass ] 28790 rpl.rpl_slave_load_in 'mix' [ pass ] 299 rpl.rpl_slave_skip 'mix' [ pass ] 1330 rpl.rpl_stm_binlog_max_cache_size 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_drop_create_temp_table 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_implicit_commit_binlog 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_innodb 'mix' [ pass ] 640 MTR's internal check of the test case 'rpl.rpl_stm_innodb' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/mysql/mysql-5.5.8/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/mysql/mysql-5.5.8/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /mysql/mysql-5.5.8/mysql-test/var/tmp/check-mysqld_1.result 2011-01-25 20:46:05.000000000 +0300 +++ /mysql/mysql-5.5.8/mysql-test/var/tmp/check-mysqld_1.reject 2011-01-25 20:46:06.000000000 +0300 @@ -308,7 +308,6 @@ def information_schema utf8 utf8_general_ci NULL def mtr latin1 latin1_swedish_ci NULL def mysql latin1 latin1_swedish_ci NULL -def mysqltest1 latin1 latin1_swedish_ci NULL def mysqltest2 latin1 latin1_swedish_ci NULL def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL mysqltest: Result content mismatch not ok rpl.rpl_stm_loaddata_concurrent 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_mixing_engines 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_stm_start_stop_slave 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_temp_table_mix_row 'mix' [ pass ] 584 rpl.rpl_trigger 'mix' [ pass ] 175060 rpl.rpl_truncate_3innodb 'mix' [ pass ] 29653 rpl.rpl_typeconv_innodb 'mix' [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_deadlock_innodb 'mix' [ pass ] 64773 rpl.rpl_relayrotate 'mix' [ pass ] 40323 rpl.rpl_skip_error 'mix' [ pass ] 15251 rpl.rpl_begin_commit_rollback 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_loaddata_m 'row' [ pass ] 7940 rpl.rpl_row_basic_11bugs 'row' [ pass ] 65193 rpl.rpl_timezone 'row' [ pass ] 442 rpl.rpl_flush_logs 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_sp 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_sp_effects 'row' [ pass ] 15170 rpl.rpl_sporadic_master 'row' [ pass ] 11619 rpl.rpl_row_mysqlbinlog 'row' [ pass ] 102634 rpl.rpl_packet 'row' [ pass ] 26848 rpl.rpl_loaddata_map 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_flushlog_loop 'row' [ pass ] 22570 rpl.rpl_binlog_auto_inc_bug33029 'row' [ pass ] 80 rpl.rpl_cross_version 'row' [ pass ] 157 rpl.rpl_binlog_query_filter_rules 'row' [ pass ] 120 rpl.rpl_loaddata_symlink 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_row_log_innodb 'row' [ pass ] 557 rpl.rpl_row_log 'row' [ pass ] 703 rpl.rpl_invoked_features 'row' [ pass ] 1017 rpl.rpl_loaddata_s 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_heartbeat 'row' [ pass ] 15223 rpl.rpl000011 'row' [ pass ] 247 rpl.rpl000013 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl000017 'row' [ pass ] 185 rpl.rpl_EE_err 'row' [ pass ] 144 rpl.rpl_LD_INFILE 'row' [ pass ] 240 rpl.rpl_alter 'row' [ pass ] 237 rpl.rpl_alter_db 'row' [ pass ] 110 rpl.rpl_auto_increment_11932 'row' [ pass ] 255 rpl.rpl_bit 'row' [ pass ] 246 rpl.rpl_bit_npk 'row' [ pass ] 283 rpl.rpl_blackhole 'row' [ skipped ] Need blackhole engine rpl.rpl_bug31076 'row' [ pass ] 235 rpl.rpl_change_master 'row' [ pass ] 479 rpl.rpl_charset 'row' [ pass ] 244 rpl.rpl_charset_sjis 'row' [ pass ] 218 rpl.rpl_colSize 'row' [ pass ] 1399 rpl.rpl_conditional_comments 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_create_if_not_exists 'row' [ pass ] 831 rpl.rpl_create_tmp_table_if_not_exists 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_critical_errors 'row' [ pass ] 1 rpl.rpl_delete_no_where 'row' [ pass ] 179 rpl.rpl_do_grant 'row' [ pass ] 1172 rpl.rpl_drop 'row' [ pass ] 252 rpl.rpl_drop_db 'row' [ pass ] 1310 rpl.rpl_drop_if_exists 'row' [ pass ] 107 rpl.rpl_drop_view 'row' [ pass ] 10539 rpl.rpl_empty_master_host 'row' [ pass ] 7643 rpl.rpl_events 'row' [ pass ] 11286 rpl.rpl_extraCol_myisam 'row' [ pass ] 111615 rpl.rpl_extraColmaster_myisam 'row' [ pass ] 3083 rpl.rpl_geometry 'row' [ pass ] 172 rpl.rpl_get_lock 'row' [ pass ] 732 rpl.rpl_grant 'row' [ pass ] 140 rpl.rpl_heartbeat_ssl 'row' [ skipped ] Test requires: 'have_ssl' rpl.rpl_idempotency 'row' [ pass ] 183 rpl.rpl_insert 'row' [ pass ] 2160 rpl.rpl_insert_select 'row' [ pass ] 247 rpl.rpl_loaddata_charset 'row' [ pass ] 591 rpl.rpl_loaddata_simple 'row' [ pass ] 153 rpl.rpl_loaddatalocal 'row' [ pass ] 2685 rpl.rpl_loadfile 'row' [ pass ] 392 rpl.rpl_locale 'row' [ pass ] 1127 rpl.rpl_manual_change_index_file 'row' [ pass ] 683 rpl.rpl_many_optimize 'row' [ pass ] 869 rpl.rpl_master_pos_wait 'row' [ pass ] 2174 rpl.rpl_misc_functions 'row' [ pass ] 682 rpl.rpl_mix_found_rows 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_mix_insert_delayed 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_mixed_bit_pk 'row' [ pass ] 360 rpl.rpl_mixed_ddl_dml 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_multi_update 'row' [ pass ] 242 rpl.rpl_multi_update3 'row' [ pass ] 420 rpl.rpl_mysql_upgrade 'row' [ pass ] 1473 rpl.rpl_name_const 'row' [ pass ] 136 rpl.rpl_nondeterministic_functions 'row' [ pass ] 191 rpl.rpl_not_null_myisam 'row' [ pass ] 499 rpl.rpl_optimize 'row' [ pass ] 13266 rpl.rpl_ps 'row' [ pass ] 1444 rpl.rpl_rbr_to_sbr 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_relay_space_myisam 'row' [ pass ] 326 rpl.rpl_row_001 'row' [ pass ] 10434 rpl.rpl_row_NOW 'row' [ pass ] 507 rpl.rpl_row_USER 'row' [ pass ] 346 rpl.rpl_row_UUID 'row' [ pass ] 10533 rpl.rpl_row_basic_2myisam 'row' [ pass ] 60550 rpl.rpl_row_basic_8partition 'row' [ pass ] 31709 rpl.rpl_row_blob_myisam 'row' [ pass ] 12620 rpl.rpl_row_colSize 'row' [ pass ] 121822 rpl.rpl_row_conflicts 'row' [ pass ] 213 rpl.rpl_row_delayed_ins 'row' [ pass ] 179 rpl.rpl_row_drop 'row' [ pass ] 182 rpl.rpl_row_find_row 'row' [ pass ] 2578 rpl.rpl_row_flsh_tbls 'row' [ pass ] 8452 rpl.rpl_row_func001 'row' [ pass ] 7487 rpl.rpl_row_func002 'row' [ pass ] 11188 rpl.rpl_row_inexist_tbl 'row' [ pass ] 7497 rpl.rpl_row_insert_delayed 'row' [ pass ] 10968 rpl.rpl_row_max_relay_size 'row' [ pass ] 165377 rpl.rpl_row_rec_comp_myisam 'row' [ pass ] 32619 rpl.rpl_row_reset_slave 'row' [ pass ] 22838 rpl.rpl_row_show_relaylog_events 'row' [ pass ] 11064 rpl.rpl_row_sp001 'row' [ pass ] 8768 rpl.rpl_row_sp005 'row' [ pass ] 13770 rpl.rpl_row_sp008 'row' [ pass ] 3851 rpl.rpl_row_sp009 'row' [ pass ] 2073 rpl.rpl_row_sp010 'row' [ pass ] 4130 rpl.rpl_row_sp011 'row' [ pass ] 4413 rpl.rpl_row_sp012 'row' [ pass ] 302 rpl.rpl_row_tabledefs_2myisam 'row' [ pass ] 786 rpl.rpl_row_trig001 'row' [ pass ] 632 rpl.rpl_row_trig002 'row' [ pass ] 10944 rpl.rpl_row_trig003 'row' [ pass ] 17261 rpl.rpl_row_trunc_temp 'row' [ pass ] 12029 rpl.rpl_row_unsafe_funcs 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_row_until 'row' [ pass ] 11892 rpl.rpl_row_utf16 'row' [ pass ] 5822 rpl.rpl_row_utf32 'row' [ pass ] 11664 rpl.rpl_row_view01 'row' [ pass ] 14906 rpl.rpl_row_wide_table 'row' [ pass ] 10487 rpl.rpl_server_id 'row' [ pass ] 3158 rpl.rpl_server_id1 'row' [ pass ] 6264 rpl.rpl_session_var 'row' [ pass ] 11545 rpl.rpl_set_charset 'row' [ pass ] 11133 rpl.rpl_set_null_myisam 'row' [ pass ] 15999 rpl.rpl_sf 'row' [ pass ] 188 rpl.rpl_slave_status 'row' [ pass ] 19092 rpl.rpl_sp004 'row' [ pass ] 15565 rpl.rpl_ssl 'row' [ skipped ] Test requires: 'have_ssl' rpl.rpl_ssl1 'row' [ skipped ] Test requires: 'have_ssl' rpl.rpl_stm_000001 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_EE_err2 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_auto_increment_bug33029 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_conflicts 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_flsh_tbls 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_found_rows 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_insert_delayed 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_loadfile 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_max_relay_size 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_mix_show_relaylog_events 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_multi_query 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_no_op 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_reset_slave 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_sql_mode 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_until 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_user_variables 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_switch_stm_row_mixed 'row' [ pass ] 45656 rpl.rpl_temp_table 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_temporary 'row' [ pass ] 24908 rpl.rpl_tmp_table_and_DDL 'row' [ pass ] 10816 rpl.rpl_trunc_temp 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_truncate_2myisam 'row' [ pass ] 24363 rpl.rpl_user 'row' [ pass ] 6527 rpl.rpl_user_variables 'row' [ pass ] 26040 rpl.rpl_variables 'row' [ pass ] 18501 rpl.rpl_variables_stm 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_view 'row' [ pass ] 20454 rpl.rpl_view_multi 'row' [ pass ] 11625 rpl.rpl_server_id2 'row' [ pass ] 12261 rpl.rpl_server_id_ignore 'row' [ pass ] 13637 rpl.rpl000010 'row' [ pass ] 6039 rpl.rpl_init_slave 'row' [ pass ] 12815 worker[1] Trying to dump core for [mysqltest - pid: 25338, winpid: 25338] worker[1] Trying to dump core for [mysqld.1 - pid: 24494, winpid: 24494] worker[1] Trying to dump core for [mysqld.2 - pid: 25312, winpid: 25312] rpl.rpl_typeconv 'row' [ fail ] timeout after 900 seconds Test ended at 2011-01-25 13:38:25 Test case timeout after 900 seconds == /mysql/mysql-5.5.8/mysql-test/var/log/rpl_typeconv.log == include/stop_slave.inc RESET SLAVE; RESET MASTER; include/start_slave.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY' **** **** Resetting master and slave **** include/stop_slave.inc RESET SLAVE; RESET MASTER; include/start_slave.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY' **** **** Resetting master and slave **** include/stop_slave.inc RESET SLAVE; RESET MASTER; include/start_slave.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY,ALL_NON_LOSSY' **** == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.2.sock' (111) == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock' (111) - saving '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_typeconv-row/' to '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_typeconv-row/' - found 'core.24495' (4/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 25621] [New Thread 25343] [New Thread 24525] [New Thread 24519] [New Thread 24518] [New Thread 24517] [New Thread 24516] [New Thread 24508] [New Thread 24507] [New Thread 24506] [New Thread 24505] [New Thread 24504] [New Thread 24503] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.1 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x1cbb78a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 14 (Thread 24503): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1d03a7b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1d03a7b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x410a10f8, message2=0x410a10f0, type=0x410a10e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 24504): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1d03a830, reset_sig_count=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1d03a830, reset_sig_count=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x427b60f8, message2=0x427b60f0, type=0x427b60e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 24505): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1d03a8b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1d03a8b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x431b70f8, message2=0x431b70f0, type=0x431b70e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 24506): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1d03a930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1d03a930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x43bb80f8, message2=0x43bb80f0, type=0x43bb80e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 24507): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1d03a9b0, reset_sig_count=2) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1d03a9b0, reset_sig_count=2) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x445b90f8, message2=0x445b90f0, type=0x445b90e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 24508): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1d03aa30, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1d03aa30, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x44fba0f8, message2=0x44fba0f0, type=0x44fba0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 24516): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1ceb8a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1ceb8a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 24517): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1ceb89a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1ceb89a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 24518): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1ceb8aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1ceb8aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 24519): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1cc32eb0, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1cc32eb0, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x00000000007c087a in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:3031 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 24525): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 25343): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x00000000008b3308 in my_sync (fd=57, my_flags=16) at /root/downloads/mysql-5.5.8/mysys/my_sync.c:64 #2 0x00000000005d4bb6 in inline_mysql_file_sync (thd=0x1d0c4cd0, file_name=0x4783c650 "./test/t1.frm", db=0x1d1d9708 "test", table=0x1d1d91a8 "t1", create_info=0x4783ec50, create_fields=..., keys=0, key_info=, db_file=0x1d1d9a40) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_file.h:1421 #3 mysql_create_frm (thd=0x1d0c4cd0, file_name=0x4783c650 "./test/t1.frm", db=0x1d1d9708 "test", table=0x1d1d91a8 "t1", create_info=0x4783ec50, create_fields=..., keys=0, key_info=, db_file=0x1d1d9a40) at /root/downloads/mysql-5.5.8/sql/unireg.cc:387 #4 0x00000000005d4d2b in rea_create_table (thd=0x1d0c4cd0, path=0x4783d530 "./test/t1", db=0x1d1d9708 "test", table_name=0x1d1d91a8 "t1", create_info=0x4783ec50, create_fields=..., keys=0, key_info=0x1d1d9bd0, file=0x1d1d9a40) at /root/downloads/mysql-5.5.8/sql/unireg.cc:454 #5 0x00000000005aeecd in mysql_create_table_no_lock (thd=0x1d0c4cd0, db=0x1d1d9708 "test", table_name=0x1d1d91a8 "t1", create_info=0x4783ec50, alter_info=0x4783ed30, internal_tmp_table=false, select_field_count=0, is_trans=0x4783da6f) at /root/downloads/mysql-5.5.8/sql/sql_table.cc:4259 #6 0x00000000005afe6d in mysql_create_table (thd=0x1d0c4cd0, create_table=0x1d1d91e0, create_info=0x4783ec50, alter_info=0x4783ed30) at /root/downloads/mysql-5.5.8/sql/sql_table.cc:4355 #7 0x000000000055d24f in mysql_execute_command (thd=0x1d0c4cd0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:2448 #8 0x000000000055d4be in mysql_parse (thd=0x1d0c4cd0, rawbuf=0x1d1d90f0 "CREATE TABLE t1 (a VARCHAR(500))", length=, parser_state=0x4783fc70) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:5496 #9 0x000000000055e4ee in dispatch_command (command=COM_QUERY, thd=0x1d0c4cd0, packet=, packet_length=32) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1032 #10 0x000000000055e812 in do_command (thd=0x1d0c4cd0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #11 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x1d0c4cd0) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #12 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #13 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #14 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #15 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 25621): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d2f06 in inline_mysql_cond_timedwait ( this=, thd=, timeout=0x4787fe80) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:1009 #2 MYSQL_BIN_LOG::wait_for_update_bin_log (this=, thd=, timeout=0x4787fe80) at /root/downloads/mysql-5.5.8/sql/log.cc:5309 #3 0x000000000056fe86 in mysql_binlog_send (thd=0x1d224560, log_ident=0x2aaaab472468 "\001", pos=4, flags=0) at /root/downloads/mysql-5.5.8/sql/sql_repl.cc:844 #4 0x000000000055dd4f in dispatch_command (command=COM_BINLOG_DUMP, thd=0x1d224560, packet=0x1d1ce081 "", packet_length=) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1209 #5 0x000000000055e812 in do_command (thd=0x1d224560) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #6 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x1d224560) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #7 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #8 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #9 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #10 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 24495): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x1cbb78a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () - found 'core.25313' (5/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 25647] [New Thread 25620] [New Thread 25327] [New Thread 25326] [New Thread 25325] [New Thread 25324] [New Thread 25323] [New Thread 25321] [New Thread 25320] [New Thread 25319] [New Thread 25318] [New Thread 25317] [New Thread 25316] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=58, argv=0x6de19a8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 14 (Thread 25316): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x7264810, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x7264810, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x40e350f8, message2=0x40e350f0, type=0x40e350e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 25317): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x7264890, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x7264890, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x4273d0f8, message2=0x4273d0f0, type=0x4273d0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 25318): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x7264910, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x7264910, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x4313e0f8, message2=0x4313e0f0, type=0x4313e0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 25319): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x7264990, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x7264990, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x43b3f0f8, message2=0x43b3f0f0, type=0x43b3f0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 25320): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x7264a10, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x7264a10, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x445400f8, message2=0x445400f0, type=0x445400e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 25321): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x7264a90, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x7264a90, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x44f410f8, message2=0x44f410f0, type=0x44f410e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 25323): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x70e2a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x70e2a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 25324): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x70e29a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x70e29a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 25325): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x70e2aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x70e2aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 25326): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x6e5ceb0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x6e5ceb0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x00000000007c087a in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:3031 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 25327): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 25620): #0 0x0000003c1609a3f1 in nanosleep () from /lib64/libc.so.6 #1 0x0000003c1609a214 in sleep () from /lib64/libc.so.6 #2 0x00000000004ff965 in safe_sleep (thd=0x7397960, sec=, thread_killed=0x4ff460 , thread_killed_arg=0x733a000) at /root/downloads/mysql-5.5.8/sql/slave.cc:2091 #3 0x0000000000508dd6 in connect_to_master (thd=0x7397960, mysql=0x73afcd0, mi=0x733a000, reconnect=true, suppress_warnings=false) at /root/downloads/mysql-5.5.8/sql/slave.cc:4238 #4 0x0000000000509260 in safe_reconnect (thd=0x7397960, mysql=0x73afcd0, mi=0x733a000, retry_count=0x4824a0c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:4281 #5 try_to_reconnect (thd=0x7397960, mysql=0x73afcd0, mi=0x733a000, retry_count=0x4824a0c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:2682 #6 0x000000000050a56d in handle_slave_io (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:2937 #7 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #8 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #9 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 25647): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d729d in inline_mysql_cond_wait (this=, thd=0x739a6e0) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:980 #2 MYSQL_BIN_LOG::wait_for_update_relay_log (this=, thd=0x739a6e0) at /root/downloads/mysql-5.5.8/sql/log.cc:5279 #3 0x0000000000503bbd in next_event (thd=0x739a6e0, rli=0x733b328) at /root/downloads/mysql-5.5.8/sql/slave.cc:4664 #4 exec_relay_log_event (thd=0x739a6e0, rli=0x733b328) at /root/downloads/mysql-5.5.8/sql/slave.cc:2448 #5 0x00000000005054c1 in handle_slave_sql (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:3320 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 25313): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=58, argv=0x6de19a8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () - deleting it, already saved 5 Retrying test rpl.rpl_typeconv, attempt(2/3)... rpl.rpl_typeconv 'row' [ retry-pass ] 842905 Retrying test rpl.rpl_typeconv, attempt(3/3)... rpl.rpl_typeconv 'row' [ retry-pass ] 790872 rpl.rpl_stm_log 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_slow_query_log 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_temporary_errors 'row' [ pass ] 230 rpl.rpl_bug38694 'row' [ pass ] 121 rpl.rpl_relayspace 'row' [ pass ] 342 rpl.rpl_multi_delete2 'row' [ pass ] 179 rpl.rpl_replicate_do 'row' [ pass ] 285 rpl.rpl_filter_tables_not_exist 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_drop_temp 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_multi_update2 'row' [ pass ] 218 rpl.rpl_ignore_table_update 'row' [ pass ] 178 rpl.rpl_err_ignoredtable 'row' [ pass ] 10200 rpl.rpl_ignore_table 'row' [ pass ] 471 rpl.rpl_rewrt_db 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_multi_update4 'row' [ pass ] 182 rpl.rpl_multi_delete 'row' [ pass ] 156 rpl.rpl_ignore_grant 'row' [ pass ] 133 rpl.rpl_ignore_revoke 'row' [ pass ] 113 rpl.rpl_free_items 'row' [ pass ] 611 rpl.rpl_replicate_ignore_db 'row' [ pass ] 257 rpl.rpl_report 'row' [ pass ] 211 rpl.rpl_slave_load_tmpdir_not_exist 'row' [ pass ] 135 rpl.rpl_concurrency_error 'row' [ skipped ] Doesn't support --binlog-format='row' worker[1] Trying to dump core for [mysqltest - pid: 27598, winpid: 27598] worker[1] Trying to dump core for [mysqld.1 - pid: 27556, winpid: 27556] worker[1] Trying to dump core for [mysqld.2 - pid: 27560, winpid: 27560] rpl.rpl_innodb_bug28430 'row' [ fail ] timeout after 900 seconds Test ended at 2011-01-25 14:23:08 Test case timeout after 900 seconds == /mysql/mysql-5.5.8/mysql-test/var/log/rpl_innodb_bug28430.log == SET local_time= NOW(); SET cur_user = CURRENT_USER(); SET local_uuid=UUID(); WHILE ins_count > 0 DO INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(), ins_count,'Going to test MBR for MySQL'); SET ins_count = ins_count - 1; END WHILE; SELECT MAX(id) FROM test.byrange_tbl INTO del_count; WHILE del_count > 0 DO DELETE FROM test.byrange_tbl WHERE id = del_count; SET del_count = del_count - 2; END WHILE; END| CALL test.proc_norm(); SELECT count(*) as "Master regular" FROM test.regular_tbl; Master regular 500 CALL test.proc_bykey(); SELECT count(*) as "Master bykey" FROM test.bykey_tbl; Master bykey 500 == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock' (111) == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.2.sock' (111) - saving '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-row/' to '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-row/' - found 'core.27557' (6/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 27609] [New Thread 27604] [New Thread 27603] [New Thread 27602] [New Thread 27581] [New Thread 27580] [New Thread 27579] [New Thread 27578] [New Thread 27577] [New Thread 27569] [New Thread 27568] [New Thread 27567] [New Thread 27566] [New Thread 27565] [New Thread 27564] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.1 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x1b8cf8a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 16 (Thread 27564): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1bd527b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1bd527b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x428970f8, message2=0x428970f0, type=0x428970e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 15 (Thread 27565): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1bd52830, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1bd52830, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x432980f8, message2=0x432980f0, type=0x432980e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 14 (Thread 27566): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1bd528b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1bd528b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x43c990f8, message2=0x43c990f0, type=0x43c990e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 27567): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1bd52930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1bd52930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x4469a0f8, message2=0x4469a0f0, type=0x4469a0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 27568): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1bd529b0, reset_sig_count=172) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1bd529b0, reset_sig_count=172) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x4509b0f8, message2=0x4509b0f0, type=0x4509b0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 27569): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1bd52a30, reset_sig_count=147) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1bd52a30, reset_sig_count=147) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x45a9c0f8, message2=0x45a9c0f0, type=0x45a9c0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 27577): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1bbd0a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1bbd0a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 27578): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1bbd09a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1bbd09a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 27579): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x1bbd0aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1bbd0aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 27580): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x000000000082a131 in fil_flush_file_spaces (purpose=501) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4704 #6 0x0000000000806b59 in buf_flush_buffered_writes () at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:890 #7 0x00000000008083b7 in buf_flush_batch (buf_pool=0x1bd67158, flush_type=467039112, min_n=20, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1711 #8 0x00000000008087c0 in buf_flush_list (min_n=20, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1929 #9 0x00000000007c0a45 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2841 #10 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #11 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 27581): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 27602): #0 0x0000003c1680d91b in read () from /lib64/libpthread.so.0 #1 0x00000000004f4edb in my_real_read (net=0x1bddceb8, complen=0x41592050) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:841 #2 0x00000000004f5223 in my_net_read (net=0x23) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:1038 #3 0x000000000055e7c5 in do_command (thd=0x1bddccd0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:718 #4 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x1bddccd0) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #5 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 27603): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x00000000008587d7 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /root/downloads/mysql-5.5.8/storage/innobase/log/log0log.c:1514 #6 0x00000000007d784b in trx_commit_complete_for_mysql (trx=0x1b93e198) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1603 #7 0x000000000079b124 in innobase_commit (hton=, thd=0x1be758c0, all=false) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:2745 #8 0x000000000064e622 in ha_commit_one_phase (thd=0x1be758c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1299 #9 0x000000000064fd5f in ha_commit_trans (thd=0x1be758c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1237 #10 0x00000000005f3c82 in trans_commit_stmt (thd=0x1be758c0) at /root/downloads/mysql-5.5.8/sql/transaction.cc:272 #11 0x0000000000557bbd in mysql_execute_command (thd=0x1be758c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:4355 #12 0x000000000070ecbc in sp_instr_stmt::exec_core (this=0x1bf76460, thd=0x0, nextp=0x2) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3162 #13 0x000000000070ee24 in sp_lex_keeper::reset_lex_and_exec_core ( this=0x1bf764a0, thd=0x1be758c0, nextp=0x415d09d8, open_tables=false, instr=0x1bf76460) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2959 #14 0x0000000000714771 in sp_instr_stmt::execute (this=0x1bf76460, thd=0x1be758c0, nextp=0x415d09d8) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3094 #15 0x0000000000712f71 in sp_head::execute (this=0x1bf6f090, thd=0x1be758c0, merge_da_on_success=true) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:1420 #16 0x0000000000713745 in sp_head::execute_procedure (this=0x1bf6f090, thd=0x1be758c0, args=0x1be77d98) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2176 #17 0x0000000000557fcc in mysql_execute_command (thd=0x1be758c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:3914 #18 0x000000000055d4be in mysql_parse (thd=0x1be758c0, rawbuf=0x1be80670 "CALL test.proc_byrange()", length=, parser_state=0x415d2c70) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:5496 #19 0x000000000055e4ee in dispatch_command (command=COM_QUERY, thd=0x1be758c0, packet=, packet_length=24) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1032 #20 0x000000000055e812 in do_command (thd=0x1be758c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #21 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x1be758c0) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #22 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #23 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #24 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #25 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 27604): #0 0x0000003c1680d91b in read () from /lib64/libpthread.so.0 #1 0x00000000004f4edb in my_real_read (net=0x1be82868, complen=0x41614050) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:841 #2 0x00000000004f5223 in my_net_read (net=0x39) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:1038 #3 0x000000000055e7c5 in do_command (thd=0x1be82680) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:718 #4 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x1be82680) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #5 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 27609): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d2f06 in inline_mysql_cond_timedwait ( this=, thd=, timeout=0x41653e80) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:1009 #2 MYSQL_BIN_LOG::wait_for_update_bin_log (this=, thd=, timeout=0x41653e80) at /root/downloads/mysql-5.5.8/sql/log.cc:5309 #3 0x000000000056fe86 in mysql_binlog_send (thd=0x1beb5370, log_ident=0x2aaaab46a668 "\001", pos=4, flags=0) at /root/downloads/mysql-5.5.8/sql/sql_repl.cc:844 #4 0x000000000055dd4f in dispatch_command (command=COM_BINLOG_DUMP, thd=0x1beb5370, packet=0x1beb80f1 "", packet_length=) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1209 #5 0x000000000055e812 in do_command (thd=0x1beb5370) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #6 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x1beb5370) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #7 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #8 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #9 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #10 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 27557): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x1b8cf8a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () - deleting it, already saved 5 - found 'core.27561' (7/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 27608] [New Thread 27607] [New Thread 27586] [New Thread 27585] [New Thread 27584] [New Thread 27583] [New Thread 27575] [New Thread 27574] [New Thread 27573] [New Thread 27572] [New Thread 27571] [New Thread 27570] [New Thread 27561] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #4 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #5 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 14 (Thread 27561): #0 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #1 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #2 0x00000000004f2f31 in mysqld_main (argc=57, argv=0x187a5bd8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #3 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #4 0x00000000004eacc9 in _start () Thread 13 (Thread 27570): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x18c28830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x18c28830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x425210f8, message2=0x425210f0, type=0x425210e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 27571): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x18c288b0, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x18c288b0, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x42f220f8, message2=0x42f220f0, type=0x42f220e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 27572): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x18c28930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x18c28930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x439230f8, message2=0x439230f0, type=0x439230e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 27573): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x18c289b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x18c289b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x443240f8, message2=0x443240f0, type=0x443240e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 27574): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x18c28a30, reset_sig_count=162) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x18c28a30, reset_sig_count=162) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x44d250f8, message2=0x44d250f0, type=0x44d250e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 27575): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x18c28ab0, reset_sig_count=147) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x18c28ab0, reset_sig_count=147) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x457260f8, message2=0x457260f0, type=0x457260e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 27583): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x18aa6a40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x18aa6a40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 27584): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x18aa69c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x18aa69c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 27585): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x18aa6ac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x18aa6ac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 27586): #0 0x0000003c160cd212 in select () from /lib64/libc.so.6 #1 0x000000000086853b in os_thread_sleep (tm=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0thread.c:274 #2 0x00000000007c13b0 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2700 #3 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #4 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 27607): #0 0x0000003c1609a3f1 in nanosleep () from /lib64/libc.so.6 #1 0x0000003c1609a214 in sleep () from /lib64/libc.so.6 #2 0x00000000004ff965 in safe_sleep (thd=0x18d8b3b0, sec=, thread_killed=0x4ff460 , thread_killed_arg=0x18cfe020) at /root/downloads/mysql-5.5.8/sql/slave.cc:2091 #3 0x0000000000508dd6 in connect_to_master (thd=0x18d8b3b0, mysql=0x18d40f50, mi=0x18cfe020, reconnect=true, suppress_warnings=false) at /root/downloads/mysql-5.5.8/sql/slave.cc:4238 #4 0x0000000000509260 in safe_reconnect (thd=0x18d8b3b0, mysql=0x18d40f50, mi=0x18cfe020, retry_count=0x418b40c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:4281 #5 try_to_reconnect (thd=0x18d8b3b0, mysql=0x18d40f50, mi=0x18cfe020, retry_count=0x418b40c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:2682 #6 0x000000000050a56d in handle_slave_io (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:2937 #7 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #8 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #9 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 27608): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func ( space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x00000000008587d7 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /root/downloads/mysql-5.5.8/storage/innobase/log/log0log.c:1514 #6 0x00000000007da9bc in trx_prepare_off_kernel (trx=0x18d5f6c8) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1889 #7 0x00000000007daa88 in trx_prepare_for_mysql (trx=0x18d5f6c8) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1925 #8 0x000000000079b972 in innobase_xa_prepare (hton=, thd=0x18d92140, all=true) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:10082 #9 0x000000000064ff34 in ha_commit_trans (thd=0x18d92140, all=) at /root/downloads/mysql-5.5.8/sql/handler.cc:1220 #10 0x00000000005f3b64 in trans_commit (thd=0x18d92140) at /root/downloads/mysql-5.5.8/sql/transaction.cc:154 #11 0x00000000006e2860 in Xid_log_event::do_apply_event (this=0x2aaab0020fc0, rli=) at /root/downloads/mysql-5.5.8/sql/log_event.cc:5565 #12 0x00000000005014cd in apply_event (ev=0x2aaab0020fc0, thd=, rli=0x18cff348) at /root/downloads/mysql-5.5.8/sql/log_event.h:1131 #13 apply_event_and_update_pos (ev=0x2aaab0020fc0, thd=, rli=0x18cff348) at /root/downloads/mysql-5.5.8/sql/slave.cc:2342 #14 0x0000000000503df9 in exec_relay_log_event (thd=0x18d92140, rli=0x18cff348) at /root/downloads/mysql-5.5.8/sql/slave.cc:2502 #15 0x00000000005054c1 in handle_slave_sql (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:3320 #16 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #17 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #18 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 27587): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #4 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #5 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 - deleting it, already saved 5 Retrying test rpl.rpl_innodb_bug28430, attempt(2/3)... worker[1] Trying to dump core for [mysqltest - pid: 27807, winpid: 27807] worker[1] Trying to dump core for [mysqld.1 - pid: 27765, winpid: 27765] worker[1] Trying to dump core for [mysqld.2 - pid: 27769, winpid: 27769] rpl.rpl_innodb_bug28430 'row' [ retry-fail ] timeout after 900 seconds Test ended at 2011-01-25 14:39:10 Test case timeout after 900 seconds == /mysql/mysql-5.5.8/mysql-test/var/log/rpl_innodb_bug28430.log == SET local_time= NOW(); SET cur_user = CURRENT_USER(); SET local_uuid=UUID(); WHILE ins_count > 0 DO INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(), ins_count,'Going to test MBR for MySQL'); SET ins_count = ins_count - 1; END WHILE; SELECT MAX(id) FROM test.byrange_tbl INTO del_count; WHILE del_count > 0 DO DELETE FROM test.byrange_tbl WHERE id = del_count; SET del_count = del_count - 2; END WHILE; END| CALL test.proc_norm(); SELECT count(*) as "Master regular" FROM test.regular_tbl; Master regular 500 CALL test.proc_bykey(); SELECT count(*) as "Master bykey" FROM test.bykey_tbl; Master bykey 500 == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock' (111) == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.2.sock' (111) - saving '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-row/' to '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-row/' Test rpl.rpl_innodb_bug28430 has failed 2 times, no more retries! rpl.rpl_dual_pos_advance 'row' [ pass ] 2850 rpl.rpl_auto_increment_update_failure 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_binlog_grant 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_commit_after_flush 'row' [ pass ] 235 rpl.rpl_ddl 'row' [ skipped ] This test needs on slave side: InnoDB disabled, default engine: MyISAM rpl.rpl_extraCol_innodb 'row' [ pass ] 31231 rpl.rpl_extraColmaster_innodb 'row' [ pass ] 1976 rpl.rpl_foreign_key_innodb 'row' [ pass ] 237 rpl.rpl_innodb_bug30888 'row' [ pass ] 668210 rpl.rpl_innodb_mixed_ddl 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_innodb_mixed_dml 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_insert_id 'row' [ pass ] 51353 rpl.rpl_insert_id_pk 'row' [ pass ] 34420 rpl.rpl_insert_ignore 'row' [ pass ] 24253 rpl.rpl_loaddata 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_mixed_binlog_max_cache_size 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_mixed_drop_create_temp_table 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_mixed_implicit_commit_binlog 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_mixed_mixing_engines 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_multi_engine 'row' [ pass ] 31336 rpl.rpl_non_direct_mixed_mixing_engines 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_non_direct_row_mixing_engines 'row' [ pass ] 335944 rpl.rpl_non_direct_stm_mixing_engines 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_not_null_innodb 'row' [ pass ] 62583 rpl.rpl_relay_space_innodb 'row' [ pass ] 18850 rpl.rpl_row_basic_3innodb 'row' [ pass ] 145475 rpl.rpl_row_binlog_max_cache_size 'row' [ pass ] 72949 rpl.rpl_row_blob_innodb 'row' [ pass ] 20983 rpl.rpl_row_drop_create_temp_table 'row' [ pass ] 596597 rpl.rpl_row_func003 'row' [ pass ] 13468 rpl.rpl_row_idempotency 'row' [ pass ] 40756 rpl.rpl_row_implicit_commit_binlog 'row' [ pass ] 74046 rpl.rpl_row_loaddata_concurrent 'row' [ pass ] 53645 rpl.rpl_row_mixing_engines 'row' [ pass ] 451979 rpl.rpl_row_rec_comp_innodb 'row' [ pass ] 37741 rpl.rpl_row_sp002_innodb 'row' [ pass ] 43541 rpl.rpl_row_sp003 'row' [ pass ] 25706 rpl.rpl_row_sp006_InnoDB 'row' [ pass ] 15073 rpl.rpl_row_sp007_innodb 'row' [ pass ] 16291 rpl.rpl_row_tabledefs_3innodb 'row' [ pass ] 55984 rpl.rpl_row_tbl_metadata 'row' [ pass ] 85031 rpl.rpl_row_trig004 'row' [ pass ] 15659 rpl.rpl_savepoint 'row' [ pass ] 19802 rpl.rpl_set_null_innodb 'row' [ pass ] 29746 rpl.rpl_slave_grp_exec 'row' [ pass ] 32341 rpl.rpl_slave_load_in 'row' [ pass ] 14025 rpl.rpl_slave_skip 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_binlog_max_cache_size 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_drop_create_temp_table 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_implicit_commit_binlog 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_innodb 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_loaddata_concurrent 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_mixing_engines 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_stm_start_stop_slave 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_temp_table_mix_row 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_trigger 'row' [ skipped ] Doesn't support --binlog-format='row' rpl.rpl_truncate_3innodb 'row' [ pass ] 32003 rpl.rpl_typeconv_innodb 'row' [ pass ] 14635 rpl.rpl_deadlock_innodb 'row' [ pass ] 64340 rpl.rpl_relayrotate 'row' [ pass ] 8244 rpl.rpl_skip_error 'row' [ pass ] 302 rpl.rpl_begin_commit_rollback 'stmt' [ pass ] 540 rpl.rpl_loaddata_m 'stmt' [ pass ] 262 rpl.rpl_row_basic_11bugs 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_timezone 'stmt' [ pass ] 315 rpl.rpl_flush_logs 'stmt' [ pass ] 274 rpl.rpl_sp 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_sp_effects 'stmt' [ pass ] 354 rpl.rpl_sporadic_master 'stmt' [ pass ] 339 rpl.rpl_row_mysqlbinlog 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_packet 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_loaddata_map 'stmt' [ pass ] 2561 rpl.rpl_flushlog_loop 'stmt' [ pass ] 486 rpl.rpl_binlog_auto_inc_bug33029 'stmt' [ pass ] 81 rpl.rpl_cross_version 'stmt' [ pass ] 156 rpl.rpl_binlog_query_filter_rules 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_loaddata_symlink 'stmt' [ pass ] 267 rpl.rpl_row_log_innodb 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_log 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_invoked_features 'stmt' [ pass ] 1074 rpl.rpl_loaddata_s 'stmt' [ pass ] 159 rpl.rpl_heartbeat 'stmt' [ pass ] 15248 rpl.rpl000011 'stmt' [ pass ] 6400 rpl.rpl000013 'stmt' [ pass ] 6615 rpl.rpl000017 'stmt' [ pass ] 3837 rpl.rpl_EE_err 'stmt' [ pass ] 146 rpl.rpl_LD_INFILE 'stmt' [ pass ] 158 rpl.rpl_alter 'stmt' [ pass ] 187 rpl.rpl_alter_db 'stmt' [ pass ] 119 rpl.rpl_auto_increment_11932 'stmt' [ pass ] 244 rpl.rpl_bit 'stmt' [ pass ] 150 rpl.rpl_bit_npk 'stmt' [ pass ] 281 rpl.rpl_blackhole 'stmt' [ skipped ] Need blackhole engine rpl.rpl_bug31076 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_change_master 'stmt' [ pass ] 563 rpl.rpl_charset 'stmt' [ pass ] 1470 rpl.rpl_charset_sjis 'stmt' [ pass ] 222 rpl.rpl_colSize 'stmt' [ pass ] 487 rpl.rpl_conditional_comments 'stmt' [ pass ] 452 rpl.rpl_create_if_not_exists 'stmt' [ pass ] 4776 rpl.rpl_create_tmp_table_if_not_exists 'stmt' [ pass ] 224 rpl.rpl_critical_errors 'stmt' [ pass ] 2 rpl.rpl_delete_no_where 'stmt' [ pass ] 198 rpl.rpl_do_grant 'stmt' [ pass ] 3001 rpl.rpl_drop 'stmt' [ pass ] 5814 rpl.rpl_drop_db 'stmt' [ pass ] 58456 rpl.rpl_drop_if_exists 'stmt' [ pass ] 2601 rpl.rpl_drop_view 'stmt' [ pass ] 9083 rpl.rpl_empty_master_host 'stmt' [ pass ] 8738 rpl.rpl_events 'stmt' [ pass ] 12626 rpl.rpl_extraCol_myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_extraColmaster_myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_geometry 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_get_lock 'stmt' [ pass ] 8790 rpl.rpl_grant 'stmt' [ pass ] 5685 rpl.rpl_heartbeat_ssl 'stmt' [ skipped ] Test requires: 'have_ssl' rpl.rpl_idempotency 'stmt' [ pass ] 7480 rpl.rpl_insert 'stmt' [ pass ] 12017 rpl.rpl_insert_select 'stmt' [ pass ] 8112 rpl.rpl_loaddata_charset 'stmt' [ pass ] 16079 rpl.rpl_loaddata_simple 'stmt' [ pass ] 6342 rpl.rpl_loaddatalocal 'stmt' [ pass ] 8891 rpl.rpl_loadfile 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_locale 'stmt' [ pass ] 154 rpl.rpl_manual_change_index_file 'stmt' [ pass ] 990 rpl.rpl_many_optimize 'stmt' [ pass ] 1958 rpl.rpl_master_pos_wait 'stmt' [ pass ] 2217 rpl.rpl_misc_functions 'stmt' [ pass ] 214 rpl.rpl_mix_found_rows 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_mix_insert_delayed 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_mixed_bit_pk 'stmt' [ pass ] 293 rpl.rpl_mixed_ddl_dml 'stmt' [ pass ] 373 rpl.rpl_multi_update 'stmt' [ pass ] 167 rpl.rpl_multi_update3 'stmt' [ pass ] 1103 rpl.rpl_mysql_upgrade 'stmt' [ pass ] 2442 rpl.rpl_name_const 'stmt' [ pass ] 201 rpl.rpl_nondeterministic_functions 'stmt' [ pass ] 257 rpl.rpl_not_null_myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_optimize 'stmt' [ pass ] 11854 rpl.rpl_ps 'stmt' [ pass ] 260 rpl.rpl_rbr_to_sbr 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_relay_space_myisam 'stmt' [ pass ] 145 rpl.rpl_row_001 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_NOW 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_USER 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_UUID 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_basic_2myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_basic_8partition 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_blob_myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_colSize 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_conflicts 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_delayed_ins 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_drop 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_find_row 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_flsh_tbls 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_func001 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_func002 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_inexist_tbl 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_insert_delayed 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_max_relay_size 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_rec_comp_myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_reset_slave 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_show_relaylog_events 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_sp001 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_sp005 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_sp008 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_sp009 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_sp010 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_sp011 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_sp012 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_tabledefs_2myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_trig001 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_trig002 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_trig003 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_trunc_temp 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_unsafe_funcs 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_until 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_utf16 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_utf32 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_view01 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_row_wide_table 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_server_id 'stmt' [ pass ] 48 rpl.rpl_server_id1 'stmt' [ pass ] 251 rpl.rpl_session_var 'stmt' [ pass ] 327 rpl.rpl_set_charset 'stmt' [ pass ] 234 rpl.rpl_set_null_myisam 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_sf 'stmt' [ pass ] 23 rpl.rpl_slave_status 'stmt' [ pass ] 9339 rpl.rpl_sp004 'stmt' [ pass ] 1204 rpl.rpl_ssl 'stmt' [ skipped ] Test requires: 'have_ssl' rpl.rpl_ssl1 'stmt' [ skipped ] Test requires: 'have_ssl' rpl.rpl_stm_000001 'stmt' [ pass ] 13739 rpl.rpl_stm_EE_err2 'stmt' [ pass ] 307 rpl.rpl_stm_auto_increment_bug33029 'stmt' [ pass ] 388 rpl.rpl_stm_conflicts 'stmt' [ pass ] 259 rpl.rpl_stm_flsh_tbls 'stmt' [ pass ] 421 rpl.rpl_stm_found_rows 'stmt' [ pass ] 482 rpl.rpl_stm_insert_delayed 'stmt' [ pass ] 4759 rpl.rpl_stm_loadfile 'stmt' [ pass ] 166 rpl.rpl_stm_max_relay_size 'stmt' [ pass ] 104962 rpl.rpl_stm_mix_show_relaylog_events 'stmt' [ pass ] 9700 rpl.rpl_stm_multi_query 'stmt' [ pass ] 7326 rpl.rpl_stm_no_op 'stmt' [ pass ] 10993 rpl.rpl_stm_reset_slave 'stmt' [ pass ] 22501 rpl.rpl_stm_sql_mode 'stmt' [ pass ] 5928 rpl.rpl_stm_until 'stmt' [ pass ] 32529 rpl.rpl_stm_user_variables 'stmt' [ pass ] 18684 rpl.rpl_switch_stm_row_mixed 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_temp_table 'stmt' [ pass ] 10779 rpl.rpl_temporary 'stmt' [ pass ] 24252 rpl.rpl_tmp_table_and_DDL 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_trunc_temp 'stmt' [ pass ] 6771 rpl.rpl_truncate_2myisam 'stmt' [ pass ] 24392 rpl.rpl_user 'stmt' [ pass ] 5526 rpl.rpl_user_variables 'stmt' [ pass ] 25684 rpl.rpl_variables 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_variables_stm 'stmt' [ pass ] 16587 rpl.rpl_view 'stmt' [ pass ] 20526 rpl.rpl_view_multi 'stmt' [ pass ] 11994 rpl.rpl_server_id2 'stmt' [ pass ] 13712 rpl.rpl_server_id_ignore 'stmt' [ pass ] 16177 rpl.rpl000010 'stmt' [ pass ] 223 rpl.rpl_init_slave 'stmt' [ pass ] 277 rpl.rpl_typeconv 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_stm_log 'stmt' [ pass ] 614 rpl.rpl_slow_query_log 'stmt' [ pass ] 27901 rpl.rpl_temporary_errors 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_bug38694 'stmt' [ pass ] 190 rpl.rpl_relayspace 'stmt' [ pass ] 10211 rpl.rpl_multi_delete2 'stmt' [ pass ] 8655 rpl.rpl_replicate_do 'stmt' [ pass ] 15457 rpl.rpl_filter_tables_not_exist 'stmt' [ pass ] 13494 rpl.rpl_drop_temp 'stmt' [ pass ] 751 rpl.rpl_multi_update2 'stmt' [ pass ] 210 rpl.rpl_ignore_table_update 'stmt' [ pass ] 175 rpl.rpl_err_ignoredtable 'stmt' [ pass ] 10229 rpl.rpl_ignore_table 'stmt' [ pass ] 281 rpl.rpl_rewrt_db 'stmt' [ pass ] 360 rpl.rpl_multi_update4 'stmt' [ pass ] 181 rpl.rpl_multi_delete 'stmt' [ pass ] 160 rpl.rpl_ignore_grant 'stmt' [ pass ] 214 rpl.rpl_ignore_revoke 'stmt' [ pass ] 200 rpl.rpl_free_items 'stmt' [ pass ] 600 rpl.rpl_replicate_ignore_db 'stmt' [ pass ] 158 rpl.rpl_report 'stmt' [ pass ] 136 rpl.rpl_slave_load_tmpdir_not_exist 'stmt' [ pass ] 39 rpl.rpl_concurrency_error 'stmt' [ pass ] 8924 rpl.rpl_innodb_bug28430 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_dual_pos_advance 'stmt' [ pass ] 823 rpl.rpl_auto_increment_update_failure 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_binlog_grant 'stmt' [ pass ] 393 rpl.rpl_commit_after_flush 'stmt' [ pass ] 145 rpl.rpl_ddl 'stmt' [ skipped ] This test needs on slave side: InnoDB disabled, default engine: MyISAM rpl.rpl_extraCol_innodb 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_extraColmaster_innodb 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_foreign_key_innodb 'stmt' [ pass ] 1723 rpl.rpl_innodb_bug30888 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_innodb_mixed_ddl 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_innodb_mixed_dml 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_insert_id 'stmt' [ pass ] 1160 rpl.rpl_insert_id_pk 'stmt' [ pass ] 366 rpl.rpl_insert_ignore 'stmt' [ pass ] 223 rpl.rpl_loaddata 'stmt' [ pass ] 5583 rpl.rpl_mixed_binlog_max_cache_size 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_mixed_drop_create_temp_table 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_mixed_implicit_commit_binlog 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_mixed_mixing_engines 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_multi_engine 'stmt' [ pass ] 429 rpl.rpl_non_direct_mixed_mixing_engines 'stmt' [ skipped ] Doesn't support --binlog-format='statement' rpl.rpl_non_direct_row_mixing_engines 'stmt' [ skipped ] Doesn't support --binlog-format='statement' The servers were restarted 149 times Spent 11849.152 of 18057 seconds executing testcases Check of testcase failed for: rpl.rpl_stm_innodb Timeout: Failed 3/475 tests, 99.37% were successful. Failing test(s): rpl.rpl_innodb_bug28430 rpl.rpl_typeconv 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://dev.mysql.com/doc/mysql/en/mysql-test-suite.html 308 tests were skipped, 25 by the test itself. Test suite timeout! Terminating... mysql-test-run: *** ERROR: Test suite aborted