hi everyone. sometimes it happens, that the slave mysql server dies because a floating point exception.
on the console where I started the slave mysql daemon I get the error: <snip> /usr/local/mysql/bin/safe_mysqld: line 274: 24423 Floating point exception$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 </snip> and the error log just contains this information: <snip> /usr/local/mysql/bin/mysqld: ready for connections 021122 13:21:03 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'smsdb01-bin.574' at position 44940042 Number of processes running now: 1 mysqld process hanging, pid 24426 - killed 021122 13:21:04 mysqld restarted /usr/local/mysql/bin/mysqld: ready for connections </snip> the sql statement on postion 44940042 is: <snip> # at 44940042 #021121 16:55:02 server id 20184 Intvar SET LAST_INSERT_ID = 781729; </snip> the statements before position 44940042 were UPDATES, so I wonder why the LAST_INSERT_ID is set? what is the difference between the LAST_INSERT_ID and the INSERT_ID? cause the next statement following the one on position 44940042 is: <snip> # at 44940064 #021121 16:55:02 server id 20184 Intvar SET INSERT_ID = 781729; </snip> master server and slave server are version 3.23.37, I also tried the latest (3.23.53a) version for the slave only, since I can't stop the master. are there any known problems? thanks in advance, martin --------------------------------------------------------------------- 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
