[Serusers] Ekiga.net, service down, impossible to restart SER

[Damien Sandras]

Hello,

Le mardi 14 mars 2006 à 22:56 +0100, Tobias Lindgren a écrit :
> Hello,
> 
> You are using MySQL-db, right? Looks like you are hitting some memory
> limiter by looking at the source code, and I'm just guessing it could be
>  because you have much data in your database and large tables with many
> rows. When SER starts and loads (or walks through?) these tables it
> cannot hold it in it's working memory and therefor your error message.
> 

I had supposed that too :(

> If I were you I'd start off by increasing the PKG_MEM_POOL_SIZE to
> something bigger, for example 1024*4096, in config.h and recompile SER
> to see if that would help you out. Starting SER with the "-m" option to
> specify more shared memory than default might also be a way, but I'm
> guessing you've already tried that and I'm also guessing that would not
> help you out.
> 

Starting with -m was not helping, so I decided to recompile with an
increased PKG_MEM_POOL_SIZE.

Now, it only seems to be a workaround. Meaning that when I will hit 4
times the current number of users, I will get problems again.

Isn't there another solution? Others are using SER in big setups, so
surely there must be something escaping me...

Thank you!


> Br,
> Tobias
> 
> Damien Sandras said the following on 2006-03-14 22:36:
> > Hello,
> > 
> > As you probably know, the Ekiga SIP softphone was released yesterday.
> > We are using SER as SIP Registrar/Proxy.
> > 
> > Tonight, it suddenly stopped working, and when restarting it, I get:
> > 0(0) convert_row(): No memory left
> >  0(0) convert_rows(): Error while converting row #5679
> >  0(0) convert_result(): Error while converting rows
> >  0(0) store_result(): Error while converting result
> >  0(0) preload_udomain(): Error while doing db_query
> >  0(0) register_udomain(): Error while preloading domain 'aliases'
> >  0(0) release_connection(): Removing connection from the pool
> > 
> > There are no memory problems, but the number of users has dramtically
> > increased lately.
> > 
> > Is that a limitation of SER?
> > 
> > I'm asking for help because we are short in time, the service is
> > currently down and users started complaining...
> > 
> > Thanks,
-- 
 _      Damien Sandras
(o-     
//\     Ekiga Softphone: http://www.ekiga.org/
v_/_    FOSDEM 2006    : http://www.fosdem.org/
        SIP Phone      : sip:dsandras at ekiga.net
                         sip:600000 at ekiga.net