Tygh\Exceptions\AException

Message

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

SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (102897, 102898, 102899, 103478, 103614, 103615, 103617, 103618, 103647, 103712, 103713, 103765) AND cscart_discussion.object_type = "P" GROUP BY cscart_discussion.object_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