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] > 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] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
