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

Tue May 15 00:01:30 PDT 2012

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/47d88270/attachment.html 
-------------- next part --------------
2012-05-15 11:44:11,424  INFO http-8080-2 org.sakaiproject.tool.su.SuTool - [SuT
ool] Username admin becoming i1009x7
2012-05-15 11:44:13,502  INFO http-8080-4 org.apache.myfaces.shared_impl.config.
MyfacesConfig - Tomahawk jar not available. Autoscrolling, DetectJavascript, Add
ResourceClass and CheckExtensionsFilter are disabled now.
2012-05-15 11:44:13,502  INFO http-8080-4 org.apache.myfaces.shared_impl.config.
MyfacesConfig - Starting up Tomahawk on the MyFaces-JSF-Implementation
2012-05-15 11:44:38,158  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.PRETTY_HTML' f
ound, using default value true
2012-05-15 11:44:38,158  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.ALLOW_JAVASCRI
PT' found, using default value true
2012-05-15 11:44:38,158  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.READONLY_AS_DI
SABLED_FOR_SELECTS' found, using default value true
2012-05-15 11:44:38,158  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.DETECT_JAVASCR
IPT' found, using default value false
2012-05-15 11:44:38,158  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.AUTO_SCROLL' f
ound, using default value false
2012-05-15 11:44:38,174  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.ADD_RESOURCE_C
LASS' found, using default value org.apache.myfaces.renderkit.html.util.DefaultA
ddResource
2012-05-15 11:44:38,174  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.RESOURCE_VIRTU
AL_PATH' found, using default value /faces/myFacesExtensionResource
2012-05-15 11:44:38,174  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - No context init parameter 'org.apache.myfaces.CHECK_EXTENSIO
NS_FILTER' found, using default value true
2012-05-15 11:44:38,174  INFO http-8080-5 org.apache.myfaces.shared_tomahawk.con
fig.MyfacesConfig - Starting up Tomahawk on the RI-JSF-Implementation.
2012-05-15 11:45:07,361  WARN SakaiClusterService.Maintenance org.sakaiproject.c
luster.impl.SakaiClusterService - run(): ghost-busting server: localhost-1337061
629346 from : localhost-1337063735486
2012-05-15 11:45:07,408  INFO SakaiClusterService.Maintenance org.sakaiproject.c
luster.impl.SakaiClusterService - Closed 2 orphaned usage session records
2012-05-15 11:46:35,627  WARN http-8080-3 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:35,627  WARN http-8080-3 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:35,627  WARN http-8080-3 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:36,596  WARN http-8080-4 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:36,611  WARN http-8080-4 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:36,627  WARN http-8080-4 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:37,783  WARN http-8080-2 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:37,783  WARN http-8080-2 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:37,783  WARN http-8080-2 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:38,549  WARN http-8080-1 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:38,565  WARN http-8080-1 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:38,565  WARN http-8080-1 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:39,783  WARN http-8080-6 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:39,783  WARN http-8080-6 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:39,783  WARN http-8080-6 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:40,768  WARN http-8080-7 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:40,783  WARN http-8080-7 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:40,783  WARN http-8080-7 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:41,408  WARN http-8080-8 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:41,408  WARN http-8080-8 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:41,408  WARN http-8080-8 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:42,361  WARN http-8080-9 org.sakaiproject.tool.assessment.facad
e.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading:
 Illegal attempt to associate a collection with two open sessions; nested except
ion is org.hibernate.HibernateException: Illegal attempt to associate a collecti
on with two open sessions
2012-05-15 11:46:42,377  WARN http-8080-9 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:42,377  WARN http-8080-9 org.sakaiproject.tool.assessment.servi
ces.PersistenceService - Illegal attempt to associate a collection with two open
 sessions; nested exception is org.hibernate.HibernateException: Illegal attempt
 to associate a collection with two open sessions
2012-05-15 11:46:43,096  WARN http-8080-10 org.sakaiproject.tool.assessment.faca
de.AssessmentGradingFacadeQueries - problem inserting/updating assessmentGrading
: Illegal attempt to associate a collection with two open sessions; nested excep
tion is org.hibernate.HibernateException: Illegal attempt to associate a collect
ion with two open sessions
2012-05-15 11:46:43,096  WARN http-8080-10 org.sakaiproject.tool.assessment.serv
ices.PersistenceService - Error saving to db...retry again....
2012-05-15 11:46:43,096  WARN http-8080-10 org.sakaiproject.tool.assessment.serv
ices.PersistenceService - Illegal attempt to associate a collection with two ope
n sessions; nested exception is org.hibernate.HibernateException: Illegal attemp
t to associate a collection with two open sessions