When changing the variable value, the backend did not trigger a re query

[wypdao]

Describe the bug

I created an SQL query and set a variable, hoping that when the value of the variable changes, the query results will change in a timely manner. The value of the variable comes from a view After completing the settings, when I update the variables, the backend log prints as: 2024-08-12 10:58:31988 DEBUG middleware. log: POST/app/card/36/query 202 [ASYNC: completed] 431.3 ms (19 database calls) Application database connection: 3/15 Jetty thread. 2/50 (4 idle, 0 queued) (85 total active threads) In flight queries: 0. (0 queues); mysql DB 3 connections: 0/1 (0 threads blocked) {:metabase-user-id 1} Is it a bug that the query results displayed on the page have not changed? We are using version 0.50.19

To Reproduce

1. Go to 'My custom question 'Display results for a certain day''
2. Click on 'selected Date'
3. Scroll down to 'The date you want to query'
4. See error The page display result has not changed,the backend log prints as: 2024-08-12 10:58:31988 DEBUG middleware. log: POST/app/card/36/query 202 [ASYNC: completed] 431.3 ms (19 database calls) Application database connection: 3/15 Jetty thread. 2/50 (4 idle, 0 queued) (85 total active threads) In flight queries: 0. (0 queues); mysql DB 3 connections: 0/1 (0 threads blocked) {:metabase-user-id 1} Is it a bug that the query results displayed on the page have not changed?

Expected behavior

After I selected a new date, the results displayed on the page changed

Logs

2024-08-12 10:58:31988 DEBUG middleware. log: POST/app/card/36/query 202 [ASYNC: completed] 431.3 ms (19 database calls) Application database connection: 3/15 Jetty thread. 2/50 (4 idle, 0 queued) (85 total active threads) In flight queries: 0. (0 queues); mysql DB 3 connections: 0/1 (0 threads blocked) {:metabase-user-id 1}

Information about your Metabase installation

my computer:win11-x64
database:mysql5.7.44
metabase:0.50.19
browser:chrome127.0.6533.100-x64

Severity

serious

Additional context

No response

[crisptrutski]

This sounds like it could be a caching issue.

[paoliniluis]

@wypdao please post a video/screenshots, I'm not able to understand the issue

[wypdao]

@paoliniluis I have provided you with the email address paoliniluis@gmail.com, I sent you an email with my metabase address and account