Tygh\Exceptions\AException

Message

Out of resources when opening file './highload_demo_mv/cscart_categories.MYD' (Errcode: 24 - Too many open files) (23)

SELECT cscart_product_filters.filter_id, cscart_product_features_values.variant_id FROM cscart_product_features_values LEFT JOIN cscart_products as products ON products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') WHERE cscart_product_filters.filter_id IN (230, 34, 3296, 4453, 3861, 3869, 3295, 4507, 1, 58) AND cscart_product_features_values.feature_id IN (251, 53, 3355, 4537, 3937, 3945, 3354, 4597, 78) AND cscart_product_features_values.lang_code = 'fr' AND cscart_categories.category_id IN (1193) AND companies.status = 'A' AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND products.product_type != 'D' AND cscart_product_features.feature_type IN ('S', 'M', 'E') GROUP BY cscart_product_features_values.variant_id

Error at

app/Tygh/Database/Connection.php, line: 1127

Backtrace

File:app/Tygh/Database/Connection.php
Line:491
Function:throwError
File:app/Tygh/Database/Connection.php
Line:372
Function:query
File:app/functions/fn.database.php
Line:107
Function:getSingleHash
File:app/functions/fn.catalog.php
Line:11413
Function:db_get_hash_single_array
File:app/functions/fn.catalog.php
Line:10947
Function:fn_get_current_filters
File:app/Tygh/BlockManager/Block.php
Line:925
Function:fn_get_filters_products_count
File:app/Tygh/BlockManager/RenderManager.php
Line:791
Function:getItems
File:app/Tygh/BlockManager/RenderManager.php
Line:653
Function:getValue
File:app/Tygh/BlockManager/RenderManager.php
Line:484
Function:renderBlockContent
File:app/Tygh/BlockManager/RenderManager.php
Line:406
Function:renderBlock
File:app/Tygh/BlockManager/RenderManager.php
Line:364
Function:renderBlocks
File:app/Tygh/BlockManager/RenderManager.php
Line:229
Function:renderGrid
File:app/Tygh/BlockManager/RenderManager.php
Line:199
Function:renderGrids
File:app/Tygh/BlockManager/RenderManager.php
Line:163
Function:_renderContainer
File:app/functions/smarty_plugins/function.render_location.php
Line:52
Function:render
File:var/cache/templates/bright_theme/776a5a06ad55e65c3aa4d5908bf5894a1dd80385.tygh.index.tpl.php
Line:183
Function:smarty_function_render_location
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_5de796b0a42064_40951597
File:app/Tygh/SmartyEngine/Core.php
Line:76
Function:fetch
File:app/functions/fn.control.php
Line:595
Function:fetch
File:index.php
Line:25
Function:fn_dispatch