Hi Matthieu, The Cleanup script that you checked in contains Table Names that do not seem to exist in 1.1 version of ODE.
Ex: BPEL_ACTIVITY_RECOVERY doesn't exist but ODE_ACTIVITY_RECOVERY Table LARGE_DATA does not exist. Is there an updated version of this Script? Thanks. - Vipul > Date: Thu, 22 May 2008 17:05:18 -0700 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: Re: Database Size > > Seems that my file didn't go through, I've committed it so you can find it > here: > > http://svn.apache.org/repos/asf/ode/trunk/dao-hibernate/etc/terminated_processes_cleanup.sql > > Cheers, > Matthieu > > On Thu, May 22, 2008 at 4:55 PM, Matthieu Riou <[EMAIL PROTECTED]> > wrote: > > > Hi, > > > > I attached a little SQL script to this e-mail that does just that. It's > > rather aggressive, cleaning up everything related to a completed instance > > and more, but you can tweak it to your will. What most people do is > > customize the script to remove only what they want to and run it regularly > > (using a cron job or similar). > > > > Cheers, > > Matthieu > > > > > > On Thu, May 22, 2008 at 4:33 PM, Alex Boisvert <[EMAIL PROTECTED]> > > wrote: > > > >> Hi Vipul, > >> > >> In your case, you can run the process "in-memory" > >> http://ode.apache.org/user-guide.html#UserGuide-Inmemoryexecution > >> > >> Otherwise, you have to issue SQL statements to remove the process data > >> from > >> the database... > >> > >> The BPEL <exit> activity just terminates the process. It does not have > >> any > >> bearing on the persistence of process data. > >> > >> alex > >> > >> > >> On Thu, May 22, 2008 at 4:15 PM, Vipul Sabhaya <[EMAIL PROTECTED]> > >> wrote: > >> > >> > > >> > How do you get ODE to remove state of a Process that finished? The 3 > >> > processes I have are pretty simple.. they have the following Sequence: > >> > - Receive > >> > - Invoke > >> > - Reply > >> > - Exit > >> > > >> > I thought Exit would "clean-up" all state associated with a Process -- > >> > doesn't seem like this is happening. Is there something in the > >> Deployment > >> > Descriptor i need to set? > >> > > >> > > >> > <html><P> </P></html> > >> > > >> > > Date: Thu, 22 May 2008 21:46:47 +0100 > >> > > From: [EMAIL PROTECTED] > >> > > To: [email protected] > >> > > Subject: Re: Database Size > >> > > > >> > > On Thu, May 22, 2008 at 7:23 PM, Vipul Sabhaya < > >> [EMAIL PROTECTED] > >> > > > >> > > wrote: > >> > > > >> > > > > >> > > > I am running ODE on a Solaris box within Tomcat. Currently there > >> are 3 > >> > > > BPEL Processes running on this intance which is with each process > >> being > >> > run > >> > > > roughly once per second. > >> > > > > >> > > > The data folder (jpadb) which contains Derby files keeps increasing > >> in > >> > size > >> > > > (already over 2 Gigs)... My question is why are we seeing this? and > >> how > >> > much > >> > > > disk space should be reserved for ODE? > >> > > > >> > > Related to this, is it possible to configure ODE to keep only 'so > >> much' > >> > > data, i.e I don't neccessarily care about processes that > >> > > completed(successfully or otherwise) last week, but I do very much > >> care > >> > > about the last 8 hours or so ? > >> > > - Ciaran > >> > > >> > _________________________________________________________________ > >> > Change the world with e-mail. Join the i'm Initiative from Microsoft. > >> > > >> http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld > >> > > > > _________________________________________________________________ E-mail for the greater good. Join the i’m Initiative from Microsoft. http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ GreaterGood
