[Building Sakai] Sakai_locks table

[Maurer, Christopher Wayne]

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-a06f8706
9dfa    8/22/2007 7:21:04 PM    (null)
MAILARCHIVE_MESSAGE
/mailarchive/channel/1093893883327-759/main/7e29bd94-a77f-440c-8019-feb95975
5f34    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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090911/603f25cc/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2141 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090911/603f25cc/attachment.bin