[01:56:14] Hmm, i guess Special:Import has issues importing template style pages? [01:56:45] Its too bad the whole process of transfering an article from enwiki, templates and all, is so non-smooth [10:27:26] Special:DeadendPages hangs until the front end times out and returns a 504. it looks to me like the code is making a LEFT JOIN query against the page and pagelinks tables, and this is what is hanging [10:28:06] i have a development mirror of the wiki with almost all the same content, the same hardware etc. this query will return instantly on the dev site, but will hang for a few seconds on the live site: `SELECT page_title FROM page LEFT JOIN pagelinks ON page_id = pl_from LIMIT 50;` [10:28:27] it looks to me like there are two indexes on the pagelinks table that are present on the development site and not the live site: https://termbin.com/z1il [10:29:34] should i add them? is there a cool way to do this with maintenance/run.php [10:30:59] i do not know why the indexes would exist on one site and not the other [15:12:16] goddamnwizards: https://www.mediawiki.org/wiki/Manual:Page_table (and other pages for other tables) documents current expected schema, including indexes [15:12:54] no good way to add them via run.php; it's supposed to be added via the database upgrader but if an upgrade only partially completed you can wind up in inconsistent states and the upgrader is not equipped to handle such scenarios [16:06:47] moonmoon: the one i see a discrepancy with is pagelinks [16:07:02] https://m.mediawiki.org/wiki/Manual:Pagelinks_table it says i can rebuildall.php? [16:09:42] thanks moonmoon [20:15:13] goddamnwizards: rebuildall rebuilds the *contents* of the table, not the *schema* [20:15:33] for schema changes, you're on your own if your wiki has drifted. just directly use SQL to add/update/remove columns and indexes