MySQL Bugs: #38096: Test 'rpl000001' fails in 'start slave' on RHEL5 and IA64 (icc)

Bug #38096	Test 'rpl000001' fails in 'start slave' on RHEL5 and IA64 (icc)
Submitted:	14 Jul 2008 13:28	Modified:	29 Oct 2008 14:52
Reporter:	Kent Boortz	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	5.0.66, 5.0.68	OS:	Linux (RHEL5 IA64 (icc))
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Using the debug enabled server from RPMs, RHEL5, IA64 (icc), this
test fails

  rpl000001                      [ fail ]

  mysqltest: At line NNN: query 'start slave' failed:
  2013: Lost connection to MySQL server during query

  The result from queries just before the failure was:
  < snip >
  drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
  start slave;
  create table t1 (word char(20) not null);
  load data infile '../std_data_ln/words.dat' into table t1;
  load data local infile 'MYSQL_TEST_DIR/std_data/words.dat' into table t1;
  select * from t1 limit 10;
  word
  Aarhus
  Aaron
  Ababa
  aback
  abaft
  abandon
  abandoned
  abandoning
  abandonment
  abandons
  stop slave;
  set password for root@"localhost" = password('foo');
  start slave;

How to repeat:
Run the test on the platform

Thank you for the report.

Verified as described. Only RPM packages are affected.

Backtrace:

Program terminated with signal 6, Aborted.
#0  0xa000000000010620 in __kernel_syscall_via_break ()
(gdb) bt full
#0  0xa000000000010620 in __kernel_syscall_via_break ()
No symbol table info available.
#1  0x200000000009f020 in pthread_kill () from /lib/libpthread.so.0
No symbol table info available.
#2  0x4000000000693920 in write_core ()
No symbol table info available.
#3  0x4000000000325000 in handle_segfault ()
No symbol table info available.
#4  <signal handler called>
No symbol table info available.
#5  0xa000000000010620 in __kernel_syscall_via_break ()
No symbol table info available.
#6  0x2000000000434100 in raise () from /lib/libc.so.6.1
No symbol table info available.
#7  0x2000000000437480 in abort () from /lib/libc.so.6.1
No symbol table info available.
#8  0x20000000006bfc50 in unw_decode_r1 () from /lib/libgcc_s.so.1
No symbol table info available.
#9  0x20000000006c0640 in unw_decode_r1 () from /lib/libgcc_s.so.1
No symbol table info available.
#10 0x20000000006c14a0 in unw_decode_r1 () from /lib/libgcc_s.so.1
No symbol table info available.
#11 0x20000000006c2260 in _Unwind_ForcedUnwind () from /lib/libgcc_s.so.1
No symbol table info available.
#12 0x20000000000a7520 in _Unwind_ForcedUnwind () from /lib/libpthread.so.0
No symbol table info available.
#13 0x20000000000a2960 in __pthread_unwind () from /lib/libpthread.so.0
No symbol table info available.
#14 0x2000000000093f40 in pthread_exit () from /lib/libpthread.so.0
No symbol table info available.
#15 0x400000000065c450 in handle_slave_io ()
No symbol table info available.
#16 0x2000000000093480 in start_thread () from /lib/libpthread.so.0
No symbol table info available.
#17 0x200000000058ec20 in __clone2 () from /lib/libc.so.6.1
No symbol table info available.
(gdb)

OK, great that you have a stack trace. But it doesn't contain anything useful except a hint that handle_slave_sql was called. I have no idea how to debug that (the best guess I have is a problem with the libraries of the host, but I really can't make a good guess).

It may help if you can produce a stack trace from a binary that has been debug-built. Also, please create a stack trace from *all* threads (use gdb's command "thread apply all bt").

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".