Last modified: 2014-01-03 16:13:01 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 T61484, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59484 - DBQ-202 No user_properties table on arwiki_p database
DBQ-202 No user_properties table on arwiki_p database
Status: RESOLVED FIXED
Product: Tool Labs tools
Classification: Unclassified
Database Queries (Other open bugs)
unspecified
All All
: Unprioritized critical
: ---
Assigned To: Bugzilla Bug Importer (valhallasw)
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-01-03 16:12 UTC by Bugzilla Bug Importer (valhallasw)
Modified: 2014-01-03 16:13 UTC (History)
0 users

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


Attachments

Description Bugzilla Bug Importer (valhallasw) 2014-01-03 16:12:57 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)
Comment 1 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:12:58 UTC
-------------------------------------------------------------------------------
From: Paolo Massa <paolo@gnuband.org>
Date: Thu, 14 Mar 2013 12:38:44
-------------------------------------------------------------------------------

Help, please
Comment 2 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:13:00 UTC
-------------------------------------------------------------------------------
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.
Comment 3 Bugzilla Bug Importer (valhallasw) 2014-01-03 16:13:01 UTC
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

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


Navigation
Links