[OpenSIPS-Users] ERROR:usrloc:preload_udomain: fetching rows failed on OpenSIPS 1.5.3

[Bogdan-Andrei Iancu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140611/4425333e/attachment.htm>