5.5.13 main.user_limits fails with T_P_S=4

Bug #780480 reported by Valentine Gostev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
percona-projects-qa
Fix Released
High
Laurynas Biveinis

Bug Description

main.user_limits [ fail ]
        Test ended at 2011-05-10 16:43:39

CURRENT_TEST: main.user_limits
mysqltest: At line 33: query 'select * from t1' failed: 1226: User 'mysqltest_1' has exceeded the 'max_questions' resource (current value: 2)

The result from queries just before the failure was:
drop table if exists t1;
create table t1 (i int);
delete from mysql.user where user like 'mysqltest\_%';
delete from mysql.db where user like 'mysqltest\_%';
delete from mysql.tables_priv where user like 'mysqltest\_%';
delete from mysql.columns_priv where user like 'mysqltest\_%';
flush privileges;
grant usage on *.* to mysqltest_1@localhost with max_queries_per_hour 2;
flush user_resources;
select * from t1;
i

Changed in percona-projects-qa:
milestone: none → 5.5.13
Changed in percona-projects-qa:
assignee: nobody → Laurynas Biveinis (laurynas-biveinis)
Changed in percona-projects-qa:
status: New → Fix Committed
importance: Undecided → High
Changed in percona-projects-qa:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.