Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

ERROR: Could not write to: Volume node0001_data] is has insufficient space.. But I have enough Free

Hi,
I Observed strange issue while running query/reports with Vertica DB.

"20150225 10:02:26.672+0000 ERROR JavaException: java.sql.SQLException: [Vertica][VJDBC](2927) ERROR: Could not write to [/home/cbi_dba/cbidb/v_cbidb_node0001_data]: Volume [/home/cbi_dba/cbidb/v_cbidb_node0001_data] is has insufficient space."



Please note, the mount point where DB data directory is mounted has good amount of free space. But it still fails with this error. 


Restart of Vertica DB instance resolved this issue. But, wanted to know. Why and which case we would see this kind of issue 


node_name resource_type rejected_reason rejected_count first_rejected_timestamp last_rejected_timestamp last_rejected_value

SELECT * FROM disk_resource_rejections; output

node_name resource_type rejected_reason rejected_count first_rejected_timestamp last_rejected_timestamp last_rejected_valuev_cbidb_node0001 Temporary Data Insufficient disk space 23 2015-02-25 04:44:38.996978 2015-02-25 14:44:54.357272 1048576

Comments

  • Take a look at table DISK_STORAGE for more info about space.  Recommend at least 40% free disk space on every node.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.