Strange System error of Space deletion

[bensonfungjava]

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

[mitpatoliya]

Hi,
I have faced the same problem that once you place more then some number of content in you one space it does not behave properly.
Actually there are several limitations imposed like hibernate batch query size limitation.Lucene search result size limitation.
All of this makes it very difficult to manage this situation.
What alfresco recommends is to divide the contents in sub spaces.It will give you better performance.