AnsweredAssumed Answered

Strange System error of Space deletion

Question asked by bensonfungjava on Nov 26, 2011
Latest reply on Dec 15, 2011 by mitpatoliya
Hi,

I inserted more than 80000 records in a single space under 'Company Home' space for doing load test of Alfresco.  Then I delete the space by clicking the trash bin icon of the single space.  Then it started to delete, however, after a while, the screen displays system error.  Please help what happen to this product.  And please teach me how to fix this problem.

I have attached the system error screenshot for investigation.


Thanks

[img]file:///home/benson/docs/Masterson/MIH/Alfresco%20system%20error.png[/img]

I don't how to add the screenshot attachment.  I pasted the system error message below just in case.

Please correct the errors below then click OK.

    Unable to delete Space due to system error: Hibernate operation: could not update: [org.alfresco.repo.domain.hibernate.NodeImpl#9008533]; SQL [update alf_node set version=?, store_id=?, uuid=?, transaction_id=?, node_deleted=?, type_qname_id=?, acl_id=?, audit_creator=?, audit_created=?, audit_modifier=?, audit_modified=?, audit_accessed=? where id=? and version=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

Outcomes