Last modified: 2014-11-17 16:30:40 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';
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.
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.
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 | +---------+-------------------+
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.
Thank you. You are right, VlaMaul is all right now, but 18 new users are not working.