System seems to be completely hosed after import&delete

[sacco]

In the course of trying to discover whether there was anything
further to report about:
WCM-817,
I imported the Alfresco Sample Web Project into the WCM and later
deleted it.

Subsequently I've seen numerous strange errors: in particular,
it is now impossible to Bulk Import the Sample Website again.
The errors can vary, but are frequently something like (it's almost always a
"system error happened during the operation"):

Please correct the errors below then click OK.

    * A system error happened during the operation: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.alfresco.repo.avm.PlainFileNodeImpl#1968]

I've tried removing and recreating everything up the to entire'Web Projects'
section, exporting & re-importing, etc. but to absolutely no avail.

The only remaining options I can think of are either to start doing surgey
directly on the database, or else to trash the entire repositoy and rebuild
it from scratch.  It seems a rather drastic, but I can't see any other alternatives.

Are there no tools for scanning the repository to preen out stale transactions and inconsistencies.
(There is also a piece of workflow that I can neither progress nor delete).

[sacco]

Selecting OK after the above error apparently tries to repeat the import:

Please correct the errors below then click OK.

    * A system error happened during the operation: Child exists: WEB-INF

although selecting 'Cancel' has often given me the somthing almost
identical.

The import is not complete though.

Trying subsequenlty  to investigate what has happened and
find out how much succeeded and what failed through CIFS,
can seemingly lead to so many internal errors that my machine
struggles just under the weight of logging them (I've had to
delete around 8Gb of error logs so far today).


Has anybody got any idea how I can get this fixed, or is my
only option to can the whole prototype and rebuild from
scratch?

[filipemingau]

I got the same kind of error too. Sometimes (yes, completely random) when i delete a folder or file and try to create it again (with the same name), i get the message:

Error : A system error happened during the operation: Child exists "filename"

Even if nobody knows how to fix this bug, i need to force the file to be deleted so i can create another with the same name, anybody knows how can i find and full remove (disk and DB) the file/folder based only in it's name?