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

[Greger V. Teigre]

20K is per server and the number is just a guidance, it all depends on your 
setup, registration intervals etc.
No matter how hard you try, you won't find a solution that scales 
indefinitely on one server. You also want redundancy, so you need to add 
some servers and decide how to manage your subcription base.
g-)

----- Original Message ----- 
From: "Damien Sandras" <dsandras at seconix.com>
To: "Tobias Lindgren" <tobias.lindgren at ip-only.se>
Cc: <serusers at lists.iptel.org>
Sent: Tuesday, March 14, 2006 11:39 PM
Subject: Re: [Serusers] Ekiga.net, service down, impossible to restart SER


> 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
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>