Description:
Dear all,
Hi. This is imacat from Taiwan. I have downloaded and tried the newly-released MySQL 5.0.33, and failed make test on mysql_upgrade. I have searched and the bug database with the keyword "mysql_upgrade" and failed to find a same report. I saw that the make test has been improved to provide more information. I do not know if I shall reporting this issue, or some tests are expected to fail on unresolved bugs. I guess I should still report it.
I run this on 3 machines, all with the same result. One is i386, Debian Sarge 3.1r4 i386, kernel 2.6.16.29, gcc 3.4.4, glibc 2.3.2. The second is x86_64, Debian Sarge 3.1r4 AMD64, kernel 2.6.16.29, gcc 3.4.4, glibc 2.3.2. The third is x86_64, Debian Etch d-i 20061126 AMD64, kernel 2.6.16.29, gcc 4.1.2, glibc 2.3.6. The configuration command line I'm using is:
./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var/lib/mysql --infodir=/usr/share/info --mandir=/usr/share/man --enable-thread-safe-client --enable-assembler --with-extra-charsets=all --with-unix-socket-path=/var/run/mysql/mysql.sock --with-mysqld-user=mysql --without-bench --without-readline
The result terminal log is below. I omit the log on i386 since the result is exactly the same. Hope this helps. Please tell me if you need any information.
imacat@atlas src/mysql-5.0.33 % ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var/lib/mysql --infodir=/usr/share/info --mandir=/usr/share/man --enable-thread-safe-client --enable-assembler --with-extra-charsets=all --with-unix-socket-path=/var/run/mysql/mysql.sock --with-mysqld-user=mysql --without-bench --without-readline
checking build system type... x86_64-unknown-linux-gnu
...
Thank you for choosing MySQL!
imacat@atlas src/mysql-5.0.33 % make
++ echo strmov.lo strxmov.lo strxnmov.lo strnmov.lo strmake.lo strend.lo strtod.lo strnlen.lo strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo strcend.lo bcmp.lo ctype-latin1.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo strtoll.lo llstr.lo my_vsnprintf.lo ctype.lo ctype-simple.lo ctype-bin.lo ctype-mb.lo ctype-big5.lo ctype-czech.lo ctype-cp932.lo ctype-eucjpms.lo ctype-euc_kr.lo ctype-win1250ch.lo ctype-utf8.lo ctype-extra.lo ctype-ucs2.lo ctype-gb2312.lo ctype-gbk.lo ctype-sjis.lo ctype-tis620.lo ctype-ujis.lo ctype-uca.lo xml.lo my_strtoll10.lo str_alloc.lo
...
g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o mysqlmanager command.o mysqlmanager.o manager.o log.o thread_registry.o listener.o protocol.o mysql_connection.o user_map.o messages.o commands.o instance.o instance_map.o instance_options.o buffer.o parse.o guardian.o parse_output.o ./.libs/liboptions.a -lpthread -lpthread -lpthread -lpthread libnet.a ../../vio/libvio.a ../../mysys/libmysys.a ../../strings/libmystrings.a ../../dbug/libdbug.a -lz -lpthread -lcrypt -lnsl -lm -lpthread
imacat@atlas src/mysql-5.0.33 % make test
MySQL Version 5.0.33
Skipping ndbcluster, mysqld not compiled with ndbcluster
Skipping SSL, mysqld not compiled with SSL
Using MTR_BUILD_THREAD = 0
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using IM_PORT = 9312
Using IM_MYSQLD1_PORT = 9313
Using IM_MYSQLD2_PORT = 9314
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
Installing Master Database
Installing Slave1 Database
Creating IM password file (/usr/local/src/mysql-5.0.33/mysql-test/var/im.passwd)
Installing Im_mysqld_1 Database
Installing Im_mysqld_2 Database
=======================================================
Starting Tests in the 'main' suite
TEST RESULT TIME (ms)
-------------------------------------------------------
alias [ pass ] 26
...
mysql_protocols [ pass ] 131
mysql_upgrade [ fail ]
Errors are (from /usr/local/src/mysql-5.0.33/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/mysql_upgrade.result 2007-01-09 16:09:32.000000000 +0300
--- r/mysql_upgrade.reject 2007-01-15 07:13:20.000000000 +0300
***************
*** 1,127 ****
Run mysql_upgrade once
- mysql.columns_priv OK
- mysql.db OK
- mysql.func OK
- mysql.help_category OK
- mysql.help_keyword OK
- mysql.help_relation OK
- mysql.help_topic OK
- mysql.host OK
- mysql.proc OK
- mysql.procs_priv OK
- mysql.tables_priv OK
- mysql.time_zone OK
- mysql.time_zone_leap_second OK
- mysql.time_zone_name OK
- mysql.time_zone_transition OK
- mysql.time_zone_transition_type OK
- mysql.user OK
- @hadGrantPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadShowDbPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateViewPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateRoutinePriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateUserPriv:=1
- 1
- 1
- 1
- 1
- 1
Run it again - should say already completed
- @hadGrantPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadShowDbPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateViewPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateRoutinePriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateUserPriv:=1
- 1
- 1
- 1
- 1
- 1
Force should run it regardless of wheter it's been run before
- mysql.columns_priv OK
- mysql.db OK
- mysql.func OK
- mysql.help_category OK
- mysql.help_keyword OK
- mysql.help_relation OK
- mysql.help_topic OK
- mysql.host OK
- mysql.proc OK
- mysql.procs_priv OK
- mysql.tables_priv OK
- mysql.time_zone OK
- mysql.time_zone_leap_second OK
- mysql.time_zone_name OK
- mysql.time_zone_transition OK
- mysql.time_zone_transition_type OK
- mysql.user OK
- @hadGrantPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadShowDbPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateViewPriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateRoutinePriv:=1
- 1
- 1
- 1
- 1
- 1
- @hadCreateUserPriv:=1
- 1
- 1
- 1
- 1
- 1
--- 1,3 ----
-------------------------------------------------------
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.
Result from queries before failure can be found in r/mysql_upgrade.log
Aborting: mysql_upgrade failed in default mode. To continue, re-run with '--force'.
Stopping All Servers
Shutting-down Instance Manager
make: *** [test] Error 1
imacat@atlas src/mysql-5.0.33 %
How to repeat:
Always, as the terminal log I attached in the "Description".
Description: Dear all, Hi. This is imacat from Taiwan. I have downloaded and tried the newly-released MySQL 5.0.33, and failed make test on mysql_upgrade. I have searched and the bug database with the keyword "mysql_upgrade" and failed to find a same report. I saw that the make test has been improved to provide more information. I do not know if I shall reporting this issue, or some tests are expected to fail on unresolved bugs. I guess I should still report it. I run this on 3 machines, all with the same result. One is i386, Debian Sarge 3.1r4 i386, kernel 2.6.16.29, gcc 3.4.4, glibc 2.3.2. The second is x86_64, Debian Sarge 3.1r4 AMD64, kernel 2.6.16.29, gcc 3.4.4, glibc 2.3.2. The third is x86_64, Debian Etch d-i 20061126 AMD64, kernel 2.6.16.29, gcc 4.1.2, glibc 2.3.6. The configuration command line I'm using is: ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var/lib/mysql --infodir=/usr/share/info --mandir=/usr/share/man --enable-thread-safe-client --enable-assembler --with-extra-charsets=all --with-unix-socket-path=/var/run/mysql/mysql.sock --with-mysqld-user=mysql --without-bench --without-readline The result terminal log is below. I omit the log on i386 since the result is exactly the same. Hope this helps. Please tell me if you need any information. imacat@atlas src/mysql-5.0.33 % ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var/lib/mysql --infodir=/usr/share/info --mandir=/usr/share/man --enable-thread-safe-client --enable-assembler --with-extra-charsets=all --with-unix-socket-path=/var/run/mysql/mysql.sock --with-mysqld-user=mysql --without-bench --without-readline checking build system type... x86_64-unknown-linux-gnu ... Thank you for choosing MySQL! imacat@atlas src/mysql-5.0.33 % make ++ echo strmov.lo strxmov.lo strxnmov.lo strnmov.lo strmake.lo strend.lo strtod.lo strnlen.lo strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo strcend.lo bcmp.lo ctype-latin1.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo strtoll.lo llstr.lo my_vsnprintf.lo ctype.lo ctype-simple.lo ctype-bin.lo ctype-mb.lo ctype-big5.lo ctype-czech.lo ctype-cp932.lo ctype-eucjpms.lo ctype-euc_kr.lo ctype-win1250ch.lo ctype-utf8.lo ctype-extra.lo ctype-ucs2.lo ctype-gb2312.lo ctype-gbk.lo ctype-sjis.lo ctype-tis620.lo ctype-ujis.lo ctype-uca.lo xml.lo my_strtoll10.lo str_alloc.lo ... g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o mysqlmanager command.o mysqlmanager.o manager.o log.o thread_registry.o listener.o protocol.o mysql_connection.o user_map.o messages.o commands.o instance.o instance_map.o instance_options.o buffer.o parse.o guardian.o parse_output.o ./.libs/liboptions.a -lpthread -lpthread -lpthread -lpthread libnet.a ../../vio/libvio.a ../../mysys/libmysys.a ../../strings/libmystrings.a ../../dbug/libdbug.a -lz -lpthread -lcrypt -lnsl -lm -lpthread imacat@atlas src/mysql-5.0.33 % make test MySQL Version 5.0.33 Skipping ndbcluster, mysqld not compiled with ndbcluster Skipping SSL, mysqld not compiled with SSL Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Using IM_PORT = 9312 Using IM_MYSQLD1_PORT = 9313 Using IM_MYSQLD2_PORT = 9314 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database Installing Master Database Installing Slave1 Database Creating IM password file (/usr/local/src/mysql-5.0.33/mysql-test/var/im.passwd) Installing Im_mysqld_1 Database Installing Im_mysqld_2 Database ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- alias [ pass ] 26 ... mysql_protocols [ pass ] 131 mysql_upgrade [ fail ] Errors are (from /usr/local/src/mysql-5.0.33/mysql-test/var/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/mysql_upgrade.result 2007-01-09 16:09:32.000000000 +0300 --- r/mysql_upgrade.reject 2007-01-15 07:13:20.000000000 +0300 *************** *** 1,127 **** Run mysql_upgrade once - mysql.columns_priv OK - mysql.db OK - mysql.func OK - mysql.help_category OK - mysql.help_keyword OK - mysql.help_relation OK - mysql.help_topic OK - mysql.host OK - mysql.proc OK - mysql.procs_priv OK - mysql.tables_priv OK - mysql.time_zone OK - mysql.time_zone_leap_second OK - mysql.time_zone_name OK - mysql.time_zone_transition OK - mysql.time_zone_transition_type OK - mysql.user OK - @hadGrantPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadShowDbPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateViewPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateRoutinePriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateUserPriv:=1 - 1 - 1 - 1 - 1 - 1 Run it again - should say already completed - @hadGrantPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadShowDbPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateViewPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateRoutinePriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateUserPriv:=1 - 1 - 1 - 1 - 1 - 1 Force should run it regardless of wheter it's been run before - mysql.columns_priv OK - mysql.db OK - mysql.func OK - mysql.help_category OK - mysql.help_keyword OK - mysql.help_relation OK - mysql.help_topic OK - mysql.host OK - mysql.proc OK - mysql.procs_priv OK - mysql.tables_priv OK - mysql.time_zone OK - mysql.time_zone_leap_second OK - mysql.time_zone_name OK - mysql.time_zone_transition OK - mysql.time_zone_transition_type OK - mysql.user OK - @hadGrantPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadShowDbPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateViewPriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateRoutinePriv:=1 - 1 - 1 - 1 - 1 - 1 - @hadCreateUserPriv:=1 - 1 - 1 - 1 - 1 - 1 --- 1,3 ---- ------------------------------------------------------- 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. Result from queries before failure can be found in r/mysql_upgrade.log Aborting: mysql_upgrade failed in default mode. To continue, re-run with '--force'. Stopping All Servers Shutting-down Instance Manager make: *** [test] Error 1 imacat@atlas src/mysql-5.0.33 % How to repeat: Always, as the terminal log I attached in the "Description".