Searched For: specialrecentchanges::doMainQuery
-+------+----------------------------------------------------+
11 rows in set (0.01 sec)
```
PHP Deprecated: Caller from TranslatablePage::getTag ignored an error originally raised from SpecialRecentChanges::doMainQuery: [1969] Query execution was interrupted (max_ … 26
* Happening at a rate of about once an hour
from LinkBatch::doQuery (for Skin::preloadExistence) ignored an error originally raised from SpecialRecentChanges::doMainQuery: [1054] Unknown column 'actor_user' in 'on cl … ppening on group 0 right now; `1.37.0-wmf.4`
The following query takes more than 2 minutes to run
```
SELECT /* SpecialRecentChanges::doMainQuery */ /*! STRAIGHT_JOIN */ rc_id,rc_timestamp, … -+---------+-----------------------------+
```
wing query is much slower on MariaDB enwiki with the FORCE INDEX than without it:
SELECT /* SpecialRecentChanges::doMainQuery */ rc_id,rc_timestamp,rc_cur_time,rc_user,rc … ------
**Version**: 1.21.x
**Severity**: major
ewrite should be considered (SELECT UNION?), or if it is not possible, disabling it entirely.
extension?
Error 1055: 'recentchanges.rc_namespace' isn't in GROUP BY (localhost)
Function: SpecialRecentChanges::doMainQuery
Query: SELECT DISTINCT rc_id,rc_timestamp,rc_ … n, screenshots, other information, etc**: 1.38
1969: Query execution was interrupted (max_statement_time exceeded) (db1099:3311)
Function: SpecialRecentChanges::doMainQuery
Query: SET STATEMENT max_statement_time=30 FO … tement_time exceeded) (db1099:3311)
Function: SpecialRecentChanges::doMainQuery
Query: SET STATEMENT max_statement_time=30 FO … index.php(3): require(string)
#18 {main}
```
se/Database.php(1227): Wikimedia\Rdbms\Database->executeQuery(string, string, integer)
```
roupProcessing\RevTagStore::getLatestRevisionWithTag ignored an error originally raised from SpecialRecentChanges::doMainQuery: [1969] Query execution was interr
```
```na … r picking the wrong table for order of join ]]
ing)
#20 {main}
```
##### Impact
Unable to see the recent changes with the filters applied
s2
[x] s3
[x] s4
[x] s5
[x] s6
[x] s7
[x] s8
labswiki: not present
labtestwiki: not present
g = 'visualeditor' AND rc_new IN ('0','1') ORDER BY rc_timestamp DESC LIMIT 50
Function: SpecialRecentChanges::doMainQuery
Error: 2062 Read timeout is reached (10.64.32 … DER BY rc_timestamp DESC LIMIT 50
Function: SpecialRecentChanges::doMainQuery
Error: 2062 Read timeout is reached (10.64.32 … index.php(3): include(string)
#13 {main}
```
BQueryError: Error 1054: Unknown column 'actor_user' in 'on clause' (10.64.16.208)
Function: SpecialRecentChanges::doMainQuery
Query: SELECT rc_id,rc_timestamp,rc_namespac … ) ORDER BY rc_timestamp DESC LIMIT 500
```
s://grafana.wikimedia.org/d/000000156/wikidata-dispatch?orgId=1&from=now-2d&to=now&refresh=1m
e now. I just wanted to raise the issue with some lead time before the schema change request.
pired (unless they have been cleaned up from the database)
**Visual Example: **
{F31806683}
_lang = 'en' AND lc_key = 'namespaceGenderAliases' LIMIT 1
[DBQuery] wikipagedb SELECT /* SpecialRecentChanges::doMainQuery */ rc_id,rc_timestamp,rc_namespace,rc_title … MIT 1
```
Expected Results:
like normal...
https://gerrit.wikimedia.org/r/#/c/295528/ makes it much better.
See related task {T146111}
edia.org/w/index.php?namespace=5&tagfilter=&title=Special%3ARecentChanges
->
Function: SpecialRecentChanges::doMainQuery
Error: 2013 Lost connection to MySQL server during query (10.64.48.14)
tchlist=watched&highlight=1&limit=50&watchlist__watched_color=c5&changeType__hidelog_color=c3
meone to delete old indexes from nlwiki, fawiki, trwiki, wikidatawiki, ptwiki, ruwiki (6 dbs)
SQL error from within function "SpecialRecentChanges::doMainQuery". SQLite returned error "1: near "(": syntax … y**: major
**OS**: Windows XP
**Platform**: PC
'20170312000000') AND rc_new IN ('0','1') ORDER BY rc_timestamp DESC LIMIT 50 \nFunction: SpecialRecentChanges::doMainQuery\nError: 2013 Lost connection to MySQL server … ER BY rc_timestamp DESC LIMIT 50 \nFunction: SpecialRecentChanges::doMainQuery\nError: 2013 Lost connection to MySQL server … ER BY rc_timestamp DESC LIMIT 50 \nFunction: SpecialRecentChanges::doMainQuery\nError: 2013 Lost connection to MySQL server … ]
},
"sort": [
1491926230000
]
}
```…
= '2009-06-01 00:00:00 GMT') AND rc_bot = '0' ORDER BY rc_timestamp DESC LIMIT 50
Function: SpecialRecentChanges::doMainQuery Error: 1 FEHLER: keine Berechtigung fr Relati … ity**: major
**OS**: Linux
**Platform**: Other
denondamaging in wikidatawiki is slow probably because there is no index on oresc_probability
ns for that class
includes/specials/SpecialRecentChanges.php:371 PhanThrowTypeAbsentForCall \SpecialRecentChanges::doMainQuery() can throw \MWException because it calls \Ch … ntChanges.php:424 PhanThrowTypeAbsentForCall \SpecialRecentChanges::doMainQuery() can throw \ConfigException because it calls … ntChanges.php:425 PhanThrowTypeAbsentForCall \SpecialRecentChanges::doMainQuery() can throw \Wikimedia\Rdbms\DBError because … #039;@throws' declarations for that class…
calls the new ChangesListSpecialPageFilters hook.
The SpecialRecentChangesQuery hook is in SpecialRecentChanges::doMainQuery. This method does _not_ call it's parent, Cha … 86d-8885-f54b72dd1951>
Label: Code-Review=-2