[OpenSIPS-Users] mysql problem on 1.5

[Brett Nemeroff]

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
> 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
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090406/55fe1f4f/attachment-0001.htm