binlog.binlog_auto_increment_bug33029 'row' [ fail ] CURRENT_TEST: binlog.binlog_auto_increment_bug33029 mysqltest: At line 50: query 'DROP PROCEDURE IF EXISTS p2' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > 11 SELECT * FROM t2; id 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 DROP TABLE IF EXISTS t1, t2; DROP PROCEDURE IF EXISTS p1; More results from queries before failure can be found in /home/sven/bzr/b38350-test_cleanup/6.0-rpl/mysql-test/var/2/log/binlog_auto_increment_bug33029.log - saving '/home/sven/bzr/b38350-test_cleanup/6.0-rpl/mysql-test/var/2/log/binlog.binlog_auto_increment_bug33029-row/' to '/home/sven/bzr/b38350-test_cleanup/6.0-rpl/mysql-test/var/log/binlog.binlog_auto_increment_bug33029-row/' - found 'core.26179' (0/5) Trying 'gdb' to get a backtrace Core generated by '/home/sven/bzr/b38350-test_cleanup/6.0-rpl/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 `/home/sven/bzr/b38350-test_cleanup/6.0-rpl/sql/mysqld --defaults-group-suffix=.'. Program terminated with signal 6, Aborted. [New process 26524] [New process 26523] [New process 26376] [New process 26358] [New process 26333] [New process 26331] [New process 26232] [New process 26231] [New process 26230] [New process 26229] [New process 26228] [New process 26221] [New process 26220] [New process 26186] [New process 26185] [New process 26179] #0 0xb7f2b410 in __kernel_vsyscall () #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee4ae7 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08995a91 in my_write_core (sig=6) at stacktrace.c:307 #3 0x083341c4 in handle_segfault (sig=6) at mysqld.cc:2674 #4 #5 0xb7f2b410 in __kernel_vsyscall () #6 0xb7c49085 in raise () from /lib/tls/i686/cmov/libc.so.6 #7 0xb7c4aa01 in abort () from /lib/tls/i686/cmov/libc.so.6 #8 0xb7c4210e in __assert_fail () from /lib/tls/i686/cmov/libc.so.6 #9 0x0840182f in check_binlog_magic (log=0x9746204, errmsg=0xaf890db4) at log.cc:2443 #10 0x084dbb5f in next_event (rli=0x9745a8c) at slave.cc:4076 #11 0x084df589 in exec_relay_log_event (thd=0x97d5988, rli=0x9745a8c) at slave.cc:2005 #12 0x084e05ad in handle_slave_sql (arg=0x97447e0) at slave.cc:2708 #13 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #14 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 16 (process 26179): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ced881 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x08334ab1 in handle_connections_sockets (arg=0x0) at mysqld.cc:5182 #3 0x08338b6f in main (argc=11, argv=0xbf9df3d4) at mysqld.cc:4690 Thread 15 (process 26185): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f37fb0) at Synchronize.cpp:123 #3 0x086579e8 in Cache::ioThread (this=0xb6f37c70) at Cache.cpp:945 #4 0x08657b8f in Cache::ioThread (arg=0xb6f37c70) at Cache.cpp:766 #5 0x08642b25 in Thread::thread (this=0xb6f37fb0) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f37fb0) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 14 (process 26186): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f38090) at Synchronize.cpp:123 #3 0x086579e8 in Cache::ioThread (this=0xb6f37c70) at Cache.cpp:945 #4 0x08657b8f in Cache::ioThread (arg=0xb6f37c70) at Cache.cpp:766 #5 0x08642b25 in Thread::thread (this=0xb6f38090) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f38090) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 13 (process 26220): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3dd2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a716 in Synchronize::sleep (this=0xb6f3f238, milliseconds=1000, callersMutex=0x0) at Synchronize.cpp:183 #3 0x0870a50f in Synchronize::sleep (this=0xb6f3f238, milliseconds=1000) at Synchronize.cpp:136 #4 0x0866dab3 in Database::ticker (this=0xb7138640) at Database.cpp:1882 #5 0x0866dae9 in Database::ticker (database=0xb7138640) at Database.cpp:1871 #6 0x08642b25 in Thread::thread (this=0xb6f3f238) at Thread.cpp:167 #7 0x08642d35 in Thread::thread (parameter=0xb6f3f238) at Thread.cpp:146 #8 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #9 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 12 (process 26221): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f3f318) at Synchronize.cpp:123 #3 0x086b6d9d in PageWriter::writer (this=0xb6f39290) at PageWriter.cpp:171 #4 0x086b6ec9 in PageWriter::writer (arg=0xb6f39290) at PageWriter.cpp:160 #5 0x08642b25 in Thread::thread (this=0xb6f3f318) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f3f318) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 11 (process 26228): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f435b8) at Synchronize.cpp:123 #3 0x0871e3f6 in Gopher::gopherThread (this=0xb6f39268) at Gopher.cpp:58 #4 0x0871e5b9 in Gopher::gopherThread (arg=0xb6f39268) at Gopher.cpp:37 #5 0x08642b25 in Thread::thread (this=0xb6f435b8) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f435b8) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 10 (process 26229): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f43698) at Synchronize.cpp:123 #3 0x0871e3f6 in Gopher::gopherThread (this=0xb6f39240) at Gopher.cpp:58 #4 0x0871e5b9 in Gopher::gopherThread (arg=0xb6f39240) at Gopher.cpp:37 #5 0x08642b25 in Thread::thread (this=0xb6f43698) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f43698) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 9 (process 26230): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f43778) at Synchronize.cpp:123 #3 0x0871e3f6 in Gopher::gopherThread (this=0xb6f39218) at Gopher.cpp:58 #4 0x0871e5b9 in Gopher::gopherThread (arg=0xb6f39218) at Gopher.cpp:37 #5 0x08642b25 in Thread::thread (this=0xb6f43778) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f43778) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 8 (process 26231): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f43858) at Synchronize.cpp:123 #3 0x0871e3f6 in Gopher::gopherThread (this=0xb6f391f0) at Gopher.cpp:58 #4 0x0871e5b9 in Gopher::gopherThread (arg=0xb6f391f0) at Gopher.cpp:37 #5 0x08642b25 in Thread::thread (this=0xb6f43858) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f43858) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 7 (process 26232): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f43938) at Synchronize.cpp:123 #3 0x0871e3f6 in Gopher::gopherThread (this=0xb6f391c8) at Gopher.cpp:58 #4 0x0871e5b9 in Gopher::gopherThread (arg=0xb6f391c8) at Gopher.cpp:37 #5 0x08642b25 in Thread::thread (this=0xb6f43938) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f43938) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 6 (process 26331): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3dd2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a716 in Synchronize::sleep (this=0xb6f46030, milliseconds=4000, callersMutex=0x0) at Synchronize.cpp:183 #3 0x0870a50f in Synchronize::sleep (this=0xb6f46030, milliseconds=4000) at Synchronize.cpp:136 #4 0x086ce0d1 in Scheduler::schedule (this=0xb6f3e600) at Scheduler.cpp:150 #5 0x086ce135 in Scheduler::schedule (lpParameter=0xb6f3e600) at Scheduler.cpp:159 #6 0x08642b25 in Thread::thread (this=0xb6f46030) at Thread.cpp:167 #7 0x08642d35 in Thread::thread (parameter=0xb6f46030) at Thread.cpp:146 #8 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #9 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 5 (process 26333): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0870a87d in Synchronize::sleep (this=0xb6f4bf38) at Synchronize.cpp:123 #3 0x086ce0e8 in Scheduler::schedule (this=0xb6f3e568) at Scheduler.cpp:152 #4 0x086ce135 in Scheduler::schedule (lpParameter=0xb6f3e568) at Scheduler.cpp:159 #5 0x08642b25 in Thread::thread (this=0xb6f4bf38) at Thread.cpp:167 #6 0x08642d35 in Thread::thread (parameter=0xb6f4bf38) at Thread.cpp:146 #7 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #8 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 4 (process 26358): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee3dd2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0899a512 in safe_cond_timedwait (cond=0x96915c0, mp=0x9691560, abstime=0xaf670378, file=0x8b9ba66 "ma_checkpoint.c", line=705) at thr_mutex.c:289 #3 0x08894ed4 in ma_checkpoint_background (arg=0x1e) at ma_checkpoint.c:705 #4 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #5 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 3 (process 26376): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee7b1a in do_sigwait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0xb7ee7bbf in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 #3 0x0833318c in signal_hand (arg=0x0) at mysqld.cc:2879 #4 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #5 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 2 (process 26523): #0 0x089797ff in _checkchunk (irem=0x970f670, filename=0x8a993cc "lock.cc", lineno=857) at safemalloc.c:483 #1 0x08979949 in _sanity (filename=0x8a993cc "lock.cc", lineno=857) at safemalloc.c:515 #2 0x089789c5 in _mymalloc (size=28, filename=0x8a993cc "lock.cc", lineno=857, MyFlags=0) at safemalloc.c:130 #3 0x08329f9e in get_lock_data (thd=0x97027d8, table_ptr=0xaf8c13d4, count=1, flags=2, write_lock_used=0xaf8c104c) at lock.cc:853 #4 0x0832aece in mysql_lock_tables (thd=0x97027d8, tables=0xaf8c13d4, count=1, flags=27, need_reopen=0xaf8c1097) at lock.cc:249 #5 0x08397ce2 in open_ltable (thd=0x97027d8, table_list=0xaf8c137c, lock_type=TL_WRITE_CONCURRENT_INSERT, lock_flags=27) at sql_base.cc:4097 #6 0x08397dfe in open_performance_schema_table (thd=0x97027d8, one_table=0xaf8c137c, backup=0xaf8c111c) at sql_base.cc:8014 #7 0x0840fb61 in Log_to_csv_event_handler::log_general (this=0x96bbc88, thd=0x97027d8, event_time=1225993093, user_host=0xaf8c1608 "root[root] @ localhost []", user_host_len=25, thread_id=7, command_type=0x8aa8f59 "Query", command_type_len=5, sql_text=0x976e6b8 "DROP PROCEDURE IF EXISTS p2", sql_text_len=27, client_cs=0x8d4cde0) at log.cc:417 #8 0x0840cb22 in LOGGER::general_log_write (this=0x8d5af20, thd=0x97027d8, command=COM_QUERY, query=0x976e6b8 "DROP PROCEDURE IF EXISTS p2", query_length=27) at log.cc:1540 #9 0x0840cbf0 in general_log_write (thd=0x97027d8, command=COM_QUERY, query=0x976e6b8 "DROP PROCEDURE IF EXISTS p2", query_length=27) at log.cc:5512 #10 0x083502bc in dispatch_command (command=COM_QUERY, thd=0x97027d8, packet=0x97625d9 "DROP PROCEDURE IF EXISTS p2", packet_length=27) at sql_parse.cc:1001 #11 0x08351945 in do_command (thd=0x97027d8) at sql_parse.cc:689 #12 0x0833df91 in handle_one_connection (arg=0x97027d8) at sql_connect.cc:1156 #13 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #14 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 1 (process 26524): #0 0xb7f2b410 in __kernel_vsyscall () #1 0xb7ee4ae7 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08995a91 in my_write_core (sig=6) at stacktrace.c:307 #3 0x083341c4 in handle_segfault (sig=6) at mysqld.cc:2674 #4 #5 0xb7f2b410 in __kernel_vsyscall () #6 0xb7c49085 in raise () from /lib/tls/i686/cmov/libc.so.6 #7 0xb7c4aa01 in abort () from /lib/tls/i686/cmov/libc.so.6 #8 0xb7c4210e in __assert_fail () from /lib/tls/i686/cmov/libc.so.6 #9 0x0840182f in check_binlog_magic (log=0x9746204, errmsg=0xaf890db4) at log.cc:2443 #10 0x084dbb5f in next_event (rli=0x9745a8c) at slave.cc:4076 #11 0x084df589 in exec_relay_log_event (thd=0x97d5988, rli=0x9745a8c) at slave.cc:2005 #12 0x084e05ad in handle_slave_sql (arg=0x97447e0) at slave.cc:2708 #13 0xb7edf4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #14 0xb7cf4e5e in clone () from /lib/tls/i686/cmov/libc.so.6 Current language: auto; currently c mysql-test-run: *** ERROR: Only 12 of 80 completed. Not all tests completed