>Description:
I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49
with master/slave replication.
The master mysqld is running on one machine, the slave on another.
Everything works fine until I shutdown the master server. The slave
then immediately crashes due to a segmentation violation fault. Here
are the lines from the mysqld_multi.log file:
/nfs/pathsoft/external/mysql-3.23.49/libexec/mysqld: ready for connections
020426 11:26:15 Slave: connected to master 'slave@babel:14641', replication started
in log 'mysql.001' at position 156
020426 11:27:03 Slave: received 0 length packet from server, apparent master
shutdown: (0)
020426 11:27:03 Slave: Failed reading log event, reconnecting to retry, log
'mysql.002' position 73
mysqld got signal 11;
My master server is configured like this:
[mysqld_multi]
mysqld = /nfs/pathsoft/external/mysql-3.23.49/bin/safe_mysqld
mysqladmin = /nfs/pathsoft/external/mysql-3.23.49/bin/mysqladmin
[mysqld1]
socket = /nfs/pathdb/arcturus/mysql/etc/mysql.prod.sock
port = 14641
pid-file = /nfs/pathdb/arcturus/mysql/etc/mysql.prod.pid
datadir = /nfs/pathdb/arcturus/mysql/data/prod
log-bin = /nfs/pathdb/arcturus/mysql/binlog/prod/mysql.binlog
language = /nfs/pathsoft/external/mysql-3.23.49/share/mysql/english
big-tables
safe-show-database
safe-user-create
server-id = 1
and my slave server like this:
[mysqld_multi]
mysqld = /nfs/pathdb/dev/external/mysql-3.23.38/bin/safe_mysqld
mysqladmin = /nfs/pathdb/dev/external/mysql-3.23.38/bin/mysqladmin
[mysqld3]
socket = /nfs/pathdb2/arcturus/mysql/etc/mysql.babel-prod.sock
port = 14643
pid-file = /nfs/pathdb2/arcturus/mysql/etc/mysql.babel-prod.pid
datadir = /nfs/pathdb2/arcturus/mysql/data/babel-prod
log-bin = /nfs/pathdb2/arcturus/mysql/binlog/babel-prod/mysql.binlog
language = /nfs/pathsoft/external/mysql-3.23.49/share/mysql/english
log-slave-updates
master-host = babel
master-port = 14641
master-user = slave
master-password = mylittlesecret
big-tables
safe-show-database
safe-user-create
server-id = 2
I can make the slave server crach *every* time it loses its connection
to the master server.
It's not a hardware problem on one machine, because I have run the master
and slave servers on several combinations of machines and the slave
crashes *every* time.
It might help you to know that when I run a slave server on an i386 Linux
machine, it survives when the master server on the Alpha machine is shut down,
and it happily reconnects when I restart the master server.
This leads me to think that the problem is in the slave code, and is specific
to the build for Compaq Alphas.
Unfortunately, I haven't been able to compile MySQL 3.23.49 successfully from
the source distribution, so I can't explore the problem with the debugger
myself :-(
>How-To-Repeat:
Can be repeated at will, as described above.
>Fix:
Not known.
>Submitter-Id:
>Originator: David Harper
>Organization: Wellcome Trust Sanger Institute, Hinxton, Cambridge, England
>
>MySQL support: none
>Synopsis:
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (Official MySQL binary)
>Environment:
System: OSF1 pcs3f V5.1 1885 alpha
Machine: alpha
Some paths: /bin/perl /bin/make /usr/local/bin/gmake /usr/local/bin/gcc /bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-dec-osf5.1/3.0.3/specs
Configured with: ../configure
Thread model: single
gcc version 3.0.3
Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline
speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline
speed -speculate all -noexceptions -nortti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root system 17 Jan 30 16:17 /lib/libc.a -> ../ccs/lib/libc.a
lrwxrwxrwx 1 root system 17 Jan 30 16:17 /usr/lib/libc.a ->
../ccs/lib/libc.a
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-local-infile --with-prefix=/usr/local/mysql
--with-mysqld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread
-lmach -lexc -lc' --disable-shared
---------------------------------------------------------------------
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
