On Thu, May 22, 2008 at 6:41 PM, Vipul Sabhaya <[EMAIL PROTECTED]> wrote:
> > 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. I think it's more a question of the script being for the Hibernate persistence layer and not OpenJPA. I don't have one for OpenJPA handy but you can just rename the tables, it should be fairly easy. Cheers, Matthieu > > - 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
