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

[Tobias Lindgren]

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

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,