Replying to myself again.......
OK, some more light on the subject. I did a complete dump of the
master and reloaded the slave thinking maybe I had corrupt tables or
something. Having started the slave with skip-start-slave, I found
that I could stop mysqld on command line using mysqladmin without
problems. As soon as I started the slave and tried to issue a stop
slave, then the crash happened again. So basically the crash only
happens if we try and stop the slave threads. This wouls explain why
mysaadmin shutdown crashed when slave IO was on, but not when slave
IO was stopped. Here is error I got this time for stop slave:
> stop slave;
ERROR 2013 (HY000): Lost connection to MySQL server during query
([EMAIL PROTECTED]) (none)> /usr/local/mysql/bin/mysqld_safe: line
1: 401 Illegal instruction nohup /usr/local/mysql/libexec/
mysqld --defaults-extra-file=/usr/local/mysql/data/my.cnf --basedir=/
usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-
file=/usr/local/mysql/data/slmini.local.pid --socket=/tmp/mysql.sock
--skip-slave-start >>/usr/local/mysql/data/slmini.local.err 2>&1
061220 16:02:05 mysqld restarted
Any ideas what could be wrong here or is this possibly a bug?
Regards, Kieran
On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote:
I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo
Mac Mini running OS X Server 10.4.8. It is a slave replicating to a
master over ssl. Replication works fine, however I get this error
always if I execute the STOP SLAVE statement
([EMAIL PROTECTED]) (none)> stop slave;
ERROR 2013 (HY000): Lost connection to MySQL server during query
([EMAIL PROTECTED]) (none)> 061220 14:48:44 mysqld restarted
Also, if I execute mysqladmin shutdown, it restarts also
slmini:/usr/local admin$ mysqladmin -u root -p shutdown
Enter password:
slmini:/usr/local admin$ 061220 14:59:19 mysqld restarted
The source has been compiled with SSL feature.
I have exact same installation on a single CPU powerpc G4 XServe
with no problems.
My installation procedure/flags are here:
Any ideas what the problem might be? Should I just rebuild the OS
from scratch? Could it be corrupt data that needs to be recopied
form the master? I'm baffled at this point.
Regards, Kieran
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]