Bug #9763 Test rpl_rotate_logs fails in default mode and with --force
Submitted: 8 Apr 2005 14:59 Modified: 2 Sep 2005 11:36
Reporter: Panu Korpela Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.3 OS:Mac OS X (Mac OS X 10.3.8)
Assigned to: CPU Architecture:Any

[8 Apr 2005 14:59] Panu Korpela
Description:
MySQL was compiled as follows:
====================

CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer" ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --disable-shared

Test suite failed as follows:
====================

Errors are (from /Users/pkorpela/Desktop/mysql-5.0.3-beta/mysql-test/var/log/mysqltest-time) :
/Users/pkorpela/Desktop/mysql-5.0.3-beta/client/mysqltest: At line 28: query 'start slave' failed with wrong errno 1201 instead of 1105...
/Users/pkorpela/Desktop/mysql-5.0.3-beta/client/mysqltest: At line 156: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl_rotate_logs.result    Tue Mar 22 22:46:47 2005
--- r/rpl_rotate_logs.reject    Fri Apr  8 15:17:02 2005
***************
*** 1,7 ****
  drop table if exists t1, t2, t3, t4;
  drop table if exists t1, t2, t3, t4;
  start slave;
! Got one of the listed errors
  start slave;
  ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
  change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
--- 1,7 ----
  drop table if exists t1, t2, t3, t4;
  drop table if exists t1, t2, t3, t4;
  start slave;
! ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
  start slave;
  ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
  change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting: rpl_rotate_logs failed in default mode. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished

How to repeat:
Run test suite on Mac OS X
[3 Jun 2005 18:30] Francesco Riosa
reproducible here, this patch was needed to pass the test (mysql-5.0.6-beta):

--- mysql.orig/mysql-test/t/rpl_rotate_logs.test        2005-05-26 16:55:48.000000000 +0200
+++ mysql.fix/mysql-test/t/rpl_rotate_logs.test 2005-06-03 20:21:51.000000000 +0200
@@ -24,7 +24,7 @@
 # START SLAVE will fail because it can't read the file (mode 000)
 # (system error 13)
 --replace_result $MYSQL_TEST_DIR TESTDIR
---error 1105,1105,29
+--error 1201,1105,29
 start slave;
 system chmod 600 var/slave-data/master.info;
 # It will fail again because the file is empty so the slave cannot get valuable
[4 Jun 2005 5:29] Sergei Golubchik
Though I cannot repeat it either, but looks like 1201 is a valid error code there.
[11 Jul 2005 12:48] Matthew Lord
Could not repeat using gcc 3.3 on OS X:
Darwin silverbullet 7.9.0 Darwin Kernel Version 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC  Power Macintosh powerpc

Using 5.0.7-beta.
[1 Aug 2005 20:42] Peter Gulutzan
I can repeat it. I pulled MySQL-5.0.11 onto my SUSE 9.2 machine today
(2005-08-01), and built with BUILD/compile-pentium-debug. The test
fails just as the original description said.

d-142-59-78-116:/home/pgulutzan/mysql-5.0/mysql-test # ./mysql-test-run rpl_rotate_logsInstalling Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb     --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb     --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
rpl_rotate_logs                [ fail ]

Errors are (from /home/pgulutzan/mysql-5.0/mysql-test/var/log/mysqltest-time) :
/home/pgulutzan/mysql-5.0/client/.libs/mysqltest: At line 28: query 'start slave' failed with wrong errno 1201 instead of 1105...
/home/pgulutzan/mysql-5.0/client/.libs/mysqltest: At line 157: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl_rotate_logs.result    2005-08-01 22:37:39.000000000 +0300
--- r/rpl_rotate_logs.reject    2005-08-01 23:33:37.374622344 +0300
***************
*** 1,7 ****
  drop table if exists t1, t2, t3, t4;
  drop table if exists t1, t2, t3, t4;
  start slave;
! Got one of the listed errors
  start slave;
  ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
  change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
--- 1,7 ----
  drop table if exists t1, t2, t3, t4;
  drop table if exists t1, t2, t3, t4;
  start slave;
! ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
  start slave;
  ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
  change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting: rpl_rotate_logs failed in default mode. To continue, re-run with '--force'.
[2 Aug 2005 11:30] Georg Richter
Does rpl_rotate_logs still fail after removing mysql-test/var and when running as non root?
[3 Aug 2005 10:05] Jonathan Miller
forbid users to run tests as root, hmm interesting work around. I would say fixing the bug would be better, as you are not going to be able to forbid users from running as root. My $.02.
[11 Aug 2005 19:22] Jennifer Vanderputten
I am using the .pkg distribution for Solars 9, Sparc, 32-bit, max, version 5.0.0.10.  The pkgadd went fine, no errors.  I am getting this same error when running the tests as root.  It is true that the test passes when running as a non-root user; of course, this is after I chmod'ed everything a+w and a+r.  Mind you, I don't think this is a permissions issue, since the chmods didn't change the failure under the root login.

My concern is, will this root error prevent run-time usage?  Though it runs under the mysql login, are there root login dependencies?
[2 Sep 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[21 Sep 2005 7:50] Sergei Golubchik
Jennifer - no, it won't prevent run-time usage. If you'll check the test file you'll see that it does 'chmod 000 var/slave-data/master.info' and then expects 'start slave' to fail because of permission problems. When run as root, the test fails because file opens successfully.
[13 Nov 2005 10:05] David Kirkby
This also fails for me. I run as root too (not tried as a normal user), but this was from a binary (maxl, not debug or minimal) distribution on the mysql web site. 

mysql-max-5.0.15-solaris9-sparc.tar.gz

(the 32-bit version for Solaris 9). 

Hardware - Sun SPARCstation 20, Solaris 9, 256 MB RAM

I don't know whether this is the last test, but once this fails, no futher tests run:

main-webserver /usr/local/mysql/mysql-test # ./mysql-test-run
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
<snip>
rpl_reset_slave                [ pass ]   
rpl_rewrite_db                 [ pass ]   
rpl_rotate_logs                [ fail ]

Errors are (from /usr/local/mysql-max-5.0.15-solaris9-sparc/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
[14 Nov 2005 16:40] Jennifer Vanderputten
In the end, the install worked correctly despite the failure of testing under root login.  My apologies that I have not updated to this effect until now.