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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


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

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to