[Serusers] "serctl moni" shows waiting stateful transactions

[Java Rockx]

No external scripts, but I do use MySQL accounting and auth_db and
uri_db. But I wouldn't think that's anything unusual.

I wonder if I can tell from some mysql tools if there is something hung.

Regards,
Paul


On Sat, 26 Mar 2005 16:19:35 -0600, Matt Schulte <mschulte at netlogic.net> wrote:
> I wonder if its caused from a process hanging even, do you do any
> external scripts, usrloc, or any kind of live db lookups? I do, we're in
> the process of nuking most of our external scripts because some just
> plain take too long and tend to hang up SER on a heavy day.. I would be
> more-so intertested in a module to deal with these 'slow' or runaway
> processes, just as a precautionary statement even. Of course that may be
> unneccesary in the eyes of the beholder :-)
> 
>         Matt
> 
> -----Original Message-----
> From: Java Rockx [mailto:javarockx at gmail.com]
> Sent: Saturday, March 26, 2005 4:03 PM
> To: Matt Schulte
> Cc: serusers at lists.iptel.org
> Subject: Re: [Serusers] "serctl moni" shows waiting stateful
> transactions
> 
> Yes, that is what I'm afraid of. I do all stateful stuff with rr also.
> 
> I'm real concerned about this. I just thought that SER would kill off
> any pending transactions if when the delete_timer expires - so now I
> assume this is not what the delete_timer does.
> 
> I guess I just don't understand what could keep this alive. I've been
> watching my SER all day it the transaction is still there.
> 
> Regards,
> Paul
> 
> On Sat, 26 Mar 2005 15:54:50 -0600, Matt Schulte <mschulte at netlogic.net>
> wrote:
> > Hmm, I get these too after long periods of time. I wonder if there was
> 
> > a 487 or 408 that never got caught (or never replied to..??). I use
> > all stateful too with rr, if that helps.
> >
> >         Matt
> >
> > -----Original Message-----
> > From: Java Rockx [mailto:javarockx at gmail.com]
> > Sent: Saturday, March 26, 2005 1:07 PM
> > To: serusers at lists.iptel.org
> > Subject: [Serusers] "serctl moni" shows waiting stateful transactions
> >
> > Hi All.
> >
> > Occasionally I see a waiting transaction in "serctl moni". These
> > waiting transactions never seem to get processed because they never
> > disappear.
> >
> > Can anyone give a hint as to why I might see such a thing?
> >
> > Regards,
> > Paul
> >
> > [cycle #: 1773; if constant make sure server lives and fifo is on]
> > Server: Sip EXpress router (0.9.1 (i386/linux))
> > Now: Sat Mar 26 14:03:06 2005
> > Up Since: Fri Mar 25 21:14:41 2005
> > Up time: 60505 [sec]
> >
> > Transaction Statistics
> > Current: 0 (1 waiting) Total: 955 (0 local)
> > Replied localy: 1066
> > Completion status 6xx: 0, 5xx: 0, 4xx: 301, 3xx: 0,2xx: 656
> >
> > Stateless Server Statistics
> > 200: 11568 202: 0 2xx: 0
> > 300: 0 301: 0 302: 0 3xx: 0
> > 400: 0 401: 2376 403: 8 404: 464 407: 31 408: 0 483: 0 4xx: 0
> > 500: 0 5xx: 0
> > 6xx: 0
> > xxx: 4707
> > failures: 0
> >
> > UsrLoc Stats
> > Domain Registered Expired
> > 'location' 28 10
> > 'aliases' 4 0
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
> >
>