Change 750814 had a related patch set uploaded (by Juan90264; author: Juan90264):

[operations/mediawiki-config@master] Delete Tematica namespace (NS:104) in Italian Wikivoyage

https://gerrit.wikimedia.org/r/750814

Change 750814 merged by jenkins-bot:

[operations/mediawiki-config@master] Delete Tematica namespace (NS:104) in Italian Wikivoyage

https://gerrit.wikimedia.org/r/750814

Mentioned in SAL (#wikimedia-operations) [2022-01-05T01:49:11Z] <ebernhardson@deploy1002> Synchronized wmf-config/InitialiseSettings.php: Config: [[gerrit:750814|Delete Tematica namespace (NS:104) in Italian Wikivoyage (T298315)]] (duration: 01m 07s)

There are still a couple of pages defined in that now-undefined namespace in the database. This shoul be fix before closing this issue.

37 rows in 105 => 'Discussioni_tematica'

sql
SELECT page_title
FROM page
WHERE page_namespace = 105;

and 226 rows in 104 => 'Tematica'

sql
SELECT page_title
FROM page
WHERE page_namespace = 104;

this should be cleaned up. I do not know whom to ping, who may do it.

Change 952817 had a related patch set uploaded (by Caenus; author: Caenus):

[operations/mediawiki-config@master] Deleting Ns:104 in itwikivoyage

https://gerrit.wikimedia.org/r/952817

@Aklapper sorry for ping. Do you know who can clean the database? There are still pages defined in that now-undefined namespace in the database.

This would need to be done with a script via MW, we do not execute commands directly on the DB.

@Marostegui do you know who can do it?

I don't know if @Ladsgroup can help with this or we need Platform Engineering for it.

In T298315#9122607, @Caenus wrote:

37 rows in 105 => 'Discussioni_tematica'
and 226 rows in 104 => 'Tematica'
this should be cleaned up. I do not know whom to ping, who may do it.

What should be done with those pages? Should they be deleted? Or moved to another namespace (which one)? Note that if we delete the pages, they won't really be accessible (just as they aren't accessible right now), because they'd still be in an undefined/deleted namespace, just also deleted by the MediaWiki's delete page option.

Unrelated note: Why is your Wikimedia account locked?

In T298315#9177635, @Urbanecm wrote:

In T298315#9122607, @Caenus wrote:

37 rows in 105 => 'Discussioni_tematica'
and 226 rows in 104 => 'Tematica'
this should be cleaned up. I do not know whom to ping, who may do it.

What should be done with those pages? Should they be deleted? Or moved to another namespace (which one)? Note that if we delete the pages, they won't really be accessible (just as they aren't accessible right now), because they'd still be in an undefined/deleted namespace, just also deleted by the MediaWiki's delete page option.

Unrelated note: Why is your Wikimedia account locked?

All those pages were just redirects, so I think they can easily be deleted.

This database also poses a problem for the bots that generate reports on Wikidata. You can see an example of this issue at https://www.wikidata.org/wiki/Wikidata:Database_reports/Sitelink_to_redirect_with_unconnected_target. The bot owner, @MisterSynergy, has mentioned that he is aware of the situation concerning itwikivoyage. This project used to have a namespace 104 ("Tematica"), and there are still a couple of pages defined in that now-undefined namespace in the database, including the five ones listed on the report. It appears that the database was not properly cleaned up after the namespace reorganization.

General question: is there a way to automate the process of ensuring that the database is consistently cleaned up after namespace reorganizations?