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?

Answers

  • Bryan_HBryan_H Vertica Employee Administrator

    This may be a known issue with older Vertica. What version of Vertica are you running?

  • I am running version 23.4.

  • Bryan_HBryan_H Vertica Employee Administrator

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file