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

[Manivasagam Sivaraman]

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>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
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090626/8cbaba1b/attachment.htm