>Description:
The database test case rpl000015 fails. It appears from the
'diff' output (withing the test output appended below) that the
testcase was expecting to run on port 9998 when it actually
ran on port 3050. As you can see from the output from the
mysqlbug script, the --with-tcp-port=3050 configuration option
was specified for the build. The same result will occur if the
mysqld database daemon is running or not.
Running "./mysql-test-run --force" , the server will complete
all of the rest of the tests fine. this is the ONLY test it fails.
>How-To-Repeat:
compile mysql, cd to the mysql-test directory, run mysql-test-run
>Fix:
unknown
>Submitter-Id: [EMAIL PROTECTED]
>Originator: Sam Rasins
>Organization:
Caribe Enterprises, Inc.
>MySQL support:
>Synopsis: mysql-3.23.38 failed test rpl000015, Linux 2.2.16, i686 (SMP)
>Severity: non-critical
>Priority: low
>Category: mysql
>Class:
>Release: mysql-3.23.38 (Source distribution)
>Environment:
System: Linux www2 2.2.16 #6 SMP Wed Apr 25 01:43:53 CDT 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-slackware-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Feb 8 07:40 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 1013224 Mar 21 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so
lrwxrwxrwx 1 root root 29 Feb 8 07:40 /usr/lib/libc.so.1 ->
/usr/i486-sysv4/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local --enable-assembler
--with-mysqld-ldflags=-all-static --enable-thread-safe-client --with-debug
--localstatedir=/usr/local/mysql/data
--with-unix-socket-path=/usr/local/mysql/mysql.sock --with-tcp-port=3050 --with-innodb
--with-berkeley-db
----------------------------------------------------------------------------
Output from running ./mysqld-test-run
----------------------------------------------------------------------------
Installing Test Databases
Removing Stale Files
Installing Master Databases
Installing Slave Databases
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests
TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------------------
alias 0.05 0.17 12.72 [ pass ]
alter_table 0.06 0.09 0.21 [ pass ]
analyse 0.08 0.06 0.13 [ pass ]
auto_increment 0.06 0.11 0.20 [ pass ]
backup 0.07 0.08 0.18 [ pass ]
bdb-crash 0.08 0.07 1.08 [ pass ]
bdb 0.15 0.11 33.88 [ pass ]
bench_count_dist 0.08 0.11 0.28 [ pass ]
bigint 0.07 0.08 0.12 [ pass ]
binary 0.06 0.08 0.15 [ pass ]
case 0.07 0.06 0.14 [ pass ]
comments 0.10 0.05 0.12 [ pass ]
compare 0.07 0.08 0.12 [ pass ]
count_distinct 0.08 0.07 0.16 [ pass ]
create 0.07 0.08 0.17 [ pass ]
delayed 0.06 0.08 3.13 [ pass ]
delete 0.08 0.08 0.15 [ pass ]
dirty-close 0.06 0.09 0.12 [ pass ]
distinct 0.07 0.11 0.34 [ pass ]
drop 0.05 0.09 0.13 [ pass ]
empty_table 0.08 0.06 0.12 [ pass ]
err000001 0.06 0.10 0.13 [ pass ]
explain 0.10 0.05 0.13 [ pass ]
flush 0.06 0.13 0.31 [ pass ]
flush_table 0.08 0.07 0.11 [ pass ]
foreign_key 0.05 0.07 0.13 [ pass ]
fulltext 0.07 0.10 0.16 [ pass ]
fulltext_cache 0.04 0.14 0.14 [ pass ]
fulltext_left_jo 0.06 0.09 0.13 [ pass ]
fulltext_multi 0.09 0.04 0.13 [ pass ]
fulltext_order_b 0.07 0.07 0.13 [ pass ]
func_crypt 0.10 0.04 0.12 [ pass ]
func_date_add 0.08 0.09 0.15 [ pass ]
func_equal 0.05 0.07 0.13 [ pass ]
func_group 0.07 0.12 0.22 [ pass ]
func_in 0.07 0.09 0.13 [ pass ]
func_like 0.05 0.07 0.12 [ pass ]
func_math 0.10 0.05 0.12 [ pass ]
func_misc 0.05 0.10 0.12 [ pass ]
func_op 0.08 0.09 0.12 [ pass ]
func_regexp 0.09 0.09 0.16 [ pass ]
func_set 0.07 0.11 0.13 [ pass ]
func_str 0.09 0.10 0.92 [ pass ]
func_system 0.06 0.07 0.12 [ pass ]
func_test 0.09 0.06 0.13 [ pass ]
func_time 0.06 0.12 0.21 [ pass ]
func_timestamp 0.08 0.04 0.12 [ pass ]
gemini .... .... .... [ skipped ]
group_by 0.09 0.07 0.29 [ pass ]
having 0.04 0.12 0.12 [ pass ]
heap 0.05 0.08 0.22 [ pass ]
innodb 0.13 0.07 1.01 [ pass ]
ins000001 0.04 0.12 0.13 [ pass ]
insert 0.09 0.06 0.12 [ pass ]
insert_select 0.08 0.09 0.13 [ pass ]
isolation .... .... .... [ skipped ]
join 0.09 0.07 0.17 [ pass ]
join_crash 0.06 0.08 0.17 [ pass ]
join_outer 0.10 0.12 0.49 [ pass ]
key 0.08 0.09 0.21 [ pass ]
key_diff 0.08 0.06 0.13 [ pass ]
key_primary 0.04 0.08 0.13 [ pass ]
keywords 0.09 0.09 0.12 [ pass ]
kill 0.07 0.08 5.13 [ pass ]
limit 0.06 0.09 0.13 [ pass ]
lock 0.06 0.12 0.17 [ pass ]
merge 0.10 0.24 0.55 [ pass ]
myisam 0.04 0.13 0.12 [ pass ]
null 0.06 0.10 0.13 [ pass ]
null_key 0.07 0.10 0.22 [ pass ]
odbc 0.07 0.06 0.12 [ pass ]
order_by 0.06 0.13 0.26 [ pass ]
outfile 0.08 0.08 0.12 [ pass ]
overflow 0.06 0.09 0.11 [ pass ]
raid .... .... .... [ skipped ]
range 0.06 0.12 0.22 [ pass ]
rename 0.04 0.11 0.16 [ pass ]
replace 0.05 0.09 0.15 [ pass ]
rollback 0.11 0.05 0.12 [ pass ]
rpl000001 0.09 0.07 2.73 [ pass ]
rpl000002 0.05 0.09 0.17 [ pass ]
rpl000003 0.04 0.09 0.16 [ pass ]
rpl000004 0.05 0.09 0.19 [ pass ]
rpl000005 0.09 0.11 0.17 [ pass ]
rpl000006 0.10 0.07 0.15 [ pass ]
rpl000007 0.07 0.09 0.17 [ pass ]
rpl000008 0.08 0.08 0.17 [ pass ]
rpl000009 0.06 0.10 0.17 [ pass ]
rpl000010 0.05 0.11 4.20 [ pass ]
rpl000011 0.06 0.10 0.16 [ pass ]
rpl000012 0.07 0.09 0.22 [ pass ]
rpl000013 0.07 0.12 0.23 [ pass ]
rpl000014 0.07 0.10 2.19 [ pass ]
rpl000015 .... .... .... [ fail ]
>> Error at line 35: Result content mismatch <<Below are the diffs between actual
and expected results:
-------------------------------------------------------
*** r/rpl000015.result Wed May 9 23:44:13 2001
--- r/rpl000015.reject Wed May 30 06:00:04 2001
***************
*** 3,9 ****
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
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
--- 3,9 ----
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 3050 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
-------------------------------------------------------
Please e-mail the above, along with the output of mysqlbug
and any other relevant info to [EMAIL PROTECTED]
Aborting. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
