[OpenSIPS-Users] mysql problem on 1.5

[Bogdan-Andrei Iancu]

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 
> <bogdan at voice-system.ro <mailto: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>
>         <mailto: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>>
>                <mailto: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>>
>                <mailto: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
>                      
>
>
>
>
>