Binaries: sources from mysql-5.0.51a.tar.gz configured/compiled with: COMP_ENV_INFO="CC='gcc' CFLAGS='-Os -arch i386 -fno-common' CXX='gcc' CXXFLAGS='-Os -arch i386 -felide-constructors -fno-common -fno-exceptions' LDFLAGS='' ASFLAGS=''" CONFIGURE_LINE="./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Server (GPL)' '--with-server-suffix=' '--enable-thread-safe-client' '--enable-local-infile' '--with-pic' '--with-client-ldflags=-static' '--with-mysqld-ldflags=-static' '--with-zlib-dir=bundled' '--with-big-tables' '--with-yassl' '--with-readline' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--with-ndbcluster' '--with-csv-storage-engine' '--with-example-storage-engine' '--without-falcon' '--with-federated-storage-engine' '--with-innodb' '--with-extra-charsets=all' '--with-debug' 'CC=gcc' 'CFLAGS=-Os -arch i386 -fno-common' 'CXXFLAGS=-Os -arch i386 -felide-constructors -fno-common -fno-exceptions' 'CXX=gcc'" All tests run with: ./mysql-test-run.pl --force --skip-ndb --do-test=rpl CRASH 1 ======= rpl_log [ fail ] mysqltest: At line 75: query 'stop slave' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: < snip > master-bin.000001 414 Query 1 517 use `test`; create table t1 (word char(20) not null) master-bin.000001 517 Begin_load_query 1 1121 ;file_id=1;block_len=581 master-bin.000001 1121 Execute_load_query 1 1269 use `test`; load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines ;file_id=1 master-bin.000001 1269 Query 1 1345 use `test`; drop table t1 show binlog events from 98 limit 1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 98 Query 1 219 use `test`; create table t1(n int not null auto_increment primary key) show binlog events from 98 limit 2; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 98 Query 1 219 use `test`; create table t1(n int not null auto_increment primary key) master-bin.000001 219 Intvar 1 247 INSERT_ID=1 show binlog events from 98 limit 2,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 247 Query 1 338 use `test`; insert into t1 values (NULL) flush logs; create table t5 (a int); drop table t5; start slave; flush logs; stop slave; More results from queries before failure can be found in /Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/rpl_log.log rpl_log.log: ------------ stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; stop slave; reset master; reset slave; reset master; create table t1(n int not null auto_increment primary key); insert into t1 values (NULL); drop table t1; create table t1 (word char(20) not null); load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines; select count(*) from t1; count(*) 69 drop table t1; show binlog events; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 98 Server ver: VERSION, Binlog ver: 4 master-bin.000001 98 Query 1 219 use `test`; create table t1(n int not null auto_increment primary key) master-bin.000001 219 Intvar 1 247 INSERT_ID=1 master-bin.000001 247 Query 1 338 use `test`; insert into t1 values (NULL) master-bin.000001 338 Query 1 414 use `test`; drop table t1 master-bin.000001 414 Query 1 517 use `test`; create table t1 (word char(20) not null) master-bin.000001 517 Begin_load_query 1 1121 ;file_id=1;block_len=581 master-bin.000001 1121 Execute_load_query 1 1269 use `test`; load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines ;file_id=1 master-bin.000001 1269 Query 1 1345 use `test`; drop table t1 show binlog events from 98 limit 1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 98 Query 1 219 use `test`; create table t1(n int not null auto_increment primary key) show binlog events from 98 limit 2; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 98 Query 1 219 use `test`; create table t1(n int not null auto_increment primary key) master-bin.000001 219 Intvar 1 247 INSERT_ID=1 show binlog events from 98 limit 2,1; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 247 Query 1 338 use `test`; insert into t1 values (NULL) flush logs; create table t5 (a int); drop table t5; start slave; flush logs; stop slave; slave.err --------- CURRENT_TEST: rpl_log 080314 13:15:44 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 080314 13:15:44 [Warning] Setting lower_case_table_names=2 because file system for /Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/slave-data/ is case insensitive 080314 13:15:44 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: ready for connections. Version: '5.0.51a-debug-log' socket: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/tmp/slave.sock' port: 9308 MySQL Community Server (GPL) 080314 13:15:44 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/slave-relay-bin.000001' position: 4 080314 13:15:44 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log 'FIRST' at position 4 080314 13:15:44 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 080314 13:15:44 [Note] Slave I/O thread killed while reading event 080314 13:15:44 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 98 080314 13:15:44 [Note] Error reading relay log event: slave SQL thread was killed 080314 13:15:44 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/slave-relay-bin.000001' position: 4 080314 13:15:44 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log 'FIRST' at position 4 080314 13:15:44 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 080314 13:15:44 [Note] Slave I/O thread killed while reading event 080314 13:15:44 [Note] Slave I/O thread exiting, read up to log 'master-bin.000002', position 260 080314 13:15:44 - 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. 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. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=2 max_connections=100 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 39423 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Writing a core file Crash reporter: --------------- Process: mysqld [35489] Path: /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld Identifier: mysqld Version: ??? (???) Code Type: X86 (Native) Parent Process: perl [33542] Date/Time: 2008-03-14 11:15:49.771 +0100 OS Version: Mac OS X 10.5.2 (9C31) Report Version: 6 Exception Type: EXC_BAD_ACCESS (SIGSEGV) Exception Codes: KERN_INVALID_ADDRESS at 0x00000000fffffff4 Crashed Thread: 4 Thread 0: 0 libSystem.B.dylib 0x95b3eb3a select$DARWIN_EXTSN + 10 1 mysqld 0x0008f093 main + 3513 (mysqld.cc:3701) 2 mysqld 0x0000186a start + 54 Thread 1: 0 libSystem.B.dylib 0x95b64796 __sigwait + 10 1 mysqld 0x00089424 signal_hand + 492 (mysqld.cc:2391) 2 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 3 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 2: 0 libSystem.B.dylib 0x95af5bce __semwait_signal + 10 1 libSystem.B.dylib 0x95b46e38 pthread_cond_timedwait$UNIX2003 + 72 2 mysqld 0x003b6618 safe_cond_timedwait + 143 (thr_mutex.c:247) 3 mysqld 0x001b0139 terminate_slave_thread(THD*, st_safe_mutex_t*, st_safe_mutex_t*, _opaque_pthread_cond_t*, unsigned int volatile*) + 471 (slave.cc:699) 4 mysqld 0x001b02b7 terminate_slave_threads(st_master_info*, int, bool) + 295 (slave.cc:654) 5 mysqld 0x001bc92c stop_slave(THD*, st_master_info*, bool) + 410 (sql_repl.cc:912) 6 mysqld 0x000a6614 mysql_execute_command(THD*) + 29418 (sql_parse.cc:3209) 7 mysqld 0x000a6a87 mysql_parse(THD*, char const*, unsigned int, char const**) + 441 (sql_parse.cc:6124) 8 mysqld 0x000a775d dispatch_command(enum_server_command, THD*, char*, unsigned int) + 2857 (sql_parse.cc:1814) 9 mysqld 0x000a88f1 do_command(THD*) + 587 (sql_parse.cc:1586) 10 mysqld 0x000a97aa handle_one_connection + 3504 (sql_parse.cc:1197) 11 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 12 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 3: 0 libSystem.B.dylib 0x95b1271a read$UNIX2003 + 10 1 mysqld 0x0007f259 my_real_read(st_net*, unsigned long*) + 169 (net_serv.cc:817) 2 mysqld 0x0007f7ec my_net_read + 32 (net_serv.cc:992) 3 mysqld 0x000a8753 do_command(THD*) + 173 (sql_parse.cc:1548) 4 mysqld 0x000a97aa handle_one_connection + 3504 (sql_parse.cc:1197) 5 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 6 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 4 Crashed: 0 libSystem.B.dylib 0x95bd55ba __pthread_kill + 10 1 mysqld 0x001c745b write_core + 43 (stacktrace.c:258) 2 mysqld 0x0008b284 handle_segfault + 656 (mysqld.cc:2196) 3 libSystem.B.dylib 0x95b5b5eb _sigtramp + 43 4 ??? 0xffffffff 0 + 4294967295 5 libSystem.B.dylib 0x95af4aed free + 106 6 mysqld 0x0039f985 my_no_flags_free + 154 7 mysqld 0x001c3a77 mysql_close_free_options + 243 (client.c:2560) 8 mysqld 0x001c620c mysql_close + 209 (client.c:2643) 9 mysqld 0x001b95e1 handle_slave_io + 5649 (slave.cc:3750) 10 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 11 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 5: 0 libSystem.B.dylib 0x95af5bce __semwait_signal + 10 1 libSystem.B.dylib 0x95b208cd pthread_cond_wait$UNIX2003 + 73 2 mysqld 0x003b64f9 safe_cond_wait + 233 (thr_mutex.c:203) 3 mysqld 0x001127e4 MYSQL_LOG::wait_for_update(THD*, bool) + 180 (log.cc:2192) 4 mysqld 0x001b2c42 next_event(st_relay_log_info*) + 1464 (slave.cc:5005) 5 mysqld 0x001b6314 exec_relay_log_event(THD*, st_relay_log_info*) + 94 (slave.cc:3255) 6 mysqld 0x001ba34b handle_slave_sql + 1667 (slave.cc:3933) 7 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 8 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 4 crashed with X86 Thread State (32-bit): eax: 0x00000000 ebx: 0x0008b002 ecx: 0xb00c65dc edx: 0x95bd55ba edi: 0x0000000b esi: 0x0000000b ebp: 0xb00c6608 esp: 0xb00c65dc ss: 0x0000001f efl: 0x00000246 eip: 0x95bd55ba cs: 0x00000007 ds: 0x0000001f es: 0x0000001f fs: 0x00000000 gs: 0x00000037 cr2: 0x0008b000 Binary Images: 0x1000 - 0x4d9fff +mysqld ??? (???) <9dcdf965f335dd2b057da7bb364b2ffa> /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld 0x8fe00000 - 0x8fe2da53 dyld 96.2 (???) <7af47d3b00b2268947563c7fa8c59a07> /usr/lib/dyld 0x92117000 - 0x9211bfff libmathCommon.A.dylib ??? (???) /usr/lib/system/libmathCommon.A.dylib 0x93d79000 - 0x93d80fe9 libgcc_s.1.dylib ??? (???) /usr/lib/libgcc_s.1.dylib 0x95aee000 - 0x95c4dff3 libSystem.B.dylib ??? (???) <4899376234e55593b22fc370935f8cdf> /usr/lib/libSystem.B.dylib 0xffff0000 - 0xffff1780 libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib CRASH 2 ======= rpl_dual_pos_advance [ pass ] 77 Warning; Aborted waiting on pid file: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/run/slave.pid' after 70 seconds rpl_empty_master_crash [ pass ] 44 In slave.err: ------------- CURRENT_TEST: rpl_dual_pos_advance 080314 13:49:11 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 080314 13:49:11 [Warning] Setting lower_case_table_names=2 because file system for /Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/slave-data/ is case insensitive 080314 13:49:11 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: ready for connections. Version: '5.0.51a-debug-log' socket: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/tmp/slave.sock' port: 9308 MySQL Community Server (GPL) 080314 13:49:11 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/slave-relay-bin.000001' position: 4 080314 13:49:11 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log 'FIRST' at position 4 080314 13:49:11 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Normal shutdown 080314 13:49:11 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 080314 13:49:11 [Note] Slave I/O thread killed while reading event 080314 13:49:11 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 441 080314 13:49:11 [Note] Error reading relay log event: slave SQL thread was killed 080314 13:49:11 - 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. 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. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=3 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 39423 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Writing a core file CURRENT_TEST: rpl_empty_master_crash 080314 13:50:22 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 080314 13:50:22 [Warning] Setting lower_case_table_names=2 because file system for /Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/slave-data/ is case insensitive 080314 13:50:22 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: ready for connections. Version: '5.0.51a-debug-log' socket: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/tmp/slave.sock' port: 9308 MySQL Community Server (GPL) 080314 13:50:23 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log 'FIRST' at position 4 080314 13:50:23 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/slave-relay-bin.000001' position: 4 080314 13:50:23 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Normal shutdown 080314 13:50:23 [Note] Slave I/O thread killed while reading event 080314 13:50:23 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 98 080314 13:50:23 [Note] Error reading relay log event: slave SQL thread was killed 080314 13:50:23 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Shutdown complete Crash reporter: --------------- Process: mysqld [37830] Path: /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld Identifier: mysqld Version: ??? (???) Code Type: X86 (Native) Parent Process: perl [35992] Date/Time: 2008-03-14 11:49:17.340 +0100 OS Version: Mac OS X 10.5.2 (9C31) Report Version: 6 Exception Type: EXC_BAD_ACCESS (SIGSEGV) Exception Codes: KERN_INVALID_ADDRESS at 0x00000000fffffff4 Crashed Thread: 2 Thread 0: 0 libSystem.B.dylib 0x95af5bce __semwait_signal + 10 1 libSystem.B.dylib 0x95b208cd pthread_cond_wait$UNIX2003 + 73 2 mysqld 0x003b64f9 safe_cond_wait + 233 (thr_mutex.c:203) 3 mysqld 0x0008f170 main + 3734 (mysqld.cc:3719) 4 mysqld 0x0000186a start + 54 Thread 1: 0 libSystem.B.dylib 0x95b64796 __sigwait + 10 1 mysqld 0x00089424 signal_hand + 492 (mysqld.cc:2391) 2 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 3 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 2 Crashed: 0 libSystem.B.dylib 0x95bd55ba __pthread_kill + 10 1 mysqld 0x001c745b write_core + 43 (stacktrace.c:258) 2 mysqld 0x0008b284 handle_segfault + 656 (mysqld.cc:2196) 3 libSystem.B.dylib 0x95b5b5eb _sigtramp + 43 4 ??? 0xffffffff 0 + 4294967295 5 libSystem.B.dylib 0x95af4aed free + 106 6 mysqld 0x003b6e2c my_thread_end + 140 (my_thr_init.c:345) 7 mysqld 0x001ba7bb handle_slave_sql + 2803 (slave.cc:4016) 8 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 9 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 3: 0 libSystem.B.dylib 0xffff0292 __spin_lock + 50 1 libSystem.B.dylib 0x95af4aed free + 106 2 mysqld 0x0039f985 my_no_flags_free + 154 3 mysqld 0x0039dd97 end_io_cache + 289 4 mysqld 0x001ba85d end_relay_log_info(st_relay_log_info*) + 149 (slave.cc:4568) 5 mysqld 0x001ba9bc end_master_info(st_master_info*) + 140 (slave.cc:1685) 6 mysqld 0x001baa8d end_slave() + 105 (slave.cc:1096) 7 mysqld 0x0008bbff kill_server(void*) + 1433 (mysqld.cc:822) 8 mysqld 0x0008bf5b kill_server_thread + 23 (mysqld.cc:1049) 9 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 10 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 2 crashed with X86 Thread State (32-bit): eax: 0x00000000 ebx: 0x0008b002 ecx: 0xb00f891c edx: 0x95bd55ba edi: 0x0000000b esi: 0x0000000b ebp: 0xb00f8948 esp: 0xb00f891c ss: 0x0000001f efl: 0x00000246 eip: 0x95bd55ba cs: 0x00000007 ds: 0x0000001f es: 0x0000001f fs: 0x00000000 gs: 0x00000037 cr2: 0xfffffff4 Binary Images: 0x1000 - 0x4d9fff +mysqld ??? (???) <9dcdf965f335dd2b057da7bb364b2ffa> /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld 0x8fe00000 - 0x8fe2da53 dyld 96.2 (???) <7af47d3b00b2268947563c7fa8c59a07> /usr/lib/dyld 0x92117000 - 0x9211bfff libmathCommon.A.dylib ??? (???) /usr/lib/system/libmathCommon.A.dylib 0x93d79000 - 0x93d80fe9 libgcc_s.1.dylib ??? (???) /usr/lib/libgcc_s.1.dylib 0x95aee000 - 0x95c4dff3 libSystem.B.dylib ??? (???) <4899376234e55593b22fc370935f8cdf> /usr/lib/libSystem.B.dylib 0xffff0000 - 0xffff1780 libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib CRASH 3: ======== rpl000005 [ pass ] 118 Warning; Aborted waiting on pid file: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/run/slave.pid' after 70 seconds rpl000006 [ pass ] 71 In slave.err: ------------- CURRENT_TEST: rpl000004 080314 14:29:47 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 080314 14:29:47 [Warning] Setting lower_case_table_names=2 because file system for /Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/slave-data/ is case insensitive 080314 14:29:48 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: ready for connections. Version: '5.0.51a-debug-log' socket: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/tmp/slave.sock' port: 9308 MySQL Community Server (GPL) 080314 14:29:48 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log 'FIRST' at position 4 080314 14:29:48 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/slave-relay-bin.000001' position: 4 080314 14:29:48 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Normal shutdown 080314 14:29:48 [Note] Slave I/O thread killed while reading event 080314 14:29:48 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 190 080314 14:29:48 [Note] Error reading relay log event: slave SQL thread was killed 080314 14:29:48 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Shutdown complete CURRENT_TEST: rpl000005 080314 14:29:49 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 080314 14:29:49 [Warning] Setting lower_case_table_names=2 because file system for /Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/slave-data/ is case insensitive 080314 14:29:49 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: ready for connections. Version: '5.0.51a-debug-log' socket: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/tmp/slave.sock' port: 9308 MySQL Community Server (GPL) 080314 14:29:49 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log 'FIRST' at position 4 080314 14:29:49 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/slave-relay-bin.000001' position: 4 080314 14:29:49 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Normal shutdown 080314 14:29:49 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 080314 14:29:49 [Note] Slave I/O thread killed while reading event 080314 14:29:49 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 742 080314 14:29:49 - 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. 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. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=2 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 39423 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Writing a core file CURRENT_TEST: rpl000006 080314 14:30:59 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 080314 14:30:59 [Warning] Setting lower_case_table_names=2 because file system for /Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/slave-data/ is case insensitive 080314 14:30:59 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: ready for connections. Version: '5.0.51a-debug-log' socket: '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/tmp/slave.sock' port: 9308 MySQL Community Server (GPL) 080314 14:31:00 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/Volumes/Data/Sources/MySQL/mysql-5.0.51a/mysql-test/var/log/slave-relay-bin.000001' position: 4 080314 14:31:00 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log 'FIRST' at position 4 080314 14:31:00 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Normal shutdown 080314 14:31:00 [Note] Slave I/O thread killed while reading event 080314 14:31:00 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001', position 174 080314 14:31:00 [Note] Error reading relay log event: slave SQL thread was killed 080314 14:31:00 [Note] /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld: Shutdown complete Crash reporter: --------------- Process: mysqld [42642] Path: /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld Identifier: mysqld Version: ??? (???) Code Type: X86 (Native) Parent Process: perl [40948] Date/Time: 2008-03-14 12:29:55.911 +0100 OS Version: Mac OS X 10.5.2 (9C31) Report Version: 6 Exception Type: EXC_BAD_ACCESS (SIGSEGV) Exception Codes: KERN_INVALID_ADDRESS at 0x00000000fffffff4 Crashed Thread: 2 Thread 0: 0 libSystem.B.dylib 0x95af5bce __semwait_signal + 10 1 libSystem.B.dylib 0x95b208cd pthread_cond_wait$UNIX2003 + 73 2 mysqld 0x003b64f9 safe_cond_wait + 233 (thr_mutex.c:203) 3 mysqld 0x0008f170 main + 3734 (mysqld.cc:3719) 4 mysqld 0x0000186a start + 54 Thread 1: 0 libSystem.B.dylib 0x95b64796 __sigwait + 10 1 mysqld 0x00089424 signal_hand + 492 (mysqld.cc:2391) 2 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 3 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 2 Crashed: 0 libSystem.B.dylib 0x95bd55ba __pthread_kill + 10 1 mysqld 0x001c745b write_core + 43 (stacktrace.c:258) 2 mysqld 0x0008b284 handle_segfault + 656 (mysqld.cc:2196) 3 libSystem.B.dylib 0x95b5b5eb _sigtramp + 43 4 ??? 0xffffffff 0 + 4294967295 5 libSystem.B.dylib 0x95af4aed free + 106 6 mysqld 0x0039f985 my_no_flags_free + 154 7 mysqld 0x001c3a77 mysql_close_free_options + 243 (client.c:2560) 8 mysqld 0x001c620c mysql_close + 209 (client.c:2643) 9 mysqld 0x001b95e1 handle_slave_io + 5649 (slave.cc:3750) 10 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 11 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 3: 0 libSystem.B.dylib 0x95af5bce __semwait_signal + 10 1 libSystem.B.dylib 0x95b208cd pthread_cond_wait$UNIX2003 + 73 2 mysqld 0x003b64f9 safe_cond_wait + 233 (thr_mutex.c:203) 3 mysqld 0x001127e4 MYSQL_LOG::wait_for_update(THD*, bool) + 180 (log.cc:2192) 4 mysqld 0x001b2c42 next_event(st_relay_log_info*) + 1464 (slave.cc:5005) 5 mysqld 0x001b6314 exec_relay_log_event(THD*, st_relay_log_info*) + 94 (slave.cc:3255) 6 mysqld 0x001ba34b handle_slave_sql + 1667 (slave.cc:3933) 7 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 8 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 4: 0 libSystem.B.dylib 0x95af5bce __semwait_signal + 10 1 libSystem.B.dylib 0x95b46e38 pthread_cond_timedwait$UNIX2003 + 72 2 mysqld 0x003b6618 safe_cond_timedwait + 143 (thr_mutex.c:247) 3 mysqld 0x001b0139 terminate_slave_thread(THD*, st_safe_mutex_t*, st_safe_mutex_t*, _opaque_pthread_cond_t*, unsigned int volatile*) + 471 (slave.cc:699) 4 mysqld 0x001b02b7 terminate_slave_threads(st_master_info*, int, bool) + 295 (slave.cc:654) 5 mysqld 0x001baa7f end_slave() + 91 (slave.cc:1095) 6 mysqld 0x0008bbff kill_server(void*) + 1433 (mysqld.cc:822) 7 mysqld 0x0008bf5b kill_server_thread + 23 (mysqld.cc:1049) 8 libSystem.B.dylib 0x95b1fc55 _pthread_start + 321 9 libSystem.B.dylib 0x95b1fb12 thread_start + 34 Thread 2 crashed with X86 Thread State (32-bit): eax: 0x00000000 ebx: 0x0008b002 ecx: 0xb00c65dc edx: 0x95bd55ba edi: 0x0000000b esi: 0x0000000b ebp: 0xb00c6608 esp: 0xb00c65dc ss: 0x0000001f efl: 0x00000246 eip: 0x95bd55ba cs: 0x00000007 ds: 0x0000001f es: 0x0000001f fs: 0x00000000 gs: 0x00000037 cr2: 0xfffffff4 Binary Images: 0x1000 - 0x4d9fff +mysqld ??? (???) <9dcdf965f335dd2b057da7bb364b2ffa> /Volumes/Data/Sources/MySQL/mysql-5.0.51a/sql/mysqld 0x8fe00000 - 0x8fe2da53 dyld 96.2 (???) <7af47d3b00b2268947563c7fa8c59a07> /usr/lib/dyld 0x92117000 - 0x9211bfff libmathCommon.A.dylib ??? (???) /usr/lib/system/libmathCommon.A.dylib 0x93d79000 - 0x93d80fe9 libgcc_s.1.dylib ??? (???) /usr/lib/libgcc_s.1.dylib 0x95aee000 - 0x95c4dff3 libSystem.B.dylib ??? (???) <4899376234e55593b22fc370935f8cdf> /usr/lib/libSystem.B.dylib 0xffff0000 - 0xffff1780 libSystem.B.dylib ??? (???) /usr/lib/libSystem.B.dylib