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

[Damien Sandras]

Hi,

Le mardi 14 mars 2006 à 23:29 +0100, Tobias Lindgren a écrit :
> Hi,
> 
> Glad it helped you out a bit. I'm not sure on that you would actually
> hit the limit with 4 times your users, as I guess it could be affected
> by other things in the database such as the alias table for example and
> therefor you'd most likely hit the limit before seeing 4 times the users.
> 
> But, I think you might find this rather long thread interresting,
> starting here:
> http://lists.iptel.org/pipermail/serusers/2005-May/019850.html
> 

Very good reading.

However, I do not know yet what is the long term solution to avoid that
problem even with large number of users.

Also, when I read that you can have maximum 20k users by computers, it
frightens me. I hope it doesn't mean 20k "subscribers" (who are not
necessarily registered), because it would be fewer than what I expected.


> Br,
> Tobias
> 
> Damien Sandras said the following on 2006-03-14 23:17:
> > 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