Skip to main content

Insufficient space issue

  • June 13, 2016
  • 1 reply
  • 9 views
Aadu

Hi, 

 

I am facing Insufficient space issue even while running simple select queries .

 

Error:[Vertica][VJDBC](2927) ERROR: Could not write to [/data/ICICI_DATA/ICICIDWHDB/v_icicidwhdb_node005_data]: Volume [/data/ICICI_DATA/ICICIDWHDB/v_icicidwhdb_node005_data] has insufficient space.

 

I have checked the space utilization from disk_storage. It has sufficient space. Still facing the issue.

 

Vertica Database Version – v7.2.1-1

 

Regards

Vinita

    1 reply

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • June 13, 2016

    Hi ,

    Vertica need some extra temporary  disk space for several use cases   like data load , Hash join and group by activity’s

    More details you can find her :

    https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/DiskSpaceRequirementsForHPVertica.htm

     

     

    I hope you will find it helpful

     

    Thanks

     

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement