Options

Append failed in UDFS File CreateTask: No space left on device

joergschaberjoergschaber Vertica Customer ✭
in General Discussion

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

  • Options
    Bryan_HBryan_H Vertica Employee Administrator

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

  • Options
    joergschaberjoergschaber Vertica Customer ✭

    I am running version 23.4.

  • Options
    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.

  • Options
    joergschaberjoergschaber Vertica Customer ✭

    will do. Thanks.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...