[gradebook2-dev] Unique constraint violation on GRADE_RECORD_T

[Geng, Kelly]

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}
-------------- next part --------------
A non-text attachment was scrubbed...
Name: catalina.out.gb2_ora0001
Type: application/octet-stream
Size: 3291700 bytes
Desc: catalina.out.gb2_ora0001
Url : http://collab.sakaiproject.org/pipermail/gradebook2-dev/attachments/20111220/163f99d5/attachment-0001.obj