[OpenSIPS-Users] mysql problem on 1.5

Brett Nemeroff brett at nemeroff.com
Wed Apr 8 14:50:21 CEST 2009


Is that on the 1_5 branch or trunk?

On Wed, Apr 8, 2009 at 7:45 AM, Bogdan-Andrei Iancu
<bogdan at 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 <
>> bogdan at voice-system.ro <mailto:bogdan at 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 at lists.opensips.org <mailto:Users at lists.opensips.org>
>>        http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090408/2479a9a8/attachment.htm 


More information about the Users mailing list