Insufficient space issue

Aadu · June 2016

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 · June 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

Insufficient space issue

Comments

Leave a Comment