Page MenuHomePhabricator

Table langlinks shows outdated links
Open, LowPublic

Description

About 1 month ago at the 28th Feb this edit is done.
Now (26th March) this query doesn't show the new interwiki link. it means labs database replacement has a long time delay. please solve it.

Event Timeline

Yamaha5 created this task.Mar 26 2018, 10:33 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 26 2018, 10:33 AM
Yamaha5 updated the task description. (Show Details)Mar 26 2018, 10:42 AM

the delay on the https://tools.wmflabs.org/replag/ is 0 so something is wrong. why one month ago edit doesn't reflect on the query?

for who are not ok with foreign language.

At the fa.wikipedia a user moved page "foo" to "bar" the extension changed the link address at the wikidata.

now at the wikidata the item's link is "bar" like local wikis. at the wikis (wikidata and locals) everything is ok.

If we get a query from labs it should be work like wikis and shows "bar" but it shows "foo" (the old link name)

zhuyifei1999 added a subscriber: zhuyifei1999.

From what I understand, کنشگران حقوق رأی زنان should be changed into سافرجت‌های. The enwiki sidebar interlanguage links reflected the change, but the replicas did not.

jcrespo added a subscriber: jcrespo.

Hi, this is not a labsdb problem- it shows the same result on production- labsdb is showing the exact same data that is on Wikipedia. If you believe the result on production is wrong (I don't know enough about mediawiki to know that, you should either create a new task or modify this to report it to Wikidata or mediawiki.

Enwiki master:

root@db1052[enwiki]> SELECT page_title,ll_title
    -> FROM page
    -> INNER JOIN langlinks ON page_id = ll_from
    -> WHERE page_namespace = 14
    ->     AND ll_lang = 'fa'
    ->     and page_title='Australian_suffragists'
    -> GROUP BY page_id;
+------------------------+------------------------------------------------------------------------+
| page_title             | ll_title                                                               |
+------------------------+------------------------------------------------------------------------+
| Australian_suffragists | رده:کنشگران حقوق رأی زنان اهل استرالیا                                 |
+------------------------+------------------------------------------------------------------------+
1 row in set (0.00 sec)
Yamaha5 removed a subscriber: Yamaha5.Mar 26 2018, 12:44 PM
Yamaha5 added a subscriber: Yamaha5.

As noted in IRC, I don't think those tables should be used for querying interwiki links.
This is a possible query that returns the correct value.

Chicocvenancio triaged this task as Low priority.Mar 26 2018, 8:14 PM
Chicocvenancio edited projects, added Wikidata; removed MediaWiki-General.
Chicocvenancio renamed this task from labs database has delay to Table langlinks shows outdated links.Mar 26 2018, 8:18 PM
This comment was removed by jcrespo.
Yamaha5 added a comment.EditedMar 29 2018, 4:59 AM

As noted in IRC, I don't think those tables should be used for querying interwiki links.
This is a possible query that returns the correct value.

sparcle is very good but it dosent support join local db table query. for example i want to get articles which are in a category and have interwiki to en.wiki but dont link to fa.wiki