centralauth_p is missing tables
Closed, DuplicatePublic
Actions

Assigned To

None

Authored By

	Legoktm
	Jun 12 2014, 4:31 PM

Description

Tool labs:

MariaDB [centralauth_p]> show tables;
---------------------------

Tables_in_centralauth_p

---------------------------

global_group_permissions

global_group_restrictions

global_user_groups

globalblocks

globaluser

localuser

wikiset

---------------------------
7 rows in set (0.00 sec)

Toolserver:

mysql> show tables;
---------------------------

Tables_in_centralauth_p

---------------------------

global_group_permissions

global_group_restrictions

global_user_groups

globalblocks

globalnames

globaluser

localnames

localuser

spoofuser

wikiset

---------------------------
10 rows in set (0.00 sec)

Missing: localnames, globalnames, spoofuser.

I need the localnames and globalnames tables, don't really care about spoofuser.

Version: unspecified
Severity: normal

Details

Reference: bz66533

Related Objects
Search...

Status	Assigned	Task
Resolved	bd808	T60788 Toolserver migration to Tools (tracking)
Resolved	bd808	T60791 Missing Toolserver features in Tools (tracking)
Resolved	• jcrespo	T50930 Database replication problems - production and labs (tracking)
Duplicate	None	T68533 centralauth_p is missing tables

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:22 AM

• bzimport added a project: Wikimedia-Labs-General.

• bzimport set Reference to bz66533.

Legoktm created this task.Jun 12 2014, 4:31 PM

Hi Coren, 5 days to go... Please say something on this!

CC'ing springle as this is getting urgent (abogott is already CC'ed).

Was this resolved?

It's moot, given the imminent transition to MariaDB 10. Keeping the bug open for tracking, however, until that's done.

Ignore my previous comment; that wasn't intended on this bug. I have to check whether there are suppression issues in those tables first. More news soon.

There are suppressed usernames in all 3 tables. spoofuser won't have the exact username since it would probably be normalized though.

@Legoktm can you explain why you need those tables? It might be simpler to give you the actual data you need rather than open up the underlying tables.

Mainly so I can test out centralauth queries before running them in production.

coren removed coren as the assignee of this task.Mar 25 2015, 2:59 PM

coren triaged this task as Low priority.

coren edited projects, added Cloud-Services; removed Wikimedia-Labs-General.

coren set Security to None.

@coren: So, if you're not planning to work on this, who else should it be assigned to?

Looks like nobody is planning on working on this atm, so is assigned to nobody :)

@Legoktm If this is important enough to you, we can huddle together for an hour next week and get this done.

Liuxinyu970226 subscribed.Mar 26 2015, 9:47 AM

• silke unsubscribed.Apr 13 2015, 6:40 AM

This is either fixed or should be merged into T103011.

Ricordisamoa subscribed.Jul 16 2015, 9:59 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 16 2015, 9:59 PM

Glaisher subscribed.Sep 26 2015, 4:13 PM

coren added a project: labs-sprint-116.Sep 28 2015, 5:17 PM

coren closed this task as a duplicate of Restricted Task.Sep 28 2015, 8:37 PM

Restricted Application removed a subscriber: Liuxinyu970226. · View Herald TranscriptSep 28 2015, 8:37 PM

coren moved this task from To do to Done on the labs-sprint-116 board.Sep 29 2015, 6:19 PM

• Phabricator_maintenance removed a subscriber: yuvipanda.Jun 7 2017, 6:59 PM

centralauth_p is missing tablesClosed, DuplicatePublicActions

Description

Details

Related ObjectsSearch...

Event Timeline

centralauth_p is missing tables
Closed, DuplicatePublic
Actions

Related Objects
Search...