You can translate the question and the replies:

No space left on device

Hi all, Could you kindly explain what is this issue? Why is this timeout and what is this "space" issue? "[ERROR] No space left on device " Error executing query. Total time 1378.258 seconds. QUERY [PROJECTION] [TOO_MANY_WORKS_TIMEOUT] Work 'Access(464842)-459-04.00-sccore_kinaxis.ds_sccore_transcodification_oracle' can't be executed: Timeout while waiting for an object (checkout) QUERY [SELECTION] [STOPPED] INVENTORY_REPORT_CEP_ON_HAND_DELTA_EXPORT_CSV [ORDERBY] [STOPPED] INVENTORY_REPORT_CEP_ON_HAND_DELTA_EXPORT_CSV [PROJECTION] [STOPPED] INVENTORY_REPORT_CEP_ON_HAND_DELTA_EXPORT_CSV [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_11_UNION_SELECTION [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_11_UNION_SELECTION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_11_UNION [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_11_UNION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_11_UNION [UNION] [STOPPED] Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results Incomplete results IV_BV_INVENTORY_STATUS_TRANSCODE_SELECTION [VIRTUAL] [PROCESSING] IV_BV_INVENTORY_STATUS_TRANSCODE_SELECTION [JDBC WRAPPER] [PROCESSING] IV_INVENTORY_REPORT_CEP_MAPPING_11_UNION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL_SELECTION [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL_SELECTION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL_SELECTION [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL_UNION [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL_UNION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL_UNION [UNION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [UNION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING1_TRANSCO_SITES [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING1_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING1_TRANSCO_SITES [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING1_TRANSCO_SITES [JOIN] [STOPPED] INVENTORY_REPORT_STOCK_PICTURE_CEP_ROW_DATA2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [UNION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_BRAZIL_UNION2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_BRAZIL_UNION2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [ORDERBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [GROUPBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [SELECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION04 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION03 [ORDERBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION03 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [ORDERBY] [ERROR] No space left on device IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [FLATTEN] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION02 [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_2_REST_ALL_UNION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_1_REST_ALL_UNION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_1_REST_ALL_UNION [UNION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [UNION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING4_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING4_TRANSCO_SITES [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING4_TRANSCO_SITES [JOIN] [STOPPED] INVENTORY_REPORT_STOCK_PICTURE_CEP_ROW_DATA2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [UNION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_BRAZIL_UNION2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_BRAZIL_UNION2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [ORDERBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [GROUPBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [SELECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION04 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION03 [ORDERBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION03 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [ORDERBY] [ERROR] No space left on device IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [FLATTEN] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION02 [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_1_REST_ALL_UNION [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_1_REST_ALL [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_1_REST_ALL [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOINFAIL_1_REST_ALL [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING_10_TRANSCO_INVENTORY_INV_JOIN_REST_ALL [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [ORDERBY] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING7_TRANSCO_BATCH [JOIN] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [UNION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING6_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING4_TRANSCO_SITES [PROJECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING4_TRANSCO_SITES [SELECTION] [STOPPED] IV_INVENTORY_REPORT_CEP_MAPPING4_TRANSCO_SITES [JOIN] [STOPPED] INVENTORY_REPORT_STOCK_PICTURE_CEP_ROW_DATA2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [UNION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_UNION [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_BRAZIL_UNION2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_BRAZIL_UNION2 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [ORDERBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [GROUPBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION05 [SELECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION04 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION03 [ORDERBY] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION03 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [ORDERBY] [ERROR] No space left on device IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [PROJECTION] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_FLATTEN01 [FLATTEN] [STOPPED] IV_INVENTORY_STOCK_PICTURE_DELTA_BRAZIL_SELECTION02 [ORDERBY] [STOPPED] Regards, Pablo
user
29-01-2020 03:07:55 -0500

1 Answer

Hi, The error "No space left on device" usually occurs when the Server does not have enough hard drive space to perform swapping. Swapping is saving intermediate results to the hard drive instead of holding them all in memory. It may be that you have many memory-demanding queries running at the same time which are swapping to disk and filling the machine's hard drive. There are 2 options for resolving this issue: * *Increase the hard drive space on the Denodo Platform installation drive*: requires alteration of the server machine, and would probably require downtime. * *Or, turn off swapping on the server or decrease the maximum amount of data that can be swapped per query*: requires you to change the configuration of the VDP server. It is possible that reducing the max swapping size would decrease performance for certain views. You could refer to the section [Configuring the Memory Usage and Swapping Policy](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy) of Virtual DataPort Administration Guide for more information about swapping and its configuration. Hope this helps!
Denodo Team
29-01-2020 07:40:17 -0500
You must sign in to add an answer. If you do not have an account, you can register here