Hi.

After a stress test with my OpenSIPS and few user agent clients on-line, just 
sending SIP REGISTER messages (1 at each minute), not making calls, I saw this 
log:



Apr 15 10:09:20 [20441] WARNING:core:fm_malloc: Not enough free memory, will 
attempt defragmentation
Apr 15 10:09:20 [20441] ERROR:db_sqlite:db_sqlite_allocate_rows: no memory left
Apr 15 10:09:20 [20441] ERROR:db_sqlite:db_sqlite_convert_rows: no private 
memory left
Apr 15 10:09:20 [20441] ERROR:db_sqlite:db_sqlite_convert_result: error while 
converting rows
Apr 15 10:09:20 [20441] ERROR:db_sqlite:db_sqlite_store_result: error while 
converting result
Apr 15 10:09:20 [20441] ERROR:avpops:db_query_avp: raw_query failed: 
db0(usr_preferences) select Value from GeneralConfigurations ...


So, I suspect that I have codified something wrong in my opensips.cfg file.

More precisely, I have used some AVPs and I'm note sure if  such use is correct 
or if it is the cause of increasingly memory consumption.

For example, I have codified somethings like this:



1        if($avp(I_A) == NULL){
                 avp_db_query("select Value from GeneralConfigurations where 
Attribute = 'CONFIGURATION_INTERCOM_A_NAME'", "$avp(I_A)");
        }


.

.

.


2        if ($rU==$avp(M_TU)){
           $rU = $avp(M_T);
        }

.

.

.


3    if (nat_uac_test("34")) {
        if (is_method("REGISTER")) {
            fix_nated_register();
            setbflag(NAT);
            $avp(attr) = "in_another_network";
        } else {
            fix_nated_contact();
            setflag(NAT);
        }
    }


.

.

.

4                $avp(ContatoRegister) = $(ct.fields(uri){s.select,0,;});
                  if($fn != NULL){
                     avp_db_query("UPDATE location SET callerName='$fn'  where 
contact like '$avp(ContatoRegister)%'");
                }
                $avp(ContatoRegister) = NULL;




Could some of the 4 piece of codes above causes some increasingly memory 
consumption?


Any hint will be very helpful!


Best regards.



RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to