[OpenSIPS-Users] opensips-1.11 storing data in memory issue .

Bogdan-Andrei Iancu bogdan at opensips.org
Wed Apr 5 10:26:57 EDT 2017


The only moment OpenSIPS reads from DB is at startup.....at runtime it 
only writes into DB (flushing the memory cache). So, just pending record 
(in DB only) might have been added without OpenSIPS being aware or they 
are bogus records which OpenSIPS refuses to load.

Check the expire time of those records ; also check for errors/warnings 
from OpenSIPS when starting up - maybe it is rejecting those records.

Regards,

Bogdan-Andrei Iancu
   OpenSIPS Founder and Developer
   http://www.opensips-solutions.com

OpenSIPS Summit May 2017 Amsterdam
   http://www.opensips.org/events/Summit-2017Amsterdam.html

On 04/05/2017 11:32 AM, Sasmita Panda wrote:
> Ohk. I got it.  You are saying,  if I am using two instance using 
> single DB then both the instance must have same scheme of writing domain.
>
>       If I will make show, then everything will be fine.
>
>       Yesterday,  I have done the same setup,  but still when contact 
> are present in the DB, in the same time they are not visible in memory.
>         I am using same command
> opensipsctl fifo ul_dump : to see the memory
> opensipsctl dB exec " select * from location"  : to see the dB entry.
>
>          The machine in which I am using single instance of opensips, 
>  they are absolutely fine.
>
> On Apr 5, 2017 1:30 PM, "Bogdan-Andrei Iancu" <bogdan at opensips.org 
> <mailto:bogdan at opensips.org>> wrote:
>
>     Bingo...that is your problem... Don't you think there is a bit of
>     a conflict in having 2 OpenSIPS with different use_domain setting
>     working over the same "location" table ? one OpenSIPS is writing
>     records without domain, the other is complaining about reading
>     record without :)
>
>     Use different tables or databases.
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>        OpenSIPS Founder and Developer
>        http://www.opensips-solutions.com <http://www.opensips-solutions.com>
>
>     OpenSIPS Summit May 2017 Amsterdam
>        http://www.opensips.org/events/Summit-2017Amsterdam.html
>     <http://www.opensips.org/events/Summit-2017Amsterdam.html>
>
>     On 04/05/2017 04:35 AM, Sasmita Panda wrote:
>>     Yes...  Both are sharing same DB.
>>     On Apr 4, 2017 11:08 PM, "Bogdan-Andrei Iancu"
>>     <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>>
>>         Are the 2 instances sharing the same database ? Regards,
>>
>>         Bogdan-Andrei Iancu
>>            OpenSIPS Founder and Developer
>>            http://www.opensips-solutions.com
>>         <http://www.opensips-solutions.com>
>>
>>         OpenSIPS Summit May 2017 Amsterdam
>>            http://www.opensips.org/events/Summit-2017Amsterdam.html
>>         <http://www.opensips.org/events/Summit-2017Amsterdam.html>
>>
>>         On 04/04/2017 06:59 PM, Sasmita Panda wrote:
>>>         I am running two different configuration file in a machine
>>>         with differ port.
>>>               In one configuration file,  use_domain is disable and
>>>         in another it's enable.
>>>               In this case,  I am not able to see those contacts in
>>>         memory which are getting saved without domain.
>>>               Is that can be a reason? I have tried a lot to know
>>>         the exact reason.  But every time I am seeing different
>>>         behaviour.
>>>                The system in which a single configuration is
>>>         running,  that's working absolutely fine.
>>>               I am stuck in this issue.
>>>         On Apr 4, 2017 4:49 PM, "Bogdan-Andrei Iancu"
>>>         <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>>>
>>>             Well, if the "use_domain" is enabled for usrloc,
>>>             OpenSIPS expects to find a domain set for all the
>>>             records in the "location" table, otherwise it will
>>>             ignore/discard them at loading time. The primary storage
>>>             for registered contacts in the memory cache - OpenSIPS
>>>             will perform lookups only in memory cache (and not it
>>>             DB) - of course, unless you use the DB ONLY mode. You
>>>             can check the in-memory registrations by "opensipsctl ul
>>>             dump" Regards,
>>>
>>>             Bogdan-Andrei Iancu
>>>                OpenSIPS Founder and Developer
>>>                http://www.opensips-solutions.com
>>>             <http://www.opensips-solutions.com>
>>>
>>>             OpenSIPS Summit May 2017 Amsterdam
>>>                http://www.opensips.org/events/Summit-2017Amsterdam.html
>>>             <http://www.opensips.org/events/Summit-2017Amsterdam.html>
>>>
>>>             On 04/04/2017 01:39 PM, Sasmita Panda wrote:
>>>>             Hi Bogdan ,
>>>>                    Yes , the domain corresponding to this username
>>>>             is empty . But the domain for all the contact is not
>>>>             empty .
>>>>                     When the domain for a contact is not empty and
>>>>             its present in the DB , I am not getting that in the
>>>>             memory . What could be the reason for this .
>>>>                    Another strange thing happening . When I am
>>>>             setting db_mode :2 , even if a contact is not present
>>>>             in the memory (but present in db)
>>>>             the call get connected . I was assuming when there is
>>>>             no contact in the memory it should send  "404 Not Found" .
>>>>                    When I am running opensips in AWS linux ,
>>>>             everything works fine . I am not seeing any issue
>>>>             regarding updating memory .
>>>>             But when I am running this in centos 7 , there is
>>>>             problem in updating memory in every refresh  .
>>>>                  So where was the problem . opensips is version is
>>>>             same every where . My config file is same everywhere .
>>>>             But still there is difference . Why this is happening ?
>>>>             */Thanks & Regards/*
>>>>             /Sasmita Panda/
>>>>             /Network Testing and Software Engineer/
>>>>             /3CLogic , ph:07827611765/
>>>>             On Tue, Apr 4, 2017 at 3:22 PM, Bogdan-Andrei Iancu
>>>>             <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>>>>
>>>>                 Hello Sasmita, The error means that at startup time
>>>>                 (preloading the usrloc content from DB into
>>>>                 memory), OpenSIPS finds a record (in the "location"
>>>>                 table) with an empty domain field (username '1111')
>>>>                 - could you confirm this by checking your DB ? Best
>>>>                 regards,
>>>>
>>>>                 Bogdan-Andrei Iancu
>>>>                    OpenSIPS Founder and Developer
>>>>                    http://www.opensips-solutions.com
>>>>                 <http://www.opensips-solutions.com>
>>>>
>>>>                 OpenSIPS Summit May 2017 Amsterdam
>>>>                    http://www.opensips.org/events/Summit-2017Amsterdam.html
>>>>                 <http://www.opensips.org/events/Summit-2017Amsterdam.html>
>>>>
>>>>                 On 03/31/2017 01:06 PM, Sasmita Panda wrote:
>>>>>                 Hi  All ,
>>>>>                     I am using opensips-1.11 from long time . But
>>>>>                 today i faced some issue .
>>>>>                 when a username det rigistered , it givind some
>>>>>                 error in the logs like bellow .
>>>>>                 *CRITICAL:usrloc:preload_udomain: empty domain for
>>>>>                 user 1111...skipping *
>>>>>                 **
>>>>>                 *    I am getting that entry in the DB but I am
>>>>>                 not getting anything in the memory . Every call to
>>>>>                 this number failing with error 404 Not found .*
>>>>>                 **
>>>>>                 **
>>>>>                 *loadmodule "usrloc.so"*
>>>>>                 *modparam("usrloc", "db_url",
>>>>>                 "mysql://yyyy:xxxx@localhost/opensips")*
>>>>>                 *modparam("usrloc", "db_mode", 1)*
>>>>>                 **
>>>>>                 *    Other default modules are loaded also . It
>>>>>                 not giving any error when starting . But while
>>>>>                 register its throughing such error . *
>>>>>                 **
>>>>>                 *      What the problem i am not getting it . This
>>>>>                 is happening in one machine . In other machine the
>>>>>                 same config with same code is runnign fine .*
>>>>>                 **
>>>>>                 *Please help me if I am doing anything wrong .*
>>>>>                 **
>>>>>                 */Thanks & Regards/*
>>>>>                 /Sasmita Panda/
>>>>>                 /Network Testing and Software Engineer/
>>>>>                 /3CLogic , ph:07827611765/
>>>>>
>>>>>                 _______________________________________________
>>>>>                 Users mailing list
>>>>>                 Users at lists.opensips.org
>>>>>                 <mailto:Users at lists.opensips.org>
>>>>>                 http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>                 <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
>>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20170405/4ed10d6d/attachment-0001.html>


More information about the Users mailing list