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 ....
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 ....