[OpenSIPS-Users] ERROR:usrloc:preload_udomain: fetching rows failed on OpenSIPS 1.5.3

[Jonathan Hunter]

Hi Bogdan,
Thanks for the prompt response as ever!! :)
The goal is to move to OpenSIPS 1.11 as soon as possible.
We are still running 1.5, we are just upgrading the OS from Fedora, and also the Database backend, so we can do things more efficiently!
The next task is upgrade to 1.11 in the lab, get our config working then look to migrate.
Thanks for your response.
Jon

Date: Wed, 11 Jun 2014 14:08:53 +0300
From: bogdan at opensips.org
To: users at lists.opensips.org; hunterj91 at hotmail.com
Subject: Re: [OpenSIPS-Users] ERROR:usrloc:preload_udomain: fetching rows failed on OpenSIPS 1.5.3


  
    
  
  
    Hi Jonathan,

        

        I guess you upgraded to OpenSIPS 1.11, right ? The "fetch_rows"
        parameter in usrloc was removed in 1.6 version - there is an
        automatic detection of available PKG mem, and based on that, the
        modules loads the proper number of rows.

        

        I understand you get that error still with 1.5, right ? if so ,
        just set a lower value. The idea behind is that OpenSIPS have a
        certain amount of private (PKG, per process) memory configured
        (default is 1M for 1.5, if I remember correctly) ; at startup,
        OpenSIPS has to load the records from location table - this
        query may return a large amount of data that needs to be proxied
        via PKG mem before landing into SHM mem (shared memory); and PKG
        may not be enough to load the table as a whole, so you can load
        it in multiple steps, fetching rows by rows.

        

        Regards,

      
      Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
      On 11.06.2014 02:21, Jonathan Hunter wrote:

    
    
      
      
        Hi Guys,
        

        
        We are going through a process of getting in a position to
          start the upgrade path from opensips 1.5.3 to the latest
          release, however to achieve this, we also
        need to move from fedora to Centos 6.5.
        

        
        We are also moving from Mysql 5.1 to Percona 5.6.17.
        

        
        Now having moved a working configuration from the fedora
          box, over to Centos 6.5, the following error is reported when
          starting opensips;
        

        
        

        
        

        
        Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]:
          ERROR:core:db_allocate_rows: no memory left
        Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]:
          ERROR:db_mysql:db_mysql_fetch_result: no memory left
        Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]:
          ERROR:usrloc:preload_udomain: fetching rows failed
        Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]:
          ERROR:usrloc:child_init: child(1): failed to preload domain
          'location'
        Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]:
          ERROR:core:init_mod_child: failed to initializing module
          usrloc, rank 1
        Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25490]:
          ERROR:core:main_loop: init_child failed for UDP listener
        Jun 10 22:44:37 localhost /usr/local/sbin/opensips[25503]:
          CRITICAL:core:receive_fd: EOF on 6
        

        
        

        
        

        
        So I have added Fetch_rows entry (which allows opensips to
          start and work), and I notice that the maximum I can set it to
          before it crashes is 1550 rows. (was set to the default).
        

        
        The server has no load, and has no memory issues
          whatsoever, so we are wondering if there is a buffer issue
          related to the fetch_rows() in the db connector.
        

        
        Or is this simply an issue with 1.5.3 and Centos 6.5?
        

        
        Any comments/thoughts would be appreciated.
        

        
        As I mentioned we are pushing to make changes so we can
          start moving the Opensips versions forward, its just doing it
          in a controlled manner.
        

        
        Many thanks
        

        
        Jon
        

        
      
      

      
      

      _______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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