MySQL Query Error: SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews, pictures,favorites,thumb,aid,map_lat,map_lng,c_jigou,c_shangjia FROM [dbpre]subject s LEFT JOIN [dbpre]subject_taoci sf ON (s.sid = sf.sid) WHERE status = '1' AND exists(SELECT 1 FROM [dbpre]subjectatt st FORCE INDEX (sid) WHERE s.sid=st.sid AND attid IN (3015,5294) GROUP BY st.sid HAVING COUNT(st.sid)=2) ORDER BY avgsort DESC LIMIT 0, 10
Error description: Concurrency control waiting count exceed max waiting count
Error number: 7534
Date: 2025-01-23 @ 11:58
Script: http://www.95ye.com/shop/mobile-do-list-catid-63-aid-4234-orderby-avgsort.html
| File | Line | Function |
|---|---|---|
| core/lib/mysql.php | 115 | ms_mysql->_halt() |
| core/lib/activerecord.php | 86 | ms_mysql->query() |
| core/modules/item/model/subject_class.php | 153 | ms_activerecord->get() |
| 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() |