Logging: ./mtr --reorder --report-features --comment=Trying reorder, report-features --mem --suite innodb --debug-server --no-warnings --force --max-test-fail=100 MySQL Version 5.6.20 ############################################################################## # Trying reorder, report-features ############################################################################## Checking supported features... - SSL connections supported - binaries are debug compiled Using suites: innodb Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/egge/aug/codership-mysql/mysql-test/var'... - symlinking 'var' to '/dev/shm/var_auto_nwjP' Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 ===== ENGINES ===== Engine Support Comment Transactions XA Savepoints MRG_MYISAM YES Collection of identical MyISAM tables NO NO NO MyISAM YES MyISAM storage engine NO NO NO BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO CSV YES CSV storage engine NO NO NO InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES ARCHIVE YES Archive storage engine NO NO NO PERFORMANCE_SCHEMA YES Performance Schema NO NO NO FEDERATED NO Federated MySQL storage engine NULL NULL NULL MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO ===== VARIABLES ===== Variable_name Value auto_increment_increment 1 auto_increment_offset 1 autocommit ON automatic_sp_privileges ON back_log 80 basedir /home/egge/aug/codership-mysql big_tables OFF bind_address * binlog_cache_size 32768 binlog_checksum CRC32 binlog_direct_non_transactional_updates ON binlog_format STATEMENT binlog_max_flush_queue_time 0 binlog_order_commits ON binlog_row_image FULL binlog_rows_query_log_events OFF binlog_stmt_cache_size 32768 binlogging_impossible_mode IGNORE_ERROR block_encryption_mode aes-128-ecb bulk_insert_buffer_size 8388608 character_set_client latin1 character_set_connection latin1 character_set_database latin1 character_set_filesystem binary character_set_results latin1 character_set_server latin1 character_set_system utf8 character_sets_dir /home/egge/aug/codership-mysql/sql/share/charsets/ collation_connection latin1_swedish_ci collation_database latin1_swedish_ci collation_server latin1_swedish_ci completion_type NO_CHAIN concurrent_insert AUTO connect_timeout 60 core_file ON datadir /home/egge/aug/codership-mysql/mysql-test/var/mysqld.1/data/ date_format %Y-%m-%d datetime_format %Y-%m-%d %H:%i:%s debug debug_sync ON - signals: '' default_storage_engine InnoDB default_tmp_storage_engine InnoDB default_week_format 0 delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 disconnect_on_expired_password ON div_precision_increment 4 end_markers_in_json OFF enforce_gtid_consistency OFF eq_range_index_dive_limit 10 error_count 0 event_scheduler OFF expire_logs_days 0 explicit_defaults_for_timestamp OFF external_user flush OFF flush_time 0 foreign_key_checks ON ft_boolean_syntax + -><()~*:""&| ft_max_word_len 84 ft_min_word_len 4 ft_query_expansion_limit 20 ft_stopword_file (built-in) general_log ON general_log_file /home/egge/aug/codership-mysql/mysql-test/var/mysqld.1/mysqld.log group_concat_max_len 1024 gtid_executed gtid_mode OFF gtid_next AUTOMATIC gtid_owned gtid_purged have_compress YES have_crypt YES have_dynamic_loading YES have_geometry YES have_openssl YES have_profiling YES have_query_cache YES have_rtree_keys YES have_ssl YES have_symlink YES host_cache_size 279 hostname host-91-221-67-96 identity 0 ignore_builtin_innodb OFF ignore_db_dirs init_connect init_file init_slave innodb_adaptive_flushing ON innodb_adaptive_flushing_lwm 10 innodb_adaptive_hash_index ON innodb_adaptive_max_sleep_delay 150000 innodb_additional_mem_pool_size 1048576 innodb_api_bk_commit_interval 5 innodb_api_disable_rowlock OFF innodb_api_enable_binlog OFF innodb_api_enable_mdl OFF innodb_api_trx_level 0 innodb_autoextend_increment 64 innodb_autoinc_lock_mode 1 innodb_buf_flush_list_now OFF innodb_buffer_pool_dump_at_shutdown OFF innodb_buffer_pool_dump_now OFF innodb_buffer_pool_evict innodb_buffer_pool_filename ib_buffer_pool innodb_buffer_pool_instances 8 innodb_buffer_pool_load_abort OFF innodb_buffer_pool_load_at_startup OFF innodb_buffer_pool_load_now OFF innodb_buffer_pool_size 8388608 innodb_change_buffer_max_size 25 innodb_change_buffering all innodb_change_buffering_debug 0 innodb_checksum_algorithm innodb innodb_checksums ON innodb_cmp_per_index_enabled OFF innodb_commit_concurrency 0 innodb_compression_failure_threshold_pct 5 innodb_compression_level 6 innodb_compression_pad_pct_max 50 innodb_concurrency_tickets 5000 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir innodb_disable_background_merge OFF innodb_disable_sort_file_cache OFF innodb_disallow_writes OFF innodb_doublewrite ON innodb_doublewrite_batch_size 120 innodb_fast_shutdown 1 innodb_fil_make_page_dirty_debug 0 innodb_file_format Antelope innodb_file_format_check ON innodb_file_format_max Antelope innodb_file_per_table ON innodb_flush_log_at_timeout 1 innodb_flush_log_at_trx_commit 1 innodb_flush_method innodb_flush_neighbors 1 innodb_flushing_avg_loops 30 innodb_force_load_corrupted OFF innodb_force_recovery 0 innodb_force_recovery_crash 0 innodb_ft_aux_table innodb_ft_cache_size 8000000 innodb_ft_enable_diag_print OFF innodb_ft_enable_stopword ON innodb_ft_max_token_size 84 innodb_ft_min_token_size 3 innodb_ft_num_word_optimize 2000 innodb_ft_result_cache_limit 2000000000 innodb_ft_server_stopword_table innodb_ft_sort_pll_degree 2 innodb_ft_total_cache_size 640000000 innodb_ft_user_stopword_table innodb_io_capacity 200 innodb_io_capacity_max 2000 innodb_large_prefix OFF innodb_limit_optimistic_insert_debug 0 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 1048576 innodb_log_checkpoint_now OFF innodb_log_compressed_pages ON innodb_log_file_size 5242880 innodb_log_files_in_group 2 innodb_log_group_home_dir ./ innodb_lru_scan_depth 100 innodb_max_dirty_pages_pct 75 innodb_max_dirty_pages_pct_lwm 0 innodb_max_purge_lag 0 innodb_max_purge_lag_delay 0 innodb_mirrored_log_groups 1 innodb_monitor_disable innodb_monitor_enable innodb_monitor_reset innodb_monitor_reset_all innodb_old_blocks_pct 37 innodb_old_blocks_time 1000 innodb_online_alter_log_max_size 134217728 innodb_open_files 431 innodb_optimize_fulltext_only OFF innodb_page_hash_locks 16 innodb_page_size 16384 innodb_print_all_deadlocks OFF innodb_purge_batch_size 300 innodb_purge_run_now OFF innodb_purge_stop_now OFF innodb_purge_threads 1 innodb_random_read_ahead OFF innodb_read_ahead_threshold 56 innodb_read_io_threads 2 innodb_read_only OFF innodb_replication_delay 0 innodb_rollback_on_timeout OFF innodb_rollback_segments 128 innodb_saved_page_number_debug 0 innodb_sort_buffer_size 1048576 innodb_spin_wait_delay 6 innodb_stats_auto_recalc ON innodb_stats_method nulls_equal innodb_stats_on_metadata OFF innodb_stats_persistent ON innodb_stats_persistent_sample_pages 20 innodb_stats_sample_pages 8 innodb_stats_transient_sample_pages 8 innodb_status_output OFF innodb_status_output_locks OFF innodb_strict_mode OFF innodb_support_xa ON innodb_sync_array_size 1 innodb_sync_spin_loops 30 innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_trx_purge_view_update_only_debug OFF innodb_trx_rseg_n_slots_debug 0 innodb_undo_directory . innodb_undo_logs 128 innodb_undo_tablespaces 0 innodb_use_native_aio OFF innodb_use_sys_malloc ON innodb_version 5.6.20 innodb_write_io_threads 2 insert_id 0 interactive_timeout 28800 join_buffer_size 262144 keep_files_on_create OFF key_buffer_size 1048576 key_cache_age_threshold 300 key_cache_block_size 1024 key_cache_division_limit 100 large_files_support ON large_page_size 0 large_pages OFF last_insert_id 0 lc_messages en_US lc_messages_dir /home/egge/aug/codership-mysql/sql/share/ lc_time_names en_US license GPL local_infile ON lock_wait_timeout 31536000 locked_in_memory OFF log_bin ON log_bin_basename /home/egge/aug/codership-mysql/mysql-test/var/mysqld.1/data/master-bin log_bin_index /home/egge/aug/codership-mysql/mysql-test/var/mysqld.1/data/master-bin.index log_bin_trust_function_creators ON log_bin_use_v1_row_events OFF log_error log_output FILE log_queries_not_using_indexes OFF log_slave_updates OFF log_slow_admin_statements OFF log_slow_slave_statements OFF log_throttle_queries_not_using_indexes 0 log_warnings 1 long_query_time 10.000000 low_priority_updates OFF lower_case_file_system OFF lower_case_table_names 0 master_info_repository FILE master_verify_checksum OFF max_allowed_packet 4194304 max_binlog_cache_size 18446744073709547520 max_binlog_size 1073741824 max_binlog_stmt_cache_size 18446744073709547520 max_connect_errors 100 max_connections 151 max_delayed_threads 20 max_error_count 64 max_heap_table_size 1048576 max_insert_delayed_threads 20 max_join_size 18446744073709551615 max_length_for_sort_data 1024 max_prepared_stmt_count 16382 max_relay_log_size 0 max_seeks_for_key 18446744073709551615 max_sort_length 1024 max_sp_recursion_depth 0 max_tmp_tables 32 max_user_connections 0 max_write_lock_count 18446744073709551615 metadata_locks_cache_size 1024 metadata_locks_hash_instances 8 min_examined_row_limit 0 multi_range_count 256 myisam_data_pointer_size 6 myisam_max_sort_file_size 9223372036853727232 myisam_mmap_size 18446744073709551615 myisam_recover_options OFF myisam_repair_threads 1 myisam_sort_buffer_size 8388608 myisam_stats_method nulls_unequal myisam_use_mmap OFF net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 new OFF old OFF old_alter_table OFF old_passwords 0 open_files_limit 1024 optimizer_prune_level 1 optimizer_search_depth 62 optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on optimizer_trace enabled=off,one_line=off optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on optimizer_trace_limit 1 optimizer_trace_max_mem_size 16384 optimizer_trace_offset -1 performance_schema ON performance_schema_accounts_size 100 performance_schema_digests_size 200 performance_schema_events_stages_history_long_size 1000 performance_schema_events_stages_history_size 10 performance_schema_events_statements_history_long_size 1000 performance_schema_events_statements_history_size 10 performance_schema_events_waits_history_long_size 10000 performance_schema_events_waits_history_size 10 performance_schema_hosts_size 100 performance_schema_max_cond_classes 80 performance_schema_max_cond_instances 1000 performance_schema_max_file_classes 50 performance_schema_max_file_handles 32768 performance_schema_max_file_instances 10000 performance_schema_max_mutex_classes 200 performance_schema_max_mutex_instances 5000 performance_schema_max_rwlock_classes 40 performance_schema_max_rwlock_instances 5000 performance_schema_max_socket_classes 10 performance_schema_max_socket_instances 1000 performance_schema_max_stage_classes 150 performance_schema_max_statement_classes 168 performance_schema_max_table_handles 1000 performance_schema_max_table_instances 500 performance_schema_max_thread_classes 50 performance_schema_max_thread_instances 200 performance_schema_session_connect_attrs_size 2048 performance_schema_setup_actors_size 100 performance_schema_setup_objects_size 100 performance_schema_users_size 100 pid_file /home/egge/aug/codership-mysql/mysql-test/var/run/mysqld.1.pid plugin_dir /home/egge/aug/codership-mysql/lib/plugin/ port 13000 preload_buffer_size 32768 profiling OFF profiling_history_size 15 protocol_version 10 proxy_user pseudo_slave_mode OFF pseudo_thread_id 2 query_alloc_block_size 8192 query_cache_limit 1048576 query_cache_min_res_unit 4096 query_cache_size 1048576 query_cache_type OFF query_cache_wlock_invalidate OFF query_prealloc_size 8192 rand_seed1 0 rand_seed2 0 range_alloc_block_size 4096 read_buffer_size 131072 read_only OFF read_rnd_buffer_size 262144 relay_log relay_log_basename relay_log_index relay_log_info_file relay-log.info relay_log_info_repository FILE relay_log_purge ON relay_log_recovery OFF relay_log_space_limit 0 report_host report_password report_port 13000 report_user rpl_stop_slave_timeout 31536000 secure_auth ON secure_file_priv /run/shm/var_auto_nwjP/ server_id 1 server_id_bits 32 server_uuid e6995e89-243d-11e4-b484-f4ce46b289ce skip_external_locking ON skip_name_resolve OFF skip_networking OFF skip_show_database OFF slave_allow_batching OFF slave_checkpoint_group 512 slave_checkpoint_period 300 slave_compressed_protocol OFF slave_exec_mode STRICT slave_load_tmpdir /home/egge/aug/codership-mysql/mysql-test/var/tmp/mysqld.1 slave_max_allowed_packet 1073741824 slave_net_timeout 120 slave_parallel_workers 0 slave_pending_jobs_size_max 16777216 slave_rows_search_algorithms TABLE_SCAN,INDEX_SCAN slave_skip_errors OFF slave_sql_verify_checksum ON slave_transaction_retries 10 slave_type_conversions slow_launch_time 2 slow_query_log ON slow_query_log_file /home/egge/aug/codership-mysql/mysql-test/var/mysqld.1/mysqld-slow.log socket /home/egge/aug/codership-mysql/mysql-test/var/tmp/mysqld.1.sock sort_buffer_size 262144 sql_auto_is_null OFF sql_big_selects ON sql_buffer_result OFF sql_log_bin ON sql_log_off OFF sql_mode NO_ENGINE_SUBSTITUTION sql_notes ON sql_quote_show_create ON sql_safe_updates OFF sql_select_limit 18446744073709551615 sql_slave_skip_counter 0 sql_warnings OFF ssl_ca /home/egge/aug/codership-mysql/mysql-test/std_data/cacert.pem ssl_capath ssl_cert /home/egge/aug/codership-mysql/mysql-test/std_data/server-cert.pem ssl_cipher ssl_crl ssl_crlpath ssl_key /home/egge/aug/codership-mysql/mysql-test/std_data/server-key.pem storage_engine InnoDB stored_program_cache 256 sync_binlog 0 sync_frm ON sync_master_info 10000 sync_relay_log 10000 sync_relay_log_info 10000 system_time_zone GMT table_definition_cache 615 table_open_cache 431 table_open_cache_instances 1 thread_cache_size 9 thread_concurrency 10 thread_handling one-thread-per-connection thread_stack 262144 time_format %H:%i:%s time_zone SYSTEM timed_mutexes OFF timestamp 1408080901.006855 tmp_table_size 16777216 tmpdir /home/egge/aug/codership-mysql/mysql-test/var/tmp/mysqld.1 transaction_alloc_block_size 8192 transaction_allow_batching OFF transaction_prealloc_size 4096 tx_isolation REPEATABLE-READ tx_read_only OFF unique_checks ON updatable_views_with_limit YES version 5.6.20-debug-log version_comment Source distribution, wsrep_25.6.r4121 version_compile_machine x86_64 version_compile_os Linux wait_timeout 28800 warning_count 0 wsrep_OSU_method TOI wsrep_auto_increment_control ON wsrep_causal_reads OFF wsrep_certify_nonPK ON wsrep_cluster_address wsrep_cluster_name my_wsrep_cluster wsrep_convert_LOCK_to_trx OFF wsrep_data_home_dir wsrep_dbug_option wsrep_debug OFF wsrep_desync OFF wsrep_drupal_282555_workaround OFF wsrep_forced_binlog_format NONE wsrep_load_data_splitting ON wsrep_log_conflicts OFF wsrep_max_ws_rows 131072 wsrep_max_ws_size 1073741824 wsrep_mysql_replication_bundle 0 wsrep_node_address wsrep_node_incoming_address AUTO wsrep_node_name host-91-221-67-96 wsrep_notify_cmd wsrep_on OFF wsrep_preordered OFF wsrep_provider none wsrep_provider_options wsrep_recover OFF wsrep_replicate_myisam OFF wsrep_restart_slave OFF wsrep_retry_autocommit 1 wsrep_slave_FK_checks ON wsrep_slave_UK_checks OFF wsrep_slave_threads 1 wsrep_sst_auth wsrep_sst_donor wsrep_sst_donor_rejects_queries OFF wsrep_sst_method rsync wsrep_sst_receive_address AUTO wsrep_start_position 00000000-0000-0000-0000-000000000000:-1 ===== STOP ===== report_features [ pass ] 11 innodb.innodb-status-output [ skipped ] Test needs 'big-test' option innodb.innodb-wl5522-debug [ skipped ] Test needs 'big-test' option innodb.innodb_bug11766634 [ skipped ] Test needs 'big-test' option innodb.innodb_bug14704286 [ skipped ] Test needs 'big-test' option innodb.innodb_bug52663 [ skipped ] Test needs 'big-test' option innodb.innodb_mysql [ skipped ] Test needs 'big-test' option innodb.innodb_bug53674 [ pass ] 42 innodb.innodb [ pass ] 10092 innodb.innodb_misc1 [ pass ] 6154 innodb.innodb_ctype_ldml [ pass ] 583 innodb.innodb-2byte-collation [ pass ] 1889 innodb.innodb-bug12552164 [ pass ] 5052 innodb.innodb-wl5980-linux [ pass ] 3213 innodb.innodb-wl5980-windows [ skipped ] Need windows innodb.innodb_bug12661768 [ pass ] 62 innodb.innodb_i_s_innodb_trx [ pass ] 281 innodb.innodb-autoinc-44030 [ pass ] 3578 innodb.innodb-autoinc [ fail ] Test ended at 2014-08-15 08:36:07 CURRENT_TEST: innodb.innodb-autoinc --- /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-autoinc.result 2014-08-05 14:51:52.924766000 +0300 +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-autoinc.reject 2014-08-15 08:36:06.978754553 +0300 @@ -1276,6 +1276,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 256 +wsrep_auto_increment_control ON CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, NULL); SHOW CREATE TABLE t1; @@ -1294,6 +1295,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 +wsrep_auto_increment_control ON CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (2147483648, 'a'); SHOW CREATE TABLE t1; mysqltest: Result content mismatch - saving '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-autoinc/' to '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-autoinc/' Retrying test innodb.innodb-autoinc, attempt(2/3)... innodb.innodb-autoinc [ retry-fail ] Test ended at 2014-08-15 08:36:20 CURRENT_TEST: innodb.innodb-autoinc --- /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-autoinc.result 2014-08-05 14:51:52.924766000 +0300 +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-autoinc.reject 2014-08-15 08:36:20.518754319 +0300 @@ -1276,6 +1276,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 256 +wsrep_auto_increment_control ON CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1, NULL); SHOW CREATE TABLE t1; @@ -1294,6 +1295,7 @@ Variable_name Value auto_increment_increment 1 auto_increment_offset 1 +wsrep_auto_increment_control ON CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB; INSERT INTO t1 VALUES (2147483648, 'a'); SHOW CREATE TABLE t1; mysqltest: Result content mismatch - saving '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-autoinc/' to '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-autoinc/' Test innodb.innodb-autoinc has failed 2 times, no more retries! innodb.innodb_bug30919 [ pass ] 4285 innodb.innodb_autoinc_lock_mode_zero [ pass ] 57 innodb.innodb-index-online [ pass ] 5224 innodb.innodb-table-online [ pass ] 5323 innodb.innodb_buffer_pool_load [ pass ] 7997 innodb.innodb_bug39438 [ pass ] 23 innodb.innodb-use-sys-malloc [ pass ] 75 innodb.innodb_stats_flag_global_off [ pass ] 7201 innodb.innodb_stats_flag_global_on [ pass ] 7334 innodb.innodb-autoinc-56228 [ pass ] 28 innodb.innodb_bug42101-nonzero [ pass ] 5 innodb.innodb_bug60049 [ pass ] 3682 innodb.innodb_bug12400341 [ pass ] 511 innodb.innodb_bug14147491 [ pass ] 6422 innodb.innodb_mysql_rbk [ pass ] 4042 innodb.innodb_lock_wait_timeout_1 [ pass ] 18211 innodb.innodb_timeout_rollback [ pass ] 3046 innodb.innodb-consistent [ pass ] 68 innodb.innodb-semi-consistent [ pass ] 12085 innodb.innodb-change-buffer-recovery [ pass ] 2687 innodb.innodb_bug60196 [ skipped ] Test requires: 'lowercase2' innodb.innodb_bug60229 [ pass ] 60 innodb.innodb_bug53756 [ pass ] 2228 innodb.innodb_bug47167 [ pass ] 5 innodb.innodb_file_format [ pass ] 5 innodb.blob-update-debug [ pass ] 30 innodb.create-index [ pass ] 26 innodb.foreign_key [ pass ] 50 innodb.innodb-ac-non-locking-select [ pass ] 53 innodb.innodb-alter-autoinc [ fail ] Test ended at 2014-08-15 08:38:53 CURRENT_TEST: innodb.innodb-alter-autoinc --- /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-alter-autoinc.result 2014-08-05 14:51:52.924766000 +0300 +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-alter-autoinc.reject 2014-08-15 08:38:53.342751675 +0300 @@ -29,17 +29,17 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 BEGIN; INSERT INTO t1 VALUES(7,0); SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 -7 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +7 47 ROLLBACK; SHOW CREATE TABLE t1; Table Create Table @@ -48,7 +48,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 ALTER TABLE t1 DROP PRIMARY KEY, ADD id INT AUTO_INCREMENT PRIMARY KEY, DROP COLUMN id, AUTO_INCREMENT = 42, LOCK=NONE; ERROR 0A000: LOCK=NONE is not supported. Reason: Adding an auto-increment column requires a lock. Try LOCK=SHARED. @@ -56,11 +56,11 @@ DROP COLUMN id, AUTO_INCREMENT = 42, ALGORITHM=INPLACE; SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 +6 42 +45 43 +123 44 +347 45 +33101 46 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -68,7 +68,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 INSERT INTO t1 SET a=123; INSERT INTO t1 VALUES(-123,-45); ALTER TABLE t1 AUTO_INCREMENT = 75; @@ -76,12 +76,12 @@ SELECT * FROM t1; a id -123 -45 -6 45 -45 50 -123 55 -347 60 -33101 65 -123 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +123 47 123 75 SHOW CREATE TABLE t1; Table Create Table @@ -90,7 +90,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1 DROP TABLE t1; CREATE TABLE t1 (a INT) ENGINE=InnoDB; INSERT INTO t1 VALUES(347),(33101),(123),(45),(6); @@ -112,17 +112,17 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 BEGIN; INSERT INTO t1 VALUES(7,0); SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 -7 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +7 47 ROLLBACK; SHOW CREATE TABLE t1; Table Create Table @@ -131,16 +131,16 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 ALTER TABLE t1 DROP PRIMARY KEY, ADD id INT AUTO_INCREMENT PRIMARY KEY, DROP COLUMN id, AUTO_INCREMENT = 42, ALGORITHM=COPY; SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 +6 42 +45 43 +123 44 +347 45 +33101 46 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -148,7 +148,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 INSERT INTO t1 SET a=123; INSERT INTO t1 VALUES(-123,-45); ALTER TABLE t1 AUTO_INCREMENT = 75; @@ -156,12 +156,12 @@ SELECT * FROM t1; a id -123 -45 -6 45 -45 50 -123 55 -347 60 -33101 65 -123 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +123 48 123 75 SHOW CREATE TABLE t1; Table Create Table @@ -170,5 +170,5 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1 DROP TABLE t1; mysqltest: Result content mismatch - saving '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-alter-autoinc/' to '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-alter-autoinc/' Retrying test innodb.innodb-alter-autoinc, attempt(2/3)... innodb.innodb-alter-autoinc [ retry-fail ] Test ended at 2014-08-15 08:38:55 CURRENT_TEST: innodb.innodb-alter-autoinc --- /home/egge/aug/codership-mysql/mysql-test/suite/innodb/r/innodb-alter-autoinc.result 2014-08-05 14:51:52.924766000 +0300 +++ /home/egge/aug/codership-mysql/mysql-test/var/log/innodb-alter-autoinc.reject 2014-08-15 08:38:55.406751640 +0300 @@ -29,17 +29,17 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 BEGIN; INSERT INTO t1 VALUES(7,0); SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 -7 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +7 47 ROLLBACK; SHOW CREATE TABLE t1; Table Create Table @@ -48,7 +48,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 ALTER TABLE t1 DROP PRIMARY KEY, ADD id INT AUTO_INCREMENT PRIMARY KEY, DROP COLUMN id, AUTO_INCREMENT = 42, LOCK=NONE; ERROR 0A000: LOCK=NONE is not supported. Reason: Adding an auto-increment column requires a lock. Try LOCK=SHARED. @@ -56,11 +56,11 @@ DROP COLUMN id, AUTO_INCREMENT = 42, ALGORITHM=INPLACE; SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 +6 42 +45 43 +123 44 +347 45 +33101 46 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -68,7 +68,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 INSERT INTO t1 SET a=123; INSERT INTO t1 VALUES(-123,-45); ALTER TABLE t1 AUTO_INCREMENT = 75; @@ -76,12 +76,12 @@ SELECT * FROM t1; a id -123 -45 -6 45 -45 50 -123 55 -347 60 -33101 65 -123 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +123 47 123 75 SHOW CREATE TABLE t1; Table Create Table @@ -90,7 +90,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1 DROP TABLE t1; CREATE TABLE t1 (a INT) ENGINE=InnoDB; INSERT INTO t1 VALUES(347),(33101),(123),(45),(6); @@ -112,17 +112,17 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 BEGIN; INSERT INTO t1 VALUES(7,0); SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 -7 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +7 47 ROLLBACK; SHOW CREATE TABLE t1; Table Create Table @@ -131,16 +131,16 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 ALTER TABLE t1 DROP PRIMARY KEY, ADD id INT AUTO_INCREMENT PRIMARY KEY, DROP COLUMN id, AUTO_INCREMENT = 42, ALGORITHM=COPY; SELECT * FROM t1; a id -6 45 -45 50 -123 55 -347 60 -33101 65 +6 42 +45 43 +123 44 +347 45 +33101 46 SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -148,7 +148,7 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 INSERT INTO t1 SET a=123; INSERT INTO t1 VALUES(-123,-45); ALTER TABLE t1 AUTO_INCREMENT = 75; @@ -156,12 +156,12 @@ SELECT * FROM t1; a id -123 -45 -6 45 -45 50 -123 55 -347 60 -33101 65 -123 70 +6 42 +45 43 +123 44 +347 45 +33101 46 +123 48 123 75 SHOW CREATE TABLE t1; Table Create Table @@ -170,5 +170,5 @@ `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), KEY `id` (`id`,`a`) -) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1 DROP TABLE t1; mysqltest: Result content mismatch - saving '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-alter-autoinc/' to '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb-alter-autoinc/' Test innodb.innodb-alter-autoinc has failed 2 times, no more retries! innodb.innodb-alter-debug [ pass ] 55 innodb.innodb-alter-discard [ pass ] 3657 innodb.innodb-alter-nullable [ pass ] 88 innodb.innodb-alter [ pass ] 1921 innodb.innodb-analyze [ pass ] 117 innodb.innodb-autoinc-18274 [ pass ] 54 innodb.innodb-autoinc-optimize [ pass ] 43 innodb.innodb-blob [ pass ] 6261 innodb.innodb-bug-14068765 [ pass ] 277 innodb.innodb-bug-14084530 [ pass ] 135 innodb.innodb-bug14219515 [ pass ] 38 innodb.innodb-double-write [ pass ] 22491 innodb.innodb-index-debug [ pass ] 176 innodb.innodb-index-online-delete [ pass ] 56 innodb.innodb-index-online-fk [ pass ] 1455 innodb.innodb-index-online-purge [ pass ] 10297 innodb.innodb-index [ pass ] 2878 innodb.innodb-index_ucs2 [ pass ] 96 innodb.innodb-lock [ pass ] 2077 innodb.innodb-log-file-size-1 [ pass ] 21234 innodb.innodb-log-file-size [ pass ] 14010 innodb.innodb-multiple-tablespaces [ pass ] 14964 innodb.innodb-read-view [ pass ] 69 innodb.innodb-replace [ pass ] 20 innodb.innodb-system-table-view [ pass ] 126 innodb.innodb-tablespace [ pass ] 265 innodb.innodb-timeout [ pass ] 4383 innodb.innodb-truncate [ pass ] 199 innodb.innodb-ucs2 [ pass ] 425 innodb.innodb-update-insert [ pass ] 106 innodb.innodb-wl5522-1 [ pass ] 3009 innodb.innodb-wl5522 [ pass ] 9288 innodb.innodb-wl5980-alter [ pass ] 1050 innodb.innodb-wl5980-debug [ pass ] 40 innodb.innodb-wl5980-discard [ pass ] 21473 innodb.innodb-wl6445-1 [ pass ] 41686 innodb.innodb-wl6445-2 [ pass ] 13099 innodb.innodb-wl6445 [ pass ] 6396 innodb.innodb_blob_unrecoverable_crash [ pass ] 2506 innodb.innodb_bug-13628249 [ pass ] 12548 innodb.innodb_bug11754376 [ pass ] 21 innodb.innodb_bug11789106 [ pass ] 32 innodb.innodb_bug11933790 [ pass ] 1042 innodb.innodb_bug12429573 [ pass ] 1046 innodb.innodb_bug13635833 [ pass ] 232 innodb.innodb_bug13867871 [ pass ] 10721 innodb.innodb_bug14006907 [ pass ] 111 innodb.innodb_bug14007109 [ pass ] 481 innodb.innodb_bug14007649 [ pass ] 56 innodb.innodb_bug14169459 [ pass ] 67 innodb.innodb_bug14676111 [ pass ] 220 innodb.innodb_bug21704 [ pass ] 132 innodb.innodb_bug30423 [ pass ] 21379 innodb.innodb_bug34053 [ pass ] 88 innodb.innodb_bug34300 [ pass ] 127 innodb.innodb_bug35220 [ pass ] 32 innodb.innodb_bug38231 [ pass ] 32 innodb.innodb_bug40360 [ pass ] 25 innodb.innodb_bug40565 [ pass ] 19 innodb.innodb_bug41904 [ pass ] 30 innodb.innodb_bug42101 [ pass ] 4 innodb.innodb_bug42419 [ pass ] 257 innodb.innodb_bug44032 [ pass ] 17 innodb.innodb_bug44369 [ pass ] 4 innodb.innodb_bug44571 [ pass ] 39 innodb.innodb_bug45357 [ pass ] 31 innodb.innodb_bug46000 [ pass ] 31 innodb.innodb_bug46676 [ pass ] 48 innodb.innodb_bug47621 [ pass ] 94 innodb.innodb_bug47622 [ pass ] 118 innodb.innodb_bug47777 [ pass ] 21 innodb.innodb_bug48024 [ pass ] 109 innodb.innodb_bug49164 [ pass ] 29 innodb.innodb_bug51378 [ pass ] 181 innodb.innodb_bug51920 [ pass ] 1033 innodb.innodb_bug52199 [ pass ] 28 innodb.innodb_bug53046 [ pass ] 74 innodb.innodb_bug53290 [ pass ] 17997 innodb.innodb_bug53592 [ pass ] 270 innodb.innodb_bug54044 [ pass ] 21 innodb.innodb_bug56143 [ pass ] 1395 innodb.innodb_bug56716 [ pass ] 20 innodb.innodb_bug56947 [ pass ] 32 innodb.innodb_bug57252 [ pass ] 23 innodb.innodb_bug57255 [ pass ] 586 innodb.innodb_bug57904 [ pass ] 46 innodb.innodb_bug59307 [ pass ] 35 innodb.innodb_bug59410 [ pass ] 29 innodb.innodb_bug59641 [ pass ] 6112 innodb.innodb_bug59733 [ pass ] 629 innodb.innodb_bug70867 [ pass ] 3906 innodb.innodb_corrupt_bit [ pass ] 3714 innodb.innodb_gis [ pass ] 389 innodb.innodb_i_s_innodb_locks [ pass ] 290 innodb.innodb_information_schema_buffer [ pass ] 99 innodb.innodb_monitor [ pass ] 190 innodb.innodb_multi_update [ pass ] 93 innodb.innodb_notembedded [ pass ] 226 innodb.innodb_page_size_func [ pass ] 3974 innodb.innodb_prefix_index_restart_server [ fail ] Test ended at 2014-08-15 08:44:20 CURRENT_TEST: innodb.innodb_prefix_index_restart_server mysqltest: At line 85: query 'INSERT INTO worklog5743 VALUES(REPEAT("b", 3500) , REPEAT("o", 3500))' failed: 1062: Duplicate entry 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb' for key 'PRIMARY' The result from queries just before the failure was: < snip > START TRANSACTION; "In connection default ....restarting the server" SELECT COUNT(*) FROM worklog5743; COUNT(*) 2 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM worklog5743; col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500) 1 1 0 1 "In connection 1" SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM worklog5743; col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500) 1 1 0 1 SELECT COUNT(*) FROM worklog5743; COUNT(*) 2 START TRANSACTION; More results from queries before failure can be found in /home/egge/aug/codership-mysql/mysql-test/var/log/innodb_prefix_index_restart_server.log - saving '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb_prefix_index_restart_server/' to '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb_prefix_index_restart_server/' Retrying test innodb.innodb_prefix_index_restart_server, attempt(2/3)... innodb.innodb_prefix_index_restart_server [ retry-fail ] Test ended at 2014-08-15 08:44:27 CURRENT_TEST: innodb.innodb_prefix_index_restart_server mysqltest: At line 85: query 'INSERT INTO worklog5743 VALUES(REPEAT("b", 3500) , REPEAT("o", 3500))' failed: 1062: Duplicate entry 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb' for key 'PRIMARY' The result from queries just before the failure was: < snip > START TRANSACTION; "In connection default ....restarting the server" SELECT COUNT(*) FROM worklog5743; COUNT(*) 2 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM worklog5743; col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500) 1 1 0 1 "In connection 1" SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM worklog5743; col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500) 1 1 0 1 SELECT COUNT(*) FROM worklog5743; COUNT(*) 2 START TRANSACTION; More results from queries before failure can be found in /home/egge/aug/codership-mysql/mysql-test/var/log/innodb_prefix_index_restart_server.log - saving '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb_prefix_index_restart_server/' to '/home/egge/aug/codership-mysql/mysql-test/var/log/innodb.innodb_prefix_index_restart_server/' Test innodb.innodb_prefix_index_restart_server has failed 2 times, no more retries! innodb.innodb_replace [ pass ] 77 innodb.innodb_stats [ pass ] 274 innodb.innodb_stats_auto_recalc [ pass ] 10149 innodb.innodb_stats_auto_recalc_ddl [ pass ] 322 innodb.innodb_stats_auto_recalc_lots [ pass ] 4560 innodb.innodb_stats_auto_recalc_on_nonexistent [ pass ] 201 innodb.innodb_stats_create_on_corrupted [ pass ] 25 innodb.innodb_stats_create_table [ pass ] 42 innodb.innodb_stats_drop_locked [ pass ] 2043 innodb.innodb_stats_external_pages [ pass ] 1727 innodb.innodb_stats_fetch [ pass ] 48 innodb.innodb_stats_fetch_corrupted [ pass ] 34 innodb.innodb_stats_fetch_nonexistent [ pass ] 37 innodb.innodb_stats_rename_table [ pass ] 27 innodb.innodb_stats_rename_table_if_exists [ pass ] 437 innodb.innodb_stats_sample_pages [ pass ] 468 innodb.innodb_stats_table_flag_auto_recalc [ pass ] 17199 innodb.innodb_stats_table_flag_sample_pages [ pass ] 14488 innodb.innodb_trx_weight [ pass ] 563 innodb.innodb_upd_stats_if_needed_not_inited [ pass ] 3670 innodb.innodb_ut_format_name [ pass ] 18 -------------------------------------------------------------------------- The servers were restarted 36 times Spent 475.284 of 634 seconds executing testcases Completed: Failed 3/162 tests, 98.15% were successful. Failing test(s): innodb.innodb-autoinc innodb.innodb-alter-autoinc innodb.innodb_prefix_index_restart_server 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 8 tests were skipped, 2 by the test itself.