Page MenuHomePhabricator

DBQ-202 No user_properties table on arwiki_p database
Closed, ResolvedPublic

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-202.
Summary: No user_properties table on arwiki_p database
Issue type: Task - A task that needs to be done.
Priority: Critical
Status: Done
Assignee: DaB. <dab@ts.wikimedia.org>


From: Paolo Massa <paolo@gnuband.org>

Date: Thu, 14 Mar 2013 12:38:09

I have a script which computes statistics on the gender of users in the different language wikipedias.
https://github.com/volpino/toolserver-scripts/blob/master/python_scripts/get_gender_table.py

Now it gets some errors for some wikis.
arwiki_p, hewiki_p, ...

It seems in the databases for this wikis (possibly all the wikis in cluster 7, I am not sure) the table "user_properties" is missing (and my script does a JOIN on that table).

Can you verify if this is the case, please? I have a deadline for writing a paper based on these data on Friday 15 (tomorrow) and currently I'm missing the data for few wikis ;(

Below a simple example that shows how the table user_properties is missing for arwiki (on sql7) and it is not missing on abwiki (on sql3).

Thanks!


sonet@wolfsbane:~/gender_table$ mysql -h sql-s7-user.toolserver.org
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5754236
Server version: 5.1.66 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use arwiki_p;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

^[[ADatabase changed
mysql> show tables LIKE 'user_properties';
Empty set (0.00 sec)

sonet@wolfsbane:~/gender_table$ mysql -h sql-s3-user.toolserver.org
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5413150
Server version: 5.1.66 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use abwiki_p;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables LIKE 'user_properties';

Tables_in_abwiki_p (user_properties)


user_properties


1 row in set (0.00 sec)


Version: unspecified
Severity: critical

Details

Reference
bz59484

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:34 AM
bzimport set Reference to bz59484.

From: Paolo Massa <paolo@gnuband.org>

Date: Thu, 14 Mar 2013 12:38:44

Help, please


From: Liangent <liangent@gmail.com>

Date: Tue, 26 Mar 2013 16:18:32

Resolved per http://lists.wikimedia.org/pipermail/toolserver-l/2013-March/005793.html , but not a DBQ issue.

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: wikimedia-bugzilla@dabpunkt.eu
CC list: liangent@gmail.com, wikimedia-bugzilla@dabpunkt.eu