diff options
| -rw-r--r-- | mysql-test/r/query_cache_debug.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/query_cache_debug.test | 10 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache_debug.result b/mysql-test/r/query_cache_debug.result index 50a3a02fe4d..ec78fe65802 100644 --- a/mysql-test/r/query_cache_debug.result +++ b/mysql-test/r/query_cache_debug.result @@ -153,7 +153,9 @@ SET DEBUG_SYNC="now WAIT_FOR parked1_2"; ** until a broadcast signal reaches them causing both threads to ** come alive and check the condition. SET DEBUG_SYNC="now SIGNAL go2"; +** Wait for thd2 to receive the signal SET DEBUG_SYNC="now SIGNAL go3"; +** Wait for thd3 to receive the signal ** ** Finally signal the DELETE statement on THD1 one last time. ** The stmt will complete the query cache invalidation and return diff --git a/mysql-test/t/query_cache_debug.test b/mysql-test/t/query_cache_debug.test index 2f85813d1ef..70b3c81168d 100644 --- a/mysql-test/t/query_cache_debug.test +++ b/mysql-test/t/query_cache_debug.test @@ -208,7 +208,17 @@ SET DEBUG_SYNC="now WAIT_FOR parked1_2"; --echo ** until a broadcast signal reaches them causing both threads to --echo ** come alive and check the condition. SET DEBUG_SYNC="now SIGNAL go2"; +--echo ** Wait for thd2 to receive the signal +let $wait_condition= + SELECT COUNT(*) = 1 FROM information_schema.processlist + WHERE state = "Waiting for query cache lock"; +--source include/wait_condition.inc SET DEBUG_SYNC="now SIGNAL go3"; +--echo ** Wait for thd3 to receive the signal +let $wait_condition= + SELECT COUNT(*) = 2 FROM information_schema.processlist + WHERE state = "Waiting for query cache lock"; +--source include/wait_condition.inc --echo ** --echo ** Finally signal the DELETE statement on THD1 one last time. |