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';
Version: unspecified
Severity: normal
vojtech.dostal wrote:
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.
vojtech.dostal wrote:
An update on my problem available here.
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.
vojtech.dostal wrote:
Thank you. You are right, VlaMaul is all right now, but 18 new users are not working.
It looks like this got resolved at some point because all the given example rows show up and select count(*) from user returns the same regardless of whether you ask the cswiki (s2) master in production, labsdb1001, labsdb1002 or labsdb1003.
thanks @Krenair, hopefully the underlying issues that caused the missing data are fixed as well.