[OpenSIPS-Users] drouting and free memory

[Bogdan-Andrei Iancu]

Hello,

DR module use private memory (pkg mem) in order to load info from DB. 
Usually OpenSIPS has 2M of pkg memory (which is also used by other 
module aside DR), so maybe that available amount of mem is not enough 
for loading a 40K rows at a time.

Try to decrease the "fetch_rows" param to 1000 for example, to see if 
ok. This will have no side effect, it will simply load data via multiple 
chunks.

Regards,
Bogdan

On 12/28/2011 02:58 PM, dpa wrote:
>
> Hello!
>
> There is such problem
>
> Opensips 1.6.4-2
>
> I am using drouting module to relay any calls.
>
> modparam("drouting", "fetch_rows", 40000)
>
> When I am try using fifo dr_reload I see such error
>
> “Dec 28 16:38:24 opensips 
> /usr/local/opensips1.6.4-2/sbin/opensips[27360]: 
> ERROR:core:db_allocate_rows: no memory left
>
> Dec 28 16:38:24 opensips 
> /usr/local/opensips1.6.4-2/sbin/opensips[27360]: 
> ERROR:db_mysql:db_mysql_fetch_result: no memory left
>
> Dec 28 16:38:24 opensips 
> /usr/local/opensips1.6.4-2/sbin/opensips[27360]: 
> ERROR:drouting:dr_load_routing_info: Error fetching rows”
>
> And I cannot see any problem with memory
>
> “shmem:total_size = 104857600
>
> shmem:used_size = 34574448
>
> shmem:real_used_size = 38811912”
>
> “pkmem:0-total_size = 5242880
>
> pkmem:0-used_size = 591616
>
> pkmem:0-real_used_size = 717016
>
> pkmem:0-max_used_size = 919520
>
> pkmem:0-free_size = 4525864
>
> pkmem:0-fragments = 2”
>
> Thank you for any help
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


-- 
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
OpenSIPS solutions and "know-how"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20111228/e1566a76/attachment-0001.htm>