Hi @spanda
There should not be any left-overs after it has generated the XLSX export, so something else must be going wrong, which causes it to fail cleanup.
For huge number of records Exports to XLSX takes time.
If in between you click let's say twice because there is no way to know in UI that your download is in progress, in the temp folder it will create 3 XML file for 3 Clicks.
And once data accumulated XLSX template file comes and it starts downloading which shows in the browser.
Now the problem is all 3 files are not able to convert to XLSX. Only one file converted.
After that 2 XML stays, which is the problem.
@spanda This one is tricky to reproduce. I can reproduce the temporary file, when I download multiple times at the same time, but after a few minutes those files are all removed.
The files are also removed if I shutdown Metabase.
And all the temporary files are just 0 bytes.
When I look at your file sizes, then several of these are 1GB and one is 2GB. That is insanely large.
Please post "Diagnostic Info" from Admin > Troubleshooting.
How much RAM can Metabase consume (this is stated right when you start Metabase)?