5.5.13 main.user_limits fails with T_P_S=4

Bug #780480 reported by Valentine Gostev on 2011-05-10
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
percona-projects-qa
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  Edit
Everyone can see this information.

Other bug subscribers