[OpenSIPS-Users] Unable to fetch rows from location table - Crashing Opensips

[Paris Stamatopoulos]

Dear all,

Ok I think I've found it. The fetch_rows parameter of usrloc module should probably be decreased.

Regards,
Paris Stamatopoulos

From: users-bounces at lists.opensips.org [mailto:users-bounces at lists.opensips.org] On Behalf Of Paris Stamatopoulos
Sent: Friday, November 05, 2010 11:49 AM
To: 'OpenSIPS users mailling list'
Subject: [OpenSIPS-Users] Unable to fetch rows from location table - Crashing Opensips

Dear all,

I am using opensips 1.6.1 and today I noticed something really strange. Suddenly opensips crashed and on attempts to restart it I got the error:

ERROR:core:db_allocate_rows: no memory left
ERROR:db_mysql:db_mysql_fetch_result: no memory left
ERROR:usrloc:preload_udomain: fetching rows failed
ERROR:usrloc:child_init: child(1): failed to preload domain 'location'
ERROR:core:init_mod_child: failed to initializing module usrloc, rank 1

Truncating the `locations` table seemed to have corrected the issue, however the table only had 2500 rows in it. (I've previously seen a similar bug on the pua module on 1.5.x)

I also noticed that there is a lot of memory in use on the server. Could it be that there is a memory leak in the usrloc module?

The usrloc configuration is simple:

modparam("usrloc", "db_mode",   2)
modparam("usrloc", "db_url", "mysql://DB_USERNAME:DB_PASSWORD@DB_HOST/DB_DATABASE")
modparam("usrloc", "nat_bflag", 6)

Regards,

Paris Stamatopoulos

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20101105/d057dda2/attachment.htm