[OpenSIPS-Users] mysql problem on 1.5

Jeff Pyle jpyle at fidelityvoice.com
Wed Apr 8 02:55:40 CEST 2009


Bogdan,

For what it's worth, these changes have not affected my inability to connect
to the siptrace db more often than not.  Still the same error 2003 as
before.


- Jeff



On 4/7/09 11:35 AM, "Bogdan-Andrei Iancu" <bogdan at voice-system.ro> wrote:

> Hi Brett,
> 
> more fixes for the DB part were done today (couple of hours ago). Please
> see if those will fix your problem. If not, try to get a backtrace from
> the core files.
> 
> 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
>>          
>> 
>> 
>> 
> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users




More information about the Users mailing list