Page MenuHomePhabricator

Investigate publishing errors where source language = target language
Closed, ResolvedPublic

Description

I noticed this in publishing error logs:

1ititRai20150707114638
1ptptAmor20150707132356

I have no idea how source and target language can be the same.

Comment on March 3 2018: This may be resolved thanks to T138494. If it doesn't happen again till the end of April 2018, close it.

Event Timeline

Nikerabbit raised the priority of this task from to Needs Triage.
Nikerabbit updated the task description. (Show Details)
Nikerabbit subscribed.
Amire80 triaged this task as Medium priority.Jul 7 2015, 8:27 PM
Amire80 set Security to None.
Amire80 moved this task from Backlog to Bugs on the ContentTranslation-Release6 board.
Amire80 subscribed.

Putting this in CX7 for investigation.

Did it happen since the bug was reported?

If it doesn't happen again by the end of CX7, I suggest closing this, because I also have no idea how could this be caused.

@Nikerabbit, did this happen recently? It has been a long time since ticket creation and last comment.

Still happened until recently:

wikiadmin@10.64.32.26(wikishared)>select
    ->     translation_start_timestamp,
    ->     translation_source_language as source,
    ->     translation_target_language as target
    -> from
    ->     cx_translations
    -> where
    ->     translation_source_language = translation_target_language
    -> order by
    ->     translation_start_timestamp desc;
+-----------------------------+--------+--------+
| translation_start_timestamp | source | target |
+-----------------------------+--------+--------+
| 20180212020741              | zh     | zh     |
| 20180201061028              | zh     | zh     |
| 20180131043107              | zh     | zh     |
| 20180129060640              | zh     | zh     |
| 20180128235427              | zh     | zh     |
| 20180125063117              | zh     | zh     |
| 20180124101356              | zh     | zh     |
| 20180120055747              | zh     | zh     |
| 20180117094716              | zh     | zh     |
| 20180116140912              | zh     | zh     |
| 20180115133402              | zh     | zh     |
| 20180113150001              | zh     | zh     |
| 20180110131323              | zh     | zh     |
| 20180106093249              | sr     | sr     |
| 20171228151900              | zh     | zh     |
| 20171224183641              | zh     | zh     |
| 20171224015700              | sr     | sr     |
| 20171219083330              | zh     | zh     |
| 20171210071003              | zh     | zh     |
| 20171206032013              | zh     | zh     |
| 20171127214155              | zh     | zh     |
| 20171127033941              | zh     | zh     |
| 20171125011330              | zh     | zh     |
| 20171124024600              | zh     | zh     |
| 20171118214859              | en     | en     |
| 20171118090746              | zh     | zh     |
| 20171117074727              | en     | en     |
| 20171117003925              | sr     | sr     |
| 20171115084834              | zh     | zh     |
| 20171114222154              | zh     | zh     |
| 20171114201253              | en     | en     |
| 20171114152019              | en     | en     |
| 20171113053839              | zh     | zh     |
| 20171112184006              | zh     | zh     |
| 20171112182740              | zh     | zh     |
| 20171112112657              | pl     | pl     |
| 20171112083846              | zh     | zh     |
| 20171111152957              | en     | en     |
| 20171108053827              | zh     | zh     |
| 20171103202635              | en     | en     |
| 20171102152751              | fr     | fr     |
| 20171031021230              | zh     | zh     |
| 20171030191439              | en     | en     |
| 20171029135146              | ru     | ru     |
| 20171028141611              | zh     | zh     |
| 20171027070816              | zh     | zh     |
| 20171025140816              | fr     | fr     |
| 20171019192110              | cs     | cs     |
| 20171019083352              | en     | en     |
| 20171016162438              | zh     | zh     |
| 20171013183045              | zh     | zh     |
| 20171011042353              | ru     | ru     |
| 20171010160636              | zh     | zh     |
| 20171007175137              | fa     | fa     |
| 20171006171332              | zh     | zh     |
| 20171002054011              | zh     | zh     |
| 20171001065507              | zh     | zh     |
| 20170930102831              | en     | en     |
| 20170929133737              | en     | en     |
| 20170926193458              | zh     | zh     |
| 20170923134819              | fr     | fr     |
| 20170918134014              | en     | en     |
| 20170913190217              | es     | es     |
| 20170913164519              | zh     | zh     |
| 20170912192625              | en     | en     |
| 20170912001024              | en     | en     |
| 20170911221018              | pt     | pt     |
| 20170909172926              | en     | en     |
| 20170909160228              | zh     | zh     |
| 20170909102352              | en     | en     |
| 20170909064756              | en     | en     |
| 20170908140404              | fi     | fi     |
| 20170831000044              | zh     | zh     |
| 20170819055603              | zh     | zh     |
| 20170819055331              | zh     | zh     |
| 20170815070016              | zh     | zh     |
| 20170807141316              | zh     | zh     |
| 20170709175146              | zh     | zh     |
| 20170705030306              | zh     | zh     |
| 20170702032752              | zh     | zh     |
| 20170624001404              | zh     | zh     |
| 20170616062946              | zh     | zh     |
| 20170613041809              | zh     | zh     |
| 20170528123747              | zh     | zh     |
| 20170525085900              | zh     | zh     |
| 20170519053418              | zh     | zh     |
| 20170505135228              | zh     | zh     |
| 20170503091332              | zh     | zh     |
| 20170328084549              | zh     | zh     |
| 20170326120458              | zh     | zh     |
| 20170320203331              | zh     | zh     |
| 20170320134811              | zh     | zh     |
| 20170308182136              | zh     | zh     |
| 20170306091653              | zh     | zh     |
| 20170302092047              | zh     | zh     |
| 20170225172048              | zh     | zh     |
| 20170217082720              | zh     | zh     |
| 20170213104338              | zh     | zh     |
| 20170209121945              | zh     | zh     |
| 20170208232715              | zh     | zh     |
| 20161226102735              | zh     | zh     |
| 20161224072019              | zh     | zh     |
| 20161212065951              | kk     | kk     |
| 20161212062427              | kk     | kk     |
| 20161129141035              | zh     | zh     |
| 20161129071814              | zh     | zh     |
| 20161119182748              | zh     | zh     |
| 20161116120601              | zh     | zh     |
| 20161113134335              | zh     | zh     |
| 20161113115020              | zh     | zh     |
| 20161110132440              | zh     | zh     |
| 20161110062254              | zh     | zh     |
| 20161109171214              | zh     | zh     |
| 20161106145209              | sr     | sr     |
| 20161104222414              | zh     | zh     |
| 20161030120300              | zh     | zh     |
| 20161021074605              | zh     | zh     |
| 20161018052537              | zh     | zh     |
| 20161010122446              | zh     | zh     |
| 20161010121822              | zh     | zh     |
| 20161010093534              | zh     | zh     |
| 20161010093250              | zh     | zh     |
| 20161010084332              | zh     | zh     |
| 20161010084119              | zh     | zh     |
| 20161010084028              | zh     | zh     |
| 20161010083915              | zh     | zh     |
| 20161010083630              | zh     | zh     |
| 20161010014936              | zh     | zh     |
| 20161003112422              | zh     | zh     |
| 20161003025811              | zh     | zh     |
| 20160929194715              | sr     | sr     |
| 20160925171929              | zh     | zh     |
| 20160920063903              | zh     | zh     |
| 20160907120255              | zh     | zh     |
| 20160906084213              | zh     | zh     |
| 20160830140630              | zh     | zh     |
| 20160808200221              | zh     | zh     |
| 20160806061748              | zh     | zh     |
| 20160725081657              | zh     | zh     |
| 20160718045630              | zh     | zh     |
| 20160701003903              | zh     | zh     |
| 20160629030652              | zh     | zh     |
| 20160617085117              | sr     | sr     |
| 20160615074512              | zh     | zh     |
| 20160530162543              | zh     | zh     |
| 20160530145002              | zh     | zh     |
| 20160527161959              | zh     | zh     |
| 20160526075156              | zh     | zh     |
| 20160517050518              | zh     | zh     |
| 20160429155645              | zh     | zh     |
| 20160429091427              | zh     | zh     |
| 20160428083401              | zh     | zh     |
| 20160428023831              | zh     | zh     |
| 20160426090847              | zh     | zh     |
| 20160410174718              | zh     | zh     |
| 20160407115353              | zh     | zh     |
| 20160327024228              | zh     | zh     |
| 20160321112222              | zh     | zh     |
| 20150709102848              | ru     | ru     |
| 20150707132144              | pt     | pt     |
| 20150707114152              | it     | it     |
| 20150707082654              | fr     | fr     |
| 20150706162044              | es     | es     |
| 20150706075858              | ru     | ru     |
| 20150703110258              | tr     | tr     |
| 20150703081823              | id     | id     |
| 20150702173415              | pt     | pt     |
| 20150629113726              | ru     | ru     |
| 20150626130336              | zh     | zh     |
| 20150626112306              | tr     | tr     |
| 20150624181642              | ru     | ru     |
| 20150623132133              | fr     | fr     |
| 20150621130133              | ru     | ru     |
| 20150616052403              | vi     | vi     |
| 20150613091526              | or     | or     |
| 20150612223956              | vi     | vi     |
| 20150612112631              | tr     | tr     |
| 20150521010043              | es     | es     |
| 20150520194756              | pt     | pt     |
| 20150520064544              | tr     | tr     |
| 20150519140455              | es     | es     |
| 20150518182607              | tr     | tr     |
| 20150517192832              | es     | es     |
| 20150516194418              | es     | es     |
| 20150516080941              | id     | id     |
| 20150515175244              | pt     | pt     |
| 20150421165646              | fr     | fr     |
| 20150411075745              | bg     | bg     |
| 20150410013753              | pt     | pt     |
| 20150331180246              | fr     | fr     |
+-----------------------------+--------+--------+
190 rows in set (0.26 sec)

(I redacted the translation titles for privacy.)

Chinese is the major leader, which may hint at an issue with variants, but there are other languages, too:

select
    translation_source_language as source,
    count(translation_target_language) as number
from
	cx_translations
where
	translation_source_language = translation_target_language
group by
    translation_source_language
order by
    number desc;
+--------+--------+
| source | number |
+--------+--------+
| zh     |    124 |
| en     |     16 |
| fr     |      7 |
| ru     |      7 |
| pt     |      6 |
| es     |      6 |
| sr     |      6 |
| tr     |      5 |
| vi     |      2 |
| id     |      2 |
| kk     |      2 |
| bg     |      1 |
| pl     |      1 |
| cs     |      1 |
| it     |      1 |
| fa     |      1 |
| or     |      1 |
| fi     |      1 |
+--------+--------+
18 rows in set (0.16 sec)

The last time it happened with a language without variants is 2017-11-18. Can we think of anything that changed then?

The last time it happened with Chinese was 2017-02-12. Maybe it's related to the recent resolution of T138494: Languages that have variants are shown as a gray interlanguage link in the Wikipedia in the same language?

I suggest waiting for a couple of months and checking again. If it doesn't happen again, close this.

Hasn't happen since the last check. Assuming it's fixed and doesn't happen any more.

Do we want to do anything about the existing entries? If there's nothing to do about them this can be marked as resolved.

Pginer-WMF claimed this task.