Unexpected error no such file executing sql.

[wshwsh12]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. Start a tidb instance.
2. rm temp-storage-path. (Simulate systemd-tempfiles clean.)
3. Execute a SQL that trigger spill action.
4. Get an error open ..... no such file.

2. What did you expect to see? (Required)

Execute successfully if tidb can create the directory again.

3. What did you see instead (Required)

return error.

4. Affected version (Required)

4.0

5. Root Cause Analysis

Os remove the file/directory in /tmp in period.