Last modified: 2014-11-17 16:30:40 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 T74908, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 72908 - Replication behind or missing records
Replication behind or missing records
Status: NEW
Product: Wikimedia Labs
Classification: Unclassified
General (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Sean Pringle
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-11-03 16:05 UTC by Dan Andreescu
Modified: 2014-11-17 16:30 UTC (History)
16 users (show)

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


Attachments

Description Dan Andreescu 2014-11-03 16:05:10 UTC
A user that registered on October 27 is still not showing up in labsdb as of this writing.  They show up in analytics-store on the cswiki database:

use cswiki;
select user_id, user_registration from user where user_name = 'VlaMaul';
Comment 1 vojtech.dostal@wikimedia.cz 2014-11-03 16:24:32 UTC
Strangely, many students before and after the problematic cases are easy to import into the cohort. I wonder why some work and some do not - that may be a key to the problem.
Comment 2 vojtech.dostal@wikimedia.cz 2014-11-15 13:14:07 UTC
An update on my problem available here. 

https://outreach.wikimedia.org/wiki/Talk:Education/Wikimetrics#Usernames_on_Czech_Wikipedia_often_not_working_for_me

In the current situation, Czech Wikipedia cannot use Wikimetrics at all. May be a problem between the chair and the computer though, I do not automatically blame the machines.
Comment 3 nuria 2014-11-17 15:47:42 UTC
Actually the initial user shows now in labsdb just fine (replication issue must have been solved)

MariaDB [cswiki_p]> select user_id, user_registration from user where user_name = 'VlaMaul';
+---------+-------------------+
| user_id | user_registration |
+---------+-------------------+
|  272895 | 20141027180854    |
+---------+-------------------+
Comment 4 nuria 2014-11-17 16:01:35 UTC
But other users on the cohort do not appear on labs but appear in production, for example, this user only shows up in prod:

mysql:research@analytics-store.eqiad.wmnet [cswiki]> select user_id, user_registration from user where user_name = 'Špunt35';
+---------+-------------------+
| user_id | user_registration |
+---------+-------------------+
|  273720 | 20141103161025    |
+---------+-------------------+
1 row in set (0.00 sec)


Assigning this bug to our dba as it points to a replication issue.
Comment 5 vojtech.dostal@wikimedia.cz 2014-11-17 16:30:40 UTC
Thank you. You are right, VlaMaul is all right now, but 18 new users are not working.

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


Navigation
Links