https://bugzilla.wikimedia.org/show_bug.cgi?id=59484
Web browser: ---
Bug ID: 59484
Summary: DBQ-202 No user_properties table on arwiki_p database
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: critical
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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. <d...@ts.wikimedia.org>
-------------------------------------------------------------------------------
From: Paolo Massa <pa...@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)
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
