Last modified: 2014-07-25 01:34:49 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T68533, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 66533 - centralauth_p is missing tables
centralauth_p is missing tables
Status: NEW
Product: Wikimedia Labs
Classification: Unclassified
General (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Marc A. Pelletier
:
Depends on:
Blocks: labs-replication tool-missing-ts-feat
  Show dependency treegraph
 
Reported: 2014-06-12 16:31 UTC by Kunal Mehta (Legoktm)
Modified: 2014-07-25 01:34 UTC (History)
7 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Kunal Mehta (Legoktm) 2014-06-12 16:31:05 UTC
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.
Comment 1 Silke Meyer (WMDE) 2014-06-26 09:59:52 UTC
Hi Coren, 5 days to go... Please say something on this!
Comment 2 Andre Klapper 2014-06-26 11:09:46 UTC
CC'ing springle as this is getting urgent (abogott is already CC'ed).
Comment 3 Andrew Bogott 2014-07-17 20:41:03 UTC
Was this resolved?
Comment 4 Marc A. Pelletier 2014-07-17 20:44:11 UTC
It's moot, given the imminent transition to MariaDB 10.  Keeping the bug open for tracking, however, until that's done.
Comment 5 Marc A. Pelletier 2014-07-25 01:31:39 UTC
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.
Comment 6 Kunal Mehta (Legoktm) 2014-07-25 01:34:49 UTC
There are suppressed usernames in all 3 tables. spoofuser won't have the exact username since it would probably be normalized though.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links