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

[Bogdan-Andrei Iancu]

Hi Mani,

Yes, it was a bug and it is fix on trunk (1.6) version. Please see my 
previous email.

Regards,
Bogdan

Manivasagam Sivaraman wrote:
> I opened pua table in my sql and found it to be more than 5000 rows. 
> But there was no clients connected to it. Opensips was holding this 
> data for offline users. Infact at any time there was not more than 3 
> users connected to this server. Two of them were subscribes for 
> sip-xmpp mapping.
>
> I deletred all rows in that table and restarted opensips. Now every 
> thing seems to be normal.
>
> ANy thing I should do to avouid this in future ? IS this a bug. Any 
> pointer is apprecaited.
>
>
> On Fri, Jun 26, 2009 at 3:53 PM, mani sivaraman 
> <mani.opensips at gmail.com <mailto:mani.opensips at gmail.com>> 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>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>