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 00:05:18 GMT
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
>>
>
>

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