Forum .LRN Q&A: Assessment is killing our .LRN.

Posted by Dario Roig on
Hi guys! we have many problems with package assessments. The package have lots of options and two features very important to us: the first autocorrection with score and feedback, the second import/export in format QTI. However, it has some disadvantages, when the professor open one assessment to 20 or 30 students in classroom and the students send at the same time their responses generate deadlocks in the database and all system down.

Valencia University instalation:
Postgresql: 8.2.10
Aolserver: 4.5.0

- Change assessment by survey. We are thinking development the features similars to assessment in survey.
- Modify assessment to avoid big transactions

Has anybody the same problem with assessment?


Posted by Gustaf Neumann on
What version of OpenACS are you using?

In case, you are not using the most recent content-repository, you should consider the following change

Please report back, if this helps
-gustaf neumann

Posted by Dario Roig on
Hi Gustaf! I've done a diff with our code and we have the same version. The line "db_dml lock_objects "LOCK TABLE acs_objects IN SHARE ROW EXCLUSIVE MODE"" is commented.

Thanks for your fast response, We will find solutions and We will post in this post!!

Posted by Hector Amado on
Hi Dario!, if you have log messages like:
Warning: db_exec: longdb 10594180 nsdb0 select .... get_sorted_choices ...
get_sorted_choices_with_feedback ....

make sure you have this update:
rev 1.5

Best Regards,

Posted by Dario Roig on
Hi Hector!
In this link you can view our file

We have rewritten this select for best performance.

Thanks by advice

Posted by Hector Amado on
Hi Dario! , you can test with the new revision in as-item-type-mc-procs.tcl, this is for multiple choice questions.
Try updating assessment package.

In the new revision you don't use r2.revision_id as content_rev_id, r2.title as content_filename and i.content_type

Best regards,