>Description: I am testing the replication of one database from this host to a slave MySQL server. Some of the queries that ALTER a table structure are not replicated to the slave, causing a stop of the replication. I said "some" because while I was troubleshooting my problems I could successfully add/change some fields to my tables (this means that the add/change was replicated) but other times a similar operation (eg ALTER of a column with the same definition of one that I had successfully altered) gave me a failure. >How-To-Repeat: I just tested this and had problems: # ON MASTER FLUSH MASTER;
# ON SLAVE FLASH SLAVE; # ON MASTER CREATE TABLE `replication_test` ( `f1` TEXT DEFAULT NULL, `f2` VARCHAR(50) DEFAULT NULL, `f3` BIGINT DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, `f4` TIMESTAMP DEFAULT NULL, `f5` VARCHAR(50) DEFAULT 'Spaghetti, pizza e mandolino' NOT NULL, INDEX (`f2`) ) TYPE = MYISAM; INSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('record number one', 'massimo ferrario', '123456789', NULL, 'Spaghetti, pizza e mandolino'); INSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('recordn number two', NULL, '987654321', NULL, 'Pizza margherita'); UPDATE `replication_test` SET `f1` = 'record number two' , `f2` = NULL, `f4` = NOW('20020717110024') WHERE `f3` = '987654321'; # THIS QUERY IS NOT REPLICATED TO THE SLAVE ALTER TABLE `eigest_euro`.`replication_test` CHANGE `f5` `f5` TEXT # INSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('record number three', 'paolino paperino', NULL, NOW(), 'Spaghetti all\'amatriciana'); NSERT INTO `replication_test` (`f1`, `f2`, `f3`, `f4`, `f5`) VALUES ('record number four', NULL, NULL, NOW(), '====****====****==== This is a very long string that should fit the text field in the master database but should be truncated in the varchar(50) field of the slave database. ====****====****===='); >Fix: I don't know >Submitter-Id: inforeti >Originator: root >Organization: Inforeti srl via Pellizzo 39 35100 Padova (PD) Italy >MySQL support: licence >Synopsis: replication not working for every ALTER TABLE query >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.49a (Official MySQL RPM) >Environment: System: Linux php3 2.2.19-6.2.12 #1 Fri Oct 26 12:20:51 EDT 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/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Sep 5 2000 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Jan 15 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273324 Jan 15 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 15 2001 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Aug 1 2001 /usr/lib/libc-client.a -> c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --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 '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc 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