[Building Sakai] Problem with column: answertext, table: sam_itemgrading_t

[Karen Tsao]

Hi Jehan,

Does this happen to all your assessments or a particular one? Can you
reproduce this consistently? If you can, please send me the assessment XML
and the steps to reproduce these warnings.

Also, can you turn the hibernate log on:
hibernate.show_sql=true

I would like to see which sql causing this error.

Thanks,
Karen

On Tue, May 15, 2012 at 12:01 AM, Jehan Badshah <jehan.badshah at nu.edu.pk>wrote:

> Dear Karen Tsao
>
> Please see attached tomcat log.
> I am getting following error
>
> WARN http-8080-9
> org.sakaiproject.tool.assessment.services.PersistenceService - Error saving
> to db...retry again....
>
> On Tue, May 15, 2012 at 4:05 AM, Karen Tsao <ktsao at stanford.edu> wrote:
>
>> Hi Jehan,
>>
>> I just ran your query in my dev instance and it is done within one
>> second. But it is very possible because I have way less data then you have.
>> However, I have to say we don't expect users run UPDATE query filtered by
>> agentid because agentid column is not indexed.
>>
>> If it takes long time from Samigo UI, can you please check if you have
>> the up to date database statistics?
>>
>> Thanks,
>> Karen
>>
>> On Mon, May 14, 2012 at 6:16 AM, Jehan Badshah <jehan.badshah at nu.edu.pk>wrote:
>>
>>> Dear All
>>>
>>> I am using database oracle 9i.
>>>
>>> I have problem with column: *answertext*, table: *sam_itemgrading_t*
>>>
>>> I can't update its data using query
>>> update  *sam_itemgrading_t*
>>> set  *answertext* =''
>>> where agentid like 'abc'
>>>
>>> my sql developer is hanging/halting for endless time.
>>>
>>>
>>> Even it is halting for some time when I want to see DDL of that table
>>> using sqldeveloper
>>>
>>> Problem raised when I took descriptive test of some students, they
>>> entered about 1500 to 3000 characters in CLOB column  *answertext.*
>>> some students test were stucked and they unable to move next question.
>>>
>>> following is DDL query
>>>
>>> CREATE TABLE "SAM_ITEMGRADING_T"
>>>   (
>>>
>>> .........
>>> ANSWERTEXT CLOB
>>> ).................
>>>   TABLESPACE "MYTEST" LOB
>>>   (
>>>     "ANSWERTEXT"
>>>   )
>>>
>>>   STORE AS
>>>   (
>>>     TABLESPACE "MYTEST" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
>>>   ) ;
>>>
>>>
>>>
>>> Regards
>>> ----------------------------------------------------
>>> Jehan Badshah | Sr. Software Engineer & Team Lead
>>> Department of Research & Development
>>> National University of Computer and Emerging Sciences
>>> A.K. Brohi Road, H-11/4, Islamabad
>>> UAN: +92 (0)51 - 111 128 128 ext 344
>>>
>>>
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
>>
>>
>
>
> --
>
> Regards
> ----------------------------------------------------
> Jehan Badshah | Sr. Software Engineer & Team Lead
> Department of Research & Development
> National University of Computer and Emerging Sciences
> A.K. Brohi Road, H-11/4, Islamabad
> UAN: +92 (0)51 - 111 128 128 ext 344
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120515/74c59974/attachment.html