Clearing failed transaction leftovers...

Jeff Hillier <[email protected]> Fri, 19 Oct 2007 12:44:20 -0700
Newsgroups gmane.comp.jakarta.slide.user
Message-ID <[email protected]>
Hi all-

We've been using slide to manage publishing files to our web sites 
for about 6 months now and everything is working very well.

We are using the J2ee store backed by an oracle DB for the nodeStore 
and a TxFileContentStore for the file store.

Our users move files from a staging environment to a production 
environment via a custom app that uses slide to move the files in a 
transaction. In addition to moving the files we collect metadata 
about the request from various places and store it in our local database.

On rare occasions these transactions fail (due to various reasons, 
other db's down etc) which seems to leave slide in an unclean state.. 
ie our "work" directory has folders in it from these failed 
transactions. While in this state moving files to these folders 
fails, due to what seems to be time outs. When we get into this state 
we have to restart the app servers and slide cleans itself up and 
everything is fine.

after the restart I see in the logs:

WARN 12:33:41,063 (file-content-store.log():110): ---> Could not 
process URI '/'! Thread Thread[Orion Launcher,5,main] marking 
transaction branch [B@1539d49 for rollback

that transaction branch is the one that failed and is a problem, and 
seems to get rolled back.

So is there anyway to manage/fix these type of problems without doing 
a restart? Is there an API to manually access and rollback transactions?

Any ideas on where to start looking would be very much appreciated.


Thanks

JEFF