Hi Bogdan, Thanks for the prompt response as ever!! :) The goal is to move to OpenSIPS 1.11 as soon as possible. We are still running 1.5, we are just upgrading the OS from Fedora, and also the Database backend, so we can do things more efficiently! The next task is upgrade to 1.11 in the lab, get our config working then look to migrate. Thanks for your response. Jon
Date: Wed, 11 Jun 2014 14:08:53 +0300 From: [email protected] To: [email protected]; [email protected] Subject: Re: [OpenSIPS-Users] ERROR:usrloc:preload_udomain: fetching rows failed on OpenSIPS 1.5.3 Hi Jonathan, I guess you upgraded to OpenSIPS 1.11, right ? The "fetch_rows" parameter in usrloc was removed in 1.6 version - there is an automatic detection of available PKG mem, and based on that, the modules loads the proper number of rows. I understand you get that error still with 1.5, right ? if so , just set a lower value. The idea behind is that OpenSIPS have a certain amount of private (PKG, per process) memory configured (default is 1M for 1.5, if I remember correctly) ; at startup, OpenSIPS has to load the records from location table - this query may return a large amount of data that needs to be proxied via PKG mem before landing into SHM mem (shared memory); and PKG may not be enough to load the table as a whole, so you can load it in multiple steps, fetching rows by rows. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 11.06.2014 02:21, Jonathan Hunter wrote: Hi Guys, We are going through a process of getting in a position to start the upgrade path from opensips 1.5.3 to the latest release, however to achieve this, we also need to move from fedora to Centos 6.5. We are also moving from Mysql 5.1 to Percona 5.6.17. Now having moved a working configuration from the fedora box, over to Centos 6.5, the following error is reported when starting opensips; Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]: ERROR:core:db_allocate_rows: no memory left Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]: ERROR:db_mysql:db_mysql_fetch_result: no memory left Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]: ERROR:usrloc:preload_udomain: fetching rows failed Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]: ERROR:usrloc:child_init: child(1): failed to preload domain 'location' Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 1 Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]: ERROR:core:main_loop: init_child failed for UDP listener Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25503]: CRITICAL:core:receive_fd: EOF on 6 So I have added Fetch_rows entry (which allows opensips to start and work), and I notice that the maximum I can set it to before it crashes is 1550 rows. (was set to the default). The server has no load, and has no memory issues whatsoever, so we are wondering if there is a buffer issue related to the fetch_rows() in the db connector. Or is this simply an issue with 1.5.3 and Centos 6.5? Any comments/thoughts would be appreciated. As I mentioned we are pushing to make changes so we can start moving the Opensips versions forward, its just doing it in a controlled manner. Many thanks Jon _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
