>Description:
I had a master and a slave server that had their clocks set to different
times, and I noticed my slave server kept crashing shortly after midnight with queries
that involved the now() function. I am using a date column as a unique identifier, so
it wasn't able to perform an insert on the slave that it could on the master. This
also would be a problem is the slave server is offline for a few hours and reconnects.
>How-To-Repeat:
Set two servers to different times and try to replicate from one to the other.
Run an insert query using now(). Notice that the date inserted is set to the slave's
local time and not the time it was inserted on the master.
>Fix:
Perhaps the now() function should be replaced with the current date on the
master in the bin-logs.
>Submitter-Id: pgatt
>Originator:
>Organization:
>MySQL support: none
>Synopsis: Minor bug / change request
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.33 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.33-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 hours 26 min 43 sec
Threads: 1111 Questions: 6291039 Slow queries: 7 Opens: 1108 Flush tables: 1 Open
tables: 512 Queries per second avg: 320.922
>Environment:
System: Linux db1.join4free.com 2.2.14-5.0smp #3 SMP Thu Aug 3 00:44:11 PDT 2000 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/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jul 31 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db
'--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
