Hi Brett, I think the problem is at DB level - what you can try to do (just to spot the problem) is to stop whatever other apps/procs that are using the opensips DB and let only opensips runing on it. Redo the test and see if you get the same behaviour.
Regards, Bogdan Brett Nemeroff wrote: > Bogdan, > I no longer get crashes. However the opensips process hangs pretty > badly while the DB operations are going on. I've tried to rewrite my > queries to do more small queries rather than longer slow ones. > > So what I'm doing, I'm using sipp performing calls at 30CPS lasting 10 > seconds (to generate a lot of call records). > > While this is running, I run my rating script, which gathers unique > callid. smashes records together into a cdr record. > > My database engine is InnoDB and I'm using transactions. I'm not > actually getting to a commit in any of this. > > So while my script is running. I see on the UAS side of sipp, it > stops receiving calls, and starts performing retransmissions. I've > verified with tshark that packets are hitting opensips, but not > getting a reply. > > I have 20 children running. Am I doing something wrong? > > Thanks for your help, > Brett > > > On Wed, Apr 8, 2009 at 7:54 AM, Bogdan-Andrei Iancu > <[email protected] <mailto:[email protected]>> wrote: > > 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 > <[email protected] <mailto:[email protected]> > <mailto:[email protected] > <mailto:[email protected]>>> 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 > <[email protected] <mailto:[email protected]> > <mailto:[email protected] <mailto:[email protected]>> > <mailto:[email protected] > <mailto:[email protected]> > <mailto:[email protected] > <mailto:[email protected]>>>> 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 > [email protected] > <mailto:[email protected]> > <mailto:[email protected] > <mailto:[email protected]>> > <mailto:[email protected] > <mailto:[email protected]> > <mailto:[email protected] > <mailto:[email protected]>>> > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
