| Bug #32651 | grant_cache.test fails | ||
|---|---|---|---|
| Submitted: | 23 Nov 2007 12:04 | Modified: | 18 Jun 17:04 |
| Reporter: | Ingo Strüwing | ||
| Status: | Closed | ||
| Category: | Tests | Severity: | S3 (Non-critical) |
| Version: | 5.0.54 | OS: | Sun Solaris (amd64) |
| Assigned to: | Target Version: | 5.0+ | |
| Tags: | pbfail | ||
| Triage: | D3 (Medium) | ||
[23 Nov 2007 12:07]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/38342 ChangeSet@1.2588, 2007-11-23 12:06:55+01:00, istruewing@stella.local +1 -0 Bug#32651 - grant_cache.test fails Disabled test case
[23 Nov 2007 12:31]
Ingo Strüwing
The patch was not meant to fix the bug.
[28 Nov 2007 11:24]
Bugs System
Pushed into 6.0.4-alpha
[28 Nov 2007 11:26]
Bugs System
Pushed into 5.1.23-rc
[28 Nov 2007 11:27]
Bugs System
Pushed into 5.0.54
[13 May 16:39]
Philip Stoev
------------------------------------------------------------ revno: 2740 committer: Philip Stoev <pstoev@mysql.com> branch nick: 5.0-bugteam timestamp: Wed 2009-05-13 17:37:20 +0300 message: Bug #32651 grant_cache.test fails It turns out that this test case no longer fails with the discrepancy in numbers that was the original cause for disabling this test (and showed potential genuine issues with the query cache). Therefore this test is being enabled after some minor adjustment of error codes and messages. === modified file 'mysql-test/r/grant_cache.result' --- mysql-test/r/grant_cache.result 2005-05-18 20:54:36 +0000 +++ mysql-test/r/grant_cache.result 2009-05-13 14:22:05 +0000 @@ -149,7 +149,7 @@ user3 user3 select * from t1; -ERROR 42000: SELECT command denied to user 'mysqltest_3'@'localhost' for column 'b' in table 't1' +ERROR 42000: SELECT command denied to user 'mysqltest_3'@'localhost' for table 't1' select a from t1; a 1 === modified file 'mysql-test/t/disabled.def' --- mysql-test/t/disabled.def 2008-04-07 11:59:51 +0000 +++ mysql-test/t/disabled.def 2009-05-13 14:22:19 +0000 @@ -16,7 +16,6 @@ im_options_set : Bug#20294: Instance manager tests fail randomly im_options_unset : Bug#20294: Instance manager tests fail randomly im_utils : Bug#20294: Instance manager tests fail randomly -grant_cache : Bug#32651: grant_cache.test fails ndb_backup_print : Bug#32357: ndb_backup_print test fails sometimes in pushbuild rpl_log_pos : Bug#8693 Test 'rpl_log_pos' fails sometimes kill : Bug#29149 Test "kill" fails on Windows === modified file 'mysql-test/t/grant_cache.test' --- mysql-test/t/grant_cache.test 2007-02-26 10:49:24 +0000 +++ mysql-test/t/grant_cache.test 2009-05-13 14:31:50 +0000 @@ -99,7 +99,7 @@ connection user3; select "user3"; --replace_result 127.0.0.1 localhost ---error 1143 +--error 1142 select * from t1; select a from t1; --replace_result 127.0.0.1 localhost
[14 May 10:07]
Bernt Johnsen
Ok to push, but --error 1142 should be changed to --error ER_TABLEACCESS_DENIED_ERROR (and similarly for the rest of the --error directives)
[28 May 9:41]
Bugs System
Pushed into 5.0.83 (revid:joro@sun.com-20090528073529-q9b8s60vlpu28fny) (version source revid:joro@sun.com-20090515131231-1r01ef8cbv6s4gk1) (merge vers: 5.0.83) (pib:6)
[28 May 10:20]
Bugs System
Pushed into 5.1.36 (revid:joro@sun.com-20090528073639-yohsb4q1jzg7ycws) (version source revid:jimw@mysql.com-20090515174051-ndjvfd1e9hc9k9c3) (merge vers: 5.1.36) (pib:6)
[2 Jun 14:41]
Philip Stoev
manually advancing the status
[2 Jun 18:16]
Paul DuBois
Test case changes. No changelog entry needed. Setting report to NDI pending push into 6.0.x.
[17 Jun 21:22]
Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090616183122-chjzbaa30qopdra9) (version source revid:joro@sun.com-20090515134506-5mq3a8fafgbkx6u1) (merge vers: 6.0.12-alpha) (pib:11)
[18 Jun 17:04]
Paul DuBois
Test case changes. No changelog entry needed.
[26 Aug 15:45]
Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 15:46]
Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 15:48]
Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 18:32]
Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
Description: grant_cache [ fail ] --- /export/home/pushbuild/pb/mysql-5.0-engines/181/mysql-5.0.54-pb181/mysql-test/r/grant_cache.result Wed Nov 21 23:30:54 2007 +++ /export/home/pushbuild/pb/mysql-5.0-engines/181/mysql-5.0.54-pb181/mysql-test/r/grant_cache.reject Thu Nov 22 17:00:24 2007 @@ -40,7 +40,7 @@ 2 2 2 test.t1 show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 1 show status like "Qcache_hits%"; Variable_name Value Qcache_hits 0 @@ -54,25 +54,25 @@ GRANT SELECT ON `mysqltest`.* TO 'mysqltest_1'@'localhost' show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 5 +Qcache_not_cached 10 select "user1"; user1 user1 show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 1 show status like "Qcache_hits"; Variable_name Value Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 9 +Qcache_not_cached 14 select * from t1; a b c 1 1 1 @@ -79,13 +79,13 @@ 2 2 2 show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 2 show status like "Qcache_hits"; Variable_name Value -Qcache_hits 1 +Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 12 +Qcache_not_cached 17 select a from t1 ; a 1 @@ -92,13 +92,13 @@ 2 show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 3 show status like "Qcache_hits"; Variable_name Value -Qcache_hits 2 +Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 15 +Qcache_not_cached 20 select c from t1; c 1 @@ -105,13 +105,13 @@ 2 show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 4 show status like "Qcache_hits"; Variable_name Value -Qcache_hits 3 +Qcache_hits 0 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 18 +Qcache_not_cached 23 show grants for current_user(); Grants for @localhost GRANT USAGE ON *.* TO ''@'localhost' @@ -138,13 +138,13 @@ ERROR 42000: SELECT command denied to user 'mysqltest_2'@'localhost' for table 't2' show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 5 show status like "Qcache_hits"; Variable_name Value -Qcache_hits 7 +Qcache_hits 3 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 22 +Qcache_not_cached 27 select "user3"; user3 user3 @@ -162,13 +162,13 @@ ERROR 42000: SELECT command denied to user 'mysqltest_3'@'localhost' for column 'c' in table 't1' show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 6 +Qcache_queries_in_cache 5 show status like "Qcache_hits"; Variable_name Value -Qcache_hits 7 +Qcache_hits 3 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 30 +Qcache_not_cached 35 select "user4"; user4 user4 @@ -192,13 +192,13 @@ 2 show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 8 +Qcache_queries_in_cache 7 show status like "Qcache_hits"; Variable_name Value -Qcache_hits 8 +Qcache_hits 4 show status like "Qcache_not_cached"; Variable_name Value -Qcache_not_cached 34 +Qcache_not_cached 39 set names binary; delete from mysql.user where user in ("mysqltest_1","mysqltest_2","mysqltest_3"); delete from mysql.db where user in ("mysqltest_1","mysqltest_2","mysqltest_3"); mysqltest: Result content mismatch Disabling test case. Please re-enable after fix. How to repeat: See pushbuild https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-5.0-engines log https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.0-engines&entry=istruewi...