A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior.
When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:
ERROR: cloud not write block 7507718 of temporary file: No space left on device
What is the cause of this error and what should the Database Specialist do to resolve this issue?
- The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to modify the workload to load the data slowly.
- The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.
- The local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.
- The local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.
Answer(s): C
Explanation:

Reference:
https://serverfault.com/questions/109828/how-can-i-tune-postgres-to-avoid-this-error
Reveal Solution Next Question