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.<br>
<br>I deletred all rows in that table and restarted opensips. Now every thing seems to be normal.<br><br>ANy thing I should do to avouid this in future ? IS this a bug. Any pointer is apprecaited.<br><br><br><div class="gmail_quote">
On Fri, Jun 26, 2009 at 3:53 PM, mani sivaraman <span dir="ltr"><<a href="mailto:mani.opensips@gmail.com">mani.opensips@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I'm using opensips 1.5.1 for the past 1 week. Suddenly I get this error below when starting. What is going on.<br><br><br><br>Jun 26 15:52:14 [2535] ERROR:core:db_allocate_rows: no memory left<br>Jun 26 15:52:14 [2535] ERROR:db_mysql:db_mysql_convert_rows: no private memory left<br>
Jun 26 15:52:14 [2535] ERROR:db_mysql:db_mysql_convert_result: error while converting rows<br>Jun 26 15:52:14 [2535] DBG:core:db_free_columns: freeing result columns at 0x81a9b78<br>Jun 26 15:52:14 [2535] ERROR:db_mysql:db_mysql_store_result: error while converting result<br>
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<br>Jun 26 15:52:14 [2535] ERROR:pua:mod_init: while restoring hash_table<br>Jun 26 15:52:14 [2535] ERROR:core:init_mod: failed to initialize module pua<br>
Jun 26 15:52:14 [2535] ERROR:core:main: error while initializing modules<br>Jun 26 15:52:14 [2535] DBG:xmpp:destroy: cleaning up...<br>Jun 26 15:52:14 [2535] DBG:pua:destroy: destroying module ...<br>Jun 26 15:52:14 [2535] DBG:db_mysql:db_mysql_submit_query: discon reset for 135960296<br>
Jun 26 15:52:14 [2535] DBG:core:pool_remove: removing connection from the pool<br>Jun 26 15:52:14 [2535] DBG:presence_xml:destroy: start<br>Jun 26 15:52:14 [2535] NOTICE:presence:destroy: destroy module ...<br>Jun 26 15:52:14 [2535] DBG:xlog:destroy: destroy module...<br>
Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: tm_shutdown : start<br>Jun 26 15:52:14 [2535] DBG:tm:unlink_timer_lists: emptying DELETE list<br>Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: emptying hash table<br>Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: releasing timers<br>
Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: removing semaphores<br>Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: destroying callback lists<br>Jun 26 15:52:14 [2535] DBG:tm:tm_shutdown: tm_shutdown : done<br>Jun 26 15:52:14 [2535] DBG:core:destroy_tls: entered<br>
Jun 26 15:52:14 [2535] DBG:core:shm_mem_destroy:<br>Jun 26 15:52:14 [2535] DBG:core:shm_mem_destroy: destroying the shared memory lock<br><br>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br>