Bug #14063 rpl_rotate_logs test case fails in 5.0.13
Submitted: 17 Oct 2005 6:21 Modified: 17 Oct 2005 10:36
Reporter: Yong Lee Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.13 OS:Linux (redhat linux 9.3)
Assigned to: CPU Architecture:Any

[17 Oct 2005 6:21] Yong Lee
Description:
Trying to compile using the rpm source (mysql-5.0.13-rc.tar.gz) and ran into problems when 1 test case died reporting : 

Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 28: query 'start slave' failed with wrong errno 1201 instead of 1105...
(the last lines may be the most important ones)

Compiling this manually using the default configure options listed in the install file :

CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \
            -fno-exceptions -fno-rtti" ./configure \
            --prefix=/usr/local/mysql --enable-assembler \
            --with-mysqld-ldflags=-all-static

gave the same results.  Note version of gcc is :

gcc --version
gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 

Next, I downloaded the binary distribution :
mysql-max-5.0.13-rc-linux-i686-glibc23.tar.gz
after untar'ing and setting up the requested links, I manually ran the test case in the 
/usr/local/mysql/mysql-test directory :

./mysql-test-run rpl_rotate_logs
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../bin/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --skip-bdb
Installing Master Databases 1
running  ../bin/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data1 --skip-innodb --skip-ndbcluster --skip-bdb
Installing Slave Databases
running  ../bin/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests
 
TEST                            RESULT
-------------------------------------------------------
rpl_rotate_logs                [ fail ]
 
Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 28: query 'start slave' failed with wrong errno 1201 instead of 1105...
(the last lines may be the most important ones)
 
Aborting: rpl_rotate_logs failed in default mode. To continue, re-run with '--force'.
 
Ending Tests
Shutting-down MySQL daemon
 
Master shutdown finished
Slave shutdown finished

Note mysql debug information :
 SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: [50 character or so descriptive subject here (for reference)]
                                                                                                                      
>Description:
        <precise description of the problem (multiple lines)>
>How-To-Repeat:
        <code/input/activities to reproduce the problem (multiple lines)>
>Fix:
        <how to correct or work around the problem, if known (multiple lines)>
                                                                                                                      
>Submitter-Id:  <submitter ID>
>Originator:    root
>Organization:
 <organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:      <synopsis of the problem (one line)>
>Severity:      <[ non-critical | serious | critical ] (one line)>
>Priority:      <[ low | medium | high ] (one line)>
>Category:      mysql
>Class:         <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release:       mysql-5.0.13-rc-max (MySQL Community Edition - Experimental (GPL))
                                                                                                                      
>C compiler:    gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>C++ compiler:  gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>Environment:
        <machine, os, target, libraries (multiple lines)>
System: Linux localhost.localdomain 2.4.20-8 #1 Thu Mar 13 17:54:28 EST 2003 i686 i686 i386 GNU/Linux
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/3.2.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux
Thread model: posix
gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx    1 root     root           13 Sep 21 23:37 /lib/libc.so.6 -> libc-2.3.2.so
-rwxr-xr-x    1 root     root      1561228 Nov 12  2003 /lib/libc-2.3.2.so
-rw-r--r--    1 root     root      2332200 Nov 12  2003 /usr/lib/libc.a
-rw-r--r--    1 root     root          204 Nov 12  2003 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Edition - Experimental (GPL)' '--with-extra-charsets=complex' '--with-server-suffix=-max' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-big-tables' '--with-readline' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--with-ndbcluster' '--with-csv-storage-engine' '--with-example-storage-engine' '--with-federated-storage-engine' '--with-innodb' 'CC=gcc' 'CXX=gcc'

Note that I could not find any .reject files.

Running test again with local option gives same result.  Please let me know if you want me to try compiling again with the debug trace option.

  
  
 

How to repeat:
Running the rpl_rotate_logs test with the 5.0.13 release seems to fail

Suggested fix:
There appears to be an old bug report number 8362 on a solaris platform that is showing the same problem with the 5.0.2 alpha release.  The bug report identifies a fix but there is no information on whether this resolved the problem or not.
[17 Oct 2005 9:30] Hartmut Holzgraefe
couldn't reproduce this on SuSE 9.3 with 5.0.13 built from source tarball
[17 Oct 2005 10:36] Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat the test failure you described on latest 5.0.16-BK build (ChangeSet@1.2040.1.1, 2005-10-14 11:28:01+02:00, mskold@mysql.com), compiled from sources on Fedora Core 1:

[openxs@Fedora mysql-test]$ ./mysql-test-run rpl_rotate_logs
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --skip-bdb
Installing Slave Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
rpl_rotate_logs                [ pass ]
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
All 1 tests were successful.

[openxs@Fedora mysql-test]$ ../libexec/mysqld --version
../libexec/mysqld  Ver 5.0.16 for redhat-linux-gnu on i686 (Source distribution)

[openxs@Fedora mysql-test]$ uname -a
Linux Fedora 2.4.22-1.2115.nptl #1 Wed Oct 29 15:42:51 EST 2003 i686 i686 i386 GNU/Linux
[4 May 2006 18:15] Dan Goodwin
I'm also experiencing this same issue with 5.0.21 on Fedora Core 5.  The test case fails if run as root.  If you run this test as a regular user, it runs fine.  That's why you were not able to reproduce it.

I perform my builds and "make test" as root for all my apps, because some tests require root access.  I came across this bug when I upgraded to mysql 5.0.