MySQL Query Error: SELECT COUNT(*) FROM [dbpre]subject s WHERE status = '1' AND exists(SELECT 1 FROM [dbpre]subjectatt st FORCE INDEX (sid) WHERE s.sid=st.sid AND attid IN (3002,9999) GROUP BY st.sid HAVING COUNT(st.sid)=2)
Error description: Concurrency control waiting count exceed max waiting count
Error number: 7534
Date: 2025-01-23 @ 11:59
Script: http://www.95ye.com/shop/mobile-do-list-catid-59-aid-8930-orderby-pageviews.html
| File | Line | Function |
|---|---|---|
| core/lib/mysql.php | 115 | ms_mysql->_halt() |
| core/lib/activerecord.php | 191 | ms_mysql->query() |
| core/modules/item/model/subject_class.php | 116 | ms_activerecord->count() |
| core/modules/item/model/subject_class.php | 123 | msm_item_subject->getcount() |
| core/modules/item/mobile/list.php | 181 | msm_item_subject->getlist() |
| core/modules/item/mobile.php | 28 | include() |
| core/modules/item/common.php | 40 | include() |
| index.php | 56 | include() |