Bogdan,<div>For what it's worth, I've updated to latest 1_5 tonight (about 20 minutes ago) and I still am having problems. Full out crashes as well.</div><div><br class="webkit-block-placeholder"></div><div>I rewrote my queries so I'd have a bunch of little (select * from acc where callid=X) kinds of queries. Of course, there is a lot of DB activity while this happens. Crashes start to happen within seconds of the DB activity ramping up.</div>
<div><br class="webkit-block-placeholder"></div><div>For grins, I slowed my queries down to ensure I only did one query per second (in my database, not opensips).. after about 15-20 queries (different each time really) opensips would just crash.</div>
<div><br class="webkit-block-placeholder"></div><div>I have acc and sip_trace loaded up, sip_trace isn't active for these calls. Also potentially relevant, my acc table is an InnoDB table.</div><div><br class="webkit-block-placeholder">
</div><div>Now if I slowed my call volume to 1CPS and keep the queries at 1 QPS, it seemed to be happier, but still crashes eventually.</div><div><br class="webkit-block-placeholder"></div><div>-Brett</div><div><br class="webkit-block-placeholder">
</div><div><br><div><br><div class="gmail_quote">On Mon, Apr 6, 2009 at 11:27 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi Brett,<br>
<br>
it looks like the DB connections are dropped and reconnect is taking place (this are the errors about). But to find out the real cause, I can enable some more logs to spot the reason for re-connect...<br>
<br>
I will do it later as right now I'm in the middle of some DB debugging and I'm afraid of mixing different patches and what goes on SVN :)<br>
<br>
Regards,<br>
Bogdan<br>
<br>
Brett Nemeroff wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div class="h5">
Hi All,<br>
So I'm doing some load testing with sipp on my opensips 1.5 system. I just checked out (like 2 hours ago, the 1.5 branch from SVN). Everything works just fine, until I run some rating scripts on my database (perl scripts accessing the mysql db directly). While my scripts are running, I see the UAS in sipp retransmitting the 200 OKs and the following gets printed to the syslog:<br>
<a href="http://www.pastebin.ca/1381169" target="_blank">http://www.pastebin.ca/1381169</a><br>
<br>
As soon as my perl script is done, the 200OKs stop retransmitting...<br>
My PERL script isn't doing anything terribly unusual, however, it is performing the queries inside of a transaction, including a "SELECT/DELETE * FROM acc WHERE " kind of clause.<br>
<br>
Any ideas as to what is causing this? I'm afraid I may be losing call records..<br>
<br>
-Brett<br>
<br></div></div>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">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>
<br>
</blockquote></div><br></div></div>