On Tue, 2004-08-10 at 16:59, sean c peters wrote:
> Hi all,
> still building 4.1.3
> I am now getting an error in make test like this:
>
> ERROR: ... 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 10 23:44:49 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 [EMAIL PROTECTED]
> ! 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'.
>
> Ending Tests
> Shutting-down MySQL daemon
>
> Master shutdown finished
> Slave shutdown finished
> make: *** [test] Error 1
>
> When i run:
> > diff grant_cache.result grant_cache.reject
>
> here is the output:
> 115,116c115,116
> < Grants for @localhost
> < GRANT USAGE ON *.* TO ''@'localhost'
> ---
> > Grants for [EMAIL PROTECTED]
> > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
>
> This looks somewhat trivial, but i cant get beyond it to finish the test.
> make does not understand the --force directive, so the advice in the error
> wont work.
>
> thanks much,
> sean peters
[EMAIL PROTECTED]
I have run into this before. Are you running your tests as system user
'root' by any chance? MySQL recognizes your system user when there is a
mysql user of the same name and, since by default MySQL user 'root'
needs no password, there is nothing to prevent it. Try running your
test as a regular user and this should fix itself.
--
- michael dykman
- [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
