percona_status_wait_query_cache_mutex test is unstable (wrong sync?)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Undecided
|
Oleg Tsarev | ||
5.1 |
Fix Released
|
Undecided
|
Oleg Tsarev | ||
5.5 |
Fix Released
|
Undecided
|
Oleg Tsarev |
Bug Description
Here are two example failures from Jenkins builds. The failures show that some threads are observed in different states than was intented by the test, so probably the sync is wrong.
_StringException: Text attachment: traceback
------------
Comment:
Logfile:
CURRENT_TEST: main.percona_
--- /home/jenkins/
+++ /home/jenkins/
@@ -14,10 +14,10 @@
SHOW PROCESSLIST;
Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read
### root ### test Query ### NULL SHOW PROCESSLIST ### ### ###
-### root ### test Query ### Waiting on query cache mutex SELECT number from t where id > 0 ### ### ###
+### root ### test Query ### Writing to net SET DEBUG_SYNC=
SELECT id, info, state FROM INFORMATION_
id info state
### SELECT id, info, state FROM INFORMATION_
-### SELECT number from t where id > 0 Waiting on query cache mutex
+### SET DEBUG_SYNC=
DROP TABLE t;
SET GLOBAL query_cache_size=0;
mysqltest: Result length mismatch
------------
_StringException: Text attachment: traceback
------------
Comment:
Logfile:
CURRENT_TEST: main.percona_
--- /home/jenkins/
+++ /home/jenkins/
@@ -18,6 +18,6 @@
SELECT id, info, state FROM INFORMATION_
id info state
### SELECT id, info, state FROM INFORMATION_
-### SELECT number from t where id > 0 Waiting on query cache mutex
+### NULL
DROP TABLE t;
SET GLOBAL query_cache_size=0;
mysqltest: Result length mismatch
------------
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 194 lines (+61/-62)1 file modifiedpatches/query_cache_enhance.patch (+61/-62)
- Laurynas Biveinis (community): Approve
-
Diff: 155 lines (+52/-61)3 files modifiedPercona-Server/mysql-test/r/percona_status_wait_query_cache_mutex.result (+16/-23)
Percona-Server/mysql-test/t/percona_status_wait_query_cache_mutex.test (+32/-34)
Percona-Server/sql/sql_cache.cc (+4/-4)
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-2701