>Description:
replication involving now() is sketchy if the two server clocks differ.
>How-To-Repeat:
Have a replicating server with a different clock (or timezone!) than the
primary server. Do an insert or update or anything involving now() and
it'll get weird, since the second server may or may not have the same
kind of data. Replicated data should not use now() but should instead
have the value calculated by now().
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
tani hosokawa
river styx internet
>
>MySQL support: email support
>Synopsis: now() shouldn't be used in the replication/logs
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.31 (Official MySQL binary)
>Environment:
System: Linux xxxx.xxxxx.xxx 2.2.19 #4 Tue May 1 12:20:47 PDT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc'
CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -fe
lide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Sep 24 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101836 Sep 5 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 19533408 Apr 16 1999 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 16 1999 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --ena
ble-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--disable-shared
Perl: This is perl, version 5.005_03 built for i686-linux
~
--
tani hosokawa
river styx internet
---------------------------------------------------------------------
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
