MySQL Bugs: #38069: Error "Can't find file: 'columns_priv' " (or 'procs

Bug #38069	Error "Can't find file: 'columns_priv' " (or 'procs_priv') in pushbuild
Submitted:	12 Jul 2008 12:59	Modified:	11 Mar 2009 18:18
Reporter:	Andrei Elkin	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	6.0	OS:	Any (vm-win2003-32-a)
Assigned to:		CPU Architecture:	Any
Tags:	pushbuild, sporadic, test failure

Description:
Example of a failure on 6.0:

        tfl_name: rpl.rpl_ignore_grant 'stmt'
    tfl_tst_type: ps_stm
       psh_order: 39
tfl_bld_platform: vm-win2003-32-a
        tfl_text: rpl.rpl_ignore_grant 'stmt'    [ fail ]

mysqltest: At line 11: query 'flush privileges' failed: 1017: Can't find file: 'columns_priv' (errno: 2)

The result from queries just before the failure was:
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
delete from mysql.user where user=_binary'rpl_ignore_grant';
delete from mysql.db where user=_binary'rpl_ignore_grant';
flush privileges;

More results from queries before failure can be found in e:\var-ps_stm-101\log\rpl_ignore_grant.log

Warnings from just before the error:
Error 1017 Can't find file: 'columns_priv' (errno: 2)

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

Please disregard 5.1 xref link. 
a 6.0 correct one: https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

here's another xref: http://tinyurl.com/6ca8y5

In most cases, the error message is:

mysqltest: At line 11: query 'flush privileges' failed: 1017: Can't find file: 'procs_priv' (errno: 2)

In one case, it was:

mysqltest: At line 11: query 'flush privileges' failed: 1017: Can't find file: 'procs_priv' (errno: 2)

All errors happened on vm-win2003-32-a.

Actually, fails on many other tests too. So this is not replication-related.

The failure "Can't find file: 'columns_priv'" happens in at least 13 tests on various windows platforms, in 5.0, 5.1, and 6.0, according to xref: http://tinyurl.com/4synyx

The failure "Can't find file: 'procs_priv'" happens in three tests according to xref ( http://tinyurl.com/4jytoc ):
rpl.rpl_ignore_grant 'row', on vm-win2003-32-a/rpl_binlog_row in 6.0-bugteam
main.connect and main.read_only, on vm-win2003-32-a/ps_stm,n_stm in 5.0-ndbwin32

I think that shows it's unlikely a replication failure. Unassigning from Zhenxing. Lars, please assign/change lead as you think appropriate.

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".