Hello! I have a problem with replication, sometimes (daily) the slave server crashes and restarts itself. I have entered "skip-slave-start" into my.cnf and this makes the server get back online but of course without relplication running. This leads me to believe that the master do something wrong with the binlog wich makes the slave go nuts. How can i verify this and preferably, do something about it?
I run mysql Ver 11.17 Distrib 3.23.49a, for pc-linux-gnu (i686) Master is a AMD tb 1400Mhz/1.5 GB ram. Slave is a Dual Celeron 450/768MB ram. both running RedHat 7.2 with kernel 2.4.7 and 2.4.7-smp. See below: -------------------------------- mysql> slave start; Query OK, 0 rows affected (0.00 sec) mysql> ./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 Number of processes running now: 39 mysqld process hanging, pid 12253 - killed mysqld process hanging, pid 11283 - killed ./bin/safe_mysqld: kill: (11283) - No such pid 020401 14:25:19 mysqld restarted mysql> -------------------------------- if do not have "skip-slave-start" in my.cnf the server will loop endlessly trying to restart/kill itself. Regards Johan ---------------------------------------------------------------- SQL SELECT UPDATE INSERT ---------------------------------------------------------------- --------------------------------------------------------------------- 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
