calfieri opened a new issue, #30150: URL: https://github.com/apache/superset/issues/30150
### Bug description first anomaly: Dashboard data don't rely on table chart cache the dashboard showing a data table is not getting its data from the underlying chart, but appears to get data directly on the chart dataset. second anomaly: Dashboard file download don't rely on dashboard cache the file download (both csv and xlsx) from a dashboard relies directly on the underlying dataset, neither on the dashboard cache nor on the chart cache. third anomaly: chart file download (only xlsx) don't rely on chart cache the file download (only xlsx) from a dashboard relies directly on the underlying dataset, not on the chart cache. The csv download instead appears to work correctly. ### How to reproduce the bug 1. precondition: cache enabled based on Redis 2. precondition: dataset chache timeout: default 3. precondition: chart refresh cache timeout: 1 day 4. precondition: dashboard refresh frequency: 1day 5. insert into dataset three lines l1, l2, l3 6. create a chart X with cache timeout 1 day based on dataset 7. create a dashboard D with refresh frequency 1 day based on chart X 8. execute the dashboard D; three lines appear 9. open chart X; three lines appear 10. delete line l3 11. open dashboard D; three lines appear l1, l2, l3 12. dowload, from dashboard, in csv format: two lines appear l1 and l2 (the download doesn't rely on dashboard cache). 13. download from dashboard in xlsx format, two lines appear l1 and l2 (the download doesn't rely on dashboard cache). 14. open chart X; three lines appear l1, l2, l3. 15. download from chart, in xlsx format three lines appear l1, l2, l3 16. download from chart, in csv format, three lines appear l1, l2, l3. 17. Open dashboard D, two lines appear l1, l2 (a dashboard refresh has been triggered simply opening the chart X) 18. After three hours 19. open chart X; three lines appear l1, l2, l3. 20. download from chart, in xlsx format two lines appear l1, l2 (the download doesn't rely on chart cache) 21. download from chart, in csv format, three lines appear l1, l2, l3 ### Screenshots/recordings three lines interted into the dataset    After deleting third row  The dashboard remains stable, relying on the cache  excel download reports 2 rows  csv dowload reports 2 rows the downloaded data don't meet the dashboard data  After entering the chart the dashboard appears to have refreshed with dataset data and not with chart data (cached)  Please pay attention the chart data is still presenting the cached data (aging 14 minutes):  Downloading csv from chart after few minutes:  Downloading xlsx from chart after few minutes:  download data meet the chart data After 3 hours  chart still rely on its data cache Downloading csv from chart:  download data meet the chart data Downloading xlsx from chart:  download data don't meet the chart data ### Superset version 3.1.3 ### Python version 3.9 ### Node version 16 ### Browser Chrome ### Additional context _No response_ ### Checklist - [ ] I have searched Superset docs and Slack and didn't find a solution to my problem. - [ ] I have searched the GitHub issue tracker and didn't find a similar bug report. - [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
