ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sathwik B P <sathwik...@gmail.com>
Subject Re: Re: Re:Re: Management API function be blocked until all the instances run to the end
Date Mon, 21 Apr 2014 07:28:48 GMT
Hi Vito,

Can you file a Jira for Postgres with openjpa.
Kindly include your configurations for bitronix, ode-axis2.properties along
with exact version of ODE, Postgres used and if possible the process
definition. Also the description of the problem you faced.

Let me try replicating the environment.

regards,
sathwik


On Mon, Apr 21, 2014 at 9:55 AM, Vito <testforvln@163.com> wrote:

> Hi Sathwik,
>
>
> Thank you for your reply.
>
>
> I'm working on both Mysql and Postgres. The problem with isolation level
> happened on Postgres with openjpa. I tried the explicit setting of the
> isolation level, but it didn't solve the problem. So I used hibernate both
> on Mysql and Postgres.
> I slowed down all the requests on both databases, and they succeeded to
> function well most of the time except for some transaction-intensive
> periods.
>
>
> regards,
> Vito
>
>
>
>
> At 2014-04-18 13:33:24,"Sathwik B P" <sathwik.bp@gmail.com> wrote:
> >Hi Vito,
> >
> >I was on vacation and hence could not respond.
> >
> >Are you on Mysql or Postgres?
> >
> >I suspect that bitronix might be using the default isolation setting of
> the
> >underlying database. Try with explicit setting of the isolation level in
> >resource.properties file and let us know how it goes.
> >
> >regards,
> >sathwik
> >
> >
> >On Thu, Mar 27, 2014 at 10:38 PM, Tammo van Lessen <tvanlessen@gmail.com
> >wrote:
> >
> >> Hi Vito,
> >>
> >> the PMAPI runs in a transaction as well, but actually I should run
> smoothly
> >> between process instances. Are your instances long or short running? Are
> >> you using a synchronous request response operation? Without the
> transaction
> >> manager you will probably run into weird situations like race conditions
> >> when using message correlation, so this is actually not an option.
> >>
> >> Best,
> >>   Tammo
> >>
> >>
> >> On Thu, Mar 27, 2014 at 9:26 AM, Vito <testforvln@163.com> wrote:
> >>
> >> > Hi all,
> >> >
> >> > These days I tried to invoke listInstancesSummary functions of
> Management
> >> > API after invoke many instances, but the functions were all blocked
> until
> >> > all the instances ran to the end. I thought of abandoning the bitronix
> >> > transaction manager, and it works. The functions are not blocked any
> >> more.
> >> > Do you know why bitronix block my functions, and can I do some
> >> modification
> >> > to the bitronix configuration in ODE?
> >> >
> >> > Regards,
> >> > Vito
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > At 2014-03-25 19:54:51,Vito <testforvln@163.com> wrote:
> >> > >Hi Sathwik,
> >> > >
> >> > >Actually I did not solve the problem of combining openjpa and
> >> postgresql,
> >> > and the two communities also did not give me much information of the
> >> > problem. What I do is to use hibernate DAO to combine ODE and
> postgresql,
> >> > and it's working just fine.
> >> > >
> >> > >The listInstancesSummary function is already in the Management API.
I
> >> > just invoked it and found it blocked sometimes when I had many
> instances
> >> > running. After looking into the ODE source code, I find that the
> function
> >> > listAllInstances() actually have little difference from
> >> > listInstancesSummary(), while the former function have few filters
> than
> >> the
> >> > latter.
> >> > >
> >> > >Have you met with the problem that the Management API be blocked? I
> >> think
> >> > it may be caused by some transaction problems.
> >> > >
> >> > >Regards,
> >> > >Vito
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >At 2014-03-25 17:02:24,"Sathwik B P" <sathwik.bp@gmail.com> wrote:
> >> > >>Vito,
> >> > >>
> >> > >>Good to know you could solve the issue with Postgresql. It would
be
> >> great
> >> > >>if you could help the community know about the changes you did
to
> make
> >> it
> >> > >>work :)
> >> > >>
> >> > >>You might have a look at listAllInstances which will list all the
> >> > instances.
> >> > >>
> >> > >>What is the query that used in listInstancesSummary?
> >> > >>
> >> > >>regards,
> >> > >>sathwik
> >> > >>
> >> > >>
> >> > >>On Tue, Mar 25, 2014 at 11:33 AM, Vito <testforvln@163.com>
wrote:
> >> > >>
> >> > >>> Hi all,
> >> > >>> Thank you for your kindly help these days. I just make ODE
up and
> >> > running
> >> > >>> with mysql and postgresql finally! But when I try some
> experiments,
> >> > other
> >> > >>> problems seem to come up. Actually, it may not be called an
error
> >> > because
> >> > >>> there is no error or exception.
> >> > >>> The problem came out when I ran multiple instances. It met
no
> problem
> >> > >>> until I try to list instances summary from ODE Management
API to
> get
> >> > the
> >> > >>> instance number in the engine. The list function returned
no
> results
> >> > until
> >> > >>> all the instances ran to the end. I think it may be blocked
by the
> >> > >>> transactions of running instances.
> >> > >>> Do you think the transactions really block the management
api
> >> > function? If
> >> > >>> this really happens, how can I get the number of instance
number
> of
> >> the
> >> > >>> current engine?
> >> > >>> Best,
> >> > >>> Vito
> >> > >>>
> >> >
> >>
> >>
> >>
> >> --
> >> Tammo van Lessen - http://www.taval.de
> >>
>

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