Renumber commons TimedText namespace 102 to 710
Open, Stalled, HighPublic
Actions

Assigned To

None

Authored By

	TheDJ
	Jan 16 2016, 3:35 AM

Description

It's probably time we get rid of this Commons exception (see also config), that has TimedText at namespace index 102 instead of 710 (and 103 vs 711). I suspect this will need a custom migration script ?

Tables in commonswiki database needing cleanup:

abuse_filter_log: afl_namespace
archive: ar_namespace
cu_changes: cuc_namespace
imagelinks: il_from_namespace
logging: log_namespace
page: page_namespace
pagelinks: pl_namespace, pl_from_namespace
protected_titles: pt_namespace
querycache: qc_namespace
recentchanges: rc_namespace, rc_moved_to_ns(?)
redirect: rd_namespace
templatelinks: tl_from_namespace, tl_namespace
titlekey: tk_namespace
watchlist: wl_namespace

Tables that currently have no relevant rows:

externallinks: el_from_namespace
job: job_namespace
mark_as_helpful: mah_namespace
moodbar_feedback: mbf_namespace
querycachetwo: qcc_namespace, qcc_namespacetwo

Other tables that keep track and 'might' have to be updated ?

echo_event: event_page_namespace

There are about 4500'ish pages in TimedText, and fewer than 500 in TimedText_talk.

Revisions and Commits

rETMH extension-TimedMediaHandler
	rETMH7cab54e2e482 Move TimedText NS id defines back into ParserAfterCache
	rETMH2512bac8def0 Move TimedText NS id defines back into ParserAfterCache

Related Objects
Search...

Status	Assigned	Task
Resolved	TheDJ	T123695 TimedText (710) namespace missing on beta enwiki
Stalled	None	T123823 Renumber commons TimedText namespace 102 to 710
Open	None	T180885 Create maintenance script to renumber namespaces

Event Timeline

TheDJ created this task.Jan 16 2016, 3:35 AM

TheDJ raised the priority of this task from to High.

TheDJ updated the task description. (Show Details)

TheDJ added projects: TimedMediaHandler, Wikimedia-Site-requests.

TheDJ added subscribers: TheDJ, Anomie, Tgr.

Restricted Application added subscribers: JEumerus, Steinsplitter, Dereckson and 2 others. · View Herald TranscriptJan 16 2016, 3:35 AM

TheDJ added a project: Technical-Debt.Jan 16 2016, 3:37 AM

TheDJ set Security to None.

TheDJ added a project: Commons.

We have a script which is supposed to deal with most of those tables called namespaceDupes.

Actually, it deals with page, pagelinks, templatelinks, and imagelinks. Not echo_event, job, logging, protected_titles, recentchanges, redirect (?), watchlist.

See T88587, T12171, T73171

mysql> select table_name, column_name from information_schema.columns where column_name like '%namespace%' and table_schema = 'commonswiki';
+--------------------+-----------------------+
| table_name         | column_name           |
+--------------------+-----------------------+
| abuse_filter_log   | afl_namespace         |
| archive            | ar_namespace          |
| archive_save       | ar_namespace          |
| click_tracking     | namespace             |
| cu_changes         | cuc_namespace         |
| cur                | cur_namespace         |
| edit_page_tracking | ept_namespace         |
| externallinks      | el_from_namespace     |
| globalimagelinks   | gil_page_namespace_id |
| globalimagelinks   | gil_page_namespace    |
| hidden             | hidden_namespace      |
| imagelinks         | il_from_namespace     |
| job                | job_namespace         |
| job_explosion_tmp  | job_namespace         |
| logging            | log_namespace         |
| logging_pre_1_10   | log_namespace         |
| mark_as_helpful    | mah_namespace         |
| moodbar_feedback   | mbf_namespace         |
| page               | page_namespace        |
| pagelinks          | pl_namespace          |
| pagelinks          | pl_from_namespace     |
| povwatch_log       | pwl_namespace         |
| protected_titles   | pt_namespace          |
| querycache         | qc_namespace          |
| querycachetwo      | qcc_namespace         |
| querycachetwo      | qcc_namespacetwo      |
| recentchanges      | rc_namespace          |
| redirect           | rd_namespace          |
| templatelinks      | tl_namespace          |
| templatelinks      | tl_from_namespace     |
| titlekey           | tk_namespace          |
| watchlist          | wl_namespace          |
+--------------------+-----------------------+
32 rows in set (0.01 sec)

Also recentchanges.rc_moved_to_ns. Some of those tables are obsolete or unused - click_tracking, hidden, job_explosion_tmp, logging_pre_1_10, titlekey, etc.

Anomie updated the task description. (Show Details)Jan 16 2016, 4:13 AM

TheDJ closed this task as Resolved by committing rETMH2512bac8def0: Move TimedText NS id defines back into ParserAfterCache.Jan 17 2016, 3:35 PM

TheDJ added a commit: rETMH2512bac8def0: Move TimedText NS id defines back into ParserAfterCache.

Looks like some Phab thing incorrectly auto-closed this task because it happened to be mentioned in the commit summary.

Anomie mentioned this in T123864: "Fix" or "Fixes Txxxxxx" in commit message closes tasks automatically.Jan 17 2016, 3:41 PM

Ricordisamoa subscribed.Jan 17 2016, 4:17 PM

In T123823#1939785, @Anomie wrote:

Looks like some Phab thing incorrectly auto-closed this task because it happened to be mentioned in the commit summary.

"Fix/Fixes T..." autocloses issues, yes. See https://secure.phabricator.com/T5132.

Paladox closed this task as Resolved by committing rETMH7cab54e2e482: Move TimedText NS id defines back into ParserAfterCache.Jan 27 2016, 9:34 PM

Paladox added a commit: rETMH7cab54e2e482: Move TimedText NS id defines back into ParserAfterCache.

Now, with free backport noise :)

TheDJ added a parent task: T87981: Convert TimedMediaHandler to use extension registration.Jan 29 2016, 10:43 AM

TheDJ removed a parent task: T87981: Convert TimedMediaHandler to use extension registration.Feb 12 2016, 7:39 AM

Changing the id is likely breaking scripts, bots, editnotices and equivalent?

Depending on how you're storing titles, maybe. You shouldn't generally be storing namespace IDs yourself, it's kind of an internal thing.

Urbanecm moved this task from Backlog to Config - to process on the Wikimedia-Site-requests board.Apr 15 2016, 7:52 PM

Restricted Application added a subscriber: Poyekhali. · View Herald TranscriptApr 15 2016, 7:52 PM

@TheDJ You want to work on this or see a plan of action we can follow? For example, do you have a script available for the tables operations?

Dereckson moved this task from Config - to process to Blocked on development on the Wikimedia-Site-requests board.Apr 17 2016, 12:42 AM

Bugreporter merged a task: T180884: Renumber TimedText and TimedText_talk on commonswiki.Mar 28 2020, 10:26 AM

Bugreporter added subscribers: Reedy, Jdforrester-WMF.

zhuyifei1999 renamed this task from Renumber commons namespace 102 to 710 to Renumber commons TimedText namespace 102 to 710.Mar 29 2020, 2:07 AM

Reedy changed the task status from Open to Stalled.Apr 22 2020, 3:52 PM

Reedy added a subtask: T180885: Create maintenance script to renumber namespaces.

RhinosF1 subscribed.Apr 22 2020, 4:23 PM

Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:01 PM

• brion moved this task from To sort to Backlog/maint on the TimedMediaHandler board.Feb 18 2022, 6:34 PM

Renumber commons TimedText namespace 102 to 710Open, Stalled, HighPublicActions

Description

Revisions and Commits

Related ObjectsSearch...

Event Timeline

Renumber commons TimedText namespace 102 to 710
Open, Stalled, HighPublic
Actions

Related Objects
Search...