CURRENT_TEST: main.exp6 mysqltest: At line 79: query 'UPDATE `PP_H` SET `varchar_5` = 'z' WHERE ( ( ( `PP_H` . `varchar_5` >= 'j' ) OR `PP_H` . `varchar_5` IN ('q', 'r' ) ) OR `PP_H` . `int_signed` BETWEEN 3 AND ( 3 + 8 ) )' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > `varchar_10` varchar(10), `datetime` datetime, `int_signed_key` int signed, `date_key` date, key (`varchar_10_key` ), key (`datetime_key` ), key (`varchar_5_key` ), key (`int_signed_key` ), key (`date_key` )) ENGINE=innodb /*!50100 PARTITION BY range column_list(varchar_5, varchar_10) subpartition by hash ( year(`date`)) subpartitions 2 ( partition p0 values less than (column_list('m','m')), partition p1 values less than (column_list('zz','zz'))) */; More results from queries before failure can be found in /mysql-5.1/mysql-test/var/log/exp6.log Server [mysqld.1 - pid: 3815, winpid: 3815, exit: 256] failed during test run - saving '/mysql-5.1/mysql-test/var/log/main.exp6/' to '/mysql-5.1/mysql-test/var/log/main.exp6/' - found 'core' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql-5.1/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). -------------------------- warning: Can't read pathname for load map: Input/output error. Core was generated by `/mysql-5.1/sql/mysqld --defaults-group-suffix=.1'. Program terminated with signal 6, Aborted. [New process 3837] [New process 3819] [New process 3822] [New process 3818] [New process 3825] [New process 3826] [New process 3824] [New process 3820] [New process 3823] [New process 3827] [New process 3821] [New process 3816] #0 0xb7f2f430 in __kernel_vsyscall () #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f121c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08de4e4f in my_write_core (sig=6) at stacktrace.c:310 #3 0x0840befc in handle_segfault (sig=6) at mysqld.cc:2569 #4 #5 0xb7f2f430 in __kernel_vsyscall () #6 0xb7d596d0 in raise () from /lib/tls/i686/cmov/libc.so.6 #7 0xb7d5b098 in abort () from /lib/tls/i686/cmov/libc.so.6 #8 0x08b10a36 in row_update_for_mysql (mysql_rec=0xb689580 "\f?\001p \001m ", prebuilt=0xb69b780) at row/row0mysql.c:1355 #9 0x08a4d052 in ha_innobase::update_row (this=0xb6893e8, old_row=0xb689580 "\f?\001p \001m ", new_row=0xb689538 "\f?\001p \001z ") at handler/ha_innodb.cc:4663 #10 0x0878b533 in handler::ha_update_row (this=0xb6893e8, old_data=0xb689580 "\f?\001p \001m ", new_data=0xb689538 "\f?\001p \001z ") at handler.cc:4690 #11 0x087b0373 in ha_partition::update_row (this=0xb688eb0, old_data=0xb689580 "\f?\001p \001m ", new_data=0xb689538 "\f?\001p \001z ") at ha_partition.cc:3090 #12 0x0878b533 in handler::ha_update_row (this=0xb688eb0, old_data=0xb689580 "\f?\001p \001m ", new_data=0xb689538 "\f?\001p \001z ") at handler.cc:4690 #13 0x0863d305 in mysql_update (thd=0xb653318, table_list=0xb68b0c8, fields=@0xb65474c, values=@0xb654968, conds=0xb68b880, order_num=0, order=0x0, limit=18446744073709551591, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xb27a26a0, updated_return=0xb27a2698) at sql_update.cc:649 #14 0x08448cd4 in mysql_execute_command (thd=0xb653318) at sql_parse.cc:3057 #15 0x0845f33f in mysql_parse (thd=0xb653318, inBuf=0xb68aef0 "UPDATE `PP_H` SET `varchar_5` = 'z' WHERE ( ( ( `PP_H` . `varchar_5` >= 'j' ) OR `PP_H` . `varchar_5` IN ('q', 'r' ) ) OR `PP_H` . `int_signed` BETWEEN 3 AND ( 3 + 8 ) )", length=171, found_semicolon=0xb27a3054) at sql_parse.cc:6002 #16 0x08461ae4 in dispatch_command (command=COM_QUERY, thd=0xb653318, packet=0xb677fd1 "UPDATE `PP_H` SET `varchar_5` = 'z' WHERE ( ( ( `PP_H` . `varchar_5` >= 'j' ) OR `PP_H` . `varchar_5` IN ('q', 'r' ) ) OR `PP_H` . `int_signed` BETWEEN 3 AND ( 3 + 8 ) )", packet_length=171) at sql_parse.cc:1222 #17 0x08465739 in do_command (thd=0xb653318) at sql_parse.cc:855 #18 0x0842a3bf in handle_one_connection (arg=0xb653318) at sql_connect.cc:1131 #19 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #20 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 12 (process 3816): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7e0a7b1 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x0840d917 in handle_connections_sockets (arg=0x0) at mysqld.cc:5084 #3 0x0841b3be in main (argc=8, argv=0xbfc49fd4) at mysqld.cc:4568 Thread 11 (process 3821): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f110e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08df0edc in safe_cond_wait (cond=0xb5ceee4, mp=0xb5cee98, file=0x909a9dd "os/os0sync.c", line=396) at thr_mutex.c:237 #3 0x08aad421 in os_event_wait_low (event=0xb5cee98, reset_sig_count=0) at os/os0sync.c:396 #4 0x08aa9eb1 in os_aio_simulated_handle (global_segment=3, message1=0xb59e0380, message2=0xb59e037c, type=0xb59e0378) at os/os0file.c:3997 #5 0x08c43d32 in fil_aio_wait (segment=3) at fil/fil0fil.c:4412 #6 0x08b51869 in io_handler_thread (arg=0x935916c) at srv/srv0start.c:490 #7 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 10 (process 3827): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f15300 in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x084092bc in signal_hand (arg=0x0) at mysqld.cc:2771 #3 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #4 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 9 (process 3823): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f110e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08df0edc in safe_cond_wait (cond=0xb5ceff4, mp=0xb5cefa8, file=0x909a9dd "os/os0sync.c", line=396) at thr_mutex.c:237 #3 0x08aad421 in os_event_wait_low (event=0xb5cefa8, reset_sig_count=0) at os/os0sync.c:396 #4 0x08aa9eb1 in os_aio_simulated_handle (global_segment=5, message1=0xb49de380, message2=0xb49de37c, type=0xb49de378) at os/os0file.c:3997 #5 0x08c43d32 in fil_aio_wait (segment=5) at fil/fil0fil.c:4412 #6 0x08b51869 in io_handler_thread (arg=0x9359174) at srv/srv0start.c:490 #7 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 8 (process 3820): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f110e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08df0edc in safe_cond_wait (cond=0xb5cee5c, mp=0xb5cee10, file=0x909a9dd "os/os0sync.c", line=396) at thr_mutex.c:237 #3 0x08aad421 in os_event_wait_low (event=0xb5cee10, reset_sig_count=0) at os/os0sync.c:396 #4 0x08aa9eb1 in os_aio_simulated_handle (global_segment=2, message1=0xb61e1380, message2=0xb61e137c, type=0xb61e1378) at os/os0file.c:3997 #5 0x08c43d32 in fil_aio_wait (segment=2) at fil/fil0fil.c:4412 #6 0x08b51869 in io_handler_thread (arg=0x9359168) at srv/srv0start.c:490 #7 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 7 (process 3824): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7e0a7b1 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x08aaed1e in os_thread_sleep (tm=1000000) at os/os0thread.c:294 #3 0x08b4d2d2 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1978 #4 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #5 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 6 (process 3826): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7e0a7b1 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x08aaed1e in os_thread_sleep (tm=1000000) at os/os0thread.c:294 #3 0x08b4ec4d in srv_master_thread (arg=0x0) at srv/srv0srv.c:2371 #4 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #5 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 5 (process 3825): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7e0a7b1 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x08aaed1e in os_thread_sleep (tm=1000000) at os/os0thread.c:294 #3 0x08b4e494 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2214 #4 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #5 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 4 (process 3818): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f110e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08df0edc in safe_cond_wait (cond=0xb5ced4c, mp=0xb5ced00, file=0x909a9dd "os/os0sync.c", line=396) at thr_mutex.c:237 #3 0x08aad421 in os_event_wait_low (event=0xb5ced00, reset_sig_count=0) at os/os0sync.c:396 #4 0x08aa9eb1 in os_aio_simulated_handle (global_segment=0, message1=0xb7d2b380, message2=0xb7d2b37c, type=0xb7d2b378) at os/os0file.c:3997 #5 0x08c43d32 in fil_aio_wait (segment=0) at fil/fil0fil.c:4412 #6 0x08b51869 in io_handler_thread (arg=0x9359160) at srv/srv0start.c:490 #7 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 3 (process 3822): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f110e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08df0edc in safe_cond_wait (cond=0xb5cef6c, mp=0xb5cef20, file=0x909a9dd "os/os0sync.c", line=396) at thr_mutex.c:237 #3 0x08aad421 in os_event_wait_low (event=0xb5cef20, reset_sig_count=0) at os/os0sync.c:396 #4 0x08aa9eb1 in os_aio_simulated_handle (global_segment=4, message1=0xb51df380, message2=0xb51df37c, type=0xb51df378) at os/os0file.c:3997 #5 0x08c43d32 in fil_aio_wait (segment=4) at fil/fil0fil.c:4412 #6 0x08b51869 in io_handler_thread (arg=0x9359170) at srv/srv0start.c:490 #7 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 2 (process 3819): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f110e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08df0edc in safe_cond_wait (cond=0xb5cedd4, mp=0xb5ced88, file=0x909a9dd "os/os0sync.c", line=396) at thr_mutex.c:237 #3 0x08aad421 in os_event_wait_low (event=0xb5ced88, reset_sig_count=0) at os/os0sync.c:396 #4 0x08aa9eb1 in os_aio_simulated_handle (global_segment=1, message1=0xb69e2380, message2=0xb69e237c, type=0xb69e2378) at os/os0file.c:3997 #5 0x08c43d32 in fil_aio_wait (segment=1) at fil/fil0fil.c:4412 #6 0x08b51869 in io_handler_thread (arg=0x9359164) at srv/srv0start.c:490 #7 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 1 (process 3837): #0 0xb7f2f430 in __kernel_vsyscall () #1 0xb7f121c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08de4e4f in my_write_core (sig=6) at stacktrace.c:310 #3 0x0840befc in handle_segfault (sig=6) at mysqld.cc:2569 #4 #5 0xb7f2f430 in __kernel_vsyscall () #6 0xb7d596d0 in raise () from /lib/tls/i686/cmov/libc.so.6 #7 0xb7d5b098 in abort () from /lib/tls/i686/cmov/libc.so.6 #8 0x08b10a36 in row_update_for_mysql (mysql_rec=0xb689580 "\f?\001p \001m ", prebuilt=0xb69b780) at row/row0mysql.c:1355 #9 0x08a4d052 in ha_innobase::update_row (this=0xb6893e8, old_row=0xb689580 "\f?\001p \001m ", new_row=0xb689538 "\f?\001p \001z ") at handler/ha_innodb.cc:4663 #10 0x0878b533 in handler::ha_update_row (this=0xb6893e8, old_data=0xb689580 "\f?\001p \001m ", new_data=0xb689538 "\f?\001p \001z ") at handler.cc:4690 #11 0x087b0373 in ha_partition::update_row (this=0xb688eb0, old_data=0xb689580 "\f?\001p \001m ", new_data=0xb689538 "\f?\001p \001z ") at ha_partition.cc:3090 #12 0x0878b533 in handler::ha_update_row (this=0xb688eb0, old_data=0xb689580 "\f?\001p \001m ", new_data=0xb689538 "\f?\001p \001z ") at handler.cc:4690 #13 0x0863d305 in mysql_update (thd=0xb653318, table_list=0xb68b0c8, fields=@0xb65474c, values=@0xb654968, conds=0xb68b880, order_num=0, order=0x0, limit=18446744073709551591, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xb27a26a0, updated_return=0xb27a2698) at sql_update.cc:649 #14 0x08448cd4 in mysql_execute_command (thd=0xb653318) at sql_parse.cc:3057 #15 0x0845f33f in mysql_parse (thd=0xb653318, inBuf=0xb68aef0 "UPDATE `PP_H` SET `varchar_5` = 'z' WHERE ( ( ( `PP_H` . `varchar_5` >= 'j' ) OR `PP_H` . `varchar_5` IN ('q', 'r' ) ) OR `PP_H` . `int_signed` BETWEEN 3 AND ( 3 + 8 ) )", length=171, found_semicolon=0xb27a3054) at sql_parse.cc:6002 #16 0x08461ae4 in dispatch_command (command=COM_QUERY, thd=0xb653318, packet=0xb677fd1 "UPDATE `PP_H` SET `varchar_5` = 'z' WHERE ( ( ( `PP_H` . `varchar_5` >= 'j' ) OR `PP_H` . `varchar_5` IN ('q', 'r' ) ) OR `PP_H` . `int_signed` BETWEEN 3 AND ( 3 + 8 ) )", packet_length=171) at sql_parse.cc:1222 #17 0x08465739 in do_command (thd=0xb653318) at sql_parse.cc:855 #18 0x0842a3bf in handle_one_connection (arg=0xb653318) at sql_connect.cc:1131 #19 0xb7f0d4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #20 0xb7e1249e in clone () from /lib/tls/i686/cmov/libc.so.6