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
