[Deploying Sakai] Assignments: submission edition lock

Jean-Francois Leveque jean-francois.leveque at upmc.fr
Fri Jan 21 01:58:30 PST 2011


I'm running a 2.7.0 with 2.7.1 or later updates.

The difference with
https://jira.sakaiproject.org/browse/SAK-11389 is that the user could 
not grade. The user was able to publish the grades that were already set 
and has added another column in the gradebook in order to set the grade 
for this student.

The problem happened late two days ago, was under the care of support 
yesterday and today I cannot find a lock in SAKAI_LOCKS:
mysql> select count(*) from SAKAI_LOCKS;
| count(*) |
|        0 |
1 row in set (0.00 sec)


Maybe this is too late to find something in SAKAI_LOCKS because of the 
publication of grades to the gradebook or some other thing that might 
have removed the lock. Daily server restarts have cleaned the caches 
twice already, AFAICT.

Is there anything else I should check now?



Zhen Qian a écrit :
> Jean-Francois:
> What version of Sakai are you running?
> This might be similar to the previous reported 
> JIRA: https://jira.sakaiproject.org/browse/SAK-11389
> You can either clear the stale locks from SAKAI_LOCKS table 
> (https://confluence.sakaiproject.org/display/DOC/Clearing+Stale+Locks) 
> or, as admin, reset the caches in Memory tool (might slow production 
> system down right afterwards).
> Thanks,
> - Zhen
> On Thu, Jan 20, 2011 at 4:53 AM, Jean-Francois Leveque 
> <jean-francois.leveque at upmc.fr <mailto:jean-francois.leveque at upmc.fr>> 
> wrote:
>     Hi all,
>     One of our users cannot grade an assignment because of a kind of lock in
>     submission edition. He gets the following message:
>     Alert: Someone else is editing this submission.
>     How do we check when the lock was created?
>     How do we unlock when the lock is, for example, more than one day old?
>     Cheers,
>     J-F
>     --
>     Jean-Francois Leveque
>     Australe CTO (local Sakai)
>     University Pierre and Marie Curie
>     France

More information about the production mailing list