mysql-test-run --debug --local rpl000015 FAILED

mysql-test-run --debug --local rpl000015 FAILED

am 19.09.2002 19:19:13 von Aaron.Tam

>Description: mysql-test-run --debug --local rpl000015 FAILED
Below include the output of this commend and the reject file output.

Please help!
Thanks

>How-To-Repeat:
download tmysql-3.23.52 (Source distribution)
./configure --prefix=/home/aaront/mysql
make
make install
script/mysql_install_db
cd /home/aaront/mysql
./bin/safe_mysqld &
cp /home/aaront/mysql/libexec/mysqld /home/aaront/mysql/mysqld
mysql-test-run --debug --local rpl000015 FAILED

>Fix:

>Submitter-Id:
>Originator:
>Organization:

>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>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-3.23.52 (Source distribution)

>Environment:

System: Linux tantulus 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686
unknown
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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Apr 15 10:40 /lib/libc.so.6 ->
libc-2.2.4.so
-rwxr-xr-x 1 root root 1285788 Apr 2 08:58 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27332668 Apr 2 08:42 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 2 08:42 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Jun 19 11:43
/usr/lib/libc-client.a -> c-client.a
Configure command: ./configure --prefix=/home/aaront/mysql


##############################################
# ./mysql-test-run --debug --local rpl000015 #
##############################################
Installing Test Databases
Removing Stale Files
Installing Master Databases
020919 19:52:42 ../bin/mysqld: Shutdown Complete

Installing Slave Databases
020919 19:52:42 ../bin/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------ ------------
rpl000015 .... .... .... [ fail ]

>> Error at line 35: Result length mismatch < actual and expected results:
-------------------------------------------------------
*** r/rpl000015.result Thu Sep 19 18:54:23 2002
--- r/rpl000015.reject Thu Sep 19 19:53:00 2002
***************
*** 1,7 ****
File Position Binlog_do_db Binlog_ignore_db
master-bin.001 73
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
! 0 0 0 No 0
0
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
127.0.0.1 test 9998 60 4 No
0 0
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
--- 1,7 ----
File Position Binlog_do_db Binlog_ignore_db
master-bin.001 73
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
! 127.0.0.1 root 9306 1 4 No
0 0
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
127.0.0.1 test 9998 60 4 No
0 0
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished


####################
# rpl000015.reject #
####################
File Position Binlog_do_db Binlog_ignore_db
master-bin.001 73
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
127.0.0.1 root 9306 1 4 No
0 0
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
127.0.0.1 test 9998 60 4 No
0 0
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
127.0.0.1 root 9999 60 4 No
0 0
Master_Host Master_User Master_Port Connect_retry Log_File
Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Last_error Skip_counter
127.0.0.1 root 9999 60 master-bin.001 73 Yes
0 0
n
10
45
90

------------------------------------------------------------ ---------
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-thread12562@lists.mysql.com
To unsubscribe, e-mail

Re: mysql-test-run --debug --local rpl000015 FAILED

am 20.09.2002 13:09:20 von Peter Zaitsev

On Thursday 19 September 2002 21:19, Tam,Aaron wrote:
> >Description: mysql-test-run --debug --local rpl000015 FAILED
>
> Below include the output of this commend and the reject file output.
>
> Please help!
> Thanks
>
> >How-To-Repeat:
>
> download tmysql-3.23.52 (Source distribution)
> ./configure --prefix=3D/home/aaront/mysql
> make
> make install
> script/mysql_install_db
> cd /home/aaront/mysql
> ./bin/safe_mysqld &
> cp /home/aaront/mysql/libexec/mysqld /home/aaront/mysql/mysqld
> mysql-test-run --debug --local rpl000015 FAILED
>
>=20

Sorry I'm not sure what are you doing at this point, and which=20
is exactly the problem.

Why do not you run mysql-test-run from ./mysql-test directory and=20
why you're copying mysqld somewhere ?

If you just run mysql-test-run from source tree or just "make test" after=
you've compiled
MySQL does it work for you ?

Does it work if you run it without debug or it is the same as with debug =
?=20


=20


--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


------------------------------------------------------------ ---------
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-thread12567@lists.mysql.com
To unsubscribe, e-mail

mysql-test-run --debug --local rpl000015 FAILED

am 25.09.2002 15:27:10 von Michael Widenius

Hi!

>>>>> "Aaron" == Aaron Tam writes:

>> Description: mysql-test-run --debug --local rpl000015 FAILED
Aaron> Below include the output of this commend and the reject file output.



>> How-To-Repeat:
Aaron> download tmysql-3.23.52 (Source distribution)
Aaron> ./configure --prefix=/home/aaront/mysql
Aaron> make
Aaron> make install
Aaron> script/mysql_install_db
Aaron> cd /home/aaront/mysql
Aaron> ./bin/safe_mysqld &
Aaron> cp /home/aaront/mysql/libexec/mysqld /home/aaront/mysql/mysqld
Aaron> mysql-test-run --debug --local rpl000015 FAILED



Aaron> TEST USER SYSTEM ELAPSED RESULT
Aaron> ------------------------------------------------------------ ------------
Aaron> rpl000015 .... .... .... [ fail ]

>>> Error at line 35: Result length mismatch <
Aaron> actual and expected results:
Aaron> -------------------------------------------------------
Aaron> *** r/rpl000015.result Thu Sep 19 18:54:23 2002
Aaron> --- r/rpl000015.reject Thu Sep 19 19:53:00 2002
Aaron> ***************
Aaron> *** 1,7 ****
Aaron> File Position Binlog_do_db Binlog_ignore_db
Aaron> master-bin.001 73
Aaron> Master_Host Master_User Master_Port Connect_retry Log_File
Aaron> Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Aaron> Last_error Skip_counter
Aaron> ! 0 0 0 No 0
Aaron> --- 1,7 ----
Aaron> File Position Binlog_do_db Binlog_ignore_db
Aaron> master-bin.001 73
Aaron> Master_Host Master_User Master_Port Connect_retry Log_File
Aaron> Pos Slave_Running Replicate_do_db Replicate_ignore_db Last_errno
Aaron> Last_error Skip_counter
Aaron> ! 127.0.0.1 root 9306 1 4 No

What this means is that because of some 'unknown reason' the slave
data was not initially reset as expect. This may be an unknown timing
issue after doing a 'reset slave'.

However this should not be critical and doesn't mean that MySQL isn't
working ok; It's more likely that this is just a bug in the test case.
(Which we should fix, but to do this we need a way to repeat this)

Is the above case repeatable ?
Do you get any other failed tests when you do:

mysql-test-run --force

Regards,
Monty

PS: The timing for this particular test is completely different in 4.0
so it's very likely that 4.0 doesn't have a problem with this.



------------------------------------------------------------ ---------
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-thread12596@lists.mysql.com
To unsubscribe, e-mail