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 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 (1504, 227, 226, 3118, 6964, 1442, 1584, 1794, 1128, 969, 6472, 741, 123, 84, 60, 9343, 161, 1020, 659, 6084, 6962, 491, 6963, 781, 1405, 7885, 22, 127, 10667, 8024, 3012, 2782, 118, 115, 1709, 1121, 2319, 23, 6471, 1699, 61, 1566, 6965, 1342, 1001, 1672, 927, 2236, 1612, 920, 5541, 7524, 5460, 2715, 3218, 1345, 1698, 5915, 117, 554, 2238, 1343, 2242, 333, 1341, 2239, 4893, 93, 82, 503, 5470, 147, 146, 224, 225, 3415, 174, 223, 160, 6968, 1213, 165, 277, 134, 1, 116, 3099, 3217, 3411, 7159, 532, 2690, 7160, 1043, 5624, 833, 94, 92, 9206, 540, 7884, 1112, 1113, 2436, 1111, 1344, 58, 36, 21, 1493) AND cscart_product_features_values.feature_id IN (1531, 247, 246, 3172, 7075, 1467, 1611, 1826, 1152, 993, 6580, 762, 143, 104, 80, 9477, 181, 1044, 680, 6191, 7073, 512, 7074, 802, 1430, 8004, 39, 147, 10809, 8145, 3066, 2834, 138, 135, 1737, 1145, 2366, 40, 6579, 1727, 81, 1593, 7076, 1367, 1025, 1700, 951, 2280, 1639, 944, 5641, 7637, 5560, 2767, 3273, 1370, 1726, 6019, 137, 575, 2282, 1368, 2286, 354, 1366, 2283, 4987, 113, 102, 524, 5570, 167, 166, 244, 245, 3475, 194, 243, 180, 7079, 1238, 185, 298, 154, 136, 3153, 3272, 3471, 7271, 553, 2742, 7272, 1067, 5724, 854, 114, 112, 9339, 561, 8003, 1136, 1137, 2486, 1135, 1369, 78, 55, 38, 1519) AND cscart_product_features_values.value = 'Y' AND cscart_product_features_values.lang_code = 'en' AND cscart_categories.category_id IN (408) 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 = 'C' GROUP BY cscart_product_features_values.feature_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:315
Function:query
File:app/functions/fn.database.php
Line:81
Function:getColumn
File:app/functions/fn.catalog.php
Line:11462
Function:db_get_fields
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