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,
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,
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,
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,
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,
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@seconix.com To: "Tobias Lindgren" tobias.lindgren@ip-only.se Cc: serusers@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@ekiga.net sip:600000@ekiga.net
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
I understand.
But I find it weird that I had to recompile for only 6000 users.
Le mercredi 15 mars 2006 à 08:33 +0100, Greger V. Teigre a écrit :
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@seconix.com To: "Tobias Lindgren" tobias.lindgren@ip-only.se Cc: serusers@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@ekiga.net sip:600000@ekiga.net
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Damien Sandras -
Greger V. Teigre -
Tobias Lindgren