Both. Brett Nemeroff wrote: > Is that on the 1_5 branch or trunk? > > > On Wed, Apr 8, 2009 at 7:45 AM, Bogdan-Andrei Iancu > <bog...@voice-system.ro <mailto:bog...@voice-system.ro>> wrote: > > Hi Brett, > > thanks to your logs, I spoted the problem. The fix is available on > SVN. > > > Thanks and regards, > Bogdan > > Brett Nemeroff wrote: > > Bogdan, > 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. > > 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. > > 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. > > 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. > > 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. > > -Brett > > > > On Mon, Apr 6, 2009 at 11:27 AM, Bogdan-Andrei Iancu > <bog...@voice-system.ro <mailto:bog...@voice-system.ro> > <mailto:bog...@voice-system.ro > <mailto:bog...@voice-system.ro>>> wrote: > > Hi Brett, > > 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... > > 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 :) > > Regards, > Bogdan > > Brett Nemeroff wrote: > > Hi All, > 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: > http://www.pastebin.ca/1381169 > > As soon as my perl script is done, the 200OKs stop > retransmitting... > 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. > > Any ideas as to what is causing this? I'm afraid I may be > losing call records.. > > -Brett > > > > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > <mailto:Users@lists.opensips.org> > <mailto:Users@lists.opensips.org > <mailto:Users@lists.opensips.org>> > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users