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