main.innodb_mysql [ fail ] timeout after 900 seconds Test ended at 2009-12-17 03:03:25 Test case timeout after 900 seconds == /MySQL/REPO/V51/platform/mysql-5.1.43-optim/mysql-test/var/log/innodb_mysql.log == 1 init+con1+con2 # Switch to connection con1 # 3. test for updated key column: TRUNCATE t1; TRUNCATE t2; INSERT INTO t1 VALUES (1,'init'); BEGIN; UPDATE t1 SET a = 2, b = CONCAT(b, '+con1') WHERE a = 1; affected rows: 1 info: Rows matched: 1 Changed: 1 Warnings: 0 SELECT * FROM t1; a b 2 init+con1 # Switch to connection con2 CALL p1;; # Switch to connection con1 SELECT * FROM t1; a b 2 init+con1 COMMIT; == /MySQL/REPO/V51/platform/mysql-5.1.43-optim/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/MySQL/REPO/V51/platform/mysql-5.1.43-optim/mysql-test/var/tmp/mysqld.1.sock' (111) - saving '/MySQL/REPO/V51/platform/mysql-5.1.43-optim/mysql-test/var/log/main.innodb_mysql/' to '/MySQL/REPO/V51/platform/mysql-5.1.43-optim/mysql-test/var/log/main.innodb_mysql/' - found 'core.15740' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/MySQL/REPO/V51/platform/mysql-5.1.43-optim/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). -------------------------- [?1034hUsing host libthread_db library "/lib/libthread_db.so.1". warning: Can't read pathname for load map: Input/output error. Core was generated by `/MySQL/REPO/V51/platform/mysql-5.1.43-optim/sql/mysqld --defaults-group-suffix='. Program terminated with signal 6, Aborted. #0 0xffffe410 in __kernel_vsyscall () #0 0xffffe410 in __kernel_vsyscall () #1 0x4003b397 in pthread_kill () from /lib/libpthread.so.0 #2 0x084f22eb in my_write_core () #3 0x0821374e in handle_segfault () #4 #5 0xffffe410 in __kernel_vsyscall () #6 0x40284591 in select () from /lib/libc.so.6 #7 0x08217436 in handle_connections_sockets () #8 0x08217e88 in main () Thread 11 (process 15742): #0 0xffffe410 in __kernel_vsyscall () #1 0x4003a566 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0842a7e3 in os_event_wait_low () #3 0x08429d4b in os_aio_simulated_handle () #4 0x083f335c in fil_aio_wait () #5 0x0845d6d8 in io_handler_thread () #6 0x40036192 in start_thread () from /lib/libpthread.so.0 #7 0x4028b02e in clone () from /lib/libc.so.6 Thread 10 (process 15743): #0 0xffffe410 in __kernel_vsyscall () #1 0x4003a566 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0842a7e3 in os_event_wait_low () #3 0x08429d4b in os_aio_simulated_handle () #4 0x083f335c in fil_aio_wait () #5 0x0845d6d8 in io_handler_thread () #6 0x40036192 in start_thread () from /lib/libpthread.so.0 #7 0x4028b02e in clone () from /lib/libc.so.6 Thread 9 (process 15744): #0 0xffffe410 in __kernel_vsyscall () #1 0x4003a566 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0842a7e3 in os_event_wait_low () #3 0x08429d4b in os_aio_simulated_handle () #4 0x083f335c in fil_aio_wait () #5 0x0845d6d8 in io_handler_thread () #6 0x40036192 in start_thread () from /lib/libpthread.so.0 #7 0x4028b02e in clone () from /lib/libc.so.6 Thread 8 (process 15745): #0 0xffffe410 in __kernel_vsyscall () #1 0x4003a566 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0842a7e3 in os_event_wait_low () #3 0x08429d4b in os_aio_simulated_handle () #4 0x083f335c in fil_aio_wait () #5 0x0845d6d8 in io_handler_thread () #6 0x40036192 in start_thread () from /lib/libpthread.so.0 #7 0x4028b02e in clone () from /lib/libc.so.6 Thread 7 (process 15746): #0 0xffffe410 in __kernel_vsyscall () #1 0x40284591 in select () from /lib/libc.so.6 #2 0x0842b4be in os_thread_sleep () #3 0x0845cebd in srv_lock_timeout_and_monitor_thread () #4 0x40036192 in start_thread () from /lib/libpthread.so.0 #5 0x4028b02e in clone () from /lib/libc.so.6 Thread 6 (process 15747): #0 0xffffe410 in __kernel_vsyscall () #1 0x40284591 in select () from /lib/libc.so.6 #2 0x0842b4be in os_thread_sleep () #3 0x0845d574 in srv_error_monitor_thread () #4 0x40036192 in start_thread () from /lib/libpthread.so.0 #5 0x4028b02e in clone () from /lib/libc.so.6 Thread 5 (process 15748): #0 0xffffe410 in __kernel_vsyscall () #1 0x40284591 in select () from /lib/libc.so.6 #2 0x0842b4be in os_thread_sleep () #3 0x0845b527 in srv_master_thread () #4 0x40036192 in start_thread () from /lib/libpthread.so.0 #5 0x4028b02e in clone () from /lib/libc.so.6 Thread 4 (process 15749): #0 0xffffe410 in __kernel_vsyscall () #1 0x4003e2aa in do_sigwait () from /lib/libpthread.so.0 #2 0x4003e34f in sigwait () from /lib/libpthread.so.0 #3 0x08212adc in signal_hand () #4 0x40036192 in start_thread () from /lib/libpthread.so.0 #5 0x4028b02e in clone () from /lib/libc.so.6 Thread 3 (process 15805): #0 0x08365dd1 in st_select_lex::cleanup () #1 0x0829b299 in mysql_select () #2 0x0829bc8d in handle_select () #3 0x0821ee10 in execute_sqlcom_select () #4 0x08222d3c in mysql_execute_command () #5 0x0822cd18 in mysql_parse () #6 0x0822dd01 in dispatch_command () #7 0x0822e501 in do_command () #8 0x0821c6dd in handle_one_connection () #9 0x40036192 in start_thread () from /lib/libpthread.so.0 #10 0x4028b02e in clone () from /lib/libc.so.6 Thread 2 (process 15806): #0 0xffffe410 in __kernel_vsyscall () #1 0x4003d63f in fsync () from /lib/libpthread.so.0 #2 0x084277c7 in os_file_flush () #3 0x083f28e5 in fil_flush () #4 0x0841930c in log_write_up_to () #5 0x08472b2d in trx_commit_off_kernel () #6 0x0846ac06 in trx_finish_rollback_off_kernel () #7 0x08436fde in que_thr_dec_refer_count () #8 0x08437131 in que_run_threads () #9 0x0846ca90 in trx_general_rollback_for_mysql () #10 0x0846d73b in trx_rollback_for_mysql () #11 0x083c105c in innobase_rollback () #12 0x0830c9e1 in ha_rollback_trans () #13 0x08202d94 in THD::cleanup () #14 0x08212d02 in unlink_thd () #15 0x08212d76 in one_thread_per_connection_end () #16 0x0821c586 in handle_one_connection () #17 0x40036192 in start_thread () from /lib/libpthread.so.0 #18 0x4028b02e in clone () from /lib/libc.so.6 Thread 1 (process 15740): #0 0xffffe410 in __kernel_vsyscall () #1 0x4003b397 in pthread_kill () from /lib/libpthread.so.0 #2 0x084f22eb in my_write_core () #3 0x0821374e in handle_segfault () #4 #5 0xffffe410 in __kernel_vsyscall () #6 0x40284591 in select () from /lib/libc.so.6 #7 0x08217436 in handle_connections_sockets () #8 0x08217e88 in main ()