[gradebook2-dev] Unique constraint violation on GRADE_RECORD_T

[Jon Gorrono]

Hi, Kelly


Could you plz post the result of the following query run in the
'SAKAI_2' schema?

select * from user_constraints where CONSTRAINT_NAME ='SYS_C0010870'



On Tue, Dec 20, 2011 at 6:48 PM, Geng, Kelly <gengx at muohio.edu> wrote:
> Here it is.
>
>
> Thanks,
> Kelly
>
>
> -----Original Message-----
> From: Jon Gorrono [mailto:jpgorrono at ucdavis.edu]
> Sent: Tuesday, December 20, 2011 6:02 PM
> To: Geng, Kelly; gradebook2-dev at collab.sakaiproject.org
> Subject: Re: [gradebook2-dev] Unique constraint violation on GRADE_RECORD_T
>
> When we have seen this error, it has been after a database restore or copy  ... in that process the sequences used to set id's for objects have current values that are too low: lower that than largest id values in the respective tables...
>
> Quick fix, than, is to increment the sequences by some sufficiently large number like 50k or 100k or ?
>
> On Tue, Dec 20, 2011 at 8:11 AM, Thomas Amsler <tpamsler at ucdavis.edu> wrote:
>> Do you have a catalina.out stack trace for this error, and if so, can
>> you please send it?
>>
>> Best,
>> -- Thomas
>>
>> On Tue, Dec 20, 2011 at 7:30 AM, Geng, Kelly <gengx at muohio.edu> wrote:
>>> During this morning, the last minute of grade submission here, we are experiencing some gradebook2 loading failure sporadically and access slowdown occasionally. From the log the most apparently relevant error is a ORA-00001: unique constraint violation on GRADE_RECORCD_T table . Anyone can shed any light on this?
>>>
>>>
>>> Kelly Geng
>>> Miami University
>> _______________________________________________
>> gradebook2-dev mailing list
>> gradebook2-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/gradebook2-dev
>
>
>
> --
> Jon Gorrono
> PGP Key: 0x5434509D -
> http{pgp.mit.edu:11371/pks/lookup?search=0x5434509D&op=index}
> GSWoT Introducer - {GSWoT:US75 5434509D Jon P. Gorrono <jpgorrono - www.gswot.org>} http{middleware.ucdavis.edu}



-- 
Jon Gorrono
PGP Key: 0x5434509D -
http{pgp.mit.edu:11371/pks/lookup?search=0x5434509D&op=index}
GSWoT Introducer - {GSWoT:US75 5434509D Jon P. Gorrono <jpgorrono -
www.gswot.org>}
http{middleware.ucdavis.edu}