Failed to create directory for spilling in Dremio like AWS Service

1

Problem ‘Failed to create directory for spilling. Please check that the spill location is accessible and confirm read, write & execute permissions.’ occured in Dremio like AWS Service. Why occured this and how I can fixed?

image
image1059×628 38.9 KB

Job Profile Error:
DATA_WRITE ERROR: Failed to create directory for spilling. Please check that the spill location is accessible and confirm read, write & execute permissions.
Spill directory path /mnt/c1/spilling
Spill directory path /mnt/c1/spilling
Caller agg spilling
SqlOperatorImpl HASH_AGGREGATE
Location 13:2:2
SqlOperatorImpl HASH_AGGREGATE
Location 13:2:2
Fragment 13:0

[Error Id: fc79cbca-249f-4cd7-89a4-9374bcbb0d1a on 192.168.5.134:0]

Failure node: 192.168.21.228:31010

Error ID: 2b9b4b8b-5b8b-4bde-bc51-b8e8aebf78ea

Verbose:

DATA_WRITE ERROR: Failed to create directory for spilling. Please check that the spill location is accessible and confirm read, write & execute permissions.

Spill directory path /mnt/c1/spilling
Spill directory path /mnt/c1/spilling
Caller agg spilling
SqlOperatorImpl HASH_AGGREGATE
Location 13:2:2
SqlOperatorImpl HASH_AGGREGATE
Location 13:2:2
Fragment 13:0

[Error Id: fc79cbca-249f-4cd7-89a4-9374bcbb0d1a on 192.168.5.134:0]

Spill directory path /mnt/c1/spilling
Spill directory path /mnt/c1/spilling
Caller agg spilling
SqlOperatorImpl HASH_AGGREGATE
Location 13:2:2
SqlOperatorImpl HASH_AGGREGATE
Location 13:2:2
Fragment 13:0

2

@lucasft Looks like the same issue reported on post IOException: No space left on device in the Dremio like AWS Service - #2 by balaji.ramaswamy

Please check your executor dremio.conf and see if you have configured a spill location?