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

[Tobias Lindgren]

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.

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.

If nothing else, could it be a memory limiter in MySQL causing your problem?

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,