Bug #3521 "make test" status
Submitted: 21 Apr 2004 1:00 Modified: 11 Jun 2004 20:42
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.1-alpha OS:Other (tru64unix 5.1A, native compiler)
Assigned to: Sergei Golubchik CPU Architecture:Any

[21 Apr 2004 1:00] [ name withheld ]
Description:
I hope the following output of "make test" will help developers. I compiled the 4.1.1-alpha with tru64unix native compiler (64-bit) and ran "make test" after this. Here is the output:

# make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --based
ir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/shar
e/english/
Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --based
ir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share
/english/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

 TEST                           RESULT
------------------------------------------
alias                          [ pass ]
alter_table                    [ pass ]
analyse                        [ pass ]
ansi                           [ pass ]
auto_increment                 [ pass ]
backup                         [ pass ]
bdb-alter-table-1              [ skipped ]
bdb-alter-table-2              [ skipped ]
bdb-crash                      [ skipped ]
bdb-deadlock                   [ skipped ]
bdb                            [ skipped ]
bdb_cache                      [ skipped ]
bench_count_distinct           [ pass ]
bigint                         [ pass ]
binary                         [ pass ]
bool                           [ pass ]
bulk_replace                   [ pass ]
case                           [ pass ]
cast                           [ pass ]
check                          [ pass ]
comments                       [ pass ]
compare                        [ pass ]
connect                        [ pass ]
constraints                    [ pass ]
count_distinct                 [ pass ]
count_distinct2                [ pass ]

count_distinct3                [ pass ]
create                         [ pass ]
ctype_collate                  [ pass ]
ctype_cp1251                   [ pass ]
ctype_latin1_de                [ pass ]
ctype_many                     [ skipped ]
ctype_mb                       [ pass ]
ctype_recoding                 [ pass ]
ctype_ucs                      [ skipped ]
ctype_ujis                     [ skipped ]
ctype_utf8                     [ pass ]
date_formats                   [ pass ]
delayed                        [ pass ]
delete                         [ pass ]
derived                        [ pass ]
dirty_close                    [ pass ]
distinct                       [ pass ]
drop                           [ pass ]
drop_temp_table                [ pass ]
empty_table                    [ pass ]
errors                         [ pass ]
explain                        [ pass ]
flush                          [ pass ]
flush_table                    [ pass ]
foreign_key                    [ pass ]
fulltext                       [ pass ]
fulltext2                      [ pass ]
fulltext_cache                 [ pass ]
fulltext_distinct              [ pass ]
fulltext_left_join             [ pass ]
fulltext_multi                 [ pass ]
fulltext_order_by              [ pass ]
fulltext_update                [ pass ]
fulltext_var                   [ pass ]
func_compress                  [ skipped ]
func_concat                    [ pass ]
func_crypt                     [ pass ]
func_date_add                  [ pass ]
func_default                   [ pass ]
func_encrypt                   [ skipped ]
func_equal                     [ pass ]
func_gconcat                   [ pass ]
func_group                     [ pass ]
func_if                        [ pass ]
func_in                        [ pass ]
func_isnull                    [ pass ]
func_like                      [ pass ]
func_math                      [ pass ]
func_misc                      [ pass ]
func_op                        [ pass ]
func_regexp                    [ pass ]
func_sapdb                     [ pass ]
func_set                       [ pass ]
func_str                       [ pass ]
func_system                    [ pass ]
func_test                      [ pass ]
func_time                      [ pass ]
func_timestamp                 [ pass ]
gcc296                         [ pass ]
gis-rtree                      [ pass ]
gis                            [ pass ]
grant                          [ pass ]
grant2                         [ pass ]
grant_cache                    [ pass ]
group_by                       [ pass ]
handler                        [ pass ]
having                         [ pass ]
heap                           [ pass ]
heap_auto_increment            [ pass ]
heap_btree                     [ pass ]
heap_hash                      [ pass ]
help                           [ pass ]
innodb-deadlock                [ pass ]
innodb                         [ pass ]
innodb_cache                   [ pass ]
innodb_handler                 [ pass ]
insert                         [ pass ]
insert_select                  [ pass ]
insert_update                  [ pass ]
isam                           [ skipped ]
join                           [ pass ]
join_crash                     [ pass ]
join_outer                     [ pass ]
key                            [ pass ]
key_cache                      [ pass ]
key_diff                       [ pass ]
key_primary                    [ pass ]
keywords                       [ pass ]
kill                           [ pass ]
limit                          [ pass ]
loaddata                       [ pass ]
lock                           [ pass ]
lock_multi                     [ pass ]
lock_tables_lost_commit        [ pass ]
lowercase_table                [ pass ]
merge                          [ pass ]
mix_innodb_myisam_binlog       [ pass ]
multi_update                   [ pass ]
myisam                         [ pass ]
mysqlbinlog                    [ pass ]
mysqldump                      [ pass ]
negation_elimination           [ pass ]
null                           [ pass ]
null_key                       [ pass ]
odbc                           [ pass ]
olap                           [ pass ]
openssl_1                      [ skipped ]
order_by                       [ pass ]
order_fill_sortbuf             [ pass ]
outfile                        [ pass ]
overflow                       [ pass ]
packet                         [ pass ]
preload                        [ pass ]
query_cache                    [ pass ]
query_cache_merge              [ pass ]
raid                           [ skipped ]
range                          [ pass ]
rename                         [ pass ]
repair_part1                   [ pass ]
repair_part2                   [ pass ]
replace                        [ skipped ]
rollback                       [ pass ]
row                            [ pass ]
rpl000001                      [ pass ]
rpl000002                      [ pass ]
rpl000004                      [ pass ]
rpl000005                      [ pass ]
rpl000006                      [ pass ]
rpl000008                      [ pass ]
rpl000009                      [ pass ]
rpl000010                      [ pass ]
rpl000011                      [ pass ]
rpl000012                      [ pass ]
rpl000013                      [ pass ]
rpl000015                      [ fail ]

Errors are (from /scratch/sources/mysql-4.1.1-alpha/mysql-test/var/log/mysqltest
-time) :
/scratch/sources/mysql-4.1.1-alpha/client/.libs/mysqltest: At line 40: Result le
ngth mismatch
(the last line(s) may be the ones that caused the die() in mysqltest)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl000015.result  Mon Dec  1 16:20:37 2003
--- r/rpl000015.reject  Wed Apr 21 10:21:43 2004
***************
*** 8,14 ****
  change master to master_host='127.0.0.1';
  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       Replicat
e_Do_DB Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table
Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table     Last_Errno      Last_Err
or      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       test    MASTER_PORT     7               4       slave-re
lay-bin.000001  4               No      No
                0               0       0       4       None            0
No                                              #
  change master to master_host='127.0.0.1',master_user='root',
  master_password='',master_port=MASTER_PORT;
  show slave status;
--- 8,14 ----
  change master to master_host='127.0.0.1';
  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       Replicat
e_Do_DB Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table
Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table     Last_Errno      Last_Err
or      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       test    3308    7               4       slave-relay-bin.
000001  4               No      No
        0               0       0       4       None            0       No
                                        #
  change master to master_host='127.0.0.1',master_user='root',
  master_password='',master_port=MASTER_PORT;
  show slave status;
-------------------------------------------------------
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: rpl000015 failed. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1

How to repeat:
CXXLDFLAGS="-lwrap" \
CC="cc -std0 -pthread -DTHREAD -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DTCPWRAP_MYSQL -D__STDC__ -DDBUG_OFF -DHAVE_LIBWRAP" \
CXX="cxx -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DTCPWRAP_MYSQL -D__STDC__ -DDBUG_OFF   -DHAVE_LIBWRAP" CFLAGS="-DUSE_SYMDIR -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DHAVE_LIBWRAP" \
LIB_EXTRA_CCFLAGS="-lwrap" \
./configure \
--prefix=/usr/local_test \
--enable-thread-safe-client \
--enable-local-infile \
--with-pthread \
--with-unix-socket-path=/tmp/mysql_4.1.sock \
--with-tcp-port=3308 \
--with-mysqld-user=mysql \
--with-libwrap=/usr/local \
--without-debug \
--with-charset=utf8 \
--with-collation=utf8_general_ci

make
make test

Suggested fix:
Just to inform the developers about the current status on this platform - probably it helps to produce the stable code branch ....
[4 May 2004 20:34] Michael Widenius
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

The given output shows that somehow MASTER_MYPORT in mysql-test-run.sh was set to 3308, which should be impossible for an unmodified script as there is no value 3308 in it.

Did you edit mysql-test-run.sh / mysql-test-run in any way to change some port settings ?

If not, please check your mysql-test-run script and try to figure out how MASTER_MYPORT could be set to 3308. If you can find out, please update this bug report with this information.

Regards,
Monty
[9 Jun 2004 10:57] [ name withheld ]
I have the production 4.0 release on the standard port and socket, so I have configured 4.1 to use port 3308 and an alternatively named socket file. The complete configure options follow:

CXXLDFLAGS="-lwrap" \
CC="cc -std0 -pthread -DTHREAD -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DTCPWRAP_MYSQL
 -D__STDC__ -DDBUG_OFF -DHAVE_LIBWRAP" \
CXX="cxx -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DTCPWRAP_MYSQL -D__STDC__ -DDBUG_OFF
 -DHAVE_LIBWRAP" CFLAGS="-DUSE_SYMDIR -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DHAVE_L
IBWRAP" \
LIB_EXTRA_CCFLAGS="-lwrap" \
./configure \
--prefix=/usr/local_test \
--enable-thread-safe-client \
--enable-local-infile \
--with-pthread \
--with-unix-socket-path=/tmp/mysql_4.1.sock \
--with-tcp-port=3308 \
--with-mysqld-user=mysql \
--with-libwrap=/usr/local \
--without-debug \
--with-charset=utf8 \
--with-collation=utf8_general_ci

To the hint I did not provide enough information: following instructions from suggested page and my info to those ones follow:

#  Remember the three basics: what you did, what you expected to happen, and what happened.
-> I think I did this

# When you provide code that demonstrates the problem, it should almost never be more than ten lines long.
-> no code of mine, only running test which are part of the distribution: "make test"

# If the product is crashing, include a backtrace. Instructions for doing this can be found here.
-> make test starts its own instance of the server - where should I go and what source files should I edit to enable debugging there ?
[11 Jun 2004 20:42] Sergei Golubchik
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.1.3