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:
None 
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 14:40] Peter O'Gorman
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.
[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