Page MenuHomePhabricator

DB error on enrollment
Closed, ResolvedPublic

Description

After enrolling, and adding a Real Name, I get the error:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "ORMRow::insert". Database returned error "1062: Duplicate entry '1746' for key 'ep_students_user_id' (10.64.16.8)".


Version: master
Severity: normal

Details

Reference
bz44365

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:13 AM
bzimport set Reference to bz44365.
bzimport added a subscriber: Unknown Object (MLST).

Tried a bunch of things and could not reproduce. Where are you seeing this? Can you provide a more detailed stack trace? Or more detailed instructions on how to reproduce?

  • Bug 43781 has been marked as a duplicate of this bug. ***

Hi Jeroen,

Sage gave me a code to enroll on test2wiki. After putting in my token, the next page (iirc) asked for the optional full name and gender. I added my full name, did not add a gender, and submitted the form. The original comment on this bug was the error message that was shown. I did not get a stack trace from the server.

  • Bug 44519 has been marked as a duplicate of this bug. ***

Copying from bug 44519:

Wed Jan 30 19:39:43 UTC 2013 mw1033 enwiki ORMRow::insert 10.64.16.6
1062 Duplicate entry '18357919' for key 'ep_students_user_id' (10.64.16.6)
INSERT INTO ep_students
(student_id,student_user_id,student_first_enroll,student_first_course,student_last_enroll,student_last_course)
VALUES (NULL,'18357919','20130130193943','8','20130130193943','8')

I can still not reproduce this. Perhaps the issue no longer exists on master?

Follow the steps specified by Chris, except filling in the real name, as this field is no longer there.

Can someone confirm this is still occurring after a0bc093633cad19e5e7f99598ad899b4c4c7fb18 or later got deployed?

Chris / Aaron: Can someone confirm this is still occurring after
a0bc093633cad19e5e7f99598ad899b4c4c7fb18 or later got deployed?

This commit touches relevant code and fixes a s bug in it, so might also fix this issue: https://gerrit.wikimedia.org/r/#/c/49654/

Haven't seen this in a long while, so it appears to have gotten fixed.