Description:
main.user_limits fails if MTR run with --mysqld=--query-cache-size=1000000
How to repeat:
$./mtr --mysqld=--query-cache-size=1000000 user_limits
Logging: ./mtr --mysqld=--query-cache-size=1000000 user_limits
100901 18:58:38 [Note] Plugin 'FEDERATED' is disabled.
100901 18:58:38 [Note] Plugin 'ndbcluster' is disabled.
MySQL Version 5.1.51
Checking supported features...
- using ndbcluster when necessary, mysqld supports it
- SSL connections supported
- binaries are debug compiled
Collecting tests...
vardir: /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var
Checking leftover processes...
Removing old var directory...
- WARNING: Using the 'mysql-test/var' symlink
Creating var directory '/users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var'...
Installing system database...
Using server port 42457
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
==============================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
main.user_limits [ fail ]
Test ended at 2010-09-01 18:58:38
CURRENT_TEST: main.user_limits
mysqltest: At line 35: query 'select * from t1' succeeded - should have failed with errno 1226...
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
select * from t1;
i
© 2025, Oracle Corporation and/or its affiliates
Description: main.user_limits fails if MTR run with --mysqld=--query-cache-size=1000000 How to repeat: $./mtr --mysqld=--query-cache-size=1000000 user_limits Logging: ./mtr --mysqld=--query-cache-size=1000000 user_limits 100901 18:58:38 [Note] Plugin 'FEDERATED' is disabled. 100901 18:58:38 [Note] Plugin 'ndbcluster' is disabled. MySQL Version 5.1.51 Checking supported features... - using ndbcluster when necessary, mysqld supports it - SSL connections supported - binaries are debug compiled Collecting tests... vardir: /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var Checking leftover processes... Removing old var directory... - WARNING: Using the 'mysql-test/var' symlink Creating var directory '/users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var'... Installing system database... Using server port 42457 worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ main.user_limits [ fail ] Test ended at 2010-09-01 18:58:38 CURRENT_TEST: main.user_limits mysqltest: At line 35: query 'select * from t1' succeeded - should have failed with errno 1226... 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 select * from t1; i