Problems with replication
>Description: Hi! My name is Ales Perme. A college of mine Samo Login gave me this adress, which was given to him by Monty, to report MySQL bugs to. The first bug report today from me is connected with replication. Our production comprizes of Windows and Linux machines. MySQL verson we are using on production is 3.23.36-log and on our development setting 3.23.49-nt-log. On both of these versions we experiance the same bug. We experiance replication problems in the following configurations: 1. Windows NT 4 (master) - > Windows NT 4 (slave) 2. Windows NT 4 (master) - > Linux (slave) Linux to Linux and Linux to Windows works okay. The problem is as follows: Suppose we have a database called "Trident3-P-0", with exactly that case! We replicate that database to the secondary with another name, with replication parameter replicate-rewrite-db. This is a part of my.cnf file with these settings on the slave machine: replicate-rewrite-db=Trident3-P-0->Trident3-S-0 replicate-rewrite-db=Trident3-P-1->Trident3-S-1 replicate-rewrite-db=Trident3-P-2->Trident3-S-2 I usualy connect to MySQL server running Windows NT 4.0 with "mysql -h master.hostname.domain -u user -ppassword" and with a USE statement change the active database to "Trident3-P-0". Whatever I do on that databese on master now DOES NOT replicate to slave. I trided to use all kinds of cases when changing the database on master - no change of replication behaviour! >Fix: Now, I found out that if instead of using "USE" I use "\r" command then the replication magicaly starts to work. So if I type "\r Trident3-P-0" instead of "USE Trident3-P-0" then the replication to "Trident3-S-0" on the slave machine starts to work. Replication also works if I connect to the database at the time of establishing connection with the server. So if I connect to the master server using "mysql -h master.hostname.domain -u user -p password Trident3-P-0" then replication also works. The problem applyes to configurations when we replicate from windows master to windows slave or windows master to linux slave. Obviously there is a problem with the windows version of mysql. With best regards, Ales Perme IT Manager Novifroum Ltd. Stegne 31 Ljubljana S L O V E N I A >Submitter-Id: >Originator:Ales Perme >Organization: Noviforum Ltd. >MySQL support: none >Synopsis: Replication problems >Severity: critical >>Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.42 (Official MySQL binary) >Server: /export/software/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.42, 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.42-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 7 days 10 min 2 sec Threads: 12 Questions: 133693547 Slow queries: 1244 Opens: 366 Flush tables: 13 Open tables: 90 Queries per second avg: 220.834 >Environment: System: Linux majstr1 2.4.18 #1 SMP tor mar 19 19:43:16 CET 2002 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-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 sep 21 2001 /lib/libc.so.6 -> libc-2.2.3.so -rwxr-xr-x1 root root 4783716 maj 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 maj 26 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 maj 26 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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
Table crash!
>Description: Hi! My name is Ales Perme. A college of mine Samo Login gave me this adress, which was given to him by Monty, to report MySQL bugs to. Production configurations: 1. Windows NT 4.0, Service pack 6a, MySQL 3.23.36 2. Slackware Linux, kernel version: SMP 2.4.18, MySQL 3.23.42-log The structure of the table we are experianceing problems with is: CREATE TABLE `repository` ( `DIGEST` varchar(32) NOT NULL default '', `CONTENT` longblob NOT NULL, `CONTENT_TYPE` varchar(60) NOT NULL default '', `CONTENT_LENGTH` int(11) NOT NULL default '-1', `CONTENT_LANGUAGE` tinyblob, `LAST_MODIFIED` datetime default NULL, `LAST_ACCESSED` datetime NOT NULL default '-00-00 00:00:00', `CONTENT_TIMESTAMP` datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`DIGEST`), KEY `REPOSITORY_LAST_ACCESSED` (`LAST_ACCESSED`) ) TYPE=MyISAM MAX_ROWS=4 The table has mysql> select count(*) from repository; +--+ | count(*) | +--+ | 5673838 | +--+ records inside. 1. I get table a "table crashed" whenever I try to fix it or check it with MYISAMCHK using -r, -o or -f parameters. And the table is then no longer usable. 2. "BACKUP TABLE repository to ..." gives a response code OK. Successfull! But when I try to restore it with "RESTORE TABLE repository FROM ...", the restore fails and tryes to restore the table without "quicksort". MySQL server on Windows NT 4.0, Service Pach 6a crashes with drwatson. 3. If I check the table with SQL statement "CHECK TABLE repository" then I get an OK! result code. What can I do? What seems to be the problem. If you need any aditional info please contact me. The table itself is 13.1 GB in size and index is 430 MB. With best regards, Ales Perme IT Manager Novifroum Ltd. Stegne 31 Ljubljana S L O V E N I A >How-To-Repeat: 1. I get table a "table crashed" whenever I try to fix it or check it with MYISAMCHK using -r, -o or -f parameters. And the table is then no longer usable. 2. "BACKUP TABLE repository to ..." gives a response code OK. Successfull! But when I try to restore it with "RESTORE TABLE repository FROM ...", the restore fails and tryes to restore the table without "quicksort". MySQL server on Windows NT 4.0, Service Pach 6a crashes with drwatson. >Fix: None available! >Submitter-Id: >Originator:Ales Perme >Organization: Noviforum Ltd. >MySQL support: none >Synopsis: Table crash! >Severity: critical >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.36 (Official MySQL binary) >Server:3.23.36 for Windows NT >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.36-log >Environment: System: Windows NT Server v4.0 , Service pack 6a Architecture: i686 - 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
