Insufficient space issue

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

eli_revach

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