Sasha,
Running the latest binary I just built, I had a single core dump and
auto-restart early this morning. Here's the backtrace:
---snip---
Core was generated by `mysqld'.
Program terminated with signal 6, Abort trap.
Reading symbols from /usr/lib/libz.so.2...done.
Reading symbols from /usr/lib/libcrypt.so.2...done.
Reading symbols from /usr/lib/libm.so.2...done.
Reading symbols from /usr/lib/libc_r.so.4...done.
Reading symbols from /usr/libexec/ld-elf.so.1...done.
#0 0x2839d330 in kill () from /usr/lib/libc_r.so.4
(gdb) bt
#0 0x2839d330 in kill () from /usr/lib/libc_r.so.4
#1 0x283e9ab1 in abort () from /usr/lib/libc_r.so.4
#2 0x283c377d in __assert () from /usr/lib/libc_r.so.4
#3 0x80f75c8 in next_event (rli=0x8305e2c) at slave.cc:2376
#4 0x80f52da in exec_relay_log_event (thd=0x203b5818, rli=0x8305e2c)
at slave.cc:1533
#5 0x80f646d in handle_slave_sql (arg=0x8305ae0) at slave.cc:1887
#6 0x2837403b in _thread_start () from /usr/lib/libc_r.so.4
#7 0x0 in ?? ()
---snip---
And the relevant bits from the log, with an assert failure just before
the restart:
---snip---
020309 3:02:21 next log './db3-relay-bin.007' is not active
020309 3:14:59 Error in Log_event::read_log_event(): 'read error',
data_len=283,event_type=2
020309 3:14:59 Slave SQL thread: I/O error reading event(errno=-1,cur_log->error=247)
assertion "((cur_log)->pos_in_file + (uint) (*(cur_log)->current_pos -
(cur_log)->request_pos)) == rli->relay_log_pos + rli->pending" failed: file
"slave.cc", line 2376
020309 03:15:20 mysqld restarted
Warning: One can only use the --user switch if running as root
/home/mysql-4-bk/libexec/mysqld: ready for connections
020309 3:15:22 Error in accept: Software caused connection abort
020309 3:15:22 Slave I/O thread initialized
020309 3:15:22 Slave SQL thread initialized, starting replication in log
'binary-log.048' at position 535046117,relay log:
name='./db3-relay-bin.007',pos='42811130'
020309 3:15:22 Error in Log_event::read_log_event(): 'read error',
data_len=283,event_type=2
020309 3:15:22 Slave SQL thread: I/O error reading event(errno=-1,cur_log->error=247)
020309 3:15:23 next log './db3-relay-bin.008' is not active
020309 3:15:23 next log './db3-relay-bin.009' is not active
020309 3:15:23 next log './db3-relay-bin.010' is not active
020309 3:15:23 next log './db3-relay-bin.011' is not active
020309 3:15:23 next log './db3-relay-bin.012' is not active
020309 3:15:23 next log './db3-relay-bin.013' is not active
020309 3:15:23 next log './db3-relay-bin.014' is not active
020309 3:15:23 next log './db3-relay-bin.015' is not active
020309 3:15:23 next log './db3-relay-bin.016' is not active
020309 3:15:23 next log './db3-relay-bin.017' is not active
020309 3:15:23 next log './db3-relay-bin.018' is not active
020309 3:15:23 next log './db3-relay-bin.019' is not active
020309 3:15:23 next log './db3-relay-bin.020' is not active
020309 3:15:23 next log './db3-relay-bin.021' is not active
020309 3:15:23 next log './db3-relay-bin.022' is not active
020309 3:15:23 next log './db3-relay-bin.023' is not active
020309 3:15:23 next log './db3-relay-bin.024' is not active
020309 3:15:23 next log './db3-relay-bin.025' is not active
020309 3:15:23 next log './db3-relay-bin.026' is not active
020309 3:15:23 next log './db3-relay-bin.027' is not active
020309 3:15:23 next log './db3-relay-bin.028' is not active
020309 3:15:23 next log './db3-relay-bin.029' is not active
020309 3:15:23 next log './db3-relay-bin.030' is not active
020309 3:15:23 next log './db3-relay-bin.031' is not active
020309 3:15:23 next log './db3-relay-bin.032' is not active
020309 3:15:23 next log './db3-relay-bin.033' is not active
020309 3:15:23 next log './db3-relay-bin.034' is not active
020309 3:15:23 next log './db3-relay-bin.035' is not active
020309 3:15:23 next log './db3-relay-bin.036' is not active
020309 3:15:23 next log './db3-relay-bin.037' is not active
020309 3:15:23 next log './db3-relay-bin.038' is not active
020309 3:15:23 next log './db3-relay-bin.039' is not active
020309 3:15:23 next log './db3-relay-bin.040' is not active
020309 3:15:23 next log './db3-relay-bin.041' is not active
020309 3:15:23 next log './db3-relay-bin.042' is not active
020309 3:15:23 next log './db3-relay-bin.043' is not active
020309 3:15:23 next log './db3-relay-bin.044' is not active
020309 3:15:23 next log './db3-relay-bin.045' is not active
020309 3:15:23 next log './db3-relay-bin.046' is not active
020309 3:15:23 next log './db3-relay-bin.047' is not active
020309 3:15:23 next log './db3-relay-bin.048' is not active
020309 3:15:23 next log './db3-relay-bin.049' is not active
020309 3:15:23 next log './db3-relay-bin.050' is not active
020309 3:15:23 next log './db3-relay-bin.051' is not active
020309 3:15:23 next log './db3-relay-bin.052' is not active
020309 3:15:23 next log './db3-relay-bin.053' is not active
020309 3:15:23 next log './db3-relay-bin.054' is not active
020309 3:15:23 next log './db3-relay-bin.055' is not active
020309 3:15:23 next log './db3-relay-bin.056' is not active
020309 3:15:23 next log './db3-relay-bin.057' is not active
020309 3:15:23 next log './db3-relay-bin.058' is not active
020309 3:15:23 next log './db3-relay-bin.059' is not active
020309 3:15:23 next log './db3-relay-bin.060' is not active
020309 3:15:23 next log './db3-relay-bin.061' is not active
020309 3:15:23 next log './db3-relay-bin.062' is not active
020309 3:15:23 next log './db3-relay-bin.063' is not active
020309 3:15:23 next log './db3-relay-bin.064' is not active
020309 3:15:23 next log './db3-relay-bin.065' is not active
020309 3:15:23 next log './db3-relay-bin.066' is not active
020309 3:15:23 next log './db3-relay-bin.067' is not active
020309 3:15:23 next log './db3-relay-bin.068' is not active
020309 3:15:23 next log './db3-relay-bin.069' is not active
020309 3:15:23 next log './db3-relay-bin.070' is not active
020309 3:15:23 next log './db3-relay-bin.071' is not active
020309 3:15:23 next log './db3-relay-bin.072' is not active
020309 3:15:23 next log './db3-relay-bin.073' is not active
020309 3:15:23 next log './db3-relay-bin.074' is not active
020309 3:15:23 next log './db3-relay-bin.075' is not active
020309 3:15:23 next log './db3-relay-bin.076' is not active
020309 3:15:23 next log './db3-relay-bin.077' is not active
020309 3:15:23 next log './db3-relay-bin.078' is not active
020309 3:15:23 next log './db3-relay-bin.079' is not active
020309 3:15:23 next log './db3-relay-bin.080' is not active
020309 3:15:23 next log './db3-relay-bin.081' is not active
020309 3:15:23 next log './db3-relay-bin.082' is not active
020309 3:15:23 next log './db3-relay-bin.083' is not active
020309 3:15:23 next log './db3-relay-bin.084' is not active
020309 3:15:23 next log './db3-relay-bin.085' is not active
020309 3:15:23 next log './db3-relay-bin.086' is not active
020309 3:15:23 next log './db3-relay-bin.087' is not active
020309 3:15:23 next log './db3-relay-bin.088' is not active
020309 3:15:23 next log './db3-relay-bin.089' is not active
020309 3:15:23 next log './db3-relay-bin.090' is not active
020309 3:15:23 next log './db3-relay-bin.091' is not active
020309 3:15:23 next log './db3-relay-bin.092' is not active
020309 3:15:23 next log './db3-relay-bin.093' is not active
020309 3:15:23 next log './db3-relay-bin.094' is not active
020309 3:15:23 next log './db3-relay-bin.095' is not active
020309 3:15:23 next log './db3-relay-bin.096' is not active
020309 3:15:23 next log './db3-relay-bin.097' is not active
020309 3:15:23 next log './db3-relay-bin.098' is not active
020309 3:15:23 next log './db3-relay-bin.099' is not active
020309 3:15:23 next log './db3-relay-bin.100' is not active
020309 3:15:23 next log './db3-relay-bin.101' is not active
020309 3:15:23 next log './db3-relay-bin.102' is not active
020309 3:15:23 next log './db3-relay-bin.103' is not active
020309 3:15:23 next log './db3-relay-bin.104' is not active
020309 3:15:23 next log './db3-relay-bin.105' is not active
020309 3:15:23 next log './db3-relay-bin.106' is not active
020309 3:15:23 next log './db3-relay-bin.107' is not active
020309 3:15:23 next log './db3-relay-bin.108' is not active
020309 3:15:23 next log './db3-relay-bin.109' is not active
020309 3:15:23 next log './db3-relay-bin.110' is not active
020309 3:15:23 next log './db3-relay-bin.111' is not active
020309 3:15:23 next log './db3-relay-bin.112' is not active
020309 3:15:23 next log './db3-relay-bin.113' is not active
020309 3:15:23 next log './db3-relay-bin.114' is not active
020309 3:15:23 next log './db3-relay-bin.115' is not active
020309 3:15:23 next log './db3-relay-bin.116' is not active
020309 3:15:23 next log './db3-relay-bin.117' is not active
020309 3:15:23 next log './db3-relay-bin.118' is not active
020309 3:15:23 next log './db3-relay-bin.119' is not active
020309 3:15:23 next log './db3-relay-bin.120' is not active
020309 3:15:23 next log './db3-relay-bin.121' is not active
020309 3:15:23 next log './db3-relay-bin.122' is not active
020309 3:15:23 next log './db3-relay-bin.123' is not active
020309 3:15:23 next log './db3-relay-bin.124' is not active
020309 3:15:23 next log './db3-relay-bin.125' is not active
020309 3:15:23 next log './db3-relay-bin.126' is not active
020309 3:15:23 next log './db3-relay-bin.127' is not active
020309 3:15:23 next log './db3-relay-bin.128' is not active
020309 3:15:23 next log './db3-relay-bin.129' is not active
020309 3:15:23 next log './db3-relay-bin.130' is not active
020309 3:15:23 next log './db3-relay-bin.131' is not active
020309 3:15:23 next log './db3-relay-bin.132' is not active
020309 3:15:23 next log './db3-relay-bin.133' is not active
020309 3:15:27 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'binary-log.050' at
position 23906110
---snip---
I believe that most of those relay files were produced during the
previous "core dump, restart, core dump" cycle that you fixed. If
memory serves, they were all 4 bytes in length.
Let me know if you need any more data from me.
Thanks!
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 30 days, processed 1,024,434,500 queries (393/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
