Is that on the 1_5 branch or trunk?<div><br><br><div class="gmail_quote">On Wed, Apr 8, 2009 at 7:45 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>
thanks to your logs, I spoted the problem. The fix is available on SVN.<div class="im"><br>
<br>
Thanks and regards,<br>
Bogdan<br>
<br>
Brett Nemeroff wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Bogdan,<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
-Brett<br>
<br>
<br>
<br></div><div><div></div><div class="h5">
On Mon, Apr 6, 2009 at 11:27 AM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a> <mailto:<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>>> wrote:<br>
<br>
Hi Brett,<br>
<br>
it looks like the DB connections are dropped and reconnect is<br>
taking place (this are the errors about). But to find out the real<br>
cause, I can enable some more logs to spot the reason for<br>
re-connect...<br>
<br>
I will do it later as right now I'm in the middle of some DB<br>
debugging and I'm afraid of mixing different patches and what goes<br>
on SVN :)<br>
<br>
Regards,<br>
Bogdan<br>
<br>
Brett Nemeroff wrote:<br>
<br>
Hi All,<br>
So I'm doing some load testing with sipp on my opensips 1.5<br>
system. I just checked out (like 2 hours ago, the 1.5 branch<br>
from SVN). Everything works just fine, until I run some<br>
rating scripts on my database (perl scripts accessing the<br>
mysql db directly). While my scripts are running, I see the<br>
UAS in sipp retransmitting the 200 OKs and the following gets<br>
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<br>
retransmitting...<br>
My PERL script isn't doing anything terribly unusual, however,<br>
it is performing the queries inside of a transaction,<br>
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<br>
losing call records..<br>
<br>
-Brett<br>
<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Users mailing list<br></div></div>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><div class="im"><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>
<br>
<br>
</div></blockquote>
<br>
</blockquote></div><br></div>