Lewis Watson wrote: > Also, I am intersted in a way to reset the entire replication thing. In > other words, just remove all hints of replication and start over... Is there > a way I can do this? > Thanks. > Lewis > > ----- Original Message ----- > From: "Lewis Watson" <[EMAIL PROTECTED]> > To: "mysql" <[EMAIL PROTECTED]> > Sent: Tuesday, October 22, 2002 12:06 PM > Subject: Replication Error > > > I had replication running fine between two mysql server machines on linux. > > Then I added yet another slave but goofed and put in the same server-id. > Now > > I am getting errors on the master server and proccesses being killed and > > restarted. It comes with this error. > > > > ./bin/safe_mysqld: line 273: 12250 Segmentation fault > > $NOHUP_NICENESS $ledir/$MYSQLD > > $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR > > $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 > > > > I have tried flushing both master and slave. I have also reset eac. I have > > also deleted the log files and the master.info file on the slave. Nothing > is > > allowing these the master and original slave to communicate anymore. Any > > ideas? > > Thanks, > > Lewis > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > --------------------------------------------------------------------- > 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
Lewis, As far as I've been able to see, there are only a few files that control replication. I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and stopping mysql on both the master and the slave. Then delete log files on the master including the *.index file. I'd then delete any files on the slave that deal with replication (master.info). Once all this is done, try restarting the master to see if it still has problems. walt --------------------------------------------------------------------- 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