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

[12 Jul 2008 12:59] Andrei Elkin
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...
[12 Jul 2008 13:03] Andrei Elkin
Please disregard 5.1 xref link. 
a 6.0 correct one: https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
[24 Jul 2008 10:03] Sven Sandberg
here's another xref: http://tinyurl.com/6ca8y5
[24 Jul 2008 10:30] Sven Sandberg
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.
[7 Oct 2008 5:33] Sven Sandberg
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.
[12 Mar 2009 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".