Options

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

Rajashekar_DasaRajashekar_Dasa
in General Discussion
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

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