Description:
If a special UPDATE request is sent to the MASTER server mysqld server
in SLAVE mode goes down by the signal 8 (at FreeBSD 4.2 REELEASE).
The only way to continue normal work is to stop MASTER and to copy
data manually. Then start servers again.
Also
mysqlbinlog *.NNN | mysql ...
can not help here because the rand() without a number as a parameter
will always return different numbers at the MASTER and SLAVE
How-To-Repeat:
create table bugtest (key char(10), testfield char(10));
# Be sure 'bugtest' will be replicated to some server
insert into bugtest (key) values ('1');
insert into bugtest (key) values ('2');
insert into bugtest (key) values ('3');
# Table prepared
update bugtest set testfield=rand();
# That is all. SLAVE will die.
Fix: No ideas yet.
Currently using RAND(<number>), <number> is calculated outside of
SQL request.
MySQL support: none
Synopsis: 'rand()' into UPDATE request breaks automatic replication
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-3.23.41 (Source distribution)
Environment:
Intel P-III 933, 256Mb RAM
System: FreeBSD 4.2-RELEASE #2: Wed Aug 29 11:31:33 MSD 2001
root@party:/usr/src/sys/compile/MRL i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxr-xr-x 1 root wheel 13 Aug 21 20:50 /lib/libc.so.6 -> libc-2.1.2.so
-rwxr-xr-x 1 root wheel 4118299 Sep 20 1999 /lib/libc-2.1.2.so
-r--r--r-- 1 root wheel 1169076 Nov 20 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Aug 21 21:02 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 559196 Nov 20 2000 /usr/lib/libc.so.4
Configure command: ./configure
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
