On Jan 16, 2011, at 8:17 AM, Hanspeter Niederstrasser wrote: > mysql-unified-5.0.45-2 failed to build with the following errors during > tests (using --build-as-nobody). Note, I'm as connecting to the build > machine via SSH. > > ******* > olap [ pass ] 63 > openssl_1 [ fail ] > > Errors are (from > /sw/buildworld.build/mysql-unified-5.0.45-2/mysql-5.0.45/mysql-test/var/log/mysqltest-time) > > : > mysqltest: At line 19: query 'connect con1,localhost,ssl_user1,,,,,SSL' > failed: 2026: SSL connection error > (the last lines may be the most important ones) > Result from queries before failure can be found in r/openssl_1.log > ... > rpl_openssl [ fail ] timeout > ... > rpl_ssl [ fail ] timeout > ... > ssl [ fail ] > > Errors are (from > /sw/buildworld.build/mysql-unified-5.0.45-2/mysql-5.0.45/mysql-test/var/log/mysqltest-time) > > : > mysqltest: At line 6: query 'connect ssl_con,localhost,root,,,,,SSL' > failed: 2026: SSL connection error > (the last lines may be the most important ones) > ... > ssl_compress [ fail ] > > Errors are (from > /sw/buildworld.build/mysql-unified-5.0.45-2/mysql-5.0.45/mysql-test/var/log/mysqltest-time) > > : > mysqltest: At line 7: query 'connect > ssl_compress_con,localhost,root,,,,,SSL COMPRESS' failed: 2026: SSL > connection error > (the last lines may be the most important ones) > ... > ssl_connect [ fail ] > > Errors are (from > /sw/buildworld.build/mysql-unified-5.0.45-2/mysql-5.0.45/mysql-test/var/log/mysqltest-time) > > : > mysqltest: At line 9: query 'connect test_con1,localhost,root,,,,,SSL' > failed: 2026: SSL connection error > (the last lines may be the most important ones) > ... > view [ fail ] > > Errors are (from > /sw/buildworld.build/mysql-unified-5.0.45-2/mysql-5.0.45/mysql-test/var/log/mysqltest-time) > > : > mysqltest: Result content mismatch > (the last lines may be the most important ones) > Below are the diffs between actual and expected results: > ------------------------------------------------------- > *** r/view.result Wed Jul 4 16:49:09 2007 > --- r/view.reject Sun Jan 16 05:16:43 2011 > *************** > *** 2711,2722 **** > v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY > DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` > from `t1` having (`Age` < 75) > SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75; > Age > 43 > - 39 > SELECT * FROM v1; > Age > 43 > - 39 > DROP VIEW v1; > DROP TABLE t1; > CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx'); > --- 2711,2722 ---- > v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY > DEFINER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` > from `t1` having (`Age` < 75) > SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75; > Age > + 47 > 43 > SELECT * FROM v1; > Age > + 47 > 43 > DROP VIEW v1; > DROP TABLE t1; > CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx'); > ------------------------------------------------------- > 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/view.log > ... > xa [ pass ] 8 > ------------------------------------------------------- > Stopping All Servers > Failed 7/470 tests, 98.51% were successful. > ... > mysql-test-run in default mode: *** Failing the test(s): openssl_1 > rpl_openssl rpl_ssl ssl ssl_compress ssl_connect view > mysql-test-run: *** ERROR: there were failing test cases > make[1]: *** [test-ns] Error 1 > make: *** [test-force] Error 2 > ### execution of [[ failed, exit code 2 > ******* > > The failures occur with either system-openssl-dev or openssl098-dev > installed. > > If I turn off --build-as-nobody (that is, build as root), the build > fails with what seems to be a typo in TestScript: > > ****** > g++ -DDBUG_OFF -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment > -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare > -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder > -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors > -fno-exceptions -fno-rtti -O3 -fno-omit-frame-pointer -g > -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE > -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ > -DIGNORE_SIGHUP_SIGQUIT -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 -Wl,-bind_at_load -L/sw/lib ./.libs/liboptions.a > libnet.a ../../vio/libvio.a ../../mysys/libmysys.a > ../../strings/libmystrings.a ../../dbug/libdbug.a > ../../extra/yassl/src/.libs/libyassl.a > ../../extra/yassl/taocrypt/src/.libs/libtaocrypt.a -lz -lm > make[3]: Nothing to be done for `all-am'. > [[ "$UID" -eq 0 ]] && { chown -R nobody. ./mysql-test && /usr/bin/sudo > -u nobody make test-force || exit 2; } || { make test-force || exit 2; } > chown: nobody.: Invalid argument > ### execution of [[ failed, exit code 2 > ****** > > Full logs for both runs available upon request. > > Package manager version: 0.29.17 > Distribution version: selfupdate-cvs Thu Jan 13 11:46:21 2011, 10.5, i386 > > Hanspeter
On 10.6/x86_64, I get the same failures, but also several more where the test expects the value -9223372036854775808 but instead gets -'..--).0-*(+,))+(0( ! That looks to me like the result of code that isn't 64 bit clean. That isn't too surprising since mysql 5.0.x is very old now, originally released in 2005. The current stable version is 5.5.8. Daniel ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Fink-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fink-users
