| Bug #37619 | duplicated entry for Binlog_Ignore_DB with mysql-5.0.51 RPM | ||
|---|---|---|---|
| Submitted: | 25 Jun 2008 2:29 | Modified: | 25 Jun 2008 6:22 |
| Reporter: | Tetsuro Ikeda | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.0.51 | OS: | Linux (RHEL4) |
| Assigned to: | CPU Architecture: | Any | |
[25 Jun 2008 3:24]
Valeriy Kravchuk
Thank you for a problem report. Please, send the results of: find / -name "my.cnf" -print 2>/dev/null
[25 Jun 2008 4:54]
Tetsuro Ikeda
Actually there is another "my.cnf" than "/etc/my.cnf" in my computer, but I don't think this affects to this issue. [root@tritonn32 etc]# find / -name "my.cnf" -print 2>/dev/null /etc/my.cnf /home/mir/rpm/BUILD/tritonn-1.0.10-mysql-5.0.51a/debian/additions/my.cnf [root@tritonn32 etc]#
[25 Jun 2008 4:56]
Paul DuBois
The my.cnf file is not quite correct. http://dev.mysql.com/doc/refman/5.0/en/binary-log.html says this about binlog-ignore-db: " To log multiple databases, use multiple options, specifying the option once for each database. " So the file should look like this: [mysqld] log-bin log binlog-ignore-db=mysql binlog-ignore-db=test However, that doesn't account for the SHOW SLAVE STATUS, which looks suspiciously like the my.cnf file is being read twice.
[25 Jun 2008 4:57]
Valeriy Kravchuk
Looks like a duplicate of http://bugs.mysql.com/bug.php?id=20748 then. Please, check.
[25 Jun 2008 5:18]
Tetsuro Ikeda
configure options in mysqlbug are... CONFIGURE_LINE="./configure '--disable-shared' '--with-server-suffix=-community' '--without-embedded -server' '--with-ndbcluster' '--with-innodb' '--with-csv-storage-engine' '--with-archive-storage-eng ine' '--with-blackhole-storage-engine' '--with-example-storage-engine' '--with-federated-storage-eng ine' '--without-bench' '--with-zlib-dir=bundled' '--with-big-tables' '--enable-assembler' '--enable- local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with -pic' '--prefix=/' '--with-extra-charsets=all' '--with-yassl' '--exec-prefix=/usr' '--libexecdir=/us r/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mys ql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thre ad-safe-client' '--with-comment=MySQL Community Edition (GPL)' '--with-readline' 'CC=gcc' 'CFLAGS=-O 2 -g -pipe -m32 -march=i386 -mtune=pentium4' 'CXXFLAGS=-O2 -g -pipe -m32 -march=i386 -mtune=pentium4 ' 'CXX=gcc' 'LDFLAGS='" This shows prefix is "/", then this issue must be duplicated of http://bugs.mysql.com/bug.php?id=20748
[25 Jun 2008 6:22]
Valeriy Kravchuk
Duplicate of bug #20748.
Description: "SHOW MASTER STATUS" shows duplicated entry like following. mysql> show master status\G *************************** 1. row *************************** File: tritonn32-bin.000006 Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: mysql,test,mysql,test 1 row in set (0.00 sec) "SHOW SLAVE STATUS" may same as well. Tarball binary package doesn't have this issue. How to repeat: Install MySQL 5.0.51a-0 for Red Hat Enterprise Linux 4 RPM (x86) Edit my.cnf like followings: [mysqld] log-bin log binlog-ignore-db=mysql,test Restart and connect to mysql, then do "SHOW MASTER STATUS".