[OpenSIPS-Users] ERROR:core:db_allocate_rows: no memory left - Please help

[Bogdan-Andrei Iancu]

Mani,

Thanks for the feedback - I did the official backport to 1.5 also.

Regards,
Bogdan

mani sivaraman wrote:
> Great. I don't see that error any more after applying the patch.
> Thanks
>
> On Mon, Jun 29, 2009 at 12:01 PM, Bogdan-Andrei Iancu 
> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>
>     Hi Mani,
>
>     if this will make the testing easier, here is the patch you can
>     apply against 1.5.
>
>     Regards,
>     Bogdan
>
>     mani sivaraman wrote:
>
>         Thanks Bogdan, I will definitely try the devel (1.6). I cannot
>         install 1.6 on the current server I have. I have to setup
>         another box and then try it out. I will let you know. Mean
>         while I'm trying hard to make xmpp2simple presence status
>         work. Any help or pointer would be appreciated.
>
>         Thanks
>         Mani
>
>         On Mon, Jun 29, 2009 at 11:04 AM, Bogdan-Andrei Iancu
>         <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>
>         <mailto:bogdan at voice-system.ro
>         <mailto:bogdan at voice-system.ro>>> wrote:
>
>            Hi Mani,
>
>            I fixed this on 1.6 (devel) version by adding fetch support
>         in the
>            PUA module, so now it can add as many row as possible
>         without any
>            mem issues. Could you give it a try? if you confirm the fix, I
>            will do a backport to 1.5 also.
>
>            Best regards,
>            Bogdan
>
>            mani sivaraman wrote:
>
>                I'm using opensips 1.5.1 for the past 1 week. Suddenly
>         I get
>                this error below when starting. What is going on.
>
>
>
>                Jun 26 15:52:14 [2535] ERROR:core:db_allocate_rows: no
>         memory left
>                Jun 26 15:52:14 [2535]
>         ERROR:db_mysql:db_mysql_convert_rows:
>                no private memory left
>                Jun 26 15:52:14 [2535]
>         ERROR:db_mysql:db_mysql_convert_result:
>                error while converting rows
>                Jun 26 15:52:14 [2535] DBG:core:db_free_columns: freeing
>                result columns at 0x81a9b78
>                Jun 26 15:52:14 [2535]
>         ERROR:db_mysql:db_mysql_store_result:
>                error while converting result
>                Jun 26 15:52:14 [2535] ERROR:core:db_do_query: error while
>                storing resultJun 26 15:52:14 [2535] ERROR:pua:db_restore:
>                while querrying table
>                Jun 26 15:52:14 [2535] ERROR:pua:mod_init: while restoring
>                hash_table
>                Jun 26 15:52:14 [2535] ERROR:core:init_mod: failed to
>                initialize module pua
>                Jun 26 15:52:14 [2535] ERROR:core:main: error while
>                initializing modules
>                Jun 26 15:52:14 [2535] DBG:xmpp:destroy: cleaning up...
>                Jun 26 15:52:14 [2535] DBG:pua:destroy: destroying
>         module ...
>                Jun 26 15:52:14 [2535] DBG:db_mysql:db_mysql_submit_query:
>                discon reset for 135960296
>                Jun 26 15:52:14 [2535] DBG:core:pool_remove: removing
>                connection from the pool
>                Jun 26 15:52:14 [2535] DBG:presence_xml:destroy: start
>                Jun 26 15:52:14 [2535] NOTICE:presence:destroy: destroy
>         module ...
>                Jun 26 15:52:14 [2535] DBG:xlog:destroy: destroy module...
>                Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: tm_shutdown
>         : start
>                Jun 26 15:52:14 [2535] DBG:tm:unlink_timer_lists: emptying
>                DELETE list
>                Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: emptying
>         hash table
>                Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: releasing timers
>                Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: removing
>         semaphores
>                Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: destroying
>         callback
>                lists
>                Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: tm_shutdown
>         : done
>                Jun 26 15:52:14 [2535] DBG:core:destroy_tls: entered
>                Jun 26 15:52:14 [2535] DBG:core:shm_mem_destroy:
>                Jun 26 15:52:14 [2535] DBG:core:shm_mem_destroy: destroying
>                the shared memory lock
>
>              
>          ------------------------------------------------------------------------
>
>
>
>                _______________________________________________
>                Users mailing list
>                Users at lists.opensips.org
>         <mailto:Users at lists.opensips.org>
>         <mailto:Users at lists.opensips.org
>         <mailto:Users at lists.opensips.org>>
>
>                http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>                
>
>
>
>