@Marostegui: After the declining of ths task - have you guessed to take something better than MariaDB, if possible? Is our DB running with full capacity again?

@Aklapper: Meanwhile I cannot reproduce the issue any more. It seems to be solved otherwise.

At least another week, possibly 2 more weeks.

Okay super! If so it will be very helpful to make a statement about it here.

Sorry for little impatience: Can you say when you are running with full capacity again? (T252209)

@Marostegui: Thank you for your explanation!

@Marostegui: my client user is u4802

@DavidBrooks and others: In the Earwig's Copyvio Detector window it's written: "We are still investigating recent performance issues/timeouts on the new infrastructure."

@Aklapper Das Tool wird häufig genutzt und ist auch nicht unwichtig. Kannst Du diesen Task bitte assignen und/oder die Tags anpassen? Danke sehr ...

@Aklapper: Oh yea, but there happens nothing for four years ... OMG

@Aklapper: please give it useful tags, I don't know any for this

Meaning: the subcategory 'Crocodylomorpha' is not counted as subcat of 'Crurotarsi'.

@Urbanecm: Please see T238500, recount again please. Maybe it makes sense to run a daily script for automatical recount.

@Urbanecm: I should reopen, if there is one more issue. Please take a look at https://de.wikipedia.org/w/index.php?title=Kategorie:Crurotarsi - it has one subcategory that is also not counted/or added to -1.

@Urbanecm: Thank you, but what about all the other language wikis?

I tested several eventualities, and could find out: database table 'categories', column 'cat_subcats' starts by -1. If there are 2 subcategory pages, then 'cat_subcats' returns 1.

T238500: I tested several eventualities, and could find out: database table 'categories', column 'cat_subcats' starts by -1. If there are 2 subcategory pages, then 'cat_subcats' returns 1. Please keep an eye on T238500 though it is marked as 'closed'. Thanks!

@Bugreporter: IMHO this task is not a duplicate of T228585, because the problem/the bug is not mentioned there.

@TTO : are you still working on it?

In T237503#5651919, @Reedy wrote:

In T237503#5651894, @doctaxon wrote:

In T237503#5643126, @Bawolff wrote:

I would be concerned about the increased potential for phising and viruses/other malicious attachments.

Why don't you consider antivirus software as freemail providers do, too?

Not allowing attachments is much easier/saner than accepting liability for scanning/dealing with attachments and not identifying something that's problematic

In T237503#5643126, @Bawolff wrote:

I would be concerned about the increased potential for phising and viruses/other malicious attachments.

@Aklapper: Because some of these attachments are copyrighted and only for private research use. If copyrighted I must not upload the content of these attachments to MediaWiki.

Please provide me with an update? Are you working on it?

In T232379#5519095, @Johan wrote:

@doctaxon I'm not sure exactly what it is you're asking? The problems with multiple deliveries stem from the problem discussed in this task, for which a fix is being merged now. If you've got general questions about Tech News and how it's being delivered, I suggest you ask them at m:Talk:Tech/News and I'll be happy to answer.

In T232379#5518629, @Aklapper wrote:

In T232379#5518455, @doctaxon wrote:

And why do you use the "MediaWiki message delivery" sending The Tech News out?

@doctaxon: Please ask general Tech News questions on https://meta.wikimedia.org/wiki/Talk:Tech/News - thanks. This task is about mass message.

And we don't need a providing of deduplication but a prevention of duplication. That has to be the first step.

And why do you use the "MediaWiki message delivery" sending The Tech News out?

This monday the Tech News has been spammed three times again. If it is running by a cron job, please check the crontab. Maybe the crontab has been started three times, too. I figured out the rhythm of the spam job: 0-1-6 minutes: The second Tech News followed within one minute, the third Tech News followed within 6 minutes. It has happend the last three weeks identically.

yes, it's the same and can be merged

@Aklapper: can you assign this ticket please?

• put Notifier and Veto to two routines
• merged to adt2.tcl

assign to TaxonBot

assign to TaxonBot

Assigned to TaxonBota

@Smalyshev What's the status to this task? There are still problems, -> https://www.wikidata.org/wiki/Wikidata:Request_a_query#SPARQL_query_result_erroneous

@Bawolff I changed the botpassword about 10:45 UTC, May 9th. A login is successful now, but it was not successful on a first test with the old botpassword before.

and how to get authorized for this link?

but first reduce the waiting time to login from 2 days to 0 minutes

okay, but prio High at least. The bot is even very important. ...

I think, the dev team can build a script to declare automatically such defective ID properties as dead links anyhow.

In T189698#4050502, @Cyberpower678 wrote:

Why did I get an email for this ticket. This doesn’t concern me.

In T179879#4006226, @Lucas_Werkmeister_WMDE wrote:

Oh, and the outer query is trying to get all the labels of the place of birth, place of death, country of citizenship, etc., in all languages. That’s also a terrible idea.

?item wdt:P27 wd:Q183 was my mistake, these are the German women. I need the Swedish, sorry: ?item wdt:P27 wd:Q34

In T179879#4006181, @Lucas_Werkmeister_WMDE wrote:

It only returns some two thousand results, so the surrounding query shouldn’t be a problem either…

@Jonas
This is such a query that runs into a timeout. It should give all Swedish women that have no sitelink to dewiki with counting the sitelinks and listing some properties to each item, and is needed for a dewiki community project. I cannot limit it because of the needed double ORDER BY, so the query has to run with unlimited result. If there is a longer timeout, the query will give a successful result. It will be great, if you can optimize it, if possible. Can you calculate, how much time the query will take to complete?

Maybe 120s limit? I think, we have to test it, but how?

Thank you, Magnus, this was my opinion, but my English is not so good like yours, so ...

@Smalyshev wrote:

This will always be the case, we will never be able to serve arbitrary requests that require unlimited time to perform.

Ah! I didn't know about, thank you

@bd808 @chasemp What is your meaning about this?

"The quantity of entities in Wikidata has risen very much.

IMHO it does not look like the same ...

Hi! I could find this emoji too, yesterday, but it was very late, so I couldn't report it any more.

@matmarex: you can find the xml here: http://tools.wmflabs.org/taxonbot/xml1.xml

@matmarex: take a look, there's nothing fixed, user:Unknown_user is back again: https://de.wikipedia.org/w/index.php?title=Benutzer:Delta456/Carcassonne_(Spiel)/Eigenst%C3%A4ndige_Spiele_2&action=history

Let me try the import once more to another target and we'll see.