Append failed in UDFS File CreateTask: No space left on device
Hi,
I get a strange error with an Insert query which goes something like:INSERT error: INSERT /*+ DIRECT */ INTO ...
then I get
Append failed in UDFS File CreateTask: /data//../_node0001_data/Sort_Temp_part_0_45035996385888743_2_0_0_-1.dat No space left on device
The Management Console says that disk space usage is low, so I wonder why there is 'No space left on device'.
Any idea?
0
Answers
This may be a known issue with older Vertica. What version of Vertica are you running?
I am running version 23.4.
Can you connect to the node and check disk space with "df -h" to be sure MC has current data? This seems like something where we'll need to see the full query, collect vertica.log from the node that runs out of space, and watch execution to see where the sort_temp files are coming from, so I recommend opening a support case.
will do. Thanks.