ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vipul Sabhaya <vipulsabh...@hotmail.com>
Subject RE: Database Size
Date Fri, 23 May 2008 01:41:46 GMT

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: 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