>Description:
When using a replication between two MySQL servers (v3.23.48) on FreeBSD the
ALTER TABLE command is not replicated. It is present in the bin-log, but the slave
seems to ignore it. This seems to be fixed in MySQL version v4.0.1
>How-To-Repeat:
Set-up a replication between two empty databases with the same name (one on
the master, one on the slave). Create a table with one column on the master. You will
see that it is also created on the slave. To verify the replication you can also put
some data in the table on the master, and check if it is replicated to the slave. Now,
change the name of the column on the master. Verify that on the slave you will still
have the old column name. Update or insert new data in the table on the master. The
replication will break because the slave does not know the column.
>Fix:
Apparently, the ALTER TABLE works correctly (in this respect) in version 4.0.1
>Submitter-Id: Paul van Diepen
>Originator: Paul van Diepen
>Organization: VMS-Keytrade
>MySQL support: none
>Synopsis: Replication of ALTER TABLE does not work in v3.23
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (FreeBSD port: mysql-server-3.23.49)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for -freebsd4.5 on i386
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.49
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 6 days 2 hours 24 min 32 sec
Threads: 1 Questions: 423 Slow queries: 0 Opens: 45 Flush tables: 1 Open tables:
4 Queries per second avg: 0.001
>Environment:
System: FreeBSD rodenbach.keytrade.com 4.5-RELEASE-p2 FreeBSD 4.5-RELEASE-p2 #0: Wed
Mar 20 19:12:10 CET 2002
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/RODENBACH_FW 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.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1208074 Jan 28 14:11 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Feb 15 17:00 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 573760 Jan 28 14:11 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/usr/db --without-perl --without-debug
--without-readline --without-bench --with-mit-threads=no --with-libwrap
--with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.49'
--enable-assembler --with-berkeley-db --with-innodb --prefix=/usr/local
i386-portbld-freebsd4.5
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
