#1035960 www.debian.org: Language trackinng broken or gone

#1035960#5
Date:
2023-05-11 16:50:30 UTC
From:
To:
Package: www.debian.org
Severity: important
Tags: l10n

The translation robot feeds the langauge tracking on Debians web pages.
This is very important to monitor for new or outdated translations (or
for long running review rounds).

When I just refreshed the web pages to see todays status, many status
are gone or broken.

For German the following pages are affected:
https://www.debian.org/international/l10n/po/de

https://www.debian.org/international/l10n/po-debconf/de

https://www.debian.org/international/l10n/po4a/de

I can give you numerous examples for broken entries, but in the last link
all entries are "empty", while they all should have a sensible status.

Kindly restore them soon, as I'm monitor if any translation needs to
be updated for bookworm (last minute updates).

Thanks!

Greetings

          Helge

#1035960#10
Date:
2023-05-12 08:36:41 UTC
From:
To:
Hi

El 12 de mayo de 2023 9:52:02 CEST, "Camaleón" <noelamac@gmail.com> escribió:

Maybe this issue in the Spanish dashboards is related to the report #1035960 about issues in the German dashboards:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1035960

I will try to investigate both issues but any help is welcome.

If any of you is sure about the last date when you saw things were working well, please tell, so I can try to learn what happened since then that could cause the issue.

Kind regards

#1035960#15
Date:
2023-05-12 09:41:57 UTC
From:
To:
Hi,

Laura Arjona Reina <larjona@debian.org> (2023-05-12):

Please pretend I don't know anything about i18/l10n, www, or how the
latter uses information published by the former…

It looks to me like at least the status.$LANG files exposed at [1] are
busted, with many references to different $LANG.po in some files.

 1. https://l10n.debian.org/coordination/00data/

For example, status.es has 5319 references to de.po…


Whether that's linked or not, I didn't find reassuring that the www
build output hundreds/thousands of warnings when running a local,
partial build of english/international…

I'll keeping looking at what's supposed to happen on tye, but I'm not
sure I'll be able to get to the bottom of it on my own.


Cheers,

#1035960#20
Date:
2023-05-12 10:04:13 UTC
From:
To:
Cyril Brulebois <kibi@debian.org> (2023-05-12):

At least there's a HUGE red flag on tye. Load to the roof, RAM/swap
almost full, lots of dl10n-spider processes running for the same
language, some of them started May 9th.

    kibi@tye:~$ uptime
     10:02:58 up 12 days, 21:47,  2 users,  load average: 63.24, 64.57, 66.51

    kibi@tye:~$ free -h
                   total        used        free      shared  buff/cache   available
    Mem:           1.9Gi       1.7Gi        69Mi       1.0Mi       125Mi        57Mi
    Swap:          511Mi       511Mi       0.0Ki

    kibi@tye:~$ ps faux|grep dl10n-spider|grep -o -- '--check-bts ..'|sort|uniq -c
          4 --check-bts ca
          1 --check-bts cs
          1 --check-bts da
         51 --check-bts de
          7 --check-bts es
          2 --check-bts fr

    kibi@tye:~$ ps faux|awk '/CRON/ {print $9}'|sort|uniq -c
         11 May09
         23 May10
         23 May11
          1 00:15
          1 02:15
          1 03:15
          1 04:15
          1 05:15
          1 06:15
          1 07:15
          1 08:13
          1 08:15
          1 09:15
          2 10:00
          1 10:01

Note that many de.po occurrences appear in the status file for other
languages, looks like processes heavily stomping onto others' feet?


It looks to me there should be some locking at the very least to avoid
that amount of concurrency. And that it would probably be best to start
afresh, killing all those processes, maybe disabling the cron jobs,
cleaning temporary and maybe corrupted data files, and triggering a
single run manually to see if it works.

But then, I have 0 knowledge about the spider, and I'll leave that up to
someone else: I don't want to risk making the matter worse!


Cheers,

#1035960#25
Date:
2023-05-12 21:50:54 UTC
From:
To:
Thanks everybody for the extra info and Cyril for the research

I have killed the spider jobs.
I have modified the crontab in tye.debian.org to disable cron.hourly job
(spiderbts) for now.

I have removed the status files [1] and launched a job spiderinit [2] to
re-create them.

[1] in /srv/i18n.debian.org/dl10n/data/spiderbts/data/status.??
[2] sudo -u debian-i18n /srv/i18n.debian.org/dl10n/git/cron/spiderinit &

Tomorrow I'll have a look at the logs of the spiderinit job [3] and
launch the cron.hourly job once.

[3] /srv/i18n.debian.org/log/spiderinit/spiderinit.20230512-2134.[err|log]


Then I'll see how long does it take and if there is any issue.
If everything went well the webpages should show correct data. Then I'll
set the "hourly" job to run 6 times a day and will keep an eye these days.

I agree that a lockfile is needed, I'll try to work on that too and when
it's set, and the issue is fixed, I'll update the cron to run hourly again.

Kind regards


El 12/5/23 a las 12:04, Cyril Brulebois escribió:

#1035960#30
Date:
2023-05-16 12:23:22 UTC
From:
To:
Hello

The spiderinit job took very long but finally it re-created all the status files and the html pages, and I think it worked well.

I have added code to use lockfiles in the spiderbts job:

https://salsa.debian.org/l10n-team/dl10n/-/commit/5d518000bf15762dde13ed7cd56dee77a2bf757b

And reenabled the cron.hourly job

I'll try to keep an eye on things these days, please report if you notice any issue.

Kind regards

El 12 de mayo de 2023 23:50:54 CEST, Laura Arjona Reina <larjona@debian.org> escribió: