[Toolserver-l] No user_properties table on arwiki_p database
First of all thanks for toolserver, it's a great service! (I posted this question on jira as well but I'm not sure I found a way to assign it to someone and so if anyone saw it. The issue on Jira is at https://jira.toolserver.org/browse/DBQ-202 ) 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 -- -- Paolo Massa Email: paolo AT gnuband DOT org Blog: http://gnuband.org ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] Error in Revision Table in lbwiki
Hello, At Saturday 16 March 2013 01:41:47 DaB. wrote: Hi all, I have a script running collecting data in multiple wikipedia(s), I started to notice that revision table in lbwiki_p has some incorrect data. Here is an example: mysql select rev_id, rev_user, rev_page, rev_deleted, rev_len, rev_timestamp from revision where rev_id = 185751; ++--+--+-+-++ | rev_id | rev_user | rev_page | rev_deleted | rev_len | rev_timestamp | ++--+--+-+-++ | 185751 | 580 |83446 | 0 |NULL | 20061203231418 | ++--+--+-+-++ The result is correct. According to my understanding if a record exist rev_len shouldn't be NULL, if the revision deleted then rev_deleted should get flag but rev_length should remain as it is. Hope someone can look into this, because people who are doing analysis might end up getting wrong results. rev_lenght will remain as it is – the problem is that rev_lenght was not there from the very beginning and was never (AFAIK) back-populated; so very old rows has no lenght and are NULL. Best; -- Anuradha Uduwage (Anu) Sincerely, DaB. -- Userpage: [[:w:de:User:DaB.]] — PGP: 0x2d3ee2d42b255885 signature.asc Description: This is a digitally signed message part. ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] No user_properties table on arwiki_p database
Hello, At Saturday 16 March 2013 01:49:12 DaB. wrote: First of all thanks for toolserver, it's a great service! (I posted this question on jira as well but I'm not sure I found a way to assign it to someone and so if anyone saw it. The issue on Jira is at https://jira.toolserver.org/browse/DBQ-202 ) That's the wrong queue. DBQ is for non-ts-people to get sql-query running. If you have a problem wit the toolserver use the TS-queue. 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 ;( I fixed the problem. But at least for me your mail was here 18 minutes before Saturday – please notice we do not offer time-travels yet. 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! Sincerely, DaB. -- Userpage: [[:w:de:User:DaB.]] — PGP: 0x2d3ee2d42b255885 signature.asc Description: This is a digitally signed message part. ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Re: [Toolserver-l] Error in Revision Table in lbwiki
DaB. wrote: rev_lenght will remain as it is – the problem is that rev_lenght was not there from the very beginning and was never (AFAIK) back-populated; so very old rows has no lenght and are NULL. Related: https://bugzilla.wikimedia.org/show_bug.cgi?id=12188. MZMcBride ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette