Bug #5325 mysql-test-run fails 'grant_cache' test on Solaris sparc with Forte compiler
Submitted: 31 Aug 2004 21:03 Modified: 31 Aug 2004 21:29
Reporter: luojia chen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:4.1.3-beta-debug OS:Solaris (Solaris 9)
Assigned to: CPU Architecture:Any

[31 Aug 2004 21:03] luojia chen
Description:
OS: Solaris 9, sparc
Compiler: Sun C 5.5 2003/03/12

The 'grant_cache' test fails with the following errors:
----------- 

grant_cache                    [ fail ]

Errors are (from /MySQL_DB/4.1.3/mysql-4.1.3-beta/mysql-test/var/log/mysqltest-time) :
/MySQL_DB/4.1.3/mysql-4.1.3-beta/client/mysqltest: At line 136: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/grant_cache.result        Mon Jun 28 01:26:46 2004
--- r/grant_cache.reject        Tue Aug 31 02:17:36 2004
***************
*** 112,119 ****
  Variable_name Value
  Qcache_not_cached     1
  show grants for current_user();
! Grants for @localhost
! GRANT USAGE ON *.* TO ''@'localhost'
  select "user2";
  user2
  user2
--- 112,119 ----
  Variable_name Value
  Qcache_not_cached     1
  show grants for current_user();
! Grants for root@localhost
! GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
  select "user2";
  user2
  user2
-------------------------------------------------------
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: grant_cache failed. To continue, re-run with '--force'.
----------------------------------

If run with mysql-test-run --debug options, get the error messages as bellow:
----------------------------------
TEST                           RESULT
------------------------------------------
grant_cache                    [ fail ]

Errors are (from /MySQL_DB/4.1.3/mysql-4.1.3-beta/mysql-test/var/log/mysqltest-time) :
/MySQL_DB/4.1.3/mysql-4.1.3-beta/client/mysqltest: Could not open connection 'root2': Can't connect to local MySQL server through socket '/MySQL_DB/4.1.3/mysql-4.1.3-beta/mysql-test/var/tmp/master.sock' (146)
(the last lines may be the most important ones)

Aborting: grant_cache failed. To continue, re-run with '--force'.
--------------------------------------------

How to repeat:
Compile with the following flags and configuration options:

CC=cc CFLAGS="-mt -fast -xstrconst -xarch=v9" CXX=CC CXXFLAGS="-noex -mt -fast -xarch=v9" ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --with-named-curses-libs=-lcurses --with-named-z-libs=bundled --disable-shared --with-debug --with-readline --with-server-suffix="-debug" --with-embedded-server --with-innodb

Run "make", then make install
Then run "make test"
[31 Aug 2004 21:29] Guilhem Bichot
Duplicate of http://bugs.mysql.com/?id=4678
fixed in 4.1.4 (just released).
Thank you for your bug report.