Bug #8362 rpl_rotate_logs test failed
Submitted: 8 Feb 2005 1:09 Modified: 3 Apr 2005 16:59
Reporter: luojia chen Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.0.2 alpha OS:Solaris (Solaris 10 x86)
Assigned to: Assigned Account CPU Architecture:Any

[8 Feb 2005 1:09] luojia chen
Description:
I did compile the MySQL 5.0.2 on Solaris 10 x86, using the following command:
---------
./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile CC=cc CFLAGS="-DBIG_TABLES -xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native" CXX=CC CXXFLAGS="-DBIG_TABLES -xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native"
---------

After compilation, all the tests succeed except the "rpl_rotate_logs", the output of the rpl_rotate_logs is as:

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

Errors are (from /tests/mysql-5.0.2-alpha/mysql-test/var/log/mysqltest-time) :
/tests/mysql-5.0.2-alpha/client/.libs/mysqltest: At line 28: query 'start slave' failed with wrong errno 1201 instead of 1105...
/tests/mysql-5.0.2-alpha/client/.libs/mysqltest: At line 155: 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	Wed Dec	 1 03:31:35 2004
--- r/rpl_rotate_logs.reject	Tue Feb	 8 03:19:51 2005
***************
*** 1,7 ****
  drop table if exists t1, t2, t3, t4;
  drop table if exists t1, t2, t3, t4;
  start slave;
! ERROR HY000: File 'TESTDIR/var/slave-data/master.info' not found (Errcode: 13)  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.

The "rpl_rotate_logs.reject" file is as bellow

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';
ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
reset slave;
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
reset master;
start slave;
create temporary table temp_table (a char(80) not null);
insert into temp_table values ("testing temporary tables");
create table t1 (s text);
insert into t1 values('Could not break slave'),('Tried hard');
show slave status;
Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master
#	127.0.0.1	root	MASTER_PORT	60	master-bin.000001	521	#	#	master-bin.000001	Yes	Yes							0		0	521	#	None		0	No						#
select * from t1;
s
Could not break slave
Tried hard
flush logs;
create table t2(m int not null auto_increment primary key);
insert into t2 values (34),(67),(123);
flush logs;
show binary logs;
Log_name
master-bin.000001
master-bin.000002
master-bin.000003
create table t3 select * from temp_table;
select * from t3;
a
testing temporary tables
drop table temp_table, t3;
insert into t2 values(1234);
set insert_id=1234;
insert into t2 values(NULL);
set global sql_slave_skip_counter=1;
start slave;
purge master logs to 'master-bin.000002';
show master logs;
Log_name
master-bin.000002
master-bin.000003
purge binary logs to 'master-bin.000002';
show binary logs;
Log_name
master-bin.000002
master-bin.000003
purge master logs before now();
show binary logs;
Log_name
master-bin.000003
insert into t2 values (65);
show slave status;
Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master
#	127.0.0.1	root	MASTER_PORT	60	master-bin.000003	469	#	#	master-bin.000003	Yes	Yes							0		0	469	#	None		0	No						#
select * from t2;
m
34
65
67
123
1234
create temporary table temp_table (a char(80) not null);
insert into temp_table values ("testing temporary tables part 2");
create table t3 (n int);
select count(*) from t3 where n >= 4;
count(*)
100
create table t4 select * from temp_table;
show binary logs;
Log_name
master-bin.000003
master-bin.000004
master-bin.000005
show master status;
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
master-bin.000005	1387		
select * from t4;
a
testing temporary tables part 2
show slave status;
Slave_IO_State	Master_Host	Master_User	Master_Port	Connect_Retry	Master_Log_File	Read_Master_Log_Pos	Relay_Log_File	Relay_Log_Pos	Relay_Master_Log_File	Slave_IO_Running	Slave_SQL_Running	Replicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	Last_Error	Skip_Counter	Exec_Master_Log_Pos	Relay_Log_Space	Until_Condition	Until_Log_File	Until_Log_Pos	Master_SSL_Allowed	Master_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master
#	127.0.0.1	root	MASTER_PORT	60	master-bin.000005	1387	#	#	master-bin.000005	Yes	Yes							0		0	1387	#	None		0	No						#
lock tables t3 read;
select count(*) from t3 where n >= 4;
count(*)
100
unlock tables;
drop table if exists t1,t2,t3,t4;

How to repeat:
1. Using Sun Studio 10 compiler

2. Run the command
---------
./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile CC=cc CFLAGS="-DBIG_TABLES -xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native" CXX=CC CXXFLAGS="-DBIG_TABLES -xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native"
---------

3. Run "make"

4. Run "make install"

5. Run "make test"
[8 Feb 2005 17:29] MySQL Verification Team
Verified with 5.0 BK tree
[3 Mar 2005 16:59] Lars Thalmann
Hi Jenny,

As I understand it, this has been fixed in the source tree.
Perhaps you could verify this and let me know if the problem 
still exists?

Best wishes,
Lars
[3 Apr 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".