Error
- mwversion: 1.45.0-wmf.8
- timestamp: 2025-07-08T22:14:00.733Z
- phpversion: 8.1.32
- reqId: e60317e2-d5d3-40b0-a760-57c3a8dbd5a3
- Find reqId in Logstash
normalized_message
Expectation (readQueryTime <= 5) by MediaWiki\Api\ApiMain::setRequestExpectations not met (actual: {actualSeconds}) in trx #{trxId}:
{query}Impact
Notes
wikiadmin2023@10.64.0.43(itwiki)> explain SELECT page_namespace,page_title,page_id,page_content_model,page_is_redirect,page_is_new,page_latest,page_touched,page_len,cl_from,cl_sortkey,cl_type,cl_timestamp FROM `page`,`categorylinks` FORCE INDEX (cl_timestamp) JOIN `linktarget` ON ((cl_target_id = lt_id )) WHERE lt_namespace = 14 AND lt_title = 'Cancellazioni_consensuali_prorogate_del_2_luglio_2025' AND (cl_from=page_id) ORDER BY cl_timestamp,cl_from LIMIT 101 ; +------+-------------+---------------+--------+----------------------------+--------------------+---------+------------------------------+----------+-----------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+---------------+--------+----------------------------+--------------------+---------+------------------------------+----------+-----------------------------+ | 1 | SIMPLE | linktarget | const | PRIMARY,lt_namespace_title | lt_namespace_title | 261 | const,const | 1 | Using index | | 1 | SIMPLE | categorylinks | ALL | NULL | NULL | NULL | NULL | 23119354 | Using where; Using filesort | | 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | itwiki.categorylinks.cl_from | 1 | | +------+-------------+---------------+--------+----------------------------+--------------------+---------+------------------------------+----------+-----------------------------+ 3 rows in set (0.001 sec) wikiadmin2023@10.64.0.43(itwiki)>