ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthieu Riou" <matth...@offthelip.org>
Subject Re: Database Size
Date Fri, 23 May 2008 02:03:31 GMT
On Thu, May 22, 2008 at 6:41 PM, Vipul Sabhaya <vipulsabhaya@hotmail.com>
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: matthieu@offthelip.org
> > To: user@ode.apache.org
> > 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 <matthieu@offthelip.org>
> > 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 <boisvert@intalio.com>
> > > 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 <
> vipulsabhaya@hotmail.com>
> > >> 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: ciaranj@gmail.com
> > >> > > To: user@ode.apache.org
> > >> > > Subject: Re: Database Size
> > >> > >
> > >> > > On Thu, May 22, 2008 at 7:23 PM, Vipul Sabhaya <
> > >> vipulsabhaya@hotmail.com
> > >> > >
> > >> > > 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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message