slave status in rpl000015.test

>Description:
rpl000015.test fails because of an additional slave status result.

>How-To-Repeat:
cd mysql-test
../mysql-test-run --do-test=rpl000015
***************
*** 5,10 ****
--- 5,11 ----
reset slave;
show slave status;
Master_Host Master_User Master_Port Connect_retry
Master_Log_File Read_Master_Log_PosRelay_Log_File Relay_Log_Pos
Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running
Replicate_do_db Replicate_ignore_db Last_errno Last_error
Skip_counter Exec_master_log_pos Relay_log_space
+ 127.0.0.1 root MASTER_PORT 1 4
slave-relay-bin.001 4 No No 0
0 0 4

>Originator: Julian Ladisch
>MySQL support: licence
>Synopsis: slave status in rpl000015.test
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.4-beta (Source distribution)
>Environment:
System: Linux 2.4.10-4GB #1 i686
Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static CFLAGS=-O3 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno -rtti' CXX=gcc


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12643@lists.mysql.com
To unsubscribe, e-mail

slave status in rpl000015.test

Hi!

>>>>> "Julian" == Julian Ladisch writes:

>> Description:
Julian> rpl000015.test fails because of an additional slave status result.

>> How-To-Repeat:
Julian> cd mysql-test
Julian> ./mysql-test-run --do-test=rpl000015
Julian> ***************
Julian> *** 5,10 ****
Julian> --- 5,11 ----
Julian> reset slave;
Julian> show slave status;
Julian> Master_Host Master_User Master_Port Connect_retry
Julian> Master_Log_File Read_Master_Log_PosRelay_Log_File Relay_Log_Pos
Julian> Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running
Julian> Replicate_do_db Replicate_ignore_db Last_errno Last_error
Julian> Skip_counter Exec_master_log_pos Relay_log_space
Julian> + 127.0.0.1 root MASTER_PORT 1 4

This is strange; I have seen this problem once before but not being
able to repeat this.

We did also run the test suite on all machines for which we make
binaries, but didn't encounter this one for 4.0.4.

This probably means that we have a non critical timing issue when
doing 'show slave status' just after a reset.

Can you repeat the above on your machine by doing just:

cd mysql-test
mysql-test-run --local rpl000015.test ?

Note that even if this fails, your MySQL distribution should be ok.

Regards,
Monty

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12656@lists.mysql.com
To unsubscribe, e-mail

Re: slave status in rpl000015.test

Hi,

Monty wrote:

> Can you repeat the above on your machine by doing just:
>
> cd mysql-test
> mysql-test-run --local rpl000015.test ?

Well, I really should have written:

> How-To-Repeat:

configure, make and install
cd /bin # e.g. /usr/local/mysql/bin
ln -s ../libexec/mysqld mysqld
cd /mysql-test # e.g. /usr/local/mysql/mysql-test
../mysql-test-run --local rpl000015.test

This makes the test fail:
*** 5,10 ****
--- 5,11 ----
reset slave;
show slave status;
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 Last_errno Last_error
Skip_counter Exec_master_log_pos Relay_log_space
+ 127.0.0.1 root MASTER_PORT 1 4
slave-relay-bin.001 4 NoNo 0
0 0 4

It works all fine if you run the test from the source tree directory.

Julian


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12666@lists.mysql.com
To unsubscribe, e-mail