Logging: ./mysql-test-run --suite=main --force --max-test-fail=5000 --parallel=5 --mem Using suites: main vardir: /data0/psergey/dev2/10.0-monty/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/data0/psergey/dev2/10.0-monty/mysql-test/var'... - symlinking 'var' to '/dev/shm/var_auto_j9wA' Checking supported features... MariaDB Version 10.0.1-MariaDB-debug Installing system database... - skipping ndbcluster - SSL connections supported - binaries are debug compiled Collecting tests... Using server port 57746 ============================================================================== TEST WORKER RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[2] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039 worker[4] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059 worker[5] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079 worker[3] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099 main.alter_table-big [ skipped ] Test needs --big-test main.count_distinct3 [ skipped ] Test needs --big-test main.create-big [ skipped ] Test needs --big-test main.create_delayed [ skipped ] Test needs --big-test main.events_stress [ skipped ] Test needs --big-test main.events_time_zone [ disabled ] Test is not predictable as it depends on precise timing. main.information_schema-big [ skipped ] Test needs --big-test main.log_tables-big [ disabled ] Bug#11756699 2010-11-15 mattiasj report already exists main.lowercase_table3 [ disabled ] Bug#11762269 2010-06-30 alik main.lowercase_table3 on Mac OSX main.merge-big [ skipped ] Test needs --big-test main.myisam-big [ skipped ] Test needs --big-test main.mysql_embedded [ disabled ] Bug#12561297 2011-05-14 Anitha Dependent on PB2 changes - eventum#41836 main.mysqlbinlog_row_big [ skipped ] Test needs --big-test main.read_many_rows_innodb [ disabled ] Bug#11748886 2010-11-15 mattiasj report already exists main.ssl-big [ skipped ] Test needs --big-test main.ssl_crl [ disabled ] broken upstream main.ssl_crl_clients_valid [ disabled ] broken upstream main.ssl_crl_clrpath [ disabled ] broken upstream main.sum_distinct-big [ disabled ] Bug#11764126 2010-11-15 mattiasj was not tested main.tablespace [ disabled ] disabled in MariaDB (no TABLESPACE table attribute) main.type_newdecimal-big [ skipped ] Test needs --big-test main.ipv6 w2 [ pass ] 116 main.ipv4_as_ipv6 w5 [ pass ] 225 main.ctype_cp932_binlog_row w5 [ pass ] 38 main.stat_tables_rbr 'xtradb' w2 [ pass ] 24 main.sp_trans_log 'xtradb' w3 [ pass ] 849 main.partition_innodb_stmt 'xtradb' w5 [ pass ] 46 main.partition_binlog_stmt w2 [ pass ] 8 main.mysqlbinlog w5 [ pass ] 339 main.ctype_filesystem w5 [ pass ] 3 main.mysqlbinlog-innodb 'xtradb' w3 [ pass ] 30 main.ctype_latin1_de w5 [ pass ] 41 main.lock_tables_lost_commit 'xtradb' w2 [ pass ] 124 main.ctype_utf16_def w5 [ pass ] 3 main.bug47671 w5 [ pass ] 7 main.ctype_ldml w5 [ pass ] 50 main.date_formats w5 [ pass ] 33 main.lowercase_utf8 w2 [ pass ] 3 main.ctype_ucs2_def w3 [ pass ] 11 main.mysqldump-max 'xtradb' w2 [ pass ] 1051 main.connect w1 [ pass ] 10316 main.lock_sync 'xtradb' w3 [ pass ] 1938 main.ctype_utf8 'xtradb' w1 [ pass ] 1354 main.bootstrap w3 [ pass ] 517 main.ctype_utf8mb4 'xtradb' w1 [ pass ] 854 main.crash_commit_before 'xtradb' w2 [ pass ] 2155 main.innodb_mysql_lock2 'xtradb' w3 [ pass ] 994 main.ctype_utf8mb4_innodb 'xtradb' w1 [ pass ] 2286 main.implicit_commit 'xtradb' w1 [ pass ] 705 main.pool_of_threads w4 [ pass ] 18345 main.partition_blackhole w4 [ pass ] 5 main.partition_cache 'xtradb' w2 [ pass ] 420 main.partition_not_blackhole w4 [ pass ] 5 main.partition_open_files_limit w4 [ skipped ] Need open_files_limit to be lower than 512 main.partition_cache_innodb 'xtradb' w2 [ pass ] 579 main.partition_datatype 'xtradb' w2 [ pass ] 207 main.mdl_sync 'xtradb' w1 [ pass ] 2133 main.partition_binlog w3 [ fail ] Test ended at 2013-07-04 18:00:32 CURRENT_TEST: main.partition_binlog mysqltest: At line 24: query 'ALTER TABLE t1 TRUNCATE PARTITION p1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1567... The result from queries just before the failure was: DROP TABLE IF EXISTS t1; # # Bug#58147: ALTER TABLE w/ TRUNCATE PARTITION fails # but the statement is written to binlog # CREATE TABLE t1(id INT) PARTITION BY RANGE (id) (PARTITION p0 VALUES LESS THAN (100), PARTITION pmax VALUES LESS THAN (MAXVALUE)); INSERT INTO t1 VALUES (1), (10), (100), (1000); ALTER TABLE t1 TRUNCATE PARTITION p1; Server [mysqld.1 - pid: 4000, winpid: 4000, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 130704 18:00:29 [Note] Plugin 'ARCHIVE' is disabled. 130704 18:00:29 [Note] Plugin 'InnoDB' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_TRX' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_CMPMEM' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_METRICS' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_FT_INSERTED' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_TABLES' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 130704 18:00:29 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 130704 18:00:29 [Note] Plugin 'SPHINX' is disabled. 130704 18:00:29 [Note] Plugin 'FEDERATED' is disabled. 130704 18:00:29 [Note] Plugin 'BLACKHOLE' is disabled. 130704 18:00:29 [Note] Plugin 'FEEDBACK' is disabled. 130704 18:00:29 [Note] Event Scheduler: Loaded 0 events 130704 18:00:29 [Note] /data0/psergey/dev2/10.0-monty/sql/mysqld: ready for connections. Version: '10.0.1-MariaDB-debug-log' socket: '/data0/psergey/dev2/10.0-monty/mysql-test/var/tmp/3/mysqld.1.sock' port: 16080 Source distribution mysqld: /home/psergey/dev2/10.0-monty/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed. 130704 18:00:29 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x35a36d0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f3eded4adf8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] sql/protocol.cc:515(Protocol::end_statement())[0x586395] sql/sql_parse.cc:1666(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61f9e7] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f3ec80077f8): ALTER TABLE t1 TRUNCATE PARTITION p1 Connection ID (thread ID): 3 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - saving '/dev/shm/var_auto_j9wA/3/log/main.partition_binlog/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.partition_binlog/' - found 'core.4001' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/data0/psergey/dev2/10.0-monty/sql/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 LWP 4043] [New LWP 4001] [New LWP 4028] [New LWP 4029] [New LWP 4030] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/data0/psergey/dev2/10.0-monty/sql/mysqld --defaults-group-suffix=.1 --defaults'. Program terminated with signal 6, Aborted. #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 63 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid), #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 #1 0x0000000000dea163 in my_write_core (sig=6) at /home/psergey/dev2/10.0-monty/mysys/stacktrace.c:457 #2 0x00000000007dfbc0 in handle_fatal_signal (sig=6) at /home/psergey/dev2/10.0-monty/sql/signal_handler.cc:262 #3 #4 0x0000003509836285 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #5 0x0000003509837b9b in __GI_abort () at abort.c:91 #6 0x000000350982ee9e in __assert_fail_base (fmt=, assertion=0xe484e8 "0", file=0xe48350 "/home/psergey/dev2/10.0-monty/sql/protocol.cc", line=, function=) at assert.c:94 #7 0x000000350982ef42 in __GI___assert_fail (assertion=0xe484e8 "0", file=0xe48350 "/home/psergey/dev2/10.0-monty/sql/protocol.cc", line=518, function=0xe490c0 "void Protocol::end_statement()") at assert.c:103 #8 0x0000000000586395 in Protocol::end_statement (this=0x35a3c48) at /home/psergey/dev2/10.0-monty/sql/protocol.cc:518 #9 0x000000000061f9e7 in dispatch_command (command=COM_QUERY, thd=0x35a36d0, packet=0x35a8ab1 "ALTER TABLE t1 TRUNCATE PARTITION p1", packet_length=36) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:1665 #10 0x000000000061d86d in do_command (thd=0x35a36d0) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:983 #11 0x00000000007270f9 in do_handle_one_connection (thd_arg=0x35a36d0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1379 #12 0x0000000000726ac7 in handle_one_connection (arg=0x35a36d0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1293 #13 0x0000000000ace81f in pfs_spawn_thread (arg=0x34c98c0) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #14 0x0000003509c07d90 in start_thread (arg=0x7f3eded4b700) at pthread_create.c:309 #15 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 5 (Thread 0x7f3eded94700 (LWP 4030)): #0 do_sigwait (set=, sig=0x7f3eded93e48) at ../sysdeps/unix/sysv/linux/sigwait.c:65 #1 0x0000003509c0f2c9 in __sigwait (set=, sig=) at ../sysdeps/unix/sysv/linux/sigwait.c:100 #2 0x000000000057490e in signal_hand (arg=0x0) at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:3157 #3 0x0000000000ace81f in pfs_spawn_thread (arg=0x32fd9e0) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #4 0x0000003509c07d90 in start_thread (arg=0x7f3eded94700) at pthread_create.c:309 #5 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 4 (Thread 0x7f3edf595700 (LWP 4029)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:165 #1 0x0000000000df0b5f in safe_cond_wait (cond=0x16ecc68, mp=0x16ecbb8, file=0xf0f820 "/home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h", line=1154) at /home/psergey/dev2/10.0-monty/mysys/thr_mutex.c:493 #2 0x000000000089fa00 in inline_mysql_cond_wait (that=0x16ecc68, mutex=0x16ecbb8, src_file=0xf0fb38 "/home/psergey/dev2/10.0-monty/sql/log.cc", src_line=8237) at /home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h:1154 #3 0x00000000008b44e4 in binlog_background_thread (arg=0x0) at /home/psergey/dev2/10.0-monty/sql/log.cc:8237 #4 0x0000000000ace81f in pfs_spawn_thread (arg=0x33a5020) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #5 0x0000003509c07d90 in start_thread (arg=0x7f3edf595700) at pthread_create.c:309 #6 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 3 (Thread 0x7f3eec116700 (LWP 4028)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216 #1 0x0000000000df0e3a in safe_cond_timedwait (cond=0x1eef960, mp=0x1eef8a0, abstime=0x7f3eec115db0, file=0xf3cf20 "/home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h", line=1191) at /home/psergey/dev2/10.0-monty/mysys/thr_mutex.c:547 #2 0x00000000009ac77b in inline_mysql_cond_timedwait (that=0x1eef960, mutex=0x1eef8a0, abstime=0x7f3eec115db0, src_file=0xf3cf60 "/home/psergey/dev2/10.0-monty/storage/maria/ma_servicethread.c", src_line=119) at /home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h:1191 #3 0x00000000009acc7d in my_service_thread_sleep (control=0x1572610, sleep_time=29000000000) at /home/psergey/dev2/10.0-monty/storage/maria/ma_servicethread.c:118 #4 0x00000000009a1d2b in ma_checkpoint_background (arg=0x1e) at /home/psergey/dev2/10.0-monty/storage/maria/ma_checkpoint.c:709 #5 0x0000000000ace81f in pfs_spawn_thread (arg=0x3318180) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #6 0x0000003509c07d90 in start_thread (arg=0x7f3eec116700) at pthread_create.c:309 #7 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 2 (Thread 0x7f3eec118740 (LWP 4001)): #0 0x00000035098e85c3 in __GI___poll (fds=, nfds=, timeout=) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x0000000000578f2d in handle_connections_sockets () at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:5833 #2 0x0000000000578108 in mysqld_main (argc=120, argv=0x3206b70) at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:5281 #3 0x000000000056f2b4 in main (argc=9, argv=0x7ffff85b2ce8) at /home/psergey/dev2/10.0-monty/sql/main.cc:25 Thread 1 (Thread 0x7f3eded4b700 (LWP 4043)): #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 #1 0x0000000000dea163 in my_write_core (sig=6) at /home/psergey/dev2/10.0-monty/mysys/stacktrace.c:457 #2 0x00000000007dfbc0 in handle_fatal_signal (sig=6) at /home/psergey/dev2/10.0-monty/sql/signal_handler.cc:262 #3 #4 0x0000003509836285 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #5 0x0000003509837b9b in __GI_abort () at abort.c:91 #6 0x000000350982ee9e in __assert_fail_base (fmt=, assertion=0xe484e8 "0", file=0xe48350 "/home/psergey/dev2/10.0-monty/sql/protocol.cc", line=, function=) at assert.c:94 #7 0x000000350982ef42 in __GI___assert_fail (assertion=0xe484e8 "0", file=0xe48350 "/home/psergey/dev2/10.0-monty/sql/protocol.cc", line=518, function=0xe490c0 "void Protocol::end_statement()") at assert.c:103 #8 0x0000000000586395 in Protocol::end_statement (this=0x35a3c48) at /home/psergey/dev2/10.0-monty/sql/protocol.cc:518 #9 0x000000000061f9e7 in dispatch_command (command=COM_QUERY, thd=0x35a36d0, packet=0x35a8ab1 "ALTER TABLE t1 TRUNCATE PARTITION p1", packet_length=36) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:1665 #10 0x000000000061d86d in do_command (thd=0x35a36d0) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:983 #11 0x00000000007270f9 in do_handle_one_connection (thd_arg=0x35a36d0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1379 #12 0x0000000000726ac7 in handle_one_connection (arg=0x35a36d0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1293 #13 0x0000000000ace81f in pfs_spawn_thread (arg=0x34c98c0) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #14 0x0000003509c07d90 in start_thread (arg=0x7f3eded4b700) at pthread_create.c:309 #15 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Compressed file /data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.partition_binlog/mysqld.1/data/core.4001 main.ps_3innodb 'xtradb' w1 [ pass ] 580 main.partition w4 [ pass ] 2335 ***Warnings generated in error logs during shutdown after running tests: main.partition_binlog mysqld: /home/psergey/dev2/10.0-monty/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed. Attempting backtrace. You can use the following information to find out main.partition_innodb 'xtradb' w2 [ pass ] 2917 main.partition_not_windows w4 [ pass ] 22 main.strict 'xtradb' w1 [ pass ] 199 main.information_schema_part w3 [ pass ] 49 main.partition_innodb_plugin 'xtradb' w2 [ pass ] 333 main.type_datetime_hires 'xtradb' w2 [ pass ] 94 main.partition_innodb_semi_consistent 'xtradb' w5 [ pass ] 15146 main.log_state_bug33693 w2 [ pass ] main.events_restart w4 [ pass ] 2894 main.events_logs_tests w1 [ pass ] 3129 main.ps w4 [ pass ] 1584 main.subselect_mat_cost w1 [ pass ] 978 main.events_bugs w3 [ pass ] 10618 main.lock w3 [ pass ] 236 main.partition_bug18198 w3 [ pass ] 31 main.partition_cache_myisam w3 [ pass ] 382 main.partition_charset w3 [ pass ] 16 main.log_state w1 [ pass ] 6431 main.partition_column w3 [ pass ] 285 main.partition_column_prune w3 [ pass ] 26 main.innodb_ignore_builtin w1 [ fail ] Test ended at 2013-07-04 18:00:48 CURRENT_TEST: main.innodb_ignore_builtin Failed to start mysqld.1 mysqltest failed but provided no output - saving '/dev/shm/var_auto_j9wA/1/log/main.innodb_ignore_builtin/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.innodb_ignore_builtin/' ***Warnings generated in error logs during shutdown after running tests: main.innodb_ignore_builtin 130704 18:00:48 [ERROR] /data0/psergey/dev2/10.0-monty/sql/mysqld: unknown option '--skip-innodb-stats-persistent' 130704 18:00:48 [ERROR] Aborting main.partition_csv w3 [ pass ] 31 main.init_file w1 [ pass ] 4 main.init_file_longline_3816 w1 [ pass ] 2 main.init_connect w1 [ pass ] 87 main.flush_block_commit_notembedded 'xtradb' w1 [ pass ] 1191 main.log_tables w4 [ pass ] 13873 main.bug46760 'xtradb' w4 [ pass ] 34 main.bug39022 'xtradb' w1 [ pass ] 281 main.commit_1innodb 'xtradb' w1 [ fail ] Test ended at 2013-07-04 18:00:57 CURRENT_TEST: main.commit_1innodb --- /data0/psergey/dev2/10.0-monty/mysql-test/r/commit_1innodb.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/commit_1innodb.reject 2013-07-04 18:00:57.128851726 +0400 @@ -843,8 +843,8 @@ alter table t3 rename t4; call p_verify_status_increment(2, 0, 2, 0); -SUCCESS - +ERROR +Expected commit increment: 2 actual: 0 rename table t4 to t3; call p_verify_status_increment(0, 0, 0, 0); SUCCESS mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/1/log/main.commit_1innodb-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.commit_1innodb-xtradb/' ***Warnings generated in error logs during shutdown after running tests: main.bug39022 main.commit_1innodb 130704 18:00:56 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave. Statement: update ignore t1 set a=2 where a=1 130704 18:00:56 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them. Statement: update t1 set a=2 where a=f1()+10 130704 18:00:57 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. REPLACE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and the slave. Statement: replace into t2 select a from t1 main.create_select_tmp 'xtradb' w1 [ pass ] 49 main.mysqldump 'xtradb' w1 [ fail ] Test ended at 2013-07-04 18:01:06 CURRENT_TEST: main.mysqldump Warning: 2048 bytes lost at 0x1809620, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:183, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804 Warning: 2048 bytes lost at 0x1808da0, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:178, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804 Warning: 192 bytes lost at 0x1808c60, allocated by T@0 at mysys/mulalloc.c:50, mysys/thr_mutex.c:160, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804, mysys/my_default.c:671 Warning: 2048 bytes lost at 0x1807bf0, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:183, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105 Warning: 2048 bytes lost at 0x1807370, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:178, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105 Warning: 192 bytes lost at 0x18071f0, allocated by T@0 at mysys/mulalloc.c:50, mysys/thr_mutex.c:160, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105, extra/my_print_defaults.c:161 Memory lost: 8576 bytes in 6 chunks mysqldump: Couldn't find table: "non_existing" Warning: 2048 bytes lost at 0x1d32630, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:183, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804 Warning: 2048 bytes lost at 0x1d31db0, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:178, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804 Warning: 192 bytes lost at 0x1d31c70, allocated by T@0 at mysys/mulalloc.c:50, mysys/thr_mutex.c:160, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804, mysys/my_default.c:671 Warning: 2048 bytes lost at 0x1d30bf0, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:183, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105 Warning: 2048 bytes lost at 0x1d30370, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:178, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105 Warning: 192 bytes lost at 0x1d301f0, allocated by T@0 at mysys/mulalloc.c:50, mysys/thr_mutex.c:160, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105, extra/my_print_defaults.c:161 Memory lost: 8576 bytes in 6 chunks Warning: 2048 bytes lost at 0xce3630, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:183, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804 Warning: 2048 bytes lost at 0xce2db0, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:178, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804 Warning: 192 bytes lost at 0xce2c70, allocated by T@0 at mysys/mulalloc.c:50, mysys/thr_mutex.c:160, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_fopen.c:72, psi/mysql_file.h:830, mysys/my_default.c:804, mysys/my_default.c:671 Warning: 2048 bytes lost at 0xce1bf0, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:183, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105 Warning: 2048 bytes lost at 0xce1370, allocated by T@0 at mysys/array.c:67, mysys/hash.c:93, mysys/thr_mutex.c:178, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105 Warning: 192 bytes lost at 0xce11f0, allocated by T@0 at mysys/mulalloc.c:50, mysys/thr_mutex.c:160, mysys/thr_mutex.c:320, psi/mysql_thread.h:689, mysys/my_thr_init.c:337, mysys/my_thr_init.c:195, mysys/my_init.c:105, extra/my_print_defaults.c:161 Memory lost: 8576 bytes in 6 chunks mysqldump: Got error: 1356: "View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356) mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE' Warning: 3072 bytes lost at 0x2642ec0, allocated by T@0 at mysys/my_malloc.c:165, mysys/string.c:107, client/mysqldump.c:5508, client/mysqldump.c:3356, client/mysqldump.c:3334, client/mysqldump.c:3515, client/mysqldump.c:4420, client/mysqldump.c:4227 Warning: 8152 bytes lost at 0x2640e60, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1631, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642 Warning: 96 bytes lost at 0x263cde0, allocated by T@0 at sql-common/client.c:1607, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0 Warning: 160 bytes lost at 0x263ccc0, allocated by T@0 at sql-common/client.c:4019, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 8152 bytes lost at 0x263ee00, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1484, sql-common/client.c:3964, sql-common/client.c:3997, libmysql/libmysql.c:715, libmysql/libmysql.c:801, client/mysqldump.c:3900, client/mysqldump.c:4391 Memory lost: 19632 bytes in 5 chunks mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE' Warning: 3072 bytes lost at 0x1c82ec0, allocated by T@0 at mysys/my_malloc.c:165, mysys/string.c:107, client/mysqldump.c:5508, client/mysqldump.c:3356, client/mysqldump.c:3334, client/mysqldump.c:3516, client/mysqldump.c:4420, client/mysqldump.c:4227 Warning: 8152 bytes lost at 0x1c80e60, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1631, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642 Warning: 96 bytes lost at 0x1c7cde0, allocated by T@0 at sql-common/client.c:1607, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0 Warning: 160 bytes lost at 0x1c7ccc0, allocated by T@0 at sql-common/client.c:4019, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 8152 bytes lost at 0x1c7ee00, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1484, sql-common/client.c:3964, sql-common/client.c:3997, libmysql/libmysql.c:715, libmysql/libmysql.c:801, client/mysqldump.c:3900, client/mysqldump.c:4391 Memory lost: 19632 bytes in 5 chunks mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE' Warning: 3072 bytes lost at 0x28f1ec0, allocated by T@0 at mysys/my_malloc.c:165, mysys/string.c:107, client/mysqldump.c:5508, client/mysqldump.c:3356, client/mysqldump.c:3334, client/mysqldump.c:3517, client/mysqldump.c:4420, client/mysqldump.c:4227 Warning: 8152 bytes lost at 0x28efe60, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1631, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642 Warning: 96 bytes lost at 0x28ebde0, allocated by T@0 at sql-common/client.c:1607, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0 Warning: 160 bytes lost at 0x28ebcc0, allocated by T@0 at sql-common/client.c:4019, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 8152 bytes lost at 0x28ede00, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1484, sql-common/client.c:3964, sql-common/client.c:3997, libmysql/libmysql.c:715, libmysql/libmysql.c:801, client/mysqldump.c:3900, client/mysqldump.c:4391 Memory lost: 19632 bytes in 5 chunks mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`! mysqldump: Got error: 1146: "Table 'test.???????????????????????' doesn't exist" when using LOCK TABLES Warning: 8152 bytes lost at 0xc7eed0, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1631, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642 Warning: 96 bytes lost at 0xc7edf0, allocated by T@0 at sql-common/client.c:1607, sql-common/client.c:4030, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0 Warning: 160 bytes lost at 0xc7ecd0, allocated by T@0 at sql-common/client.c:4019, libmysql/libmysql.c:804, client/mysqldump.c:3900, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 8152 bytes lost at 0xc846f0, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1484, sql-common/client.c:3964, sql-common/client.c:3997, libmysql/libmysql.c:715, libmysql/libmysql.c:801, client/mysqldump.c:3900, client/mysqldump.c:4391 Warning: 1024 bytes lost at 0xc7e850, allocated by T@0 at mysys/string.c:39, client/mysqldump.c:5489, client/mysqldump.c:4391, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Memory lost: 17584 bytes in 5 chunks Warning: 152 bytes lost at 0x196dcf0, allocated by T@0 at client/mysqldump.c:3382, client/mysqldump.c:1448, client/mysqldump.c:2211, client/mysqldump.c:4438, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Memory lost: 152 bytes in 1 chunks Warning: 152 bytes lost at 0x224bf30, allocated by T@0 at client/mysqldump.c:3382, client/mysqldump.c:1448, client/mysqldump.c:2211, client/mysqldump.c:4438, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 152 bytes lost at 0x224be10, allocated by T@0 at client/mysqldump.c:3382, client/mysqldump.c:1448, client/mysqldump.c:2211, client/mysqldump.c:4438, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 152 bytes lost at 0x224bcf0, allocated by T@0 at client/mysqldump.c:3382, client/mysqldump.c:1448, client/mysqldump.c:2211, client/mysqldump.c:4438, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Memory lost: 456 bytes in 3 chunks Warning: 160 bytes lost at 0x1afc450, allocated by T@0 at client/mysqldump.c:3382, client/mysqldump.c:1448, client/mysqldump.c:2211, client/mysqldump.c:4438, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Memory lost: 160 bytes in 1 chunks mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE' Warning: 1024 bytes lost at 0x19d5df0, allocated by T@0 at mysys/string.c:39, client/mysqldump.c:5489, client/mysqldump.c:3480, client/mysqldump.c:4661, client/mysqldump.c:5631, ??:0, ??:0 Warning: 8152 bytes lost at 0x19d3850, allocated by T@0 at mysys/my_alloc.c:233, client/mysqldump.c:4591, client/mysqldump.c:5631, ??:0, ??:0 Memory lost: 9176 bytes in 2 chunks mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE' Warning: 1024 bytes lost at 0x1143df0, allocated by T@0 at mysys/string.c:39, client/mysqldump.c:5489, client/mysqldump.c:3480, client/mysqldump.c:4661, client/mysqldump.c:5631, ??:0, ??:0 Warning: 8152 bytes lost at 0x1141850, allocated by T@0 at mysys/my_alloc.c:233, client/mysqldump.c:4591, client/mysqldump.c:5631, ??:0, ??:0 Memory lost: 9176 bytes in 2 chunks mysqldump: user1 has insufficent privileges to SHOW CREATE FUNCTION `hello1`! Warning: 8152 bytes lost at 0x26dfa40, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1631, sql-common/client.c:4030, client/mysqldump.c:1110, client/mysqldump.c:2360, client/mysqldump.c:4443, client/mysqldump.c:4227, client/mysqldump.c:5642 Warning: 96 bytes lost at 0x26d9be0, allocated by T@0 at sql-common/client.c:1607, sql-common/client.c:4030, client/mysqldump.c:1110, client/mysqldump.c:2360, client/mysqldump.c:4443, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0 Warning: 200 bytes lost at 0x26d9a90, allocated by T@0 at sql-common/client.c:4019, client/mysqldump.c:1110, client/mysqldump.c:2360, client/mysqldump.c:4443, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 8152 bytes lost at 0x26e1aa0, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1484, sql-common/client.c:3964, sql-common/client.c:3997, libmysql/libmysql.c:715, client/mysqldump.c:1109, client/mysqldump.c:2360, client/mysqldump.c:4443 Warning: 8152 bytes lost at 0x26dd9e0, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1631, sql-common/client.c:4030, client/mysqldump.c:1110, client/mysqldump.c:2346, client/mysqldump.c:4443, client/mysqldump.c:4227, client/mysqldump.c:5642 Warning: 96 bytes lost at 0x26d99b0, allocated by T@0 at sql-common/client.c:1607, sql-common/client.c:4030, client/mysqldump.c:1110, client/mysqldump.c:2346, client/mysqldump.c:4443, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0 Warning: 240 bytes lost at 0x26d9840, allocated by T@0 at sql-common/client.c:4019, client/mysqldump.c:1110, client/mysqldump.c:2346, client/mysqldump.c:4443, client/mysqldump.c:4227, client/mysqldump.c:5642, ??:0, ??:0 Warning: 8152 bytes lost at 0x26db980, allocated by T@1 at mysys/my_alloc.c:233, sql-common/client.c:1484, sql-common/client.c:3964, sql-common/client.c:3997, libmysql/libmysql.c:715, client/mysqldump.c:1109, client/mysqldump.c:2346, client/mysqldump.c:4443 Memory lost: 33240 bytes in 8 chunks --- /data0/psergey/dev2/10.0-monty/mysql-test/r/mysqldump.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/mysqldump.reject 2013-07-04 18:01:06.208852509 +0400 @@ -2698,13 +2698,13 @@ # DROP TABLE IF EXISTS `test1`; Warnings: -Note 1051 Unknown table 'test1' +Note 1051 Unknown table 'test.test1' CREATE TABLE `test1` ( `a1` int(11) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `test2`; Warnings: -Note 1051 Unknown table 'test2' +Note 1051 Unknown table 'test.test2' CREATE TABLE `test2` ( `a2` int(11) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; @@ -5239,9 +5239,9 @@ SHOW CREATE TABLE mysql.general_log; Table Create Table general_log CREATE TABLE `general_log` ( - `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), + `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `user_host` mediumtext NOT NULL, - `thread_id` int(11) NOT NULL, + `thread_id` bigint(21) unsigned NOT NULL, `server_id` int(10) unsigned NOT NULL, `command_type` varchar(64) NOT NULL, `argument` mediumtext NOT NULL @@ -5259,7 +5259,8 @@ `last_insert_id` int(11) NOT NULL, `insert_id` int(11) NOT NULL, `server_id` int(10) unsigned NOT NULL, - `sql_text` mediumtext NOT NULL + `sql_text` mediumtext NOT NULL, + `thread_id` bigint(21) unsigned NOT NULL ) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log' SET @@global.log_output= @old_log_output_state; SET @@global.slow_query_log= @old_slow_query_log_state; mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/1/log/main.mysqldump-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.mysqldump-xtradb/' main.concurrent_innodb_unsafelog 'xtradb' w4 [ pass ] 8542 main.sp_trans 'xtradb' w1 [ fail ] Test ended at 2013-07-04 18:01:08 CURRENT_TEST: main.sp_trans --- /data0/psergey/dev2/10.0-monty/mysql-test/r/sp_trans.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/sp_trans.reject 2013-07-04 18:01:08.668852722 +0400 @@ -99,8 +99,6 @@ end| set @error_in_func:= 0| insert into t1 values (bug10015_6(5)), (bug10015_6(6))| -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' select @error_in_func| @error_in_func 1 @@ -526,8 +524,6 @@ close c; end| call bug14210()| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select count(*) from t4| count(*) 256 mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/1/log/main.sp_trans-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.sp_trans-xtradb/' main.mysql_client_test w5 [ fail ] Test ended at 2013-07-04 18:01:10 CURRENT_TEST: main.mysql_client_test mysqltest: At line 17: exec of '/data0/psergey/dev2/10.0-monty/tests/mysql_client_test --defaults-file=/dev/shm/var_auto_j9wA/5/my.cnf --testcase --vardir=/dev/shm/var_auto_j9wA/5 --getopt-ll-test=25600M >> /dev/shm/var_auto_j9wA/5/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 2 Output from before failure: SET @old_slow_query_log= @@global.slow_query_log; The result from queries just before the failure was: SET @old_general_log= @@global.general_log; SET @old_slow_query_log= @@global.slow_query_log; - saving '/dev/shm/var_auto_j9wA/5/log/main.mysql_client_test/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.mysql_client_test/' main.mysql_client_test_nonblock w2 [ fail ] Test ended at 2013-07-04 18:01:10 CURRENT_TEST: main.mysql_client_test_nonblock mysqltest: At line 17: exec of '/data0/psergey/dev2/10.0-monty/tests/mysql_client_test --defaults-file=/dev/shm/var_auto_j9wA/2/my.cnf --testcase --vardir=/dev/shm/var_auto_j9wA/2 --non-blocking-api --getopt-ll-test=25600M >> /dev/shm/var_auto_j9wA/2/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 0 Output from before failure: SET @old_slow_query_log= @@global.slow_query_log; The result from queries just before the failure was: SET @old_general_log= @@global.general_log; SET @old_slow_query_log= @@global.slow_query_log; - saving '/dev/shm/var_auto_j9wA/2/log/main.mysql_client_test_nonblock/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.mysql_client_test_nonblock/' main.status_user 'xtradb' w1 [ pass ] 1103 main.lowercase_mixed_tmpdir_innodb 'xtradb' w5 [ skipped ] Test requires: 'lowercase2' main.lowercase_table4 'xtradb' w2 [ skipped ] Test requires: 'case_insensitive_file_system' main.xa_binlog 'xtradb' w1 [ pass ] 563 main.unsafe_binlog_innodb 'xtradb' w4 [ pass ] 8253 main.plugin_auth 'xtradb' w5 [ pass ] 4541 main.information_schema_all_engines 'xtradb' w4 [ skipped ] Needs XtraDB engine main.plugin_loaderr w4 [ pass ] 4 ***Warnings generated in error logs during shutdown after running tests: main.plugin_auth 130704 18:01:19 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out main.myisam-blob w4 [ pass ] 730 main.index_merge_innodb 'xtradb' w5 [ skipped ] Needs XtraDB engine main.key_cache w5 [ pass ] 422 main.stat_tables_innodb 'xtradb' w2 [ pass ] 11785 main.information_schema 'xtradb' w5 [ skipped ] Needs XtraDB engine main.progress_976225 'xtradb' w5 [ skipped ] Needs XtraDB engine main.rowid_order_innodb 'xtradb' w5 [ skipped ] Needs XtraDB engine main.xtradb_mrr 'xtradb' w5 [ skipped ] Needs XtraDB engine main.ctype_cp932_binlog_stm w5 [ fail ] Test ended at 2013-07-04 18:01:31 CURRENT_TEST: main.ctype_cp932_binlog_stm --- /data0/psergey/dev2/10.0-monty/mysql-test/r/ctype_cp932_binlog_stm.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/ctype_cp932_binlog_stm.reject 2013-07-04 18:01:31.058854652 +0400 @@ -44,7 +44,7 @@ INSERT INTO t4 VALUES (ins1, ins2, ind); END master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO t4 VALUES ( NAME_CONST('ins1',_latin1 0x466F6F2773206120426172 COLLATE 'latin1_swedish_ci'), NAME_CONST('ins2',_cp932 0xED40ED41ED42 COLLATE 'cp932_japanese_ci'), NAME_CONST('ind',47.93)) +master-bin.000001 # Query # # use `test`; INSERT INTO t4 VALUES ( NAME_CONST('ins1',_latin1 0x466F6F2773206120426172 COLLATE 'latin1_swedish_ci'), NAME_CONST('ins2',_cp932 0xED40ED41ED42 COLLATE 'cp932_japanese_ci'), ind) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # use `test`; DROP PROCEDURE bug18293 master-bin.000001 # Query # # use `test`; DROP TABLE `t4` /* generated by server */ mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/5/log/main.ctype_cp932_binlog_stm/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.ctype_cp932_binlog_stm/' ***Warnings generated in error logs during shutdown after running tests: main.ctype_cp932_binlog_stm 130704 18:01:29 [ERROR] Error in Log_event::read_log_event(): 'Event too big', data_len: 1163087433, event_type: 116 main.select_pkeycache w4 [ fail ] Test ended at 2013-07-04 18:01:31 CURRENT_TEST: main.select_pkeycache --- /data0/psergey/dev2/10.0-monty/mysql-test/r/select_pkeycache.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/select_pkeycache.reject 2013-07-04 18:01:31.642854703 +0400 @@ -4175,10 +4175,14 @@ set SQL_MODE=TRADITIONAL; select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34'; str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34' -1 +0 +Warnings: +Warning 1292 Incorrect datetime value: '2007-10-00 12:34' select str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34'; str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34' 0 +Warnings: +Warning 1292 Incorrect datetime value: '2007-10-00 12:34' select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-01 12:34'; str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-01 12:34' 0 mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/4/log/main.select_pkeycache/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.select_pkeycache/' main.concurrent_innodb_safelog 'xtradb' w1 [ pass ] 16469 main.show_check w4 [ pass ] 1274 main.status w4 [ fail ] Test ended at 2013-07-04 18:01:33 CURRENT_TEST: main.status mysqltest: At line 300: query 'show procedure status where name ='proc37908' and 1 in (select f1 from db37908.t1)' failed with wrong errno 1044: 'Access denied for user 'mysqltest_1'@'localhost' to database 'db37908'', instead of 1142... The result from queries just before the failure was: < snip > return ret; end // drop function f1; show status like 'Com%function'; Variable_name Value Com_alter_function 0 Com_create_function 1 Com_drop_function 1 create database db37908; create table db37908.t1(f1 int); insert into db37908.t1 values(1); grant usage,execute on test.* to mysqltest_1@localhost; create procedure proc37908() begin select 1; end | create function func37908() returns int sql security invoker return (select * from db37908.t1 limit 1)| select * from db37908.t1; ERROR 42000: SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1' show status where variable_name ='uptime' and 2 in (select * from db37908.t1); ERROR 42000: SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1' show procedure status where name ='proc37908' and 1 in (select f1 from db37908.t1); More results from queries before failure can be found in /dev/shm/var_auto_j9wA/4/log/status.log - saving '/dev/shm/var_auto_j9wA/4/log/main.status/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.status/' main.multi_statement w4 [ pass ] 6 main.row-checksum-old 'xtradb' w1 [ fail ] Test ended at 2013-07-04 18:01:35 CURRENT_TEST: main.row-checksum-old --- /data0/psergey/dev2/10.0-monty/mysql-test/r/row-checksum-old.result 2012-07-11 11:49:27.463401000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/row-checksum-old.reject 2013-07-04 18:01:35.066854998 +0400 @@ -73,7 +73,7 @@ drop table if exists t1; create table t1 (a int null, v varchar(100)) engine=innodb checksum=0 row_format=fixed; Warnings: -Warning 140 InnoDB: assuming ROW_FORMAT=COMPACT. +Warning 1478 InnoDB: assuming ROW_FORMAT=COMPACT. insert into t1 values(null, null), (1, "hello"); checksum table t1; Table Checksum mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/1/log/main.row-checksum-old-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.row-checksum-old-xtradb/' main.multi_update w5 [ pass ] 3533 main.union w4 [ pass ] 673 main.ctype_gbk_binlog w5 [ pass ] 19 main.blackhole w4 [ pass ] 5 main.mysqldump_restore w5 [ pass ] 201 main.mysqldump-compat w4 [ pass ] 26 main.named_pipe w4 [ skipped ] Need windows main.alter_table_online 'xtradb' w1 [ fail ] Test ended at 2013-07-04 18:01:36 CURRENT_TEST: main.alter_table_online mysqltest: At line 33: query 'alter online table t1 modify b int default 5' succeeded - should have failed with errno 1915... The result from queries just before the failure was: drop table if exists t1,t2,t3; create table t1 (a int not null primary key, b int, c varchar(80), e enum('a','b')); insert into t1 (a) values (1),(2),(3); alter online table t1 modify b int default 5; alter online table t1 change b new_name int; alter online table t1 modify e enum('a','b','c'); alter online table t1 comment "new comment"; alter online table t1 rename to t2; alter online table t2 rename to t1; drop table t1; create temporary table t1 (a int not null primary key, b int, c varchar(80), e enum('a','b')); insert into t1 (a) values (1),(2),(3); alter online table t1 modify b int default 5; - saving '/dev/shm/var_auto_j9wA/1/log/main.alter_table_online-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.alter_table_online-xtradb/' main.plugin_load w4 [ pass ] 5 main.plugin_load_option w4 [ pass ] 4 main.shm w4 [ skipped ] Need windows main.warnings w4 [ pass ] 62 main.skip_log_bin w4 [ pass ] 4 main.alter_table_trans 'xtradb' w1 [ fail ] Test ended at 2013-07-04 18:01:38 CURRENT_TEST: main.alter_table_trans --- /data0/psergey/dev2/10.0-monty/mysql-test/r/alter_table_trans.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/alter_table_trans.reject 2013-07-04 18:01:38.405855286 +0400 @@ -2,5 +2,5 @@ CREATE TABLE t1 (a INT, INDEX(a)) engine=innodb; ALTER TABLE t1 RENAME TO t2, DISABLE KEYS; Warnings: -Note 1031 Table storage engine for 't1' doesn't have this option +Note 1031 Table storage engine for 'InnoDB' doesn't have this option DROP TABLE t2; mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/1/log/main.alter_table_trans-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.alter_table_trans-xtradb/' main.partition_disabled w4 [ pass ] 13 main.variables-notembedded w4 [ pass ] 16 main.ssl_cipher w4 [ pass ] 36 main.lowercase_mixed_tmpdir w4 [ pass ] 5 main.grant_lowercase w4 [ pass ] 17 main.auto_increment_ranges_innodb 'xtradb' w1 [ pass ] 405 main.lowercase_view w4 [ pass ] 48 main.cache_innodb 'xtradb' w1 [ pass ] 296 main.commit 'xtradb' w1 [ fail ] Test ended at 2013-07-04 18:01:41 CURRENT_TEST: main.commit mysqltest: At line 537: query 'SELECT f2()' failed: 1792: Cannot execute statement in a READ ONLY transaction. The result from queries just before the failure was: < snip > EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; # 6: Stored routines CREATE FUNCTION f1() RETURNS INT BEGIN DELETE FROM t1; RETURN 1; END| CREATE FUNCTION f2() RETURNS INT BEGIN DELETE FROM temp_t2; RETURN 1; END| CREATE PROCEDURE p1() DELETE FROM t1; CREATE PROCEDURE p2() DELETE FROM temp_t2; START TRANSACTION READ ONLY; SELECT f1(); ERROR 25006: Cannot execute statement in a READ ONLY transaction. SELECT f2(); More results from queries before failure can be found in /dev/shm/var_auto_j9wA/1/log/commit.log - saving '/dev/shm/var_auto_j9wA/1/log/main.commit-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.commit-xtradb/' main.lowercase_table w4 [ pass ] 33 main.lowercase_table_grant w4 [ pass ] 7 main.lowercase_table_qcache w4 [ pass ] 7 main.user_limits w4 [ pass ] 40 main.stat_tables_par_innodb 'xtradb' w2 [ pass ] 15108 main.statistics 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:01:42 CURRENT_TEST: main.statistics mysqltest: At line 280: query 'LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/save_column_stats' INTO TABLE mysql.column_stats FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'' failed: 1062: Duplicate entry 'test-t1-b' for key 'PRIMARY' The result from queries just before the failure was: < snip > test t1 a 0 49 0.0000 4.0000 1.0000 test t1 b vvvvvvvvvvvvv zzzzzzzzzzzzzzzzzz 0.2000 17.1250 6.4000 test t1 c aaaa dddddddd 0.1250 6.6571 7.0000 test t1 d 1989-03-12 1999-07-23 0.1500 3.0000 8.5000 test t1 e 0.01 0.112 0.2250 8.0000 6.2000 test t1 f 1 5 0.2000 1.0000 6.4000 SELECT * FROM mysql.index_stats; db_name table_name index_name prefix_arity avg_frequency test t1 PRIMARY 1 1.0000 test t1 idx1 1 6.4000 test t1 idx1 2 1.6875 test t1 idx2 1 7.0000 test t1 idx2 2 2.3846 test t1 idx3 1 8.5000 test t1 idx4 1 6.2000 test t1 idx4 2 1.6875 test t1 idx4 3 1.1304 LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/save_column_stats' INTO TABLE mysql.column_stats FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/statistics.log - saving '/dev/shm/var_auto_j9wA/2/log/main.statistics-xtradb/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.statistics-xtradb/' main.variables w4 [ pass ] 296 main.consistent_snapshot 'xtradb' w1 [ pass ] 35 main.count_distinct2 w2 [ pass ] 2213 main.myisam w4 [ fail ] Test ended at 2013-07-04 18:01:45 CURRENT_TEST: main.myisam --- /data0/psergey/dev2/10.0-monty/mysql-test/r/myisam.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/myisam.reject 2013-07-04 18:01:45.263855877 +0400 @@ -454,7 +454,7 @@ drop table t1; DROP TABLE IF EXISTS t1; Warnings: -Note 1051 Unknown table 't1' +Note 1051 Unknown table 'test.t1' CREATE TABLE t1 (a varchar(150) NOT NULL, KEY (a)); INSERT t1 VALUES ("can \tcan"); INSERT t1 VALUES ("can can"); @@ -618,7 +618,7 @@ alter table t1 engine=heap; alter table t1 disable keys; Warnings: -Note 1031 Table storage engine for 't1' doesn't have this option +Note 1031 Table storage engine for 'MEMORY' doesn't have this option show keys from t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment t1 1 a 1 a NULL 500 NULL NULL YES HASH @@ -2281,8 +2281,6 @@ 2 33 30 multip. char NULL DROP TABLE t1; create table t1 (n int not null, c char(1)) transactional=1; -Warnings: -Warning 1478 Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1' show create table t1; Table Create Table t1 CREATE TABLE `t1` ( mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/4/log/main.myisam/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.myisam/' ***Warnings generated in error logs during shutdown after running tests: main.myisam 130704 18:01:45 [Warning] Warning: Enabling keys got errno 12 on test.t1, retrying 130704 18:01:45 [ERROR] Got an error from thread_id=2, /home/psergey/dev2/10.0-monty/storage/myisam/ha_myisam.cc:935 130704 18:01:45 [ERROR] MySQL thread id 2, OS thread handle 0x7f44e92af700, query id 2844 localhost root Checking table 130704 18:01:45 [ERROR] mysqld: Table './test/t1' is marked as crashed and should be repaired main.multi_update_tiny_hash w2 [ pass ] 52 main.old-mode w2 [ pass ] 6 main.no-threads w2 [ skipped ] Test requires: 'one_thread_per_connection' main.merge_recover w4 [ pass ] 714 main.mysql_plugin w2 [ skipped ] Test requires known location of daemon_example.ini file. main.mysqltest w5 [ pass ] 10656 main.user_var-binlog w5 [ pass ] 43 main.plugin_auth_qa_2 w2 [ pass ] 77 main.func_encrypt w5 [ pass ] 28 main.bug58669 w2 [ pass ] 6 main.secure_file_priv_win w2 [ skipped ] Need windows main.plugin_auth_qa_3 w5 [ pass ] 22 main.plugin_maturity w5 [ pass ] 5 main.myisam_crash_before_flush_keys w2 [ pass ] 336 main.grant3 w5 [ pass ] 61 main.flush2 w2 [ pass ] 2 main.bug46261 w5 [ pass ] 2 main.mysqldump-no-binlog w2 [ pass ] 7 main.merge_mmap w4 [ fail ] Test ended at 2013-07-04 18:01:49 CURRENT_TEST: main.merge_mmap mysqltest: At line 44: query 'INSERT INTO m2 SELECT * FROM m1' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > 4 SELECT * FROM t2; c1 2 3 4 1 2 3 4 DROP TABLE m2, m1, t2, t1; CREATE TABLE t1 (c1 INT); CREATE TABLE t2 (c1 INT); CREATE TEMPORARY TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) INSERT_METHOD=LAST; CREATE TABLE m2 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) INSERT_METHOD=LAST; INSERT INTO t1 VALUES (1); INSERT INTO t2 VALUES (2), (3), (4); INSERT INTO m2 SELECT * FROM m1; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/4/log/merge_mmap.log Server [mysqld.1 - pid: 8886, winpid: 8886, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 130704 18:01:46 [Note] Plugin 'ARCHIVE' is disabled. 130704 18:01:46 [Note] Plugin 'InnoDB' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_TRX' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_CMPMEM' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_METRICS' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_FT_INSERTED' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_TABLES' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 130704 18:01:46 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 130704 18:01:46 [Note] Plugin 'SPHINX' is disabled. 130704 18:01:46 [Note] Plugin 'FEDERATED' is disabled. 130704 18:01:46 [Note] Plugin 'BLACKHOLE' is disabled. 130704 18:01:46 [Note] Plugin 'FEEDBACK' is disabled. 130704 18:01:46 [Note] Plugin 'partition' is disabled. 130704 18:01:46 [Note] Event Scheduler: Loaded 0 events 130704 18:01:46 [Note] /data0/psergey/dev2/10.0-monty/sql/mysqld: ready for connections. Version: '10.0.1-MariaDB-debug-log' socket: '/data0/psergey/dev2/10.0-monty/mysql-test/var/tmp/4/mysqld.1.sock' port: 16040 Source distribution mysqld: /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631: MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*): Assertion `child_l' failed. 130704 18:01:46 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x3821bc0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7fb6a44bbdf8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] myisammrg/ha_myisammrg.cc:633(myisammrg_attach_children_callback)[0xa8ddfe] myisammrg/myrg_open.c:409(myrg_attach_children)[0xa91d92] myisammrg/ha_myisammrg.cc:825(ha_myisammrg::attach_children())[0xa8e514] myisammrg/ha_myisammrg.cc:1333(ha_myisammrg::extra(ha_extra_function))[0xa8fa56] sql/sql_base.cc:5303(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x5c7118] sql/sql_base.cc:5797(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x5c7c46] sql/sql_base.h:505(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int))[0x5bb2b7] sql/sql_parse.cc:3400(mysql_execute_command(THD*))[0x62368a] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fb69c0077f8): INSERT INTO m2 SELECT * FROM m1 Connection ID (thread ID): 2 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - saving '/dev/shm/var_auto_j9wA/4/log/main.merge_mmap/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.merge_mmap/' - found 'core.8887' (1/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/data0/psergey/dev2/10.0-monty/sql/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 LWP 8931] [New LWP 8887] [New LWP 8909] [New LWP 8908] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/data0/psergey/dev2/10.0-monty/sql/mysqld --defaults-group-suffix=.1 --defaults'. Program terminated with signal 6, Aborted. #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 63 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid), #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 #1 0x0000000000dea163 in my_write_core (sig=6) at /home/psergey/dev2/10.0-monty/mysys/stacktrace.c:457 #2 0x00000000007dfbc0 in handle_fatal_signal (sig=6) at /home/psergey/dev2/10.0-monty/sql/signal_handler.cc:262 #3 #4 0x0000003509836285 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #5 0x0000003509837b9b in __GI_abort () at abort.c:91 #6 0x000000350982ee9e in __assert_fail_base (fmt=, assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=, function=) at assert.c:94 #7 0x000000350982ef42 in __GI___assert_fail (assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=631, function=0xf511c0 "MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*)") at assert.c:103 #8 0x0000000000a8ddfe in (anonymous namespace)::myisammrg_attach_children_callback (callback_param=0x7fb6a44bab20) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631 #9 0x0000000000a91d92 in myrg_attach_children (m_info=0x7fb69c038380, handle_locking=18, callback=0xa8dd63 <(anonymous namespace)::myisammrg_attach_children_callback(void*)>, callback_param=0x7fb6a44bab20, need_compat_check=0x7fb6a44bab20 "") at /home/psergey/dev2/10.0-monty/storage/myisammrg/myrg_open.c:409 #10 0x0000000000a8e514 in ha_myisammrg::attach_children (this=0x7fb69c044868) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:828 #11 0x0000000000a8fa56 in ha_myisammrg::extra (this=0x7fb69c044868, operation=HA_EXTRA_ATTACH_CHILDREN) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:1333 #12 0x00000000005c7118 in open_tables (thd=0x3821bc0, start=0x7fb6a44badb0, counter=0x7fb6a44badf4, flags=0, prelocking_strategy=0x7fb6a44bae30) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5303 #13 0x00000000005c7c46 in open_and_lock_tables (thd=0x3821bc0, tables=0x7fb69c0078e0, derived=true, flags=0, prelocking_strategy=0x7fb6a44bae30) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5797 #14 0x00000000005bb2b7 in open_and_lock_tables (thd=0x3821bc0, tables=0x7fb69c0078e0, derived=true, flags=0) at /home/psergey/dev2/10.0-monty/sql/sql_base.h:505 #15 0x000000000062368a in mysql_execute_command (thd=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:3400 #16 0x000000000062afd7 in mysql_parse (thd=0x3821bc0, rawbuf=0x7fb69c0077f8 "INSERT INTO m2 SELECT * FROM m1", length=31, parser_state=0x7fb6a44bb600) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:6196 #17 0x000000000061e6ac in dispatch_command (command=COM_QUERY, thd=0x3821bc0, packet=0x3826fa1 "INSERT INTO m2 SELECT * FROM m1", packet_length=31) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:1267 #18 0x000000000061d86d in do_command (thd=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:983 #19 0x00000000007270f9 in do_handle_one_connection (thd_arg=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1379 #20 0x0000000000726ac7 in handle_one_connection (arg=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1293 #21 0x0000000000ace81f in pfs_spawn_thread (arg=0x3747db0) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #22 0x0000003509c07d90 in start_thread (arg=0x7fb6a44bc700) at pthread_create.c:309 #23 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 4 (Thread 0x7fb6b1086700 (LWP 8908)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216 #1 0x0000000000df0e3a in safe_cond_timedwait (cond=0x1eef960, mp=0x1eef8a0, abstime=0x7fb6b1085db0, file=0xf3cf20 "/home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h", line=1191) at /home/psergey/dev2/10.0-monty/mysys/thr_mutex.c:547 #2 0x00000000009ac77b in inline_mysql_cond_timedwait (that=0x1eef960, mutex=0x1eef8a0, abstime=0x7fb6b1085db0, src_file=0xf3cf60 "/home/psergey/dev2/10.0-monty/storage/maria/ma_servicethread.c", src_line=119) at /home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h:1191 #3 0x00000000009acc7d in my_service_thread_sleep (control=0x1572610, sleep_time=29000000000) at /home/psergey/dev2/10.0-monty/storage/maria/ma_servicethread.c:118 #4 0x00000000009a1d2b in ma_checkpoint_background (arg=0x1e) at /home/psergey/dev2/10.0-monty/storage/maria/ma_checkpoint.c:709 #5 0x0000000000ace81f in pfs_spawn_thread (arg=0x359b210) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #6 0x0000003509c07d90 in start_thread (arg=0x7fb6b1086700) at pthread_create.c:309 #7 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 3 (Thread 0x7fb6a4505700 (LWP 8909)): #0 do_sigwait (set=, sig=0x7fb6a4504e48) at ../sysdeps/unix/sysv/linux/sigwait.c:65 #1 0x0000003509c0f2c9 in __sigwait (set=, sig=) at ../sysdeps/unix/sysv/linux/sigwait.c:100 #2 0x000000000057490e in signal_hand (arg=0x0) at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:3157 #3 0x0000000000ace81f in pfs_spawn_thread (arg=0x357d060) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #4 0x0000003509c07d90 in start_thread (arg=0x7fb6a4505700) at pthread_create.c:309 #5 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 2 (Thread 0x7fb6b1088740 (LWP 8887)): #0 0x00000035098e85c3 in __GI___poll (fds=, nfds=, timeout=) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x0000000000578f2d in handle_connections_sockets () at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:5833 #2 0x0000000000578108 in mysqld_main (argc=119, argv=0x348bb20) at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:5281 #3 0x000000000056f2b4 in main (argc=8, argv=0x7fff6f71b668) at /home/psergey/dev2/10.0-monty/sql/main.cc:25 Thread 1 (Thread 0x7fb6a44bc700 (LWP 8931)): #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 #1 0x0000000000dea163 in my_write_core (sig=6) at /home/psergey/dev2/10.0-monty/mysys/stacktrace.c:457 #2 0x00000000007dfbc0 in handle_fatal_signal (sig=6) at /home/psergey/dev2/10.0-monty/sql/signal_handler.cc:262 #3 #4 0x0000003509836285 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #5 0x0000003509837b9b in __GI_abort () at abort.c:91 #6 0x000000350982ee9e in __assert_fail_base (fmt=, assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=, function=) at assert.c:94 #7 0x000000350982ef42 in __GI___assert_fail (assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=631, function=0xf511c0 "MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*)") at assert.c:103 #8 0x0000000000a8ddfe in (anonymous namespace)::myisammrg_attach_children_callback (callback_param=0x7fb6a44bab20) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631 #9 0x0000000000a91d92 in myrg_attach_children (m_info=0x7fb69c038380, handle_locking=18, callback=0xa8dd63 <(anonymous namespace)::myisammrg_attach_children_callback(void*)>, callback_param=0x7fb6a44bab20, need_compat_check=0x7fb6a44bab20 "") at /home/psergey/dev2/10.0-monty/storage/myisammrg/myrg_open.c:409 #10 0x0000000000a8e514 in ha_myisammrg::attach_children (this=0x7fb69c044868) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:828 #11 0x0000000000a8fa56 in ha_myisammrg::extra (this=0x7fb69c044868, operation=HA_EXTRA_ATTACH_CHILDREN) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:1333 #12 0x00000000005c7118 in open_tables (thd=0x3821bc0, start=0x7fb6a44badb0, counter=0x7fb6a44badf4, flags=0, prelocking_strategy=0x7fb6a44bae30) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5303 #13 0x00000000005c7c46 in open_and_lock_tables (thd=0x3821bc0, tables=0x7fb69c0078e0, derived=true, flags=0, prelocking_strategy=0x7fb6a44bae30) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5797 #14 0x00000000005bb2b7 in open_and_lock_tables (thd=0x3821bc0, tables=0x7fb69c0078e0, derived=true, flags=0) at /home/psergey/dev2/10.0-monty/sql/sql_base.h:505 #15 0x000000000062368a in mysql_execute_command (thd=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:3400 #16 0x000000000062afd7 in mysql_parse (thd=0x3821bc0, rawbuf=0x7fb69c0077f8 "INSERT INTO m2 SELECT * FROM m1", length=31, parser_state=0x7fb6a44bb600) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:6196 #17 0x000000000061e6ac in dispatch_command (command=COM_QUERY, thd=0x3821bc0, packet=0x3826fa1 "INSERT INTO m2 SELECT * FROM m1", packet_length=31) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:1267 #18 0x000000000061d86d in do_command (thd=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:983 #19 0x00000000007270f9 in do_handle_one_connection (thd_arg=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1379 #20 0x0000000000726ac7 in handle_one_connection (arg=0x3821bc0) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1293 #21 0x0000000000ace81f in pfs_spawn_thread (arg=0x3747db0) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #22 0x0000003509c07d90 in start_thread (arg=0x7fb6a44bc700) at pthread_create.c:309 #23 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Compressed file /data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.merge_mmap/mysqld.1/data/core.8887 main.deadlock_innodb 'xtradb' w1 [ pass ] 6132 main.ssl_crl_clients w2 [ skipped ] Needs OpenSSL ***Warnings generated in error logs during shutdown after running tests: main.merge_mmap mysqld: /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631: MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*): Assertion `child_l' failed. Attempting backtrace. You can use the following information to find out main.skip_grants w5 [ pass ] 25 main.endspace 'xtradb' w1 [ pass ] 126 main.plugin_auth_qa w4 [ pass ] 78 main.udf_skip_grants w5 [ pass ] 1 main.events_trans 'xtradb' w1 [ pass ] 74 main.skip_name_resolve w5 [ pass ] 10 main.plugin_auth_qa_1 w4 [ pass ] 140 main.events_trans_notembedded 'xtradb' w1 [ pass ] 131 main.flush-innodb 'xtradb' w1 [ pass ] 86 main.sysdate_is_now w4 [ pass ] 1000 main.flush_block_commit 'xtradb' w1 [ pass ] 1030 main.temp_table w4 [ pass ] 59 main.stat_tables w4 [ pass ] 2457 main.ssl_8k_key w2 [ pass ] 7295 main.stat_tables_par w4 [ pass ] 2643 main.deprecated_features w2 [ pass ] 1 main.derived w2 [ pass ] 2275 main.derived_opt w2 [ pass ] 5495 main.derived_view w2 [ pass ] 458 main.join_outer w4 [ pass ] 12780 main.dirty_close w2 [ pass ] 5089 main.distinct w2 [ pass ] 405 main.drop w2 [ pass ] 253 main.drop-no_root w2 [ pass ] 4 main.drop_debug w2 [ pass ] 4 main.dyncol w2 [ pass ] 116 main.empty_table w2 [ pass ] 3 main.error_simulation w2 [ pass ] 26 main.errors w2 [ pass ] 28 main.events_1 w2 [ pass ] 414 main.events_2 w2 [ pass ] 131 main.events_embedded w2 [ skipped ] Test requires: 'is_embedded' main.events_grant w2 [ pass ] 138 main.events_microsec w2 [ pass ] 2 main.events_scheduling w2 [ pass ] 5867 main.execution_constants w2 [ pass ] 475 main.explain w2 [ pass ] 85 main.join_outer_jcl6 w4 [ pass ] 13637 main.failed_auth_3909 w2 [ pass ] 3011 main.features w2 [ pass ] 22 main.file_contents w2 [ pass ] 6 main.filesort_debug w2 [ pass ] 68 main.fix_priv_tables w2 [ pass ] 266 main.flush w2 [ pass ] 2858 main.multi_update2 w5 [ pass ] 42202 main.long_tmpdir w5 [ pass ] 1 main.trans_read_only w5 [ pass ] 107 main.flush_table w2 [ pass ] 4026 main.fulltext w2 [ pass ] 136 main.gcc296 w5 [ pass ] 4 main.gis w5 [ pass ] 231 main.fulltext2 w2 [ pass ] 770 main.fulltext3 w2 [ pass ] 7 main.fulltext_cache w2 [ pass ] 8 main.fulltext_distinct w2 [ pass ] 7 main.fulltext_left_join w2 [ pass ] 25 main.fulltext_multi w2 [ pass ] 4 main.fulltext_order_by w2 [ pass ] 21 main.fulltext_update w2 [ pass ] 4 main.fulltext_var w2 [ pass ] 6 main.func_compress w2 [ pass ] 758 main.func_concat w2 [ pass ] 22 main.func_crypt w2 [ fail ] Test ended at 2013-07-04 18:02:38 CURRENT_TEST: main.func_crypt --- /data0/psergey/dev2/10.0-monty/mysql-test/r/func_crypt.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/func_crypt.reject 2013-07-04 18:02:38.588860476 +0400 @@ -43,7 +43,7 @@ NULL select password(NULL); password(NULL) -NULL + set global old_passwords=on; select password(''); password('') mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/2/log/main.func_crypt/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.func_crypt/' main.func_date_add w2 [ pass ] 16 main.func_default w2 [ pass ] 6 main.func_des_encrypt w2 [ pass ] 5 main.func_digest w2 [ pass ] 84 main.func_encrypt_nossl w2 [ skipped ] only without SSL main.func_encrypt_ucs2 w2 [ pass ] 3 main.func_equal w2 [ pass ] 8 main.func_gconcat w2 [ pass ] 217 main.func_group w2 [ pass ] 1153 main.func_if w2 [ pass ] 27 main.func_in w2 [ pass ] 2031 main.func_isnull w2 [ pass ] 10 main.func_like w2 [ pass ] 21 main.func_math w2 [ pass ] 70 main.func_misc w2 [ pass ] 136 main.func_op w2 [ pass ] 6 main.func_regexp w2 [ pass ] 19 main.func_sapdb w2 [ pass ] 20 main.func_set w2 [ pass ] 20 main.func_str w2 [ pass ] 264 main.func_system w2 [ pass ] 11 main.func_test w2 [ pass ] 31 main.gis-precise w5 [ pass ] 16533 main.gis-rt-precise w5 [ pass ] 164 main.gis-rtree w5 [ pass ] 514 main.gis2 w5 [ pass ] 5 main.grant w5 [ pass ] 866 main.grant2 w5 [ pass ] 289 main.grant4 w5 [ pass ] 60 main.func_time w2 [ fail ] Test ended at 2013-07-04 18:02:56 CURRENT_TEST: main.func_time --- /data0/psergey/dev2/10.0-monty/mysql-test/r/func_time.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/func_time.reject 2013-07-04 18:02:56.043861981 +0400 @@ -1470,11 +1470,11 @@ WEEK('2009-10-00') NULL WEEK(DATE('2009-10-00')) NULL WEEK(DATE'2009-10-00') NULL -WEEK(STR_TO_DATE('200910','%Y%m')) NULL +WEEK(STR_TO_DATE('200910','%Y%m')) 39 WEEKOFYEAR('2009-10-00') NULL WEEKOFYEAR(DATE('2009-10-00')) NULL WEEKOFYEAR(DATE'2009-10-00') NULL -WEEKOFYEAR(STR_TO_DATE('200910','%Y%m')) NULL +WEEKOFYEAR(STR_TO_DATE('200910','%Y%m')) 40 DAYOFYEAR('2009-10-00') NULL DAYOFYEAR(DATE('2009-10-00')) NULL DAYOFYEAR(DATE'2009-10-00') NULL @@ -1482,7 +1482,7 @@ WEEKDAY('2009-10-00') NULL WEEKDAY(DATE('2009-10-00')) NULL WEEKDAY(DATE'2009-10-00') NULL -WEEKDAY(STR_TO_DATE('200910','%Y%m')) NULL +WEEKDAY(STR_TO_DATE('200910','%Y%m')) 2 TO_DAYs('2009-10-00') NULL TO_DAYs(DATE('2009-10-00')) NULL TO_DAYs(DATE'2009-10-00') NULL @@ -1498,9 +1498,6 @@ Code 1292 Message Incorrect datetime value: '2009-10-00' Level Warning -Code 1411 -Message Incorrect datetime value: '200910' for function str_to_date -Level Warning Code 1292 Message Incorrect datetime value: '2009-10-00' Level Warning @@ -1510,9 +1507,6 @@ Code 1292 Message Incorrect datetime value: '2009-10-00' Level Warning -Code 1411 -Message Incorrect datetime value: '200910' for function str_to_date -Level Warning Code 1292 Message Incorrect datetime value: '2009-10-00' Level Warning @@ -1534,9 +1528,6 @@ Code 1292 Message Incorrect datetime value: '2009-10-00' Level Warning -Code 1411 -Message Incorrect datetime value: '200910' for function str_to_date -Level Warning Code 1292 Message Incorrect datetime value: '2009-10-00' Level Warning @@ -1584,11 +1575,11 @@ WEEK('0000-01-00') NULL WEEK(DATE('0000-01-00')) NULL WEEK(DATE'0000-01-00') NULL -WEEK(STR_TO_DATE('000001','%Y%m')) NULL +WEEK(STR_TO_DATE('000001','%Y%m')) 52 WEEKOFYEAR('0000-01-00') NULL WEEKOFYEAR(DATE('0000-01-00')) NULL WEEKOFYEAR(DATE'0000-01-00') NULL -WEEKOFYEAR(STR_TO_DATE('000001','%Y%m')) NULL +WEEKOFYEAR(STR_TO_DATE('000001','%Y%m')) 52 DAYOFYEAR('0000-01-00') NULL DAYOFYEAR(DATE('0000-01-00')) NULL DAYOFYEAR(DATE'0000-01-00') NULL @@ -1596,7 +1587,7 @@ WEEKDAY('0000-01-00') NULL WEEKDAY(DATE('0000-01-00')) NULL WEEKDAY(DATE'0000-01-00') NULL -WEEKDAY(STR_TO_DATE('000001','%Y%m')) NULL +WEEKDAY(STR_TO_DATE('000001','%Y%m')) 5 TO_DAYs('0000-01-00') NULL TO_DAYs(DATE('0000-01-00')) NULL TO_DAYs(DATE'0000-01-00') NULL @@ -1612,9 +1603,6 @@ Code 1292 Message Incorrect datetime value: '0000-01-00' Level Warning -Code 1411 -Message Incorrect datetime value: '000001' for function str_to_date -Level Warning Code 1292 Message Incorrect datetime value: '0000-01-00' Level Warning @@ -1624,9 +1612,6 @@ Code 1292 Message Incorrect datetime value: '0000-01-00' Level Warning -Code 1411 -Message Incorrect datetime value: '000001' for function str_to_date -Level Warning Code 1292 Message Incorrect datetime value: '0000-01-00' Level Warning @@ -1648,9 +1633,6 @@ Code 1292 Message Incorrect datetime value: '0000-01-00' Level Warning -Code 1411 -Message Incorrect datetime value: '000001' for function str_to_date -Level Warning Code 1292 Message Incorrect datetime value: '0000-01-00' Level Warning mysqltest: Result length mismatch - saving '/dev/shm/var_auto_j9wA/2/log/main.func_time/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.func_time/' main.func_time_hires w2 [ pass ] 42 main.grant_cache_no_prot w5 [ pass ] 789 main.grant_cache_ps_prot w5 [ skipped ] Need ps-protocol main.func_timestamp w2 [ pass ] 7 main.grant_lowercase_fs w5 [ skipped ] Test requires: 'case_insensitive_fs' main.function_defaults_notembedded w2 [ pass ] 51 main.greedy_optimizer w5 [ pass ] 150 main.query_cache w4 [ pass ] 30575 main.group_min_max w5 [ pass ] 1770 main.handler_read_last w5 [ pass ] 6 main.handlersocket w5 [ pass ] 7 main.having w5 [ pass ] 118 main.help w5 [ pass ] 76 main.implicit_char_to_num_conversion w5 [ pass ] 92 main.in_datetime_241 w5 [ pass ] 2 main.index_intersect w5 [ pass ] 881 main.index_merge_myisam w5 [ pass ] 16845 main.information_schema2 w5 [ pass ] 3 main.information_schema_chmod w5 [ pass ] 3 main.information_schema_db w5 [ pass ] 457 main.information_schema_parameters w5 [ pass ] 45 main.information_schema_routines w5 [ pass ] 38 main.insert w5 [ pass ] 1623 main.insert_notembedded w5 [ pass ] 144 main.insert_select w5 [ pass ] 470 main.insert_update w5 [ pass ] 2068 main.mdev-504 w2 [ pass ] 27847 main.join w5 [ pass ] 466 main.mdev316 w2 [ pass ] 5 main.mdev375 w2 [ pass ] 4 main.merge w2 [ fail ] Test ended at 2013-07-04 18:03:27 CURRENT_TEST: main.merge mysqltest: At line 234: query 'SELECT * FROM t3' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > 2 21 drop table t6, t5, t4, t3, t2, t1; CREATE TABLE t1 ( a int(11) NOT NULL default '0', b int(11) NOT NULL default '0', PRIMARY KEY (a,b)) ENGINE=MyISAM; INSERT INTO t1 VALUES (1,1), (2,1); CREATE TABLE t2 ( a int(11) NOT NULL default '0', b int(11) NOT NULL default '0', PRIMARY KEY (a,b)) ENGINE=MyISAM; INSERT INTO t2 VALUES (1,2), (2,2); CREATE TABLE t3 ( a int(11) NOT NULL default '0', b int(11) NOT NULL default '0', KEY a (a,b)) ENGINE=MRG_MyISAM UNION=(t1,t2); select max(b) from t3 where a = 2; max(b) 2 select max(b) from t1 where a = 2; max(b) 1 drop table t3,t1,t2; CREATE TABLE t1 (c1 INT NOT NULL); CREATE TABLE t2 (c1 INT NOT NULL); INSERT INTO t1 VALUES (1); INSERT INTO t2 VALUES (2); CREATE TEMPORARY TABLE t3 (c1 INT NOT NULL) ENGINE=MRG_MYISAM UNION=(t1,t2); SELECT * FROM t3; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/merge.log Server [mysqld.1 - pid: 11189, winpid: 11189, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- mysqld: /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631: MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*): Assertion `child_l' failed. 130704 18:03:25 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=5 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x3128c70 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f8003152df8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] myisammrg/ha_myisammrg.cc:633(myisammrg_attach_children_callback)[0xa8ddfe] myisammrg/myrg_open.c:409(myrg_attach_children)[0xa91d92] myisammrg/ha_myisammrg.cc:825(ha_myisammrg::attach_children())[0xa8e514] myisammrg/ha_myisammrg.cc:1333(ha_myisammrg::extra(ha_extra_function))[0xa8fa56] sql/sql_base.cc:5303(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x5c7118] sql/sql_base.cc:5797(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x5c7c46] sql/sql_base.h:505(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int))[0x5bb2b7] sql/sql_parse.cc:5025(execute_sqlcom_select)[0x6285ab] sql/sql_parse.cc:2501(mysql_execute_command(THD*))[0x621323] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f7fe4005018): SELECT * FROM t3 Connection ID (thread ID): 10244 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - saving '/dev/shm/var_auto_j9wA/2/log/main.merge/' to '/data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.merge/' - found 'core.11190' (2/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/data0/psergey/dev2/10.0-monty/sql/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 LWP 21949] [New LWP 11193] [New LWP 11192] [New LWP 11190] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/data0/psergey/dev2/10.0-monty/sql/mysqld --defaults-group-suffix=.1 --defaults'. Program terminated with signal 6, Aborted. #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 63 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid), #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 #1 0x0000000000dea163 in my_write_core (sig=6) at /home/psergey/dev2/10.0-monty/mysys/stacktrace.c:457 #2 0x00000000007dfbc0 in handle_fatal_signal (sig=6) at /home/psergey/dev2/10.0-monty/sql/signal_handler.cc:262 #3 #4 0x0000003509836285 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #5 0x0000003509837b9b in __GI_abort () at abort.c:91 #6 0x000000350982ee9e in __assert_fail_base (fmt=, assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=, function=) at assert.c:94 #7 0x000000350982ef42 in __GI___assert_fail (assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=631, function=0xf511c0 "MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*)") at assert.c:103 #8 0x0000000000a8ddfe in (anonymous namespace)::myisammrg_attach_children_callback (callback_param=0x7f80031516b0) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631 #9 0x0000000000a91d92 in myrg_attach_children (m_info=0x7f7fe405eef0, handle_locking=18, callback=0xa8dd63 <(anonymous namespace)::myisammrg_attach_children_callback(void*)>, callback_param=0x7f80031516b0, need_compat_check=0x7f80031516b0 "") at /home/psergey/dev2/10.0-monty/storage/myisammrg/myrg_open.c:409 #10 0x0000000000a8e514 in ha_myisammrg::attach_children (this=0x7f7fe4060278) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:828 #11 0x0000000000a8fa56 in ha_myisammrg::extra (this=0x7f7fe4060278, operation=HA_EXTRA_ATTACH_CHILDREN) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:1333 #12 0x00000000005c7118 in open_tables (thd=0x3128c70, start=0x7f8003151940, counter=0x7f8003151984, flags=0, prelocking_strategy=0x7f80031519c0) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5303 #13 0x00000000005c7c46 in open_and_lock_tables (thd=0x3128c70, tables=0x7f7fe40051f8, derived=true, flags=0, prelocking_strategy=0x7f80031519c0) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5797 #14 0x00000000005bb2b7 in open_and_lock_tables (thd=0x3128c70, tables=0x7f7fe40051f8, derived=true, flags=0) at /home/psergey/dev2/10.0-monty/sql/sql_base.h:505 #15 0x00000000006285ab in execute_sqlcom_select (thd=0x3128c70, all_tables=0x7f7fe40051f8) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:5025 #16 0x0000000000621323 in mysql_execute_command (thd=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:2501 #17 0x000000000062afd7 in mysql_parse (thd=0x3128c70, rawbuf=0x7f7fe4005018 "SELECT * FROM t3", length=16, parser_state=0x7f8003152600) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:6196 #18 0x000000000061e6ac in dispatch_command (command=COM_QUERY, thd=0x3128c70, packet=0x312e051 "SELECT * FROM t3", packet_length=16) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:1267 #19 0x000000000061d86d in do_command (thd=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:983 #20 0x00000000007270f9 in do_handle_one_connection (thd_arg=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1379 #21 0x0000000000726ac7 in handle_one_connection (arg=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1293 #22 0x0000000000ace81f in pfs_spawn_thread (arg=0x3004920) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #23 0x0000003509c07d90 in start_thread (arg=0x7f8003153700) at pthread_create.c:309 #24 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 4 (Thread 0x7f800fdfa740 (LWP 11190)): #0 0x00000035098e85c3 in __GI___poll (fds=, nfds=, timeout=) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x0000000000578f2d in handle_connections_sockets () at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:5833 #2 0x0000000000578108 in mysqld_main (argc=118, argv=0x2d92b20) at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:5281 #3 0x000000000056f2b4 in main (argc=7, argv=0x7fffe1c36848) at /home/psergey/dev2/10.0-monty/sql/main.cc:25 Thread 3 (Thread 0x7f800fdf8700 (LWP 11192)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216 #1 0x0000000000df0e3a in safe_cond_timedwait (cond=0x1eef960, mp=0x1eef8a0, abstime=0x7f800fdf7db0, file=0xf3cf20 "/home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h", line=1191) at /home/psergey/dev2/10.0-monty/mysys/thr_mutex.c:547 #2 0x00000000009ac77b in inline_mysql_cond_timedwait (that=0x1eef960, mutex=0x1eef8a0, abstime=0x7f800fdf7db0, src_file=0xf3cf60 "/home/psergey/dev2/10.0-monty/storage/maria/ma_servicethread.c", src_line=119) at /home/psergey/dev2/10.0-monty/include/mysql/psi/mysql_thread.h:1191 #3 0x00000000009acc7d in my_service_thread_sleep (control=0x1572610, sleep_time=30000000000) at /home/psergey/dev2/10.0-monty/storage/maria/ma_servicethread.c:118 #4 0x00000000009a1d2b in ma_checkpoint_background (arg=0x1e) at /home/psergey/dev2/10.0-monty/storage/maria/ma_checkpoint.c:709 #5 0x0000000000ace81f in pfs_spawn_thread (arg=0x2ea2210) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #6 0x0000003509c07d90 in start_thread (arg=0x7f800fdf8700) at pthread_create.c:309 #7 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 2 (Thread 0x7f8003277700 (LWP 11193)): #0 do_sigwait (set=, sig=0x7f8003276e48) at ../sysdeps/unix/sysv/linux/sigwait.c:65 #1 0x0000003509c0f2c9 in __sigwait (set=, sig=) at ../sysdeps/unix/sysv/linux/sigwait.c:100 #2 0x000000000057490e in signal_hand (arg=0x0) at /home/psergey/dev2/10.0-monty/sql/mysqld.cc:3157 #3 0x0000000000ace81f in pfs_spawn_thread (arg=0x2e84060) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #4 0x0000003509c07d90 in start_thread (arg=0x7f8003277700) at pthread_create.c:309 #5 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1 (Thread 0x7f8003153700 (LWP 21949)): #0 __pthread_kill (threadid=, signo=) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 #1 0x0000000000dea163 in my_write_core (sig=6) at /home/psergey/dev2/10.0-monty/mysys/stacktrace.c:457 #2 0x00000000007dfbc0 in handle_fatal_signal (sig=6) at /home/psergey/dev2/10.0-monty/sql/signal_handler.cc:262 #3 #4 0x0000003509836285 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #5 0x0000003509837b9b in __GI_abort () at abort.c:91 #6 0x000000350982ee9e in __assert_fail_base (fmt=, assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=, function=) at assert.c:94 #7 0x000000350982ef42 in __GI___assert_fail (assertion=0xf50733 "child_l", file=0xf50548 "/home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc", line=631, function=0xf511c0 "MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*)") at assert.c:103 #8 0x0000000000a8ddfe in (anonymous namespace)::myisammrg_attach_children_callback (callback_param=0x7f80031516b0) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631 #9 0x0000000000a91d92 in myrg_attach_children (m_info=0x7f7fe405eef0, handle_locking=18, callback=0xa8dd63 <(anonymous namespace)::myisammrg_attach_children_callback(void*)>, callback_param=0x7f80031516b0, need_compat_check=0x7f80031516b0 "") at /home/psergey/dev2/10.0-monty/storage/myisammrg/myrg_open.c:409 #10 0x0000000000a8e514 in ha_myisammrg::attach_children (this=0x7f7fe4060278) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:828 #11 0x0000000000a8fa56 in ha_myisammrg::extra (this=0x7f7fe4060278, operation=HA_EXTRA_ATTACH_CHILDREN) at /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:1333 #12 0x00000000005c7118 in open_tables (thd=0x3128c70, start=0x7f8003151940, counter=0x7f8003151984, flags=0, prelocking_strategy=0x7f80031519c0) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5303 #13 0x00000000005c7c46 in open_and_lock_tables (thd=0x3128c70, tables=0x7f7fe40051f8, derived=true, flags=0, prelocking_strategy=0x7f80031519c0) at /home/psergey/dev2/10.0-monty/sql/sql_base.cc:5797 #14 0x00000000005bb2b7 in open_and_lock_tables (thd=0x3128c70, tables=0x7f7fe40051f8, derived=true, flags=0) at /home/psergey/dev2/10.0-monty/sql/sql_base.h:505 #15 0x00000000006285ab in execute_sqlcom_select (thd=0x3128c70, all_tables=0x7f7fe40051f8) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:5025 #16 0x0000000000621323 in mysql_execute_command (thd=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:2501 #17 0x000000000062afd7 in mysql_parse (thd=0x3128c70, rawbuf=0x7f7fe4005018 "SELECT * FROM t3", length=16, parser_state=0x7f8003152600) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:6196 #18 0x000000000061e6ac in dispatch_command (command=COM_QUERY, thd=0x3128c70, packet=0x312e051 "SELECT * FROM t3", packet_length=16) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:1267 #19 0x000000000061d86d in do_command (thd=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_parse.cc:983 #20 0x00000000007270f9 in do_handle_one_connection (thd_arg=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1379 #21 0x0000000000726ac7 in handle_one_connection (arg=0x3128c70) at /home/psergey/dev2/10.0-monty/sql/sql_connect.cc:1293 #22 0x0000000000ace81f in pfs_spawn_thread (arg=0x3004920) at /home/psergey/dev2/10.0-monty/storage/perfschema/pfs.cc:1853 #23 0x0000003509c07d90 in start_thread (arg=0x7f8003153700) at pthread_create.c:309 #24 0x00000035098f0f5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Compressed file /data0/psergey/dev2/10.0-monty/mysql-test/var/log/main.merge/mysqld.1/data/core.11190 ***Warnings generated in error logs during shutdown after running tests: main.mdev375 main.merge main.mdev316 main.function_defaults_notembedded main.mdev-504 main.func_timestamp main.func_time_hires mysqld: /home/psergey/dev2/10.0-monty/storage/myisammrg/ha_myisammrg.cc:631: MI_INFO* {anonymous}::myisammrg_attach_children_callback(void*): Assertion `child_l' failed. Attempting backtrace. You can use the following information to find out main.merge_debug w2 [ pass ] 12 main.join_cache w5 [ pass ] 5526 main.metadata w2 [ pass ] 36 main.join_crash w5 [ pass ] 15 main.join_nested w5 [ pass ] 244 main.join_nested_jcl6 w5 [ pass ] 250 main.join_optimizer w5 [ pass ] 249 main.key w5 [ pass ] 123 main.key_diff w5 [ pass ] 5 main.key_primary w5 [ pass ] 4 main.keywords w5 [ pass ] 29 main.kill w5 [ pass ] 1316 main.last_value w5 [ pass ] 7 main.limit w5 [ pass ] 43 main.limit_rows_examined w5 [ fail ] Test ended at 2013-07-04 18:03:34 CURRENT_TEST: main.limit_rows_examined mysqltest: At line 111: query 'call test_limit_rows(3)' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > ========================================================================= set @@join_cache_level=0; set @l = 2; Prepared statement parameter prepare st1 from "select * from t1, t2 where c1 = c2 LIMIT ROWS EXAMINED ?"; execute st1 using @l; c1 c2 bb bb Warnings: Warning 1930 Query execution was interrupted. The query examined at least 3 rows, which exceeds LIMIT ROWS EXAMINED (2). The query result may be incomplete. deallocate prepare st1; User variable (not supported for LIMIT in MariaDB 5.3/MySQL 5.1) select * from t1, t2 where c1 = c2 LIMIT ROWS EXAMINED @l; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@l' at line 1 Stored procedure parameter create procedure test_limit_rows(l int) begin select * from t1, t2 where c1 = c2 LIMIT ROWS EXAMINED l; end| call test_limit_rows(3); More results from queries before failure can be found in /dev/shm/var_auto_j9wA/5/log/limit_rows_examined.log Server [mysqld.1 - pid: 10370, winpid: 10370, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- mysqld: /home/psergey/dev2/10.0-monty/sql/item.cc:1394: virtual longlong Item_sp_variable::val_int(): Assertion `fixed' failed. 130704 18:03:34 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=8 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x2fde540 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7feb910a1df8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] sql/item.cc:1395(Item_sp_variable::val_int())[0x7f404a] sql/item.h:786(Item::val_uint())[0x618d07] sql/sql_lex.h:2488(LEX::set_limit_rows_examined())[0x68c44b] sql/sql_select.cc:1862(JOIN::init_execution())[0x653be2] sql/sql_select.cc:2455(JOIN::exec_inner())[0x655d58] sql/sql_select.cc:2258(JOIN::exec())[0x6550ad] sql/sql_select.cc:3195(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x6583a0] sql/sql_select.cc:363(handle_select(THD*, LEX*, select_result*, unsigned long))[0x64eff4] sql/sql_parse.cc:5067(execute_sqlcom_select)[0x6287ef] sql/sql_parse.cc:2501(mysql_execute_command(THD*))[0x621323] sql/sp_head.cc:3114(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x90fc2a] sql/sp_head.cc:2907(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x90f447] sql/sp_head.cc:3046(sp_instr_stmt::execute(THD*, unsigned int*))[0x90f9e2] sql/sp_head.cc:1326(sp_head::execute(THD*, bool))[0x90b882] sql/sp_head.cc:2105(sp_head::execute_procedure(THD*, List*))[0x90d4f3] sql/sql_parse.cc:4502(mysql_execute_command(THD*))[0x626c4c] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7feb880b9020): select * from t1, t2 where c1 = c2 LIMIT ROWS EXAMINED l Connection ID (thread ID): 296 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - skipping '/dev/shm/var_auto_j9wA/5/log/main.limit_rows_examined/' ***Warnings generated in error logs during shutdown after running tests: main.grant_lowercase_fs main.insert main.gcc296 main.help main.information_schema_parameters main.index_intersect main.group_min_max main.handlersocket main.index_merge_myisam main.key main.gis2 main.grant4 main.gis main.key_primary main.grant main.gis-rt-precise main.join_cache main.handler_read_last main.having main.in_datetime_241 main.key_diff main.gis-precise main.information_schema2 main.kill main.grant_cache_no_prot main.information_schema_db main.limit_rows_examined main.limit main.last_value main.gis-rtree main.grant_cache_ps_prot main.insert_select main.join_nested main.insert_update main.greedy_optimizer main.join_optimizer main.keywords main.grant2 main.join_crash main.join main.implicit_char_to_num_conversion main.information_schema_routines main.information_schema_chmod main.join_nested_jcl6 main.insert_notembedded mysqld: /home/psergey/dev2/10.0-monty/sql/item.cc:1394: virtual longlong Item_sp_variable::val_int(): Assertion `fixed' failed. Attempting backtrace. You can use the following information to find out main.mix2_myisam w2 [ pass ] 4078 main.mix2_myisam_ucs2 w2 [ pass ] 66 main.loaddata w5 [ pass ] 106 main.loadxml w5 [ pass ] 3215 main.locale w5 [ pass ] 10 main.mrr_icp_extra w2 [ pass ] 10253 main.myisam-system w2 [ pass ] 10 main.myisam_debug w2 [ pass ] 172 main.lock_multi w5 [ pass ] 7559 main.myisam_icp w2 [ pass ] 376 main.myisam_icp_notembedded w2 [ pass ] 356 main.myisam_mrr w2 [ pass ] 370 main.myisampack w2 [ pass ] 807 main.lock_multi_bug38499 w5 [ pass ] 3157 main.mysql w2 [ pass ] 1456 main.mysql-bug41486 w2 [ pass ] 297 main.mysql-bug45236 w2 [ pass ] 196 main.mysql_comments w2 [ pass ] 46 main.mysql_cp932 w2 [ pass ] 33 main.mysql_locale_posix w2 [ pass ] 164 main.mysql_not_windows w2 [ pass ] 5 main.lock_multi_bug38691 w5 [ pass ] 1965 main.mysql_protocols w2 [ pass ] 32 main.log_slow w5 [ pass ] 12 main.log_tables_debug w5 [ pass ] 14 main.lowercase_fs_off w5 [ pass ] 256 main.mysqladmin w2 [ pass ] 1026 main.mysqld--defaults-file w2 [ pass ] 39 main.mysqld--help 'unix' w2 [ pass ] 206 main.order_by w5 [ pass ] 5887 main.order_by_sortkey w5 [ pass ] 2398 main.order_fill_sortbuf w5 [ pass ] 1346 main.outfile w5 [ pass ] 18 main.mysqld_option_err w2 [ pass ] 9189 main.outfile_loaddata w5 [ pass ] 70 main.overflow w5 [ pass ] 6 main.packet w5 [ pass ] 14 main.parser w5 [ pass ] 110 main.parser_not_embedded w5 [ pass ] 11 main.mysqlhotcopy_myisam w2 [ pass ] 766 main.parser_precedence w5 [ pass ] 52 main.mysqlshow w2 [ pass ] 114 main.parser_stack w5 [ pass ] 2448 main.perror w5 [ pass ] 16 main.perror-win w5 [ skipped ] Need windows main.mysqlslap w2 [ pass ] 5241 main.plugin w5 [ fail ] Test ended at 2013-07-04 18:04:10 CURRENT_TEST: main.plugin mysqltest: At line 36: query 'DROP TABLE t1' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > example_enum_var e1 example_ulong_var 500 UNINSTALL SONAME 'ha_example'; Warnings: Warning 1620 Plugin is busy and will be uninstalled on shutdown select * from information_schema.plugins where plugin_library like 'ha_example%'; PLUGIN_NAME EXAMPLE PLUGIN_VERSION 0.1 PLUGIN_STATUS DELETED PLUGIN_TYPE STORAGE ENGINE PLUGIN_TYPE_VERSION # PLUGIN_LIBRARY ha_example.so PLUGIN_LIBRARY_VERSION 1.5 PLUGIN_AUTHOR Brian Aker, MySQL AB PLUGIN_DESCRIPTION Example storage engine PLUGIN_LICENSE GPL LOAD_OPTION ON PLUGIN_MATURITY Experimental PLUGIN_AUTH_VERSION 0.1 DROP TABLE t1; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/5/log/plugin.log Server [mysqld.1 - pid: 22216, winpid: 22216, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 130704 18:04:07 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=2 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x2986550 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f9552d72df8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] sql/table.cc:456(TABLE_SHARE::destroy())[0x6e6592] sql/table.cc:494(free_table_share(TABLE_SHARE*))[0x6e66fc] sql/sql_base.cc:437(table_def_free_entry)[0x5bdb4d] mysys/hash.c:608(my_hash_delete)[0xdc388b] sql/sql_base.cc:871(release_table_share(TABLE_SHARE*))[0x5be974] sql/table.cc:2772(closefrm(TABLE*, bool))[0x6ecbdf] sql/sql_base.cc:1006(intern_close_table(TABLE*))[0x5bef60] sql/sql_base.cc:1030(free_cache_entry)[0x5befcd] sql/sql_base.cc:9770(tdc_remove_table(THD*, enum_tdc_remove_table_type, char const*, char const*, bool))[0x5d0ef6] sql/sql_table.cc:2101(mysql_rm_table(THD*, TABLE_LIST*, char, char))[0x6b9dc8] sql/sql_parse.cc:3538(mysql_execute_command(THD*))[0x623df4] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f954803ff38): DROP TABLE t1 Connection ID (thread ID): 139 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - skipping '/dev/shm/var_auto_j9wA/5/log/main.plugin/' ***Warnings generated in error logs during shutdown after running tests: main.lock_multi main.log_slow main.outfile main.overflow main.order_by main.perror-win main.order_fill_sortbuf main.parser_precedence main.parser_stack main.loaddata main.lock_multi_bug38499 main.plugin main.order_by_sortkey main.parser main.outfile_loaddata main.packet main.lock_multi_bug38691 main.lowercase_fs_off main.perror main.loadxml main.parser_not_embedded main.log_tables_debug main.locale 130704 18:04:07 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out main.mysqltest_256 w2 [ pass ] main.mysqltest_cont_on_error w2 [ pass ] 13 main.mysqltest_ps w2 [ skipped ] Need ps-protocol main.plugin_not_embedded w5 [ pass ] 13 main.negation_elimination w2 [ pass ] 34 main.no_binlog w2 [ pass ] 1 main.non_blocking_api w2 [ pass ] 4 main.not_embedded_server w2 [ pass ] 116 main.not_partition w2 [ skipped ] Test requires: 'not_partition' main.null w2 [ pass ] 66 main.null_key w2 [ pass ] 888 main.odbc w2 [ pass ] 6 main.olap w2 [ pass ] 87 main.openssl_1 w2 [ pass ] 828 main.preload w5 [ pass ] 3104 main.rename w2 [ pass ] 39 main.renamedb w2 [ pass ] 1 main.profiling w5 [ pass ] 178 main.ps_10nestset w5 [ pass ] 12 main.ps_11bugs w5 [ pass ] 34 main.repair w2 [ fail ] Test ended at 2013-07-04 18:04:14 CURRENT_TEST: main.repair mysqltest: At line 158: query 'REPAIR TABLE tt1 USE_FRM' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > test.t1 repair status OK SHOW TABLE STATUS LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment t1 MyISAM 10 Fixed 2 7 14 1970324836974591 1024 0 NULL # # NULL latin1_swedish_ci NULL SELECT * FROM t1; id 1 2 REPAIR TABLE t1 USE_FRM; Table Op Msg_type Msg_text test.t1 repair warning Number of rows changed from 0 to 2 test.t1 repair status OK SELECT * FROM t1; id 1 2 DROP TABLE t1; DROP TABLE IF EXISTS tt1; CREATE TEMPORARY TABLE tt1 (c1 INT); REPAIR TABLE tt1 USE_FRM; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/repair.log Server [mysqld.1 - pid: 21965, winpid: 21965, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 130704 18:04:14 [Note] Found 1 of 0 rows when repairing './test/t1' 130704 18:04:14 [Note] Found 1 of 0 rows when repairing './test/t1' 130704 18:04:14 [Warning] Warning: Enabling keys got errno 12 on test.t1, retrying 130704 18:04:14 [Note] Retrying repair of: './test/t1' with keycache 130704 18:04:14 [Note] Found 2 of 0 rows when repairing './test/t1' mysqld: /home/psergey/dev2/10.0-monty/sql/sql_base.cc:6452: bool open_temporary_table(THD*, TABLE_LIST*): Assertion `tl->table == __null' failed. 130704 18:04:14 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=6 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x34b4550 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7fdf4fe1adf8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] sql/sql_base.cc:6460(open_temporary_table(THD*, TABLE_LIST*))[0x5c93ab] sql/sql_base.cc:6547(open_temporary_tables(THD*, TABLE_LIST*))[0x5c96fb] sql/sql_admin.cc:417(mysql_admin_table)[0x736e59] sql/sql_admin.cc:1214(Sql_cmd_repair_table::execute(THD*))[0x739859] sql/sql_parse.cc:4896(mysql_execute_command(THD*))[0x627ed1] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fdf44048e28): REPAIR TABLE tt1 USE_FRM Connection ID (thread ID): 1480 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - skipping '/dev/shm/var_auto_j9wA/2/log/main.repair/' ***Warnings generated in error logs during shutdown after running tests: main.renamedb main.not_partition main.mysqltest_cont_on_error main.mysql_cp932 main.myisam_debug main.mysql_not_windows main.no_binlog main.myisam-system main.myisam_icp main.mix2_myisam main.not_embedded_server main.mrr_icp_extra main.mysqld_option_err main.mysql-bug45236 main.null main.odbc main.mix2_myisam_ucs2 main.rename main.mysql_locale_posix main.mysql_protocols main.mysqlhotcopy_myisam main.mysqld--help main.myisam_icp_notembedded main.openssl_1 main.mysql-bug41486 main.mysqlshow main.mysqld--defaults-file main.mysqltest_ps main.metadata main.mysqladmin main.mysqltest_256 main.negation_elimination main.myisampack main.mysql_comments main.olap main.mysql main.non_blocking_api main.merge_debug main.mysqlslap main.repair main.null_key main.myisam_mrr 130704 18:04:14 [Warning] Warning: Enabling keys got errno 12 on test.t1, retrying mysqld: /home/psergey/dev2/10.0-monty/sql/sql_base.cc:6452: bool open_temporary_table(THD*, TABLE_LIST*): Assertion `tl->table == __null' failed. Attempting backtrace. You can use the following information to find out main.replace w2 [ pass ] 14 main.ps_1general w5 [ pass ] 443 main.rollback w2 [ pass ] 4 main.round w2 [ pass ] 42 main.row w2 [ pass ] 119 main.ps_2myisam w5 [ pass ] 488 main.schema w2 [ pass ] 50 main.ps_4heap w5 [ pass ] 337 main.ps_5merge w5 [ pass ] 726 main.ps_ddl w5 [ fail ] Test ended at 2013-07-04 18:04:17 CURRENT_TEST: main.ps_ddl --- /data0/psergey/dev2/10.0-monty/mysql-test/r/ps_ddl.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/ps_ddl.reject 2013-07-04 18:04:17.739869026 +0400 @@ -487,8 +487,8 @@ execute stmt; a call p_verify_reprepare_count(1); -SUCCESS - +ERROR +Expected: 1, actual: 0 execute stmt; a call p_verify_reprepare_count(0); @@ -516,8 +516,8 @@ count(*) 1 call p_verify_reprepare_count(1); -SUCCESS - +ERROR +Expected: 1, actual: 0 execute stmt; count(*) 1 @@ -637,8 +637,8 @@ execute stmt; a call p_verify_reprepare_count(1); -SUCCESS - +ERROR +Expected: 1, actual: 0 select * from t1; a b drop temporary table t1; @@ -1829,8 +1829,8 @@ Warnings: Note 1050 Table 't2' already exists call p_verify_reprepare_count(1); -SUCCESS - +ERROR +Expected: 1, actual: 0 select * from t2; a 1 @@ -1851,8 +1851,8 @@ select * from t2; a call p_verify_reprepare_count(1); -SUCCESS - +ERROR +Expected: 1, actual: 0 drop table t1; create table t1 (x int); execute stmt; mysqltest: Result length mismatch Warnings from just before the error: Note 1051 Unknown table 'test.v1' - skipping '/dev/shm/var_auto_j9wA/5/log/main.ps_ddl/' main.ps_ddl1 w5 [ pass ] 118 main.ps_grant w5 [ pass ] 17 main.ps_not_windows w5 [ pass ] 6 main.query_cache_28249 w5 [ pass ] 17 main.query_cache_merge w5 [ pass ] 1328 main.select w2 [ fail ] Test ended at 2013-07-04 18:04:24 CURRENT_TEST: main.select --- /data0/psergey/dev2/10.0-monty/mysql-test/r/select.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/select.reject 2013-07-04 18:04:24.393869600 +0400 @@ -4175,10 +4175,14 @@ set SQL_MODE=TRADITIONAL; select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34'; str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34' -1 +0 +Warnings: +Warning 1292 Incorrect datetime value: '2007-10-00 12:34' select str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34'; str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34' 0 +Warnings: +Warning 1292 Incorrect datetime value: '2007-10-00 12:34' select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-01 12:34'; str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-01 12:34' 0 mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.select/' main.select_debug w2 [ pass ] 41 main.select_found w2 [ pass ] 179 main.query_cache_notembedded w5 [ pass ] 6282 main.query_cache_ps_no_prot w5 [ pass ] 69 main.query_cache_ps_ps_prot w5 [ skipped ] Test requires: ps-protocol enabled, other protocols disabled main.query_cache_with_views w5 [ pass ] 46 main.range_vs_index_merge w5 [ pass ] 4335 main.read_only w5 [ pass ] 141 main.sp-error w5 [ fail ] Test ended at 2013-07-04 18:04:32 CURRENT_TEST: main.sp-error --- /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-error.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-error.reject 2013-07-04 18:04:32.203870274 +0400 @@ -466,7 +466,7 @@ end| create table t5 (x int)| call bug3294()| -ERROR 42S02: Unknown table 't5' +ERROR 42S02: Unknown table 'test.t5' drop procedure bug3294| drop procedure if exists bug8776_1| drop procedure if exists bug8776_2| @@ -1344,8 +1344,6 @@ select func_20713_a(); func_20713_a() NULL -Warnings: -Error 1146 Table 'test.bogus_table_20713' doesn't exist select @in_func; @in_func 2 @@ -1353,8 +1351,6 @@ select func_20713_b(); func_20713_b() NULL -Warnings: -Error 1146 Table 'test.bogus_table_20713' doesn't exist select @in_func; @in_func 2 @@ -1567,7 +1563,7 @@ 1 drop function f2; drop table t2; -ERROR 42S02: Unknown table 't2' +ERROR 42S02: Unknown table 'test.t2' End of 5.1 tests drop procedure if exists proc_33983_a; drop procedure if exists proc_33983_b; @@ -1821,11 +1817,8 @@ c 3 @@warning_count -1 +0 Level Code Message -Warning 1292 Truncated incorrect INTEGER value: '10 ' -Warnings: -Warning 1292 Truncated incorrect INTEGER value: '10 ' CALL p6(); CAST('10 ' as unsigned integer) 10 @@ -1833,8 +1826,6 @@ Warning 1292 Truncated incorrect INTEGER value: '10 ' c 1 -Warnings: -Warning 1292 Truncated incorrect INTEGER value: '10 ' DROP PROCEDURE p1; DROP PROCEDURE p2; DROP PROCEDURE p3; @@ -1885,9 +1876,6 @@ CALL p1(); exception exception -Warnings: -Warning 1292 Truncated incorrect INTEGER value: '10 ' -Error 1048 Column 'b' cannot be null DROP TABLE t1; DROP PROCEDURE p1; # @@ -1931,11 +1919,8 @@ NULL warning caught (expected) warning caught (expected) -Warnings: -Warning 1365 Division by 0 SHOW WARNINGS; Level Code Message -Warning 1365 Division by 0 CALL p2(); 5 / 0 NULL mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/5/log/main.sp-error/' main.sp-fib w5 [ pass ] 11 main.sp-lock w5 [ pass ] 881 main.sp-no-code w5 [ skipped ] Does not run with debug binaries main.sp-prelocking w5 [ pass ] 114 main.sp-security w5 [ pass ] 177 main.select_jcl6 w2 [ fail ] Test ended at 2013-07-04 18:04:34 CURRENT_TEST: main.select_jcl6 --- /data0/psergey/dev2/10.0-monty/mysql-test/r/select_jcl6.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/select_jcl6.reject 2013-07-04 18:04:34.540870475 +0400 @@ -4186,10 +4186,14 @@ set SQL_MODE=TRADITIONAL; select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34'; str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34' -1 +0 +Warnings: +Warning 1292 Incorrect datetime value: '2007-10-00 12:34' select str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34'; str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34' 0 +Warnings: +Warning 1292 Incorrect datetime value: '2007-10-00 12:34' select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-01 12:34'; str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-01 12:34' 0 mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.select_jcl6/' main.select_safe w2 [ pass ] 43 main.show_explain_ps w2 [ pass ] 60 main.show_profile w2 [ pass ] 6 main.signal w2 [ fail ] Test ended at 2013-07-04 18:04:36 CURRENT_TEST: main.signal --- /data0/psergey/dev2/10.0-monty/mysql-test/r/signal.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/signal.reject 2013-07-04 18:04:36.232870621 +0400 @@ -1191,8 +1191,6 @@ call test_signal() $$ Caught by SQLSTATE Caught by SQLSTATE -Warnings: -Warning 1012 Raising a warning drop procedure test_signal $$ create procedure test_signal() begin @@ -1208,8 +1206,6 @@ call test_signal() $$ Caught by number Caught by number -Warnings: -Warning 1012 Raising a warning drop procedure test_signal $$ create procedure test_signal() begin @@ -1225,8 +1221,6 @@ call test_signal() $$ Caught by SQLWARNING Caught by SQLWARNING -Warnings: -Warning 1012 Raising a warning drop procedure test_signal $$ create procedure test_signal() begin @@ -1242,8 +1236,6 @@ call test_signal() $$ Caught by SQLSTATE Caught by SQLSTATE -Warnings: -Error 1012 Raising a not found drop procedure test_signal $$ create procedure test_signal() begin @@ -1259,8 +1251,6 @@ call test_signal() $$ Caught by number Caught by number -Warnings: -Error 1012 Raising a not found drop procedure test_signal $$ create procedure test_signal() begin @@ -1276,8 +1266,6 @@ call test_signal() $$ Caught by NOT FOUND Caught by NOT FOUND -Warnings: -Error 1012 Raising a not found drop procedure test_signal $$ create procedure test_signal() begin @@ -1293,8 +1281,6 @@ call test_signal() $$ Caught by SQLSTATE Caught by SQLSTATE -Warnings: -Error 1012 Raising an error drop procedure test_signal $$ create procedure test_signal() begin @@ -1310,8 +1296,6 @@ call test_signal() $$ Caught by number Caught by number -Warnings: -Error 1012 Raising an error drop procedure test_signal $$ create procedure test_signal() begin @@ -1327,8 +1311,6 @@ call test_signal() $$ Caught by SQLEXCEPTION Caught by SQLEXCEPTION -Warnings: -Error 1012 Raising an error drop procedure test_signal $$ # # Test where SIGNAL can be used @@ -1557,7 +1539,7 @@ call test_resignal() $$ before RESIGNAL before RESIGNAL -ERROR 42S02: Unknown table 'no_such_table' +ERROR 42S02: Unknown table 'test.no_such_table' drop procedure test_resignal $$ create procedure test_resignal() begin @@ -1703,7 +1685,6 @@ after RESIGNAL after RESIGNAL Warnings: -Warning 1012 Raising a warning Warning 5555 RESIGNAL to warning drop procedure test_resignal $$ create procedure test_resignal() @@ -1727,7 +1708,6 @@ ERROR 02222: RESIGNAL to not found show warnings $$ Level Code Message -Warning 1012 Raising a warning Error 5555 RESIGNAL to not found drop procedure test_resignal $$ create procedure test_resignal() @@ -1751,7 +1731,6 @@ ERROR 33333: RESIGNAL to error show warnings $$ Level Code Message -Warning 1012 Raising a warning Error 5555 RESIGNAL to error drop procedure test_resignal $$ create procedure test_resignal() @@ -1775,7 +1754,6 @@ after RESIGNAL after RESIGNAL Warnings: -Error 1012 Raising a not found Warning 5555 RESIGNAL to warning drop procedure test_resignal $$ create procedure test_resignal() @@ -1799,7 +1777,6 @@ ERROR 02222: RESIGNAL to not found show warnings $$ Level Code Message -Error 1012 Raising a not found Error 5555 RESIGNAL to not found drop procedure test_resignal $$ create procedure test_resignal() @@ -1823,7 +1800,6 @@ ERROR 33333: RESIGNAL to error show warnings $$ Level Code Message -Error 1012 Raising a not found Error 5555 RESIGNAL to error drop procedure test_resignal $$ create procedure test_resignal() @@ -1847,7 +1823,6 @@ after RESIGNAL after RESIGNAL Warnings: -Error 1012 Raising an error Warning 5555 RESIGNAL to warning drop procedure test_resignal $$ create procedure test_resignal() @@ -1871,7 +1846,6 @@ ERROR 02222: RESIGNAL to not found show warnings $$ Level Code Message -Error 1012 Raising an error Error 5555 RESIGNAL to not found drop procedure test_resignal $$ create procedure test_resignal() @@ -1895,7 +1869,6 @@ ERROR 33333: RESIGNAL to error show warnings $$ Level Code Message -Error 1012 Raising an error Error 5555 RESIGNAL to error drop procedure test_resignal $$ create procedure test_resignal() @@ -1916,7 +1889,6 @@ after RESIGNAL after RESIGNAL Warnings: -Warning 1264 Out of range value for column 'a' at row 1 Warning 5555 RESIGNAL to a warning drop procedure test_resignal $$ create procedure test_resignal() @@ -1937,7 +1909,6 @@ ERROR 02444: RESIGNAL to a not found show warnings $$ Level Code Message -Warning 1264 Out of range value for column 'a' at row 1 Error 5555 RESIGNAL to a not found drop procedure test_resignal $$ create procedure test_resignal() @@ -1958,7 +1929,6 @@ ERROR 44444: RESIGNAL to an error show warnings $$ Level Code Message -Warning 1264 Out of range value for column 'a' at row 1 Error 5555 RESIGNAL to an error drop procedure test_resignal $$ create procedure test_resignal() @@ -1983,7 +1953,6 @@ after RESIGNAL after RESIGNAL Warnings: -Error 1329 No data - zero rows fetched, selected, or processed Warning 5555 RESIGNAL to a warning drop procedure test_resignal $$ create procedure test_resignal() @@ -2008,7 +1977,6 @@ ERROR 02444: RESIGNAL to a not found show warnings $$ Level Code Message -Error 1329 No data - zero rows fetched, selected, or processed Error 5555 RESIGNAL to a not found drop procedure test_resignal $$ create procedure test_resignal() @@ -2033,7 +2001,6 @@ ERROR 44444: RESIGNAL to an error show warnings $$ Level Code Message -Error 1329 No data - zero rows fetched, selected, or processed Error 5555 RESIGNAL to an error drop procedure test_resignal $$ create procedure test_resignal() @@ -2054,7 +2021,6 @@ after RESIGNAL after RESIGNAL Warnings: -Error 1051 Unknown table 'no_such_table' Warning 5555 RESIGNAL to a warning drop procedure test_resignal $$ create procedure test_resignal() @@ -2075,7 +2041,6 @@ ERROR 02444: RESIGNAL to a not found show warnings $$ Level Code Message -Error 1051 Unknown table 'no_such_table' Error 5555 RESIGNAL to a not found drop procedure test_resignal $$ create procedure test_resignal() @@ -2096,7 +2061,6 @@ ERROR 44444: RESIGNAL to an error show warnings $$ Level Code Message -Error 1051 Unknown table 'no_such_table' Error 5555 RESIGNAL to an error drop procedure test_resignal $$ # @@ -2199,15 +2163,10 @@ 3 3 Level Code Message -Error 1231 Variable 'sql_mode' can't be set to the value of 'NULL' -Error 1232 Variable 'sql_mode' can't be set to the value of 'NULL' Error 9999 Variable 'sql_mode' can't be set to the value of 'NULL' ERROR 42000: Hi, I am a useless error message show warnings $$ Level Code Message -Error 1231 Variable 'sql_mode' can't be set to the value of 'NULL' -Error 1232 Variable 'sql_mode' can't be set to the value of 'NULL' -Error 9999 Variable 'sql_mode' can't be set to the value of 'NULL' Error 9999 Hi, I am a useless error message drop procedure peter_p1 $$ drop procedure peter_p2 $$ @@ -2224,7 +2183,6 @@ ERROR 99002: Original show warnings $$ Level Code Message -Error 1 Original Error 2 Original drop procedure peter_p3 $$ drop table t_warn; mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.signal/' main.sp-threads w5 [ pass ] 2038 main.sp-ucs2 w5 [ pass ] 22 main.signal_code w2 [ pass ] 4 main.signal_demo1 w2 [ pass ] 37 main.sp-vars w5 [ pass ] 186 main.sp_gis w5 [ pass ] 14 main.signal_demo2 w2 [ pass ] 38 main.signal_demo3 w2 [ fail ] Test ended at 2013-07-04 18:04:37 CURRENT_TEST: main.signal_demo3 --- /data0/psergey/dev2/10.0-monty/mysql-test/r/signal_demo3.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/signal_demo3.reject 2013-07-04 18:04:37.253870709 +0400 @@ -77,15 +77,6 @@ ERROR 45000: Oops in proc_1 show warnings; Level Code Message -Error 1051 Unknown table 'oops_it_is_not_here' -Error 1644 Oops in proc_9 -Error 1644 Oops in proc_8 -Error 1644 Oops in proc_7 -Error 1644 Oops in proc_6 -Error 1644 Oops in proc_5 -Error 1644 Oops in proc_4 -Error 1644 Oops in proc_3 -Error 1644 Oops in proc_2 Error 1644 Oops in proc_1 SET @@session.max_error_count = 5; SELECT @@session.max_error_count; @@ -95,11 +86,7 @@ ERROR 45000: Oops in proc_1 show warnings; Level Code Message -Error 1051 Unknown table 'oops_it_is_not_here' -Error 1644 Oops in proc_9 -Error 1644 Oops in proc_8 -Error 1644 Oops in proc_7 -Error 1644 Oops in proc_6 +Error 1644 Oops in proc_1 SET @@session.max_error_count = 7; SELECT @@session.max_error_count; @@session.max_error_count @@ -108,13 +95,7 @@ ERROR 45000: Oops in proc_1 show warnings; Level Code Message -Error 1051 Unknown table 'oops_it_is_not_here' -Error 1644 Oops in proc_9 -Error 1644 Oops in proc_8 -Error 1644 Oops in proc_7 -Error 1644 Oops in proc_6 -Error 1644 Oops in proc_5 -Error 1644 Oops in proc_4 +Error 1644 Oops in proc_1 SET @@session.max_error_count = 9; SELECT @@session.max_error_count; @@session.max_error_count @@ -123,15 +104,7 @@ ERROR 45000: Oops in proc_1 show warnings; Level Code Message -Error 1051 Unknown table 'oops_it_is_not_here' -Error 1644 Oops in proc_9 -Error 1644 Oops in proc_8 -Error 1644 Oops in proc_7 -Error 1644 Oops in proc_6 -Error 1644 Oops in proc_5 -Error 1644 Oops in proc_4 -Error 1644 Oops in proc_3 -Error 1644 Oops in proc_2 +Error 1644 Oops in proc_1 drop database demo; SET @@global.max_error_count = @start_global_value; SELECT @@global.max_error_count; mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.signal_demo3/' main.signal_sqlmode w2 [ pass ] 26 main.sp_notembedded w5 [ pass ] 505 main.single_delete_update w2 [ pass ] 662 main.sp_stress_case w5 [ pass ] 3409 main.sp_sync w5 [ pass ] 52 main.sql_mode w5 [ pass ] 157 main.sp w2 [ fail ] Test ended at 2013-07-04 18:04:47 CURRENT_TEST: main.sp /data0/psergey/dev2/10.0-monty/client/mysqltest: Error on delete of '/dev/shm/var_auto_j9wA/2/tmp//t1.frm' (Errcode: 2 "No such file or directory") /data0/psergey/dev2/10.0-monty/client/mysqltest: Error on delete of '/dev/shm/var_auto_j9wA/2/tmp//t1.MYD' (Errcode: 2 "No such file or directory") --- /data0/psergey/dev2/10.0-monty/mysql-test/r/sp.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/sp.reject 2013-07-04 18:04:47.619871603 +0400 @@ -737,8 +737,6 @@ end| insert into t2 values ("foo", 42, -1.9), ("bar", 3, 12.1), ("zap", 666, -3.14)| call cur1()| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select * from t1| id data foo 40 @@ -774,8 +772,6 @@ close c2; end| call cur2()| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select * from t3 order by i,s| s i bar 3 @@ -865,8 +861,6 @@ set @@sql_mode = ''| set sql_select_limit = 1| call modes(@c1, @c2)| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed set sql_select_limit = default| select @c1, @c2| @c1 @c2 @@ -1688,64 +1682,42 @@ call h_ee()| h_ee Inner (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' call h_es()| h_es -Outer (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' +Inner (bad) call h_en()| h_en -Outer (good) -Warnings: -Warning 1329 No data - zero rows fetched, selected, or processed +Inner (bad) call h_ew()| h_ew -Outer (good) +Inner (bad) call h_ex()| h_ex -Outer (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' +Inner (bad) call h_se()| h_se Inner (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' call h_ss()| h_ss Inner (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' call h_sn()| h_sn -Outer (good) -Warnings: -Warning 1329 No data - zero rows fetched, selected, or processed +Inner (bad) call h_sw()| h_sw -Outer (good) +Inner (bad) call h_sx()| h_sx -Outer (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' +Inner (bad) call h_ne()| h_ne Inner (good) -Warnings: -Warning 1329 No data - zero rows fetched, selected, or processed call h_ns()| h_ns Inner (good) -Warnings: -Warning 1329 No data - zero rows fetched, selected, or processed call h_nn()| h_nn Inner (good) -Warnings: -Warning 1329 No data - zero rows fetched, selected, or processed call h_we()| h_we Inner (good) @@ -1758,18 +1730,12 @@ call h_xe()| h_xe Inner (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' call h_xs()| h_xs Inner (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' call h_xx()| h_xx Inner (good) -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' drop table t3| drop procedure h_ee| drop procedure h_es| @@ -1918,8 +1884,6 @@ close c1; end| call bug2260()| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select @x2| @x2 2 @@ -2063,8 +2027,6 @@ insert into t3 values (0); end| call bug2780()| -Warnings: -Warning 1264 Out of range value for column 's1' at row 1 select @x| @x 1 @@ -2487,8 +2449,6 @@ select s1 from t3 union select s2 from t3; end| call bug4904()| -Warnings: -Error 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,IMPLICIT) for operation 'UNION' drop procedure bug4904| drop table t3| drop procedure if exists bug336| @@ -2628,17 +2588,13 @@ row_count() 1 call bug4905()| -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' select row_count()| row_count() --1 +0 call bug4905()| -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' select row_count()| row_count() --1 +0 select * from t3| s1 1 @@ -2659,14 +2615,10 @@ call bug6029()| sqlstate 23000 sqlstate 23000 -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' delete from t3| call bug6029()| 1136 1136 -Warnings: -Error 1136 Column count doesn't match value count at row 1 drop procedure bug6029| drop table t3| drop procedure if exists bug8540| @@ -2961,23 +2913,15 @@ call bug6900()| 2 2 -Warnings: -Error 1136 Column count doesn't match value count at row 1 call bug9074()| x1 x2 x3 x4 x5 x6 1 1 1 1 1 1 -Warnings: -Error 1062 Duplicate entry 'a' for key 'w' call bug6900_9074(0)| sqlexception sqlexception -Warnings: -Error 1136 Column count doesn't match value count at row 1 call bug6900_9074(1)| -23000 -23000 -Warnings: -Error 1062 Duplicate entry 'a' for key 'w' +sqlexception +sqlexception drop procedure bug6900| drop procedure bug9074| drop procedure bug6900_9074| @@ -3020,13 +2964,9 @@ call bug9856()| 16 16 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed call bug9856()| 16 16 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed drop procedure bug9856| drop procedure if exists bug9674_1| drop procedure if exists bug9674_2| @@ -3256,8 +3196,6 @@ 2 x 3 -Warnings: -Error 1326 Cursor is not open call bug10961()| x 1 @@ -3265,8 +3203,6 @@ 2 x 3 -Warnings: -Error 1326 Cursor is not open drop procedure bug10961| DROP PROCEDURE IF EXISTS bug6866| DROP VIEW IF EXISTS tv| @@ -3274,9 +3210,9 @@ Note 1051 Unknown table 'test.tv' DROP TABLE IF EXISTS tt1,tt2,tt3| Warnings: -Note 1051 Unknown table 'tt1' -Note 1051 Unknown table 'tt2' -Note 1051 Unknown table 'tt3' +Note 1051 Unknown table 'test.tt1' +Note 1051 Unknown table 'test.tt2' +Note 1051 Unknown table 'test.tt3' CREATE TABLE tt1 (a1 int, a2 int, a3 int, data varchar(10))| CREATE TABLE tt2 (a2 int, data2 varchar(10))| CREATE TABLE tt3 (a3 int, data3 varchar(10))| @@ -3382,11 +3318,7 @@ ('Name4', 13), ('Name5', 14)| call bug11529()| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed call bug11529()| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed delete from t1| drop procedure bug11529| set character set utf8| @@ -3560,32 +3492,24 @@ end if; end| call bug12168('a')| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select * from t4| a 1 3 truncate t4| call bug12168('b')| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select * from t4| a 2 4 truncate t4| call bug12168('a')| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select * from t4| a 1 3 truncate t4| call bug12168('b')| -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select * from t4| a 2 @@ -3885,8 +3809,6 @@ call bug7049_2()| Result Caught it -Warnings: -Error 1062 Duplicate entry '42' for key 'x' select * from t3| x 42 @@ -3894,16 +3816,12 @@ call bug7049_4()| Result Caught it -Warnings: -Error 1062 Duplicate entry '42' for key 'x' select * from t3| x 42 select bug7049_2()| bug7049_2() 1 -Warnings: -Error 1062 Duplicate entry '42' for key 'x' drop table t3| drop procedure bug7049_1| drop procedure bug7049_2| @@ -4031,8 +3949,6 @@ call bug14845()| a 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed drop procedure bug14845| drop procedure if exists bug13549_1| drop procedure if exists bug13549_2| @@ -4236,8 +4152,6 @@ call bug13729()| 55 55 -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' select * from t3| s1 1 @@ -4274,15 +4188,11 @@ boo v isnull(v) NULL 1 -Warnings: -Error 1054 Unknown column 'undefined_var' in 'field list' call bug14643_2()| Handler boo Handler boo -Warnings: -Error 1054 Unknown column 'undefined_var' in 'field list' drop procedure bug14643_1| drop procedure bug14643_2| drop procedure if exists bug14304| @@ -4606,15 +4516,11 @@ error End done -Warnings: -Error 1054 Unknown column 'v' in 'field list' call bug14498_2()| Handler error End done -Warnings: -Error 1054 Unknown column 'v' in 'field list' call bug14498_3()| v maybe @@ -4622,22 +4528,16 @@ error End done -Warnings: -Error 1054 Unknown column 'v' in 'field list' call bug14498_4()| Handler error End done -Warnings: -Error 1054 Unknown column 'v' in 'field list' call bug14498_5()| Handler error End done -Warnings: -Error 1054 Unknown column 'v' in 'field list' drop procedure bug14498_1| drop procedure bug14498_2| drop procedure bug14498_3| @@ -4702,8 +4602,6 @@ After NOT FOUND condtition is triggered xid xdone 1 1 -Warnings: -Warning 1329 No data - zero rows fetched, selected, or processed call bug15231_3()| Result Missed it (correct) @@ -4711,8 +4609,6 @@ Warning 1366 Incorrect decimal value: 'zap' for column 'x' at row 1 Result Caught it (correct) -Warnings: -Warning 1366 Incorrect decimal value: 'zap' for column 'x' at row 1 call bug15231_5()| Result Missed it (correct) @@ -4741,8 +4637,6 @@ call bug15011()| Handler Inner -Warnings: -Error 1062 Duplicate entry '1' for key 'PRIMARY' drop procedure bug15011| drop table t3| drop procedure if exists bug17476| @@ -4818,8 +4712,6 @@ 1 i 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed drop table t3| drop procedure bug16887| drop procedure if exists bug16474_1| @@ -4892,8 +4784,6 @@ select no_such_function(); end| call bug18787()| -Warnings: -Error 1305 FUNCTION test.no_such_function does not exist drop procedure bug18787| create database bug18344_012345678901| use bug18344_012345678901| @@ -5267,8 +5157,6 @@ statement failed statement after update statement after update -Warnings: -Error 1242 Subquery returns more than 1 row select * from t3| a 1 @@ -5280,8 +5168,6 @@ statement failed statement after update statement after update -Warnings: -Error 1242 Subquery returns more than 1 row select * from t3| a 1 @@ -5314,8 +5200,6 @@ in continue handler reachable code a2 reachable code a2 -Warnings: -Error 1242 Subquery returns more than 1 row select * from t3| a 1 @@ -5331,8 +5215,6 @@ in continue handler reachable code a2 reachable code a2 -Warnings: -Error 1242 Subquery returns more than 1 row select * from t3| a 1 @@ -5366,8 +5248,6 @@ in continue handler reachable code a2 reachable code a2 -Warnings: -Error 1305 FUNCTION test.no_such_function does not exist drop procedure bug8153_proc_a| drop procedure bug8153_proc_b| drop table t3| @@ -5936,13 +5816,9 @@ select func_8407_a()| func_8407_a() NULL -Warnings: -Error 1146 Table 'test.no_such_view' doesn't exist select func_8407_b()| func_8407_b() 1500 -Warnings: -Error 1146 Table 'test.no_such_view' doesn't exist drop function func_8407_a| drop function func_8407_b| drop table if exists table_26503| @@ -6064,8 +5940,6 @@ looping 0 leaving handler leaving handler -Warnings: -Error 1062 Duplicate entry '1' for key 'a' call proc_26503_ok_2(2)| do something do something @@ -6077,8 +5951,6 @@ looping 4 leaving handler leaving handler -Warnings: -Error 1062 Duplicate entry '2' for key 'a' call proc_26503_ok_3(3)| do something do something @@ -6098,8 +5970,6 @@ looping 0 leaving handler leaving handler -Warnings: -Error 1062 Duplicate entry '3' for key 'a' call proc_26503_ok_4(4)| do something do something @@ -6111,8 +5981,6 @@ looping 4 leaving handler leaving handler -Warnings: -Error 1062 Duplicate entry '4' for key 'a' drop table table_26503| drop procedure proc_26503_ok_1| drop procedure proc_26503_ok_2| @@ -6826,8 +6694,6 @@ SELECT x FROM t1; END| CALL bug29770(); -Warnings: -Error 1054 Unknown column 'x' in 'field list' SELECT @state, @exception; @state @exception run NULL @@ -6866,8 +6732,6 @@ end while; end// call proc_33618(20); -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed drop table t_33618; drop procedure proc_33618; # @@ -7803,9 +7667,6 @@ SELECT f1(); f1() 1 -Warnings: -Error 1424 Recursive stored functions and triggers are not allowed. -Error 1305 FUNCTION test.f1 does not exist DROP FUNCTION f1; # ------------------------------------------------------------------ # -- End of 5.1 tests mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.sp/' main.sp-big w2 [ fail ] Test ended at 2013-07-04 18:04:48 CURRENT_TEST: main.sp-big --- /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-big.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-big.reject 2013-07-04 18:04:48.590871687 +0400 @@ -46,8 +46,6 @@ close cur1; end| call p1(); -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed select count(*) from t1; count(*) 256 mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.sp-big/' main.sp-bugs w2 [ fail ] Test ended at 2013-07-04 18:04:49 CURRENT_TEST: main.sp-bugs --- /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-bugs.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-bugs.reject 2013-07-04 18:04:49.040871726 +0400 @@ -43,8 +43,6 @@ SELECT f2 (); f2 () NULL -Warnings: -Error 1305 FUNCTION testdb.f_not_exists does not exist DROP SCHEMA testdb; USE test; # mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.sp-bugs/' main.sp-code w2 [ fail ] Test ended at 2013-07-04 18:04:49 CURRENT_TEST: main.sp-code --- /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-code.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-code.reject 2013-07-04 18:04:49.529871768 +0400 @@ -711,8 +711,6 @@ looping 1 looping i looping 0 -Warnings: -Error 1062 Duplicate entry '1' for key 'a' call proc_26977_works(2); do something do something @@ -732,8 +730,6 @@ looping 0 optimizer: keep hreturn optimizer: keep hreturn -Warnings: -Error 1062 Duplicate entry '2' for key 'a' drop table t1; drop procedure proc_26977_broken; drop procedure proc_26977_works; mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.sp-code/' main.ssl w5 [ pass ] 7788 main.sp-destruct w2 [ fail ] Test ended at 2013-07-04 18:04:50 CURRENT_TEST: main.sp-destruct --- /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-destruct.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/sp-destruct.reject 2013-07-04 18:04:50.100871817 +0400 @@ -149,7 +149,7 @@ # The below statement should not cause assertion failure. drop database mysqltest; Warnings: -Error 1728 Column count of mysql.proc is wrong. Expected 20, found 19. The table is probably corrupted +Error 1805 Column count of mysql.proc is wrong. Expected 20, found 19. The table is probably corrupted # Restore mysql.proc. drop table mysql.proc; # @@ -166,7 +166,7 @@ ALTER TABLE mysql.proc MODIFY comment CHAR (32); DROP DATABASE db1; Warnings: -Error 1729 Cannot load from mysql.proc. The table is probably corrupted +Error 1728 Cannot load from mysql.proc. The table is probably corrupted # Restore mysql.proc DROP TABLE mysql.proc; RENAME TABLE proc_backup TO mysql.proc; mysqltest: Result content mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.sp-destruct/' ***Warnings generated in error logs during shutdown after running tests: main.sp-destruct 130704 18:04:50 [ERROR] Column count of mysql.proc is wrong. Expected 20, found 19. The table is probably corrupted 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_1': invalid value in column mysql.proc.character_set_client. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_1': invalid value in column mysql.proc.collation_connection. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_1': invalid value in column mysql.proc.db_collation. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_1': invalid value in column mysql.proc.character_set_client. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_1': invalid value in column mysql.proc.collation_connection. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_1': invalid value in column mysql.proc.db_collation. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_2': invalid value in column mysql.proc.character_set_client. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_2': invalid value in column mysql.proc.collation_connection. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_2': invalid value in column mysql.proc.db_collation. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_2': invalid value in column mysql.proc.character_set_client. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_2': invalid value in column mysql.proc.collation_connection. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_2': invalid value in column mysql.proc.db_collation. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_3': invalid value in column mysql.proc.character_set_client. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_3': invalid value in column mysql.proc.collation_connection. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_3': invalid value in column mysql.proc.db_collation. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_3': invalid value in column mysql.proc.character_set_client. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_3': invalid value in column mysql.proc.collation_connection. 130704 18:04:50 [Warning] Stored routine 'test'.'bug14233_3': invalid value in column mysql.proc.db_collation. main.sp-dynamic w2 [ pass ] 95 main.subselect w2 [ pass ] 3614 main.subselect3 w2 [ pass ] 573 main.subselect3_jcl6 w2 [ pass ] 580 main.subselect4 w2 [ pass ] 376 main.subselect_cache w2 [ pass ] 1014 main.subselect_debug w2 [ pass ] 7 main.ssl_compress w5 [ pass ] 7730 main.subselect_extra w2 [ pass ] 260 main.subselect_extra_no_semijoin w2 [ pass ] 655 main.subselect_gis w2 [ pass ] 7 main.subselect_mat w2 [ pass ] 473 main.subselect_mat_cost_bugs w2 [ pass ] 88 main.ssl_connect w5 [ pass ] 3762 main.status2 w5 [ pass ] 14 main.status_bug17954 w5 [ pass ] 9 main.str_to_datetime_457 w5 [ pass ] 3 main.strict_autoinc_1myisam w5 [ pass ] 4 main.strict_autoinc_3heap w5 [ pass ] 3 main.subselect_sj w5 [ pass ] 489 main.subselect_sj_aria w5 [ pass ] 23 main.subselect_no_mat w2 [ pass ] 3759 main.subselect_sj_jcl6 w5 [ pass ] 726 main.subselect_sj_mat w5 [ pass ] 369 main.subselect_sj_nonmerged w5 [ pass ] 62 main.sum_distinct w5 [ pass ] 716 main.symlink w5 [ pass ] 1573 main.synchronization w5 [ pass ] 84 main.system_mysql_db w5 [ pass ] 13 main.subselect_no_opts w2 [ pass ] 3789 main.system_mysql_db_refs w5 [ pass ] 34 main.table_elim w5 [ pass ] 154 main.table_elim_debug w5 [ pass ] 6 main.table_options w5 [ pass ] 30 main.tablelock w5 [ pass ] 30 main.timezone w5 [ pass ] 8 main.timezone2 w5 [ pass ] 44 main.timezone3 w5 [ pass ] 7 main.timezone4 w5 [ pass ] 1 main.timezone_grant w5 [ pass ] 31 main.subselect_no_scache w2 [ pass ] 3848 main.trigger w5 [ pass ] 858 main.trigger-compat w5 [ pass ] 68 main.trigger_notembedded w5 [ pass ] 2254 main.truncate w5 [ pass ] 29 main.subselect_no_semijoin w2 [ pass ] 4512 main.subselect_notembedded w2 [ pass ] 267 main.subselect_nulls w2 [ pass ] 30 main.subselect_partial_match w2 [ pass ] 384 main.type_ranges w2 [ pass ] 97 main.type_set w2 [ pass ] 37 main.type_time w2 [ pass ] 54 main.type_timestamp w2 [ pass ] 198 main.type_uint w2 [ pass ] 7 main.type_varchar w2 [ pass ] 205 main.type_year w2 [ pass ] 91 main.udf w2 [ pass ] 179 main.udf_query_cache w2 [ pass ] 15 main.update_ignore_216 w2 [ pass ] 8 main.upgrade w2 [ fail ] Test ended at 2013-07-04 18:05:20 CURRENT_TEST: main.upgrade mysqltest: At line 45: query 'create table `txu@0023p@0023p1` (s1 int)' succeeded - should have failed with errno 1050... The result from queries just before the failure was: < snip > mysqltest-1 CREATE DATABASE `mysqltest-1` /*!40100 DEFAULT CHARACTER SET latin1 */ show create database `#mysql50#mysqltest-1`; ERROR 42000: Unknown database '#mysql50#mysqltest-1' show tables in `mysqltest1`; Tables_in_mysqltest1 t1 t-1 show tables in `mysqltest-1`; Tables_in_mysqltest-1 t1 t-1 drop database `mysqltest1`; drop database `mysqltest-1`; drop table if exists `txu@0023p@0023p1`; drop table if exists `txu#p#p1`; create table `txu#p#p1` (s1 int); insert into `txu#p#p1` values (1); select * from `txu@0023p@0023p1`; ERROR 42S02: Table 'test.txu@0023p@0023p1' doesn't exist create table `txu@0023p@0023p1` (s1 int); More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/upgrade.log - skipping '/dev/shm/var_auto_j9wA/2/log/main.upgrade/' main.user_var w2 [ pass ] 199 main.varbinary w2 [ pass ] 44 main.variables_community w2 [ pass ] 5 main.view w2 [ fail ] Test ended at 2013-07-04 18:05:23 CURRENT_TEST: main.view mysqltest: At line 2023: query 'CREATE VIEW v1 AS SELECT f1()' succeeded - should have failed with errno 1352... The result from queries just before the failure was: < snip > call p1(); ERROR 42S02: Table 'test.t1' doesn't exist call p1(); ERROR 42S02: Table 'test.t1' doesn't exist drop procedure p1; create table t1 (f1 int); create table t2 (f1 int); insert into t1 values (1); insert into t2 values (2); create view v1 as select * from t1 union select * from t2 union all select * from t2; select * from v1; f1 1 2 2 drop view v1; drop table t1,t2; CREATE TEMPORARY TABLE t1 (a int); CREATE FUNCTION f1 () RETURNS int RETURN (SELECT COUNT(*) FROM t1); CREATE VIEW v1 AS SELECT f1(); More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/view.log - skipping '/dev/shm/var_auto_j9wA/2/log/main.view/' main.view_alias w2 [ pass ] 107 main.view_grant w2 [ pass ] 999 main.wait_timeout w2 [ pass ] 4105 main.warnings_engine_disabled w2 [ pass ] 13 main.windows w2 [ skipped ] Need windows main.xml w2 [ pass ] 182 main.auth_rpl 'mix' w2 [ pass ] 1454 main.rpl_mysqldump_slave 'mix' w2 [ pass ] 1454 main.stat_tables_repl 'row' w2 [ pass ] 1324 main.auth_rpl 'row' w2 [ pass ] 1458 main.partition_debug_sync w3 [ fail ] Test ended at 2013-07-04 18:05:49 CURRENT_TEST: main.partition_debug_sync mysqltest: At line 45: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction The result from queries just before the failure was: < snip > b INTEGER NOT NULL, KEY (b)) ENGINE = MYISAM /*!50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2), PARTITION p1 VALUES LESS THAN (20), PARTITION p2 VALUES LESS THAN (100), PARTITION p3 VALUES LESS THAN MAXVALUE ) */; SET SESSION debug_dbug= "+d,sleep_before_create_table_no_lock"; SET DEBUG_SYNC= 'alter_table_before_create_table_no_lock SIGNAL removing_partitioning WAIT_FOR waiting_for_alter'; SET DEBUG_SYNC= 'alter_table_before_main_binlog SIGNAL partitioning_removed'; ALTER TABLE t1 REMOVE PARTITIONING; # Con default SET DEBUG_SYNC= 'now WAIT_FOR removing_partitioning'; SET DEBUG_SYNC= 'mdl_acquire_lock_wait SIGNAL waiting_for_alter'; SET DEBUG_SYNC= 'rm_table_no_locks_before_delete_table WAIT_FOR partitioning_removed'; DROP TABLE IF EXISTS t1; Warnings: Warning 1639 debug sync point wait timed out # Con 1 More results from queries before failure can be found in /dev/shm/var_auto_j9wA/3/log/partition_debug_sync.log - skipping '/dev/shm/var_auto_j9wA/3/log/main.partition_debug_sync/' main.rpl_mysqldump_slave 'row' w2 [ pass ] 1361 main.partition_error w3 [ pass ] 432 main.partition_grant w3 [ pass ] 48 main.partition_key_cache w3 [ pass ] 670 main.partition_list w3 [ pass ] 55 main.partition_mgm w3 [ pass ] 62 main.partition_mgm_err w3 [ fail ] Test ended at 2013-07-04 18:05:52 CURRENT_TEST: main.partition_mgm_err mysqltest: At line 150: query 'ALTER TABLE t1 ADD PARTITION PARTITIONS 1024' failed with wrong errno 23: 'Out of resources when opening file './test/t1#P#p483.MYD' (Errcode: 24 "Too many open files")', instead of 1499... The result from queries just before the failure was: < snip > ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 DROP PARTITION x1; ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 COALESCE PARTITION 1; ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 ANALYZE PARTITION p1; ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 CHECK PARTITION p1; ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 OPTIMIZE PARTITION p1; ERROR HY000: Partition management on a not partitioned table is not possible ALTER TABLE t1 REPAIR PARTITION p1; ERROR HY000: Partition management on a not partitioned table is not possible DROP TABLE t1; CREATE TABLE t1 (a int) PARTITION BY KEY (a) (PARTITION x0, PARTITION x1); ALTER TABLE t1 ADD PARTITION PARTITIONS 0; ERROR HY000: At least one partition must be added ALTER TABLE t1 ADD PARTITION PARTITIONS 1024; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/3/log/partition_mgm_err.log - skipping '/dev/shm/var_auto_j9wA/3/log/main.partition_mgm_err/' main.partition_mgm_err2 w3 [ pass ] 23 main.partition_myisam w3 [ fail ] Test ended at 2013-07-04 18:05:52 CURRENT_TEST: main.partition_myisam --- /data0/psergey/dev2/10.0-monty/mysql-test/r/partition_myisam.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/partition_myisam.reject 2013-07-04 18:05:52.617877208 +0400 @@ -29,8 +29,6 @@ 2000-01-02 03:04:05 2001-02-03 04:05:06 ALTER TABLE t1 ADD PARTITION PARTITIONS 2; -Warnings: -Warning 1486 Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed ALTER TABLE t1 PARTITION BY RANGE (TO_DAYS(a)) (PARTITION p0 VALUES LESS THAN (10000), @@ -109,7 +107,7 @@ # Note that it is currently impossible to drop a partitioned table # without the .par file DROP TABLE t1; -ERROR 42S02: Unknown table 't1' +ERROR 42S02: Unknown table 'test.t1' # # Bug#50392: insert_id is not reset for partitioned tables # auto_increment on duplicate entry mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/3/log/main.partition_myisam/' main.partition_order w3 [ pass ] 287 main.auth_rpl 'stmt' w2 [ pass ] 1364 main.partition_pruning w3 [ pass ] 965 main.partition_range w3 [ pass ] 401 main.partition_symlink w3 [ pass ] 63 main.partition_sync w3 [ pass ] 16 main.partition_truncate w3 [ fail ] Test ended at 2013-07-04 18:05:57 CURRENT_TEST: main.partition_truncate mysqltest: At line 15: query 'alter table t1 truncate partition p0' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1567... The result from queries just before the failure was: drop table if exists t1, t2, t3, t4; create table t1 (a int) partition by list (a) (partition p1 values in (0)); alter table t1 truncate partition p1,p1; ERROR HY000: Incorrect partition name alter table t1 truncate partition p0; Server [mysqld.1 - pid: 29098, winpid: 29098, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- mysqld: /home/psergey/dev2/10.0-monty/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed. 130704 18:05:55 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=3 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x3923730 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7eff70cd4df8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] sql/protocol.cc:515(Protocol::end_statement())[0x586395] sql/sql_parse.cc:1666(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61f9e7] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7eff6804dbd8): alter table t1 truncate partition p0 Connection ID (thread ID): 26 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - skipping '/dev/shm/var_auto_j9wA/3/log/main.partition_truncate/' ***Warnings generated in error logs during shutdown after running tests: main.partition_order main.partition_pruning main.partition_truncate main.partition_range main.partition_symlink main.partition_sync mysqld: /home/psergey/dev2/10.0-monty/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed. Attempting backtrace. You can use the following information to find out main.partition_utf8 w3 [ pass ] 17 main.partition_windows w3 [ skipped ] Need windows main.rpl_mysqldump_slave 'stmt' w2 [ pass ] 1365 main.stat_tables_partition w3 [ pass ] 6 main.partition_example w2 [ pass ] 14 main.partition_hash w2 [ pass ] 66 main.func_analyse 'xtradb' w3 [ pass ] 54 main.partition_rename_longfilename w2 [ pass ] 11 main.func_group_innodb 'xtradb' w3 [ pass ] 156 main.function_defaults 'xtradb' w3 [ pass ] 846 main.group_min_max_innodb 'xtradb' w3 [ fail ] Test ended at 2013-07-04 18:06:02 CURRENT_TEST: main.group_min_max_innodb --- /data0/psergey/dev2/10.0-monty/mysql-test/r/group_min_max_innodb.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/group_min_max_innodb.reject 2013-07-04 18:06:01.912878010 +0400 @@ -70,7 +70,7 @@ 1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index; Using temporary explain select distinct f1, f2 from t1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL PRIMARY 5 NULL 3 Using index for group-by; Using temporary +1 SIMPLE t1 index NULL PRIMARY 5 NULL 4 Using index drop table t1; create table t1(pk int primary key) engine=innodb; create view v1 as select pk from t1 where pk < 20; mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/3/log/main.group_min_max_innodb-xtradb/' main.func_rollback 'xtradb' w2 [ pass ] 270 main.group_by 'xtradb' w2 [ pass ] 550 main.group_by_innodb 'xtradb' w2 [ pass ] 28 main.information_schema_inno 'xtradb' w3 [ pass ] 245 main.innodb_bug878769 'xtradb' w3 [ pass ] 28 main.index_intersect_innodb 'xtradb' w2 [ pass ] 3525 main.innodb_icp 'xtradb' w2 [ pass ] 2083 main.innodb_mrr_cpk 'xtradb' w2 [ pass ] 775 main.innodb_ext_key 'xtradb' w3 [ pass ] 6935 main.innodb_mysql_lock 'xtradb' w2 [ pass ] 2150 main.join_outer_innodb 'xtradb' w2 [ pass ] 169 main.loaddata_autocom_innodb 'xtradb' w2 [ pass ] 49 main.log_tables_upgrade 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:06:13 CURRENT_TEST: main.log_tables_upgrade --- /data0/psergey/dev2/10.0-monty/mysql-test/r/log_tables_upgrade.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/log_tables_upgrade.reject 2013-07-04 18:06:13.685879025 +0400 @@ -32,16 +32,12 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.renamed_general_log OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.log_tables_upgrade-xtradb/' main.merge_innodb 'xtradb' w2 [ pass ] 59 main.multi_update_innodb 'xtradb' w2 [ pass ] 62 main.mysql_upgrade 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:06:19 CURRENT_TEST: main.mysql_upgrade --- /data0/psergey/dev2/10.0-monty/mysql-test/r/mysql_upgrade.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/mysql_upgrade.reject 2013-07-04 18:06:19.015879485 +0400 @@ -20,15 +20,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -65,15 +61,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -110,15 +102,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -158,15 +146,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -209,15 +193,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -263,15 +243,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -320,15 +296,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.mysql_upgrade-xtradb/' main.mysql_upgrade_ssl 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:06:21 CURRENT_TEST: main.mysql_upgrade_ssl --- /data0/psergey/dev2/10.0-monty/mysql-test/r/mysql_upgrade_ssl.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/mysql_upgrade_ssl.reject 2013-07-04 18:06:21.154879669 +0400 @@ -22,15 +22,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.mysql_upgrade_ssl-xtradb/' main.mysqlcheck 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:06:23 CURRENT_TEST: main.mysqlcheck Error: /data0/psergey/dev2/10.0-monty/client/mysqlcheck doesn't support multiple contradicting commands. Error: /data0/psergey/dev2/10.0-monty/client/mysqlcheck doesn't support multiple contradicting commands. --- /data0/psergey/dev2/10.0-monty/mysql-test/r/mysqlcheck.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/mysqlcheck.reject 2013-07-04 18:06:23.548879876 +0400 @@ -16,15 +16,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -52,15 +48,11 @@ mysql.innodb_table_stats note : Table does not support optimize, doing recreate + analyze instead status : OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -82,15 +74,11 @@ mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK -mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK -mysql.slave_master_info OK -mysql.slave_relay_log_info OK -mysql.slave_worker_info OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK @@ -116,15 +104,11 @@ mysql.innodb_table_stats note : Table does not support optimize, doing recreate + analyze instead status : OK -mysql.ndb_binlog_index Table is already up to date mysql.plugin Table is already up to date mysql.proc Table is already up to date mysql.procs_priv Table is already up to date mysql.proxies_priv Table is already up to date mysql.servers Table is already up to date -mysql.slave_master_info Table is already up to date -mysql.slave_relay_log_info Table is already up to date -mysql.slave_worker_info Table is already up to date mysql.table_stats Table is already up to date mysql.tables_priv Table is already up to date mysql.time_zone Table is already up to date mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.mysqlcheck-xtradb/' main.parser_bug21114_innodb 'xtradb' w2 [ pass ] 6201 main.plugin_innodb 'xtradb' w2 [ pass ] 3584 main.range 'xtradb' w2 [ pass ] 873 main.range_mrr_icp 'xtradb' w2 [ pass ] 847 main.range_vs_index_merge_innodb 'xtradb' w2 [ pass ] 16742 main.read_only_innodb 'xtradb' w2 [ pass ] 253 main.row-checksum 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:06:55 CURRENT_TEST: main.row-checksum --- /data0/psergey/dev2/10.0-monty/mysql-test/r/row-checksum.result 2012-07-11 11:49:27.463401000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/row-checksum.reject 2013-07-04 18:06:55.151882601 +0400 @@ -73,7 +73,7 @@ drop table if exists t1; create table t1 (a int null, v varchar(100)) engine=innodb checksum=0 row_format=fixed; Warnings: -Warning 140 InnoDB: assuming ROW_FORMAT=COMPACT. +Warning 1478 InnoDB: assuming ROW_FORMAT=COMPACT. insert into t1 values(null, null), (1, "hello"); checksum table t1; Table Checksum mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.row-checksum-xtradb/' main.show_explain 'xtradb' w2 [ pass ] 2363 main.ssl_and_innodb 'xtradb' w2 [ pass ] 30 main.stat_tables_disabled 'xtradb' w2 [ pass ] 9001 main.strict_autoinc_2innodb 'xtradb' w2 [ pass ] 22 main.subselect2 'xtradb' w2 [ pass ] 340 main.subselect_innodb 'xtradb' w2 [ pass ] 533 main.subselect_sj2 'xtradb' w2 [ pass ] 1036 main.subselect_sj2_jcl6 'xtradb' w2 [ pass ] 1175 main.subselect_sj2_mat 'xtradb' w2 [ pass ] 1005 main.system_mysql_db_fix40123 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:07:14 CURRENT_TEST: main.system_mysql_db_fix40123 ERROR 1060 (42S21) at line 249: Duplicate column name 'File_priv' ERROR 1060 (42S21) at line 255: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 256: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 257: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 268: Duplicate column name 'ssl_type' ERROR 1061 (42000) at line 278: Duplicate key name 'Grantor' ERROR 1054 (42S22) at line 305: Unknown column 'Type' in 'columns_priv' ERROR 1060 (42S21) at line 327: Duplicate column name 'type' ERROR 1060 (42S21) at line 337: Duplicate column name 'Show_db_priv' ERROR 1060 (42S21) at line 354: Duplicate column name 'max_questions' ERROR 1060 (42S21) at line 364: Duplicate column name 'Create_tmp_table_priv' ERROR 1060 (42S21) at line 367: Duplicate column name 'Create_tmp_table_priv' ERROR 1054 (42S22) at line 458: Unknown column 'thread_id' in 'general_log' ERROR 1060 (42S21) at line 470: Duplicate column name 'thread_id' ERROR 1054 (42S22) at line 496: Unknown column 'Create_view_priv' in 'where clause' ERROR 1054 (42S22) at line 531: Unknown column 'Create_routine_priv' in 'where clause' ERROR 1054 (42S22) at line 583: Unknown column 'Create_user_priv' in 'where clause' ERROR 1060 (42S21) at line 607: Duplicate column name 'Routine_type' ERROR 1060 (42S21) at line 675: Duplicate column name 'character_set_client' ERROR 1060 (42S21) at line 690: Duplicate column name 'collation_connection' ERROR 1060 (42S21) at line 705: Duplicate column name 'db_collation' ERROR 1060 (42S21) at line 723: Duplicate column name 'body_utf8' ERROR 1054 (42S22) at line 735: Unknown column 'Event_priv' in 'where clause' ERROR 1060 (42S21) at line 751: Duplicate column name 'sql_mode' ERROR 1060 (42S21) at line 790: Duplicate column name 'originator' ERROR 1060 (42S21) at line 794: Duplicate column name 'time_zone' ERROR 1060 (42S21) at line 797: Duplicate column name 'character_set_client' ERROR 1060 (42S21) at line 803: Duplicate column name 'collation_connection' ERROR 1060 (42S21) at line 809: Duplicate column name 'db_collation' ERROR 1060 (42S21) at line 815: Duplicate column name 'body_utf8' ERROR 1054 (42S22) at line 825: Unknown column 'Trigger_priv' in 'where clause' ERROR 1054 (42S22) at line 843: Unknown column 'Create_tablespace_priv' in 'where clause' mysqltest: At line 81: query 'DROP TABLE db, host, user, func, plugin, tables_priv, columns_priv, procs_priv, servers, help_category, help_keyword, help_relation, help_topic, proc, time_zone, time_zone_leap_second, time_zone_name, time_zone_transition, time_zone_transition_type, general_log, slow_log, event, ndb_binlog_index, proxies_priv, slave_master_info, slave_relay_log_info, innodb_index_stats, innodb_table_stats, slave_worker_info, table_stats, column_stats, index_stats' failed: 1051: Unknown table 'test.ndb_binlog_index,test.slave_master_info,test.slave_relay_log_info,test.slave_worker_info' The result from queries just before the failure was: < snip > `db_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `column_name` varchar(64) COLLATE utf8_bin NOT NULL, `min_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `max_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `nulls_ratio` double DEFAULT NULL, `avg_length` double DEFAULT NULL, `avg_frequency` double DEFAULT NULL, PRIMARY KEY (`db_name`,`table_name`,`column_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Statistics on Columns' show create table index_stats; Table Create Table index_stats CREATE TABLE `index_stats` ( `db_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `index_name` varchar(64) COLLATE utf8_bin NOT NULL, `prefix_arity` int(11) unsigned NOT NULL, `avg_frequency` double DEFAULT NULL, PRIMARY KEY (`db_name`,`table_name`,`index_name`,`prefix_arity`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Statistics on Indexes' More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/system_mysql_db_fix40123.log - skipping '/dev/shm/var_auto_j9wA/2/log/main.system_mysql_db_fix40123-xtradb/' main.system_mysql_db_fix50030 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:07:16 CURRENT_TEST: main.system_mysql_db_fix50030 ERROR 1060 (42S21) at line 249: Duplicate column name 'File_priv' ERROR 1060 (42S21) at line 255: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 256: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 257: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 268: Duplicate column name 'ssl_type' ERROR 1061 (42000) at line 278: Duplicate key name 'Grantor' ERROR 1054 (42S22) at line 305: Unknown column 'Type' in 'columns_priv' ERROR 1060 (42S21) at line 327: Duplicate column name 'type' ERROR 1060 (42S21) at line 337: Duplicate column name 'Show_db_priv' ERROR 1060 (42S21) at line 354: Duplicate column name 'max_questions' ERROR 1060 (42S21) at line 364: Duplicate column name 'Create_tmp_table_priv' ERROR 1060 (42S21) at line 367: Duplicate column name 'Create_tmp_table_priv' ERROR 1054 (42S22) at line 458: Unknown column 'thread_id' in 'general_log' ERROR 1060 (42S21) at line 470: Duplicate column name 'thread_id' ERROR 1060 (42S21) at line 501: Duplicate column name 'Create_view_priv' ERROR 1060 (42S21) at line 504: Duplicate column name 'Create_view_priv' ERROR 1060 (42S21) at line 507: Duplicate column name 'Create_view_priv' ERROR 1060 (42S21) at line 513: Duplicate column name 'Show_view_priv' ERROR 1060 (42S21) at line 516: Duplicate column name 'Show_view_priv' ERROR 1060 (42S21) at line 519: Duplicate column name 'Show_view_priv' ERROR 1060 (42S21) at line 536: Duplicate column name 'Create_routine_priv' ERROR 1060 (42S21) at line 539: Duplicate column name 'Create_routine_priv' ERROR 1060 (42S21) at line 542: Duplicate column name 'Create_routine_priv' ERROR 1060 (42S21) at line 548: Duplicate column name 'Alter_routine_priv' ERROR 1060 (42S21) at line 551: Duplicate column name 'Alter_routine_priv' ERROR 1060 (42S21) at line 554: Duplicate column name 'Alter_routine_priv' ERROR 1060 (42S21) at line 557: Duplicate column name 'Execute_priv' ERROR 1060 (42S21) at line 560: Duplicate column name 'Execute_priv' ERROR 1060 (42S21) at line 575: Duplicate column name 'max_user_connections' ERROR 1060 (42S21) at line 585: Duplicate column name 'Create_user_priv' ERROR 1060 (42S21) at line 607: Duplicate column name 'Routine_type' ERROR 1054 (42S22) at line 735: Unknown column 'Event_priv' in 'where clause' ERROR 1060 (42S21) at line 751: Duplicate column name 'sql_mode' ERROR 1060 (42S21) at line 790: Duplicate column name 'originator' ERROR 1060 (42S21) at line 794: Duplicate column name 'time_zone' ERROR 1060 (42S21) at line 797: Duplicate column name 'character_set_client' ERROR 1060 (42S21) at line 803: Duplicate column name 'collation_connection' ERROR 1060 (42S21) at line 809: Duplicate column name 'db_collation' ERROR 1060 (42S21) at line 815: Duplicate column name 'body_utf8' ERROR 1054 (42S22) at line 825: Unknown column 'Trigger_priv' in 'where clause' ERROR 1054 (42S22) at line 843: Unknown column 'Create_tablespace_priv' in 'where clause' mysqltest: At line 88: query 'DROP TABLE db, host, user, func, plugin, tables_priv, columns_priv, procs_priv, servers, help_category, help_keyword, help_relation, help_topic, proc, time_zone, time_zone_leap_second, time_zone_name, time_zone_transition, time_zone_transition_type, general_log, slow_log, event, ndb_binlog_index, proxies_priv, slave_master_info, slave_relay_log_info, innodb_index_stats, innodb_table_stats, slave_worker_info, table_stats, column_stats, index_stats' failed: 1051: Unknown table 'test.ndb_binlog_index,test.slave_master_info,test.slave_relay_log_info,test.slave_worker_info' The result from queries just before the failure was: < snip > `db_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `column_name` varchar(64) COLLATE utf8_bin NOT NULL, `min_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `max_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `nulls_ratio` double DEFAULT NULL, `avg_length` double DEFAULT NULL, `avg_frequency` double DEFAULT NULL, PRIMARY KEY (`db_name`,`table_name`,`column_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Statistics on Columns' show create table index_stats; Table Create Table index_stats CREATE TABLE `index_stats` ( `db_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `index_name` varchar(64) COLLATE utf8_bin NOT NULL, `prefix_arity` int(11) unsigned NOT NULL, `avg_frequency` double DEFAULT NULL, PRIMARY KEY (`db_name`,`table_name`,`index_name`,`prefix_arity`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Statistics on Indexes' More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/system_mysql_db_fix50030.log - skipping '/dev/shm/var_auto_j9wA/2/log/main.system_mysql_db_fix50030-xtradb/' main.system_mysql_db_fix50117 'xtradb' w2 [ fail ] Test ended at 2013-07-04 18:07:19 CURRENT_TEST: main.system_mysql_db_fix50117 ERROR 1060 (42S21) at line 249: Duplicate column name 'File_priv' ERROR 1060 (42S21) at line 255: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 256: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 257: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 268: Duplicate column name 'ssl_type' ERROR 1061 (42000) at line 278: Duplicate key name 'Grantor' ERROR 1054 (42S22) at line 305: Unknown column 'Type' in 'columns_priv' ERROR 1060 (42S21) at line 327: Duplicate column name 'type' ERROR 1060 (42S21) at line 337: Duplicate column name 'Show_db_priv' ERROR 1060 (42S21) at line 354: Duplicate column name 'max_questions' ERROR 1060 (42S21) at line 364: Duplicate column name 'Create_tmp_table_priv' ERROR 1060 (42S21) at line 367: Duplicate column name 'Create_tmp_table_priv' ERROR 1054 (42S22) at line 458: Unknown column 'thread_id' in 'general_log' ERROR 1060 (42S21) at line 470: Duplicate column name 'thread_id' ERROR 1060 (42S21) at line 501: Duplicate column name 'Create_view_priv' ERROR 1060 (42S21) at line 504: Duplicate column name 'Create_view_priv' ERROR 1060 (42S21) at line 507: Duplicate column name 'Create_view_priv' ERROR 1060 (42S21) at line 513: Duplicate column name 'Show_view_priv' ERROR 1060 (42S21) at line 516: Duplicate column name 'Show_view_priv' ERROR 1060 (42S21) at line 519: Duplicate column name 'Show_view_priv' ERROR 1060 (42S21) at line 536: Duplicate column name 'Create_routine_priv' ERROR 1060 (42S21) at line 539: Duplicate column name 'Create_routine_priv' ERROR 1060 (42S21) at line 542: Duplicate column name 'Create_routine_priv' ERROR 1060 (42S21) at line 548: Duplicate column name 'Alter_routine_priv' ERROR 1060 (42S21) at line 551: Duplicate column name 'Alter_routine_priv' ERROR 1060 (42S21) at line 554: Duplicate column name 'Alter_routine_priv' ERROR 1060 (42S21) at line 557: Duplicate column name 'Execute_priv' ERROR 1060 (42S21) at line 560: Duplicate column name 'Execute_priv' ERROR 1060 (42S21) at line 575: Duplicate column name 'max_user_connections' ERROR 1060 (42S21) at line 585: Duplicate column name 'Create_user_priv' ERROR 1060 (42S21) at line 607: Duplicate column name 'Routine_type' ERROR 1060 (42S21) at line 737: Duplicate column name 'Event_priv' ERROR 1060 (42S21) at line 742: Duplicate column name 'Event_priv' ERROR 1060 (42S21) at line 751: Duplicate column name 'sql_mode' ERROR 1054 (42S22) at line 789: Unknown column 'originator' in 'event' ERROR 1060 (42S21) at line 794: Duplicate column name 'time_zone' ERROR 1060 (42S21) at line 827: Duplicate column name 'Trigger_priv' ERROR 1060 (42S21) at line 830: Duplicate column name 'Trigger_priv' ERROR 1060 (42S21) at line 833: Duplicate column name 'Trigger_priv' ERROR 1054 (42S22) at line 843: Unknown column 'Create_tablespace_priv' in 'where clause' mysqltest: At line 107: query 'DROP TABLE db, host, user, func, plugin, tables_priv, columns_priv, procs_priv, servers, help_category, help_keyword, help_relation, help_topic, proc, time_zone, time_zone_leap_second, time_zone_name, time_zone_transition, time_zone_transition_type, general_log, slow_log, event, ndb_binlog_index, proxies_priv, slave_master_info, slave_relay_log_info, innodb_index_stats, innodb_table_stats, slave_worker_info, table_stats, column_stats, index_stats' failed: 1051: Unknown table 'test.slave_master_info,test.slave_relay_log_info,test.slave_worker_info' The result from queries just before the failure was: < snip > `db_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `column_name` varchar(64) COLLATE utf8_bin NOT NULL, `min_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `max_value` varchar(255) COLLATE utf8_bin DEFAULT NULL, `nulls_ratio` double DEFAULT NULL, `avg_length` double DEFAULT NULL, `avg_frequency` double DEFAULT NULL, PRIMARY KEY (`db_name`,`table_name`,`column_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Statistics on Columns' show create table index_stats; Table Create Table index_stats CREATE TABLE `index_stats` ( `db_name` varchar(64) COLLATE utf8_bin NOT NULL, `table_name` varchar(64) COLLATE utf8_bin NOT NULL, `index_name` varchar(64) COLLATE utf8_bin NOT NULL, `prefix_arity` int(11) unsigned NOT NULL, `avg_frequency` double DEFAULT NULL, PRIMARY KEY (`db_name`,`table_name`,`index_name`,`prefix_arity`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Statistics on Indexes' More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/system_mysql_db_fix50117.log - skipping '/dev/shm/var_auto_j9wA/2/log/main.system_mysql_db_fix50117-xtradb/' main.trigger-trans 'xtradb' w2 [ pass ] 211 main.type_bit_innodb 'xtradb' w2 [ pass ] 252 main.type_time_hires 'xtradb' w2 [ pass ] 113 main.type_timestamp_hires 'xtradb' w2 [ pass ] 122 main.update 'xtradb' w2 [ pass ] 481 main.warnings_debug 'xtradb' w2 [ pass ] 29 main.xa 'xtradb' w2 [ pass ] 2355 main.adddate_454 w2 [ pass ] 7 main.alias w2 [ pass ] 68 main.almost_full w2 [ pass ] 169 main.alter_table w2 [ fail ] Test ended at 2013-07-04 18:07:30 CURRENT_TEST: main.alter_table mysqltest: At line 212: query 'SHOW INDEX FROM t1' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > Host varchar(16) binary NOT NULL default '', User varchar(16) binary NOT NULL default '', PRIMARY KEY (Host,User), KEY (Host) ) ENGINE=MyISAM; ALTER TABLE t1 DISABLE KEYS; SHOW INDEX FROM t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment t1 0 PRIMARY 1 Host A NULL NULL NULL BTREE t1 0 PRIMARY 2 User A 0 NULL NULL BTREE t1 1 Host 1 Host A NULL NULL NULL BTREE disabled LOCK TABLES t1 WRITE; INSERT INTO t1 VALUES ('localhost','root'),('localhost',''); SHOW INDEX FROM t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment t1 0 PRIMARY 1 Host A NULL NULL NULL BTREE t1 0 PRIMARY 2 User A 0 NULL NULL BTREE t1 1 Host 1 Host A NULL NULL NULL BTREE disabled ALTER TABLE t1 ENABLE KEYS; SHOW INDEX FROM t1; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/alter_table.log Server [mysqld.1 - pid: 30848, winpid: 30848, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- mysqld: /home/psergey/dev2/10.0-monty/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed. 130704 18:07:28 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=2 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x3a52c70 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f27dba18df8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] myisam/mi_open.c:68(test_if_reopen)[0xa52eb9] myisam/mi_open.c:117(mi_open)[0xa530a4] myisam/ha_myisam.cc:746(ha_myisam::open(char const*, int, unsigned int))[0xa28b77] sql/handler.cc:2357(handler::ha_open(TABLE*, char const*, int, unsigned int))[0x7e4ac6] sql/table.cc:2651(open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool))[0x6ec758] sql/sql_base.cc:3225(open_table(THD*, TABLE_LIST*, st_mem_root*, Open_table_context*))[0x5c355d] sql/sql_base.cc:4625(open_and_process_table)[0x5c5b24] sql/sql_base.cc:5182(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x5c6d6d] sql/sql_base.cc:5860(open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int, unsigned int))[0x5c7e7c] sql/sql_show.cc:4084(fill_schema_table_by_open)[0x69b290] sql/sql_show.cc:4640(get_all_tables(THD*, TABLE_LIST*, Item*))[0x69c24c] sql/sql_show.cc:7971(do_fill_table)[0x6a9f5f] sql/sql_show.cc:8069(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x6aa2d8] sql/sql_select.cc:2412(JOIN::exec_inner())[0x655a3d] sql/sql_select.cc:2258(JOIN::exec())[0x6550ad] sql/sql_select.cc:3195(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x6583a0] sql/sql_select.cc:363(handle_select(THD*, LEX*, select_result*, unsigned long))[0x64eff4] sql/sql_parse.cc:5067(execute_sqlcom_select)[0x6287ef] sql/sql_parse.cc:2501(mysql_execute_command(THD*))[0x621323] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f27d005c4b8): SHOW INDEX FROM t1 Connection ID (thread ID): 15 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - skipping '/dev/shm/var_auto_j9wA/2/log/main.alter_table/' ***Warnings generated in error logs during shutdown after running tests: main.alter_table main.adddate_454 main.almost_full main.alias mysqld: /home/psergey/dev2/10.0-monty/storage/myisam/mi_open.c:67: test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed. Attempting backtrace. You can use the following information to find out main.alter_table_mdev539_maria w2 [ pass ] 8156 main.alter_table_mdev539_myisam w2 [ pass ] 2411 main.analyze w2 [ fail ] Test ended at 2013-07-04 18:07:42 CURRENT_TEST: main.analyze mysqltest: At line 71: query 'analyze table t1' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > create table t1 (a mediumtext, fulltext key key1(a)) charset utf8 collate utf8_general_ci engine myisam; insert into t1 values ('hello'); analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status Table is already up to date drop table t1; CREATE TABLE t1 (a int); prepare stmt1 from "SELECT * FROM t1 PROCEDURE ANALYSE()"; execute stmt1; Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype execute stmt1; Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype deallocate prepare stmt1; drop table t1; create temporary table t1(a int, index(a)); insert into t1 values('1'),('2'),('3'),('4'),('5'); analyze table t1; More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/analyze.log Server [mysqld.1 - pid: 30916, winpid: 30916, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- mysqld: /home/psergey/dev2/10.0-monty/sql/sql_base.cc:6452: bool open_temporary_table(THD*, TABLE_LIST*): Assertion `tl->table == __null' failed. 130704 18:07:42 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x384ec70 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7fa139b80df8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] sql/sql_base.cc:6460(open_temporary_table(THD*, TABLE_LIST*))[0x5c93ab] sql/sql_base.cc:6547(open_temporary_tables(THD*, TABLE_LIST*))[0x5c96fb] sql/sql_admin.cc:432(mysql_admin_table)[0x736ec3] sql/sql_admin.cc:1125(Sql_cmd_analyze_table::execute(THD*))[0x739377] sql/sql_parse.cc:4896(mysql_execute_command(THD*))[0x627ed1] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fa1300a57d8): analyze table t1 Connection ID (thread ID): 10 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - skipping '/dev/shm/var_auto_j9wA/2/log/main.analyze/' ***Warnings generated in error logs during shutdown after running tests: main.alter_table_mdev539_maria main.analyze main.alter_table_mdev539_myisam mysqld: /home/psergey/dev2/10.0-monty/sql/sql_base.cc:6452: bool open_temporary_table(THD*, TABLE_LIST*): Assertion `tl->table == __null' failed. Attempting backtrace. You can use the following information to find out main.ansi w2 [ pass ] 13 main.auto_increment w2 [ pass ] 219 main.auto_increment_ranges_myisam w2 [ pass ] 117 main.bench_count_distinct w2 [ pass ] 90 main.bigint w2 [ pass ] 145 main.binary w2 [ pass ] 76 main.blackhole_plugin w2 [ skipped ] Need blackhole plugin main.bool w2 [ pass ] 23 main.bug12427262 w2 [ pass ] 33 main.bug13633383 w2 [ pass ] 92 main.bulk_replace w2 [ pass ] 6 main.case w2 [ pass ] 63 main.cast w2 [ fail ] Test ended at 2013-07-04 18:07:45 CURRENT_TEST: main.cast --- /data0/psergey/dev2/10.0-monty/mysql-test/r/cast.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/cast.reject 2013-07-04 18:07:45.636886955 +0400 @@ -750,13 +750,19 @@ set sql_mode= TRADITIONAL; select cast("2101-00-01 02:03:04" as datetime); cast("2101-00-01 02:03:04" as datetime) -2101-00-01 02:03:04 +NULL +Warnings: +Warning 1292 Incorrect datetime value: '2101-00-01 02:03:04' select cast(cast("2101-00-01 02:03:04" as datetime) as time); cast(cast("2101-00-01 02:03:04" as datetime) as time) -02:03:04 +NULL +Warnings: +Warning 1292 Incorrect datetime value: '2101-00-01 02:03:04' SELECT CAST(CAST('20:05:05' AS TIME) as date); CAST(CAST('20:05:05' AS TIME) as date) -0000-00-00 +NULL +Warnings: +Warning 1292 Truncated incorrect date value: '0000-00-00' set sql_mode=DEFAULT; create table t1 (f1 time, f2 date, f3 datetime); insert into t1 values ('11:22:33','2011-12-13','2011-12-13 11:22:33'); mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.cast/' main.change_user w2 [ pass ] 56 main.change_user_notembedded w2 [ pass ] 5011 main.query_cache_debug w4 [ pass ] 300094 main.1st w4 [ fail ] Test ended at 2013-07-04 18:07:57 CURRENT_TEST: main.1st --- /data0/psergey/dev2/10.0-monty/mysql-test/r/1st.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/1st.reject 2013-07-04 18:07:57.761888000 +0400 @@ -21,15 +21,11 @@ index_stats innodb_index_stats innodb_table_stats -ndb_binlog_index plugin proc procs_priv proxies_priv servers -slave_master_info -slave_relay_log_info -slave_worker_info slow_log table_stats tables_priv mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/4/log/main.1st/' main.aborted_clients w4 [ pass ] 11 main.comments w4 [ pass ] 13 main.compare w4 [ pass ] 39 main.check w2 [ fail ] Test ended at 2013-07-04 18:07:59 CURRENT_TEST: main.check mysqltest: At line 53: query 'CHECK TABLE t1' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: drop table if exists t1,t2; drop view if exists v1; create table t1(n int not null, key(n), key(n), key(n), key(n)); check table t1 extended; insert into t1 values (200000); Table Op Msg_type Msg_text test.t1 check status OK drop table t1; Create table t1(f1 int); Create table t2(f1 int); Create view v1 as Select * from t1; Check Table v1,t2; Table Op Msg_type Msg_text test.v1 check status OK test.t2 check status OK drop view v1; drop table t1, t2; CREATE TEMPORARY TABLE t1(a INT); CHECK TABLE t1; Server [mysqld.1 - pid: 31165, winpid: 31165, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- mysqld: /home/psergey/dev2/10.0-monty/sql/sql_base.cc:6452: bool open_temporary_table(THD*, TABLE_LIST*): Assertion `tl->table == __null' failed. 130704 18:07:57 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.1-MariaDB-debug-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=3 max_threads=153 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62297 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x245bc70 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7ff19d7ecdf8 thread_stack 0x48000 mysys/stacktrace.c:246(my_print_stacktrace)[0xdea08f] sql/signal_handler.cc:155(handle_fatal_signal)[0x7df8b1] ??:0(??)[0x3509c0f500] ??:0(??)[0x3509836285] ??:0(??)[0x3509837b9b] ??:0(??)[0x350982ee9e] ??:0(??)[0x350982ef42] sql/sql_base.cc:6460(open_temporary_table(THD*, TABLE_LIST*))[0x5c93ab] sql/sql_base.cc:6547(open_temporary_tables(THD*, TABLE_LIST*))[0x5c96fb] sql/sql_admin.cc:432(mysql_admin_table)[0x736ec3] sql/sql_admin.cc:1157(Sql_cmd_check_table::execute(THD*))[0x73952d] sql/sql_parse.cc:4896(mysql_execute_command(THD*))[0x627ed1] sql/sql_parse.cc:6196(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x62afd7] sql/sql_parse.cc:1269(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x61e6ac] sql/sql_parse.cc:983(do_command(THD*))[0x61d86d] sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x7270f9] sql/sql_connect.cc:1294(handle_one_connection)[0x726ac7] perfschema/pfs.cc:1855(pfs_spawn_thread)[0xace81f] ??:0(??)[0x3509c07d90] ??:0(??)[0x35098f0f5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7ff19404c818): CHECK TABLE t1 Connection ID (thread ID): 11 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ----------SERVER LOG END------------- - skipping '/dev/shm/var_auto_j9wA/2/log/main.check/' ***Warnings generated in error logs during shutdown after running tests: main.change_user_notembedded main.check main.change_user mysqld: /home/psergey/dev2/10.0-monty/sql/sql_base.cc:6452: bool open_temporary_table(THD*, TABLE_LIST*): Assertion `tl->table == __null' failed. Attempting backtrace. You can use the following information to find out main.client_xml w2 [ pass ] 50 main.comment_column w2 [ pass ] 74 main.comment_column2 w2 [ pass ] 77 main.comment_index w2 [ pass ] 64 main.comment_table w2 [ pass ] 24 main.count_distinct w2 [ pass ] 32 main.create w2 [ fail ] Test ended at 2013-07-04 18:08:01 CURRENT_TEST: main.create mysqltest: At line 1578: query 'create table `t-1` (a int)' succeeded - should have failed with errno 1050... The result from queries just before the failure was: < snip > drop table if exists t1,t2,t3; # Fix modified for MariaDB: we support this syntax create table t1 (a int) transactional=0; create table t2 (a int) page_checksum=1; create table t3 (a int) row_format=page; drop table t1,t2,t3; # -- End of Bug#45829 # new table creation/renaming blocked if old encoded table present create table `t-1` (a int) engine=myisam; insert into `t-1` values (1); show tables; Tables_in_test t-1 flush tables; convert table files in mysql 5.0 file name encoding show tables; Tables_in_test #mysql50#t-1 create table `t-1` (a int); More results from queries before failure can be found in /dev/shm/var_auto_j9wA/2/log/create.log - skipping '/dev/shm/var_auto_j9wA/2/log/main.create/' main.create-uca w2 [ pass ] 7 main.create_not_windows w2 [ pass ] 10 main.ctype_ascii w2 [ pass ] 11 main.ctype_big5 w2 [ pass ] 817 main.ctype_binary w2 [ pass ] 507 main.ctype_collate w2 [ pass ] 47 main.ctype_cp1250_ch w2 [ pass ] 41 main.ctype_cp1251 w2 [ pass ] 534 main.ctype_create w2 [ pass ] 13 main.ctype_errors w2 [ pass ] 8 main.compress w4 [ pass ] 7988 main.constraints w4 [ pass ] 16 main.contributors w4 [ pass ] main.ctype_latin2 w4 [ pass ] 13 main.ctype_latin2_ch w4 [ pass ] 8 main.ctype_eucjpms w2 [ pass ] 2430 main.ctype_like_range w4 [ pass ] 334 main.ctype_many w4 [ pass ] 116 main.ctype_mb w4 [ pass ] 12 main.ctype_sjis w4 [ pass ] 1183 main.ctype_euckr w2 [ pass ] 1699 main.ctype_tis620 w4 [ pass ] 105 main.ctype_filename w2 [ pass ] 14 main.ctype_uca w4 [ pass ] 236 main.ctype_gb2312 w2 [ pass ] 847 main.ctype_ucs w4 [ pass ] 775 main.ctype_gbk w2 [ pass ] 835 main.ctype_hebrew w2 [ pass ] 4 main.ctype_latin1 w2 [ pass ] 538 main.ctype_recoding w2 [ pass ] 48 main.ctype_ujis_ucs2 w4 [ pass ] 1593 main.ctype_utf16_uca w4 [ pass ] 303 main.ctype_utf32_uca w4 [ pass ] 142 main.ddl_i18n_utf8 w4 [ pass ] 877 main.debug_sync w4 [ pass ] 37 main.default w4 [ pass ] 23 main.default_storage_engine w4 [ pass ] 169 main.ctype_ujis w2 [ pass ] 2427 main.ctype_utf16 w2 [ pass ] 318 main.ctype_utf32 w2 [ pass ] 339 main.ctype_utf8mb4_heap w2 [ pass ] 618 main.delayed w4 [ pass ] 2477 main.ctype_utf8mb4_myisam w2 [ pass ] 690 main.delete w4 [ pass ] 153 main.datetime_456 w2 [ pass ] 2 main.type_datetime w4 [ pass ] 145 main.type_newdecimal w4 [ pass ] 240 main.ddl_i18n_koi8r w2 [ pass ] 1132 main.type_decimal w2 [ fail ] Test ended at 2013-07-04 18:08:20 CURRENT_TEST: main.type_decimal --- /data0/psergey/dev2/10.0-monty/mysql-test/r/type_decimal.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/type_decimal.reject 2013-07-04 18:08:19.941889913 +0400 @@ -167,21 +167,21 @@ insert into t1 values ("1e+1000"),("1e-1000"),("-1e+1000"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 -Note 1265 Data truncated for column 'a' at row 2 +Warning 1265 Data truncated for column 'a' at row 2 Warning 1264 Out of range value for column 'a' at row 3 insert into t1 values ("1e+4294967296"),("1e-4294967296"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 -Note 1265 Data truncated for column 'a' at row 2 +Warning 1265 Data truncated for column 'a' at row 2 insert into t1 values ("1e+18446744073709551615"),("1e+18446744073709551616"),("1e-9223372036854775807"),("1e-9223372036854775809"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 Warning 1366 Incorrect decimal value: '1e+18446744073709551616' for column 'a' at row 2 -Note 1265 Data truncated for column 'a' at row 3 +Warning 1265 Data truncated for column 'a' at row 3 Warning 1366 Incorrect decimal value: '1e-9223372036854775809' for column 'a' at row 4 insert into t1 values ("123.4e"),("123.4e+2"),("123.4e-2"),("123e1"),("123e+0"); Warnings: -Note 1265 Data truncated for column 'a' at row 1 +Warning 1265 Data truncated for column 'a' at row 1 Note 1265 Data truncated for column 'a' at row 3 select * from t1; a @@ -242,11 +242,11 @@ insert into t1 values ("1e+1000"),("1e-1000"),("-1e+1000"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 -Note 1265 Data truncated for column 'a' at row 2 +Warning 1265 Data truncated for column 'a' at row 2 Warning 1264 Out of range value for column 'a' at row 3 insert into t1 values ("123.4e"),("123.4e+2"),("123.4e-2"),("123e1"),("123e+0"); Warnings: -Note 1265 Data truncated for column 'a' at row 1 +Warning 1265 Data truncated for column 'a' at row 1 Note 1265 Data truncated for column 'a' at row 3 select * from t1; a @@ -301,11 +301,11 @@ insert into t1 values ("1e+1000"),("1e-1000"),("-1e+1000"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 -Note 1265 Data truncated for column 'a' at row 2 +Warning 1265 Data truncated for column 'a' at row 2 Warning 1264 Out of range value for column 'a' at row 3 insert into t1 values ("123.4e"),("123.4e+2"),("123.4e-2"),("123e1"),("123e+0"); Warnings: -Note 1265 Data truncated for column 'a' at row 1 +Warning 1265 Data truncated for column 'a' at row 1 Note 1265 Data truncated for column 'a' at row 3 select * from t1; a mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/2/log/main.type_decimal/' main.type_enum w2 [ pass ] 279 main.type_float w2 [ pass ] 166 main.type_nchar w2 [ pass ] 22 main.truncate_coverage w5 [ fail ] Test ended at 2013-07-04 18:15:16 CURRENT_TEST: main.truncate_coverage --- /data0/psergey/dev2/10.0-monty/mysql-test/r/truncate_coverage.result 2012-06-28 18:31:05.561398000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/truncate_coverage.reject 2013-07-04 18:15:15.139925714 +0400 @@ -16,6 +16,8 @@ # # connection con2 SET DEBUG_SYNC='now WAIT_FOR waiting'; +Warnings: +Warning 1639 debug sync point wait timed out KILL QUERY @id; # # connection default @@ -42,6 +44,8 @@ # # connection con2 SET DEBUG_SYNC='now WAIT_FOR waiting'; +Warnings: +Warning 1639 debug sync point wait timed out # # connection con1 HANDLER t1 CLOSE; @@ -50,7 +54,7 @@ ERROR 42S02: Table 'test.t1' doesn't exist UNLOCK TABLES; DROP TABLE t1; -ERROR 42S02: Unknown table 't1' +ERROR 42S02: Unknown table 'test.t1' SET DEBUG_SYNC='RESET'; CREATE TABLE t1 (c1 INT); INSERT INTO t1 VALUES (1); mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/5/log/main.truncate_coverage/' main.type_binary w5 [ pass ] 65 main.type_bit w5 [ pass ] 259 main.type_blob w5 [ pass ] 354 main.type_date w5 [ fail ] Test ended at 2013-07-04 18:15:17 CURRENT_TEST: main.type_date --- /data0/psergey/dev2/10.0-monty/mysql-test/r/type_date.result 2013-05-21 14:45:31.670397000 +0400 +++ /data0/psergey/dev2/10.0-monty/mysql-test/r/type_date.reject 2013-07-04 18:15:17.793925947 +0400 @@ -218,6 +218,8 @@ a 0000-00-00 0000-00-00 +Warnings: +Warning 1292 Incorrect datetime value: '0000-00-00' INSERT INTO t1 VALUES ('0000-00-00'); ERROR 22007: Incorrect date value: '0000-00-00' for column 'a' at row 1 SET SQL_MODE=DEFAULT; @@ -245,8 +247,8 @@ 1000-00-00 SELECT * FROM t2 WHERE a = '1000-00-00'; a -1000-00-00 -1000-00-00 +Warnings: +Warning 1292 Incorrect datetime value: '1000-00-00' INSERT INTO t1 VALUES ('1000-00-00'); ERROR 22007: Incorrect date value: '1000-00-00' for column 'a' at row 1 SET SQL_MODE=DEFAULT; mysqltest: Result length mismatch - skipping '/dev/shm/var_auto_j9wA/5/log/main.type_date/' worker[1] Trying to dump core for [mysqltest - pid: 9640, winpid: 9640] worker[1] Trying to dump core for [mysqld.1 - pid: 7680, winpid: 7680] main.flush_read_lock 'xtradb' w1 [ fail ] timeout after 900 seconds Test ended at 2013-07-04 18:17:46 Test case timeout after 900 seconds == /dev/shm/var_auto_j9wA/1/log/flush_read_lock.log == # Skip last part of compatibility testing as this statement # releases metadata locks in non-standard place. Success: Was able to run 'call p2((select count(*) from t1_base))' under FTWRL. Success: Was able to run 'call p2((select count(*) from t1_base))' with FTWRL active in another connection. # # 5.b) In case when an expression uses function which updates # base tables CALL should be incompatible with FTWRL. # # Skip last part of compatibility testing as this statement # releases metadata locks in non-standard place. Success: Was not able to run 'call p2(f2_base())' under FTWRL. Success: 'call p2(f2_base())' is blocked by FTWRL active in another connection. # # 5.c) If function used as argument updates temporary tables # CALL statement should be compatible with FTWRL. # # Skip last part of compatibility testing as this statement # releases metadata locks in non-standard place. Error: Wasn't able to run 'call p2(f2_temp())' under FTWRL! Success: Was able to run 'call p2(f2_temp())' with FTWRL active in another connection. == /dev/shm/var_auto_j9wA/1/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 '/data0/psergey/dev2/10.0-monty/mysql-test/var/tmp/1/mysqld.1.sock' (111 "Connection refused") - skipping '/dev/shm/var_auto_j9wA/1/log/main.flush_read_lock-xtradb/' ***Warnings generated in error logs during shutdown after running tests: main.events_trans main.flush_block_commit main.deadlock_innodb main.flush-innodb main.endspace main.events_trans_notembedded main.flush_read_lock main.consistent_snapshot Attempting backtrace. You can use the following information to find out main.flush_read_lock_kill 'xtradb' w1 [ pass ] 101 main.foreign_key 'xtradb' w1 [ pass ] 59 worker[3] Trying to dump core for [mysqltest - pid: 29722, winpid: 29722] worker[3] Trying to dump core for [mysqld.1 - pid: 29545, winpid: 29545] main.innodb_mysql_sync 'xtradb' w3 [ fail ] timeout after 900 seconds Test ended at 2013-07-04 18:21:15 Test case timeout after 900 seconds == /dev/shm/var_auto_j9wA/3/log/innodb_mysql_sync.log == WHERE state= 'Waiting for table metadata lock' AND info='SELECT * FROM t1' Id User Host db Command Time State Info Progress 14 root localhost test Sleep 331 NULL 0.000 19 root localhost test Sleep 31 NULL 0.000 20 root localhost test Query 0 init show full processlist 0.000 SET DEBUG_SYNC= "now SIGNAL query"; # Connection default # Reaping: ALTER TABLE t1 ADD UNIQUE INDEX(a) # Connection con1 # Reaping: SELECT * FROM t1 a b # Test 3: Primary index (explicit), should block reads. # Connection default ALTER TABLE t1 DROP INDEX a; SET DEBUG_SYNC= "alter_table_manage_keys SIGNAL manage WAIT_FOR query"; # Sending: ALTER TABLE t1 ADD PRIMARY KEY (a); # Connection con1 SET DEBUG_SYNC= "now WAIT_FOR manage"; == /dev/shm/var_auto_j9wA/3/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default': 2013 Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer" - skipping '/dev/shm/var_auto_j9wA/3/log/main.innodb_mysql_sync-xtradb/' ***Warnings generated in error logs during shutdown after running tests: main.innodb_bug878769 main.innodb_mysql_sync main.innodb_ext_key main.information_schema_inno Attempting backtrace. You can use the following information to find out main.innodb_utf8 'xtradb' w3 [ pass ] 38 main.lowercase_table2 'xtradb' w3 [ skipped ] Test requires: 'lowercase2' -------------------------------------------------------------------------- The servers were restarted 180 times Spent 1015.401 of 1271 seconds executing testcases Completed: Failed 60/630 tests, 90.48% were successful. Failing test(s): main.partition_binlog main.innodb_ignore_builtin main.commit_1innodb main.mysqldump main.sp_trans main.mysql_client_test main.mysql_client_test_nonblock main.ctype_cp932_binlog_stm main.select_pkeycache main.status main.row-checksum-old main.alter_table_online main.alter_table_trans main.commit main.statistics main.myisam main.merge_mmap main.func_crypt main.func_time main.merge main.limit_rows_examined main.plugin main.repair main.ps_ddl main.select main.sp-error main.select_jcl6 main.signal main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.upgrade main.view main.partition_debug_sync main.partition_mgm_err main.partition_myisam main.partition_truncate main.group_min_max_innodb main.log_tables_upgrade main.mysql_upgrade main.mysql_upgrade_ssl main.mysqlcheck main.row-checksum main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.alter_table main.analyze main.cast main.1st main.check main.create main.type_decimal main.truncate_coverage main.type_date main.flush_read_lock main.innodb_mysql_sync 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 Errors/warnings were found in logfiles during server shutdown after running the following sequence(s) of tests: main.partition_binlog main.innodb_ignore_builtin main.bug39022 main.commit_1innodb main.plugin_auth main.ctype_cp932_binlog_stm main.myisam main.merge_mmap main.mdev375 main.merge main.mdev316 main.function_defaults_notembedded main.mdev-504 main.func_timestamp main.func_time_hires main.grant_lowercase_fs main.insert main.gcc296 main.help main.information_schema_parameters main.index_intersect main.group_min_max main.handlersocket main.index_merge_myisam main.key main.gis2 main.grant4 main.gis main.key_primary main.grant main.gis-rt-precise main.join_cache main.handler_read_last main.having main.in_datetime_241 main.key_diff main.gis-precise main.information_schema2 main.kill main.grant_cache_no_prot main.information_schema_db main.limit_rows_examined main.limit main.last_value main.gis-rtree main.grant_cache_ps_prot main.insert_select main.join_nested main.insert_update main.greedy_optimizer main.join_optimizer main.keywords main.grant2 main.join_crash main.join main.implicit_char_to_num_conversion main.information_schema_routines main.information_schema_chmod main.join_nested_jcl6 main.insert_notembedded main.lock_multi main.log_slow main.outfile main.overflow main.order_by main.perror-win main.order_fill_sortbuf main.parser_precedence main.parser_stack main.loaddata main.lock_multi_bug38499 main.plugin main.order_by_sortkey main.parser main.outfile_loaddata main.packet main.lock_multi_bug38691 main.lowercase_fs_off main.perror main.loadxml main.parser_not_embedded main.log_tables_debug main.locale main.renamedb main.not_partition main.mysqltest_cont_on_error main.mysql_cp932 main.myisam_debug main.mysql_not_windows main.no_binlog main.myisam-system main.myisam_icp main.mix2_myisam main.not_embedded_server main.mrr_icp_extra main.mysqld_option_err main.mysql-bug45236 main.null main.odbc main.mix2_myisam_ucs2 main.rename main.mysql_locale_posix main.mysql_protocols main.mysqlhotcopy_myisam main.mysqld--help main.myisam_icp_notembedded main.openssl_1 main.mysql-bug41486 main.mysqlshow main.mysqld--defaults-file main.mysqltest_ps main.metadata main.mysqladmin main.mysqltest_256 main.negation_elimination main.myisampack main.mysql_comments main.olap main.mysql main.non_blocking_api main.merge_debug main.mysqlslap main.repair main.null_key main.myisam_mrr main.sp-destruct main.partition_order main.partition_pruning main.partition_truncate main.partition_range main.partition_symlink main.partition_sync main.alter_table main.adddate_454 main.almost_full main.alias main.alter_table_mdev539_maria main.analyze main.alter_table_mdev539_myisam main.change_user_notembedded main.check main.change_user main.events_trans main.flush_block_commit main.deadlock_innodb main.flush-innodb main.endspace main.events_trans_notembedded main.flush_read_lock main.consistent_snapshot main.innodb_bug878769 main.innodb_mysql_sync main.innodb_ext_key main.information_schema_inno 39 tests were skipped, 28 by the test itself.