[OpenSIPS-Users] mysql problem on 1.5

Bogdan-Andrei Iancu bogdan at voice-system.ro
Wed Apr 8 14:54:25 CEST 2009


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
>                
>
>
>
>




More information about the Users mailing list