[OpenSIPS-Users] mysql problem on 1.5

[Brett Nemeroff]

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
<bogdan at voice-system.ro>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 <
>> bogdan at voice-system.ro <mailto: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>
>>        <mailto: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>
>>        <mailto: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/3095a1b2/attachment-0001.htm