Last modified: 2014-01-03 16:13:01 UTC
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)
------------------------------------------------------------------------------- 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