[Building Sakai] Sakai_locks table

[Matthew Jones]

Perhaps this confluence page helps?
http://confluence.sakaiproject.org/display/DOC/Clearing+Stale+Locks

On Fri, Sep 11, 2009 at 3:29 PM, Maurer, Christopher Wayne
<chmaurer at iupui.edu> wrote:
> I just want to make sure that I’m remembering how this works correctly...the
> stuff in the sakai_locks table isn’t meant for any sort of long-term
> locking, is it?
> I’ve got a handful of old records in there and I want to make sure there
> isn’t any harm in removing them...
>
> CONTENT_COLLECTION    /attachment/54aeac2a-66d2-46a7-007c-90812f6756f8/
>    12/1/2006 9:36:20 PM    (null)
> CONTENT_RESOURCE    /group/PortfolioAdmin/system/contentOverText.jpg
>    3/1/2007 8:02:21 PM    (null)
> CONTENT_COLLECTION    /group/7ee9b602-ab14-4643-8008-0ad408bfd1e4)/Podcasts/
>    7/29/2007 9:27:18 AM    (null)
> MAILARCHIVE_MESSAGE
>    /mailarchive/channel/1093893883327-759/main/8327be96-8735-4ca1-8003-a06f87069dfa
>    8/22/2007 7:21:04 PM    (null)
> MAILARCHIVE_MESSAGE
>    /mailarchive/channel/1093893883327-759/main/7e29bd94-a77f-440c-8019-feb959755f34
>    8/27/2007 7:10:16 PM    (null)
> CONTENT_COLLECTION    /attachment/a01b38ee-6454-4633-801b-7b3e427df649/
>    9/10/2007 5:08:40 PM    (null)
> ANNOUNCEMENT_CHANNEL
>    /announcement/channel/~483dc4d9-e78e-44bd-87e2-1374f0a8ceef/main
>    9/16/2008 2:32:24 AM    (null)
> SAKAI_USER    b02349e3-c2e2-4862-88c1-3929cacc774d    6/6/2009 10:07:45 PM
>    (null)
> SAKAI_DIGEST    nsabine    9/1/2009 8:08:15 PM    (null)
>
>
> As you can see some from 2006 and 2007!  Junk that can be removed?
> The main reason why I ask is that I see a constraint violation for that
> table every now and then when the mail digester runs and also on startup
> when doing something with collections.
>
> Chris
> _______________________________________________
> 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"
>