[Building Sakai] cannot delete locked resource item

[Zhen Qian]

Thank you both for the suggestions.

We are running 2.9.2. It turns out this was a different problem. Here is
the error message inside the log file:

"2015-01-21 21:02:10,797 [ajp-apr-127.0.0.1-8009-exec-1] WARN
 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code:
12899 sql: insert into CONTENT_RESOURCE_DELETE
(RESOURCE_ID,IN_COLLECTION,CONTEXT,FILE_SIZE,RESOURCE_TYPE_ID,FILE_PATH,RESOURCE_UUID,DELETE_DATE,DELETE_USERID,BINARY_ENTITY,
XML) values ( ?,  ?, ?, ?, ?, ?, ? ,? ,? ,?, NULL) binds:  <resource_id>
<collection_id> 07fe5aa3-4141-4c70-9d64-8b28a3fddfdb 37376
org.sakaiproject.content.types.fileUpload
/fs2014/2014/357/14/1d25328d-b8a5-4d4c-9e1a-ce6da64a3fb5
6b360d81-7639-4353-b8ea-395f513ab4b2 20150122020210796
java.sql.SQLException: ORA-12899: value too large for column
"CTOOLS_USER"."CONTENT_RESOURCE_DELETE"."RESOURCE_ID" (actual: 256,
maximum: 255)"

The solution without change the content_resource_delete table schema is to
move the to_be_deleted folder into a shorter-titled parent folder, and then
deletion from the new location finished successfully.

Thanks,

- Zhen

On Mon, Jan 19, 2015 at 9:57 AM, Juan José Meroño Sánchez <jjmerono at um.es>
wrote:

> I think this jira solves this kind of issues:
>
> https://jira.sakaiproject.org/browse/KNL-1194
>
> Bye.
>
> El 19/1/2015, a las 15:28, Adam Marshall <adam.marshall at it.ox.ac.uk>
> escribió:
>
> We had this – something to do with WebDAV locking the file??
>
> adam
>
> --
>
> ** Note change of email address to adam.marshall at it.ox.ac.uk **
>
> Dr A C Marshall, WebLearn Service Manager, University of Oxford.
> IT Services, 13 Banbury Rd, Oxford. OX2 6NN.
>
>
> *From:* sakai-dev-bounces at collab.sakaiproject.org [
> mailto:sakai-dev-bounces at collab.sakaiproject.org
> <sakai-dev-bounces at collab.sakaiproject.org>] *On Behalf Of *Zhen Qian
> *Sent:* 19 January 2015 13:55
> *To:* sakai-dev
> *Subject:* [Building Sakai] cannot delete locked resource item
>
>
> Hi, all:
>
> We have a problem deleting resource or folder items in Sakai, and got the
> following alert message:
> Alert: The resource <resource/collection name> is locked and cannot be
> deleted.
>
>
> I have checked both content_resource_lock and sakai_locks tables, but
> cannot locate any related records.
>
> Any suggestions?
>
> Thanks,
> - Zhen
> _______________________________________________
> 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"
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20150121/ddcb0d18/attachment.html