| Bug #25096 | test failures on solaris10/x86 with sun studio 11 compiler at -xO2 | ||
|---|---|---|---|
| Submitted: | 15 Dec 2006 14:40 | Modified: | 10 Apr 2007 21:30 |
| Reporter: | Peter O'Gorman | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.0.33, 5.0.27 | OS: | Solaris (solaris10/x86) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | ps_2myisam, solaris, test, VIEW, view_grant | ||
[15 Dec 2006 18:27]
Valeriy Kravchuk
Thank you for a problem report. Please, send the exact ./configure command line and CCFLAGS value used.
[15 Dec 2006 22:50]
Peter O'Gorman
./configure CC=cc CFLAGS="-mr -Qn -xstrconst -xO2 -xtarget=pentium4" \ CXX=CC CXXFLAGS="-xO2 -xtarget=pentium4" \ CPPFLAGS="-I/opt/TWWfsw/readline/include -I/opt/TWWfsw/zlib\include \ -I/opt/TWWfsw/ncurses/include -I/opt/TWWfsw/ncurses/include/ncurses \ LDFLAGS="-L /opt/TWWfsw/readline/lib -L/opt/TWWfsw/zlib/lib \ -L/opt/TWWfsw/ncurses/lib" \ --enable-shared --enable-static --without-debug \ --with-innodb --with-berkeley-db --without-readline \ --without-bench --with-mysqlfs=no --with-openssl=no \ --enable-local-infile --with-extra-charsets=all \ --enable-thread-safe-client --disable-dependency-tracking \ --prefix=/opt/TWWfsw/mysql5027 Passes all tests with same configure options and -xO1 though...
[20 Feb 2007 14:47]
Valeriy Kravchuk
Verified with latest 5.0.33. Test view still fails after the following commands executed: ./configure CC=cc CFLAGS="-mr -Qn -xstrconst -xO2 -xtarget=pentium4" \ CXX=CC CXXFLAGS="-xO2 -xtarget=pentium4" \ --enable-shared --enable-static --without-debug --with-innodb \ --with-berkeley-db --with-readline --without-bench --with-mysqlfs=no \ --with-openssl=no --enable-local-infile --with-extra-charsets=all \ --enable-thread-safe-client --disable-dependency-tracking \ --prefix=/export/users/mysqldev/valeriy/dbs/5.0 make Then: mysqldev@sol10-x86:~/valeriy/mysql-5.0.33> cd mysql-test/ < ./mysql-test-run.pl --force ps_2myisam view view_grant Logging: ./mysql-test-run.pl --force ps_2myisam view view_grant 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 Saving snapshot of installed databases ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- ps_2myisam [ pass ] 620 view [ fail ] Errors are (from /export/home/mysqldev/valeriy/mysql-5.0.33/mysql-test/var/log/m ysqltest-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 Tue Jan 9 16:09:33 2007 --- r/view.reject Tue Feb 20 17:35:35 2007 *************** *** 2686,2697 **** v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFIN ER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` havin g (`Age` < 75) SELECT (year(now())-year(DOB)) AS Age FROM t1 HAVING Age < 75; Age ! 42 ! 38 SELECT * FROM v1; Age ! 42 ! 38 DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx'); --- 2686,2697 ---- v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFIN ER VIEW `v1` AS select (year(now()) - year(`t1`.`DOB`)) AS `Age` from `t1` havin g (`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'); ------------------------------------------------------- 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 Stopping All Servers Restoring snapshot of databases Resuming Tests view_grant [ pass ] 509 ------------------------------------------------------- Stopping All Servers Failed 1/3 tests, 66.67% were successful. The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://www.mysql.com/doc/en/MySQL_test_suite.html The servers were restarted 2 times Spent 1.129 seconds actually executing testcases mysql-test-run in default mode: *** Failing the test(s): view mysql-test-run: *** ERROR: there where failing test cases So, errors are different, but we still see a test failure. mysqldev@sol10-x86:~/valeriy/mysql-5.0.33/mysql-test> uname -a SunOS sol10-x86 5.10 Generic i86pc i386 i86pc mysqldev@sol10-x86:~/valeriy/mysql-5.0.33/mysql-test> cc -V cc: Sun C 5.7 2005/01/07 usage: cc [ options] files. Use 'cc -flags' for details
[20 Feb 2007 16:00]
Valeriy Kravchuk
As my colleague pointed out, test failure I've got (for view test) is a duplicate of http://bugs.mysql.com/bug.php?id=25359 (and is different from failure in your case). So, please, check 5.0.33, and, if you will have the same failures as you had initially, I think, we may have a bug in your (newer) C compiler version.
[21 Mar 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[10 Apr 2007 21:30]
Peter O'Gorman
Can not repeat with mysql-5.0.38
Description: Thress tests fail when mysql-5.0.27 is built on solaris10/x86 with -xO2 or greater with sun studio 11 compiler. The tests pass at -xO1. ps_2myisam [ fail ] Errors are (from /opt/build/mysql-5.0.27/mysql-test/var/log/mysqltest-time) : mysqltest: At line 35: query 'execute stmt1 using @arg00 ' failed: 126: Incorrect key file for table './test/t2.MYI'; try to repair it (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished view [ fail ] Errors are (from /opt/build/mysql-5.0.27/mysql-test/var/log/mysqltest-time) : mysqltest: At line 651: query 'insert into t1 (c2) VALUES ('real Beer'),('Water'),('Kossu'),('Coca-Cola'),('Vodka'),('Wine'),('almost real Beer')' failed: 126: Incorrect key file for table './test/t1.MYI'; try to repair it (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished view_grant [ fail ] Errors are (from /opt/build/mysql-5.0.27/mysql-test/var/log/mysqltest-time) : mysqltest: At line 634: query 'create table t1 as select * from mysql.user where user=''' failed: 1050: Table 't1' already exists (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished How to repeat: run tests on solaris10/x86. Suggested fix: Default to -xO1 on solaris2.10/x86.