Tygh\Exceptions\AException

Message

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

SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids, product_position_source.position AS position FROM cscart_products_categories INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_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') LEFT JOIN cscart_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 372 WHERE cscart_products_categories.product_id IN (59657, 44724, 8879, 9369, 12180, 8485, 8917, 2928, 70692, 158324, 4208, 102858, 14519, 32512, 32189, 5871, 59095, 50609, 16985, 16980, 4096, 15209, 41328, 9012, 128104, 149850, 4209, 4820, 64641, 185028, 28239, 130897, 12686, 120659, 126008, 120496, 127141, 111024, 104662, 63678, 104656, 104665, 119843, 181645, 128000, 127999, 52443, 113920) GROUP BY cscart_products_categories.product_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:249
Function:query
File:app/functions/fn.database.php
Line:44
Function:getHash
File:app/functions/fn.catalog.php
Line:7895
Function:db_get_hash_array
File:app/functions/fn.catalog.php
Line:7807
Function:fn_load_extra_data_by_entity_ids
File:app/functions/fn.catalog.php
Line:7595
Function:fn_load_products_extra_data
File:app/controllers/frontend/categories.php
Line:105
Function:fn_get_products
File:app/functions/fn.control.php
Line:664
Function:include
File:app/functions/fn.control.php
Line:415
Function:fn_run_controller
File:index.php
Line:25
Function:fn_dispatch