| 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: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.0.3 | OS: | MacOS (Mac OS X 10.3.8) |
| Assigned to: | CPU Architecture: | Any | |
[8 Apr 2005 14:59]
Panu Korpela
[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.
