Hi Brett, Brett Nemeroff wrote: > All, > Ok, so I fixed my kernel panic issue Cool, what was the cause ?
> .. But I'm not real happy with the fix. I'm loading up like 157,000 > routes.. each route has between 1-4 gateways in the gwlist. however, > **I only have 1 actual route in the dr_gateways table**.. I hadn't > added the other 3 gateways.. > > Now when dr_reload runs, it sucks up routes, but if there is a missing > gateway for that route, the entire route is dropped. I didn't expect > that, I thought it would have just skipped loading that gateway for > that route. Make sense - please open a bug report on the tracker about this. > Seems that all of that loading / unloading of routes halted my system. > I have no idea why.. But it's consistent and repeatable **on Ubuntu > 8.04** I did the same setup, same routes in CentOS 5.2 and could not > for the life of me reproduce the problem. So, do you think it is OS or setup-only specific ? > > It's also worth mentioning that I hadn't increased the SHM in that > config... but do you get any error about mem (like running out of mem). > > > Ok, so different issue.. This is the same "opensips crashes under > heavy db load" issue.. I load up Opensips with 100 CPS with SIPP. It's > real busy, and processing real happily. OK > > Then I run an external perl based rating script.. For about 15-20 > second, all is good.. then I start getting retrans, then opensips > dies. I reported this like a week ago, and I think bogdan pushed out > some fixes that are in 1.5.1 (which I am running)... Well, my rating > script was running, and I got a DateTime error.. it was telling me > that a Date/Time written in the DB wasn't valid.. Could you post the exact error from the log ? > so I checked it out.. Look at this from my acc table: > > > +-------+--------+------------+-------------------------+----------------------------+----------+----------------------------+---------------------+-----------------------+------------+--------+------------------+------------+-----------+------+-------+ > | id | method | from_tag | to_tag | callid > | sip_code | sip_reason | time > | ua | from_did | to_did | srcip > | gw | harvested | pdd | trace | > +-------+--------+------------+-------------------------+----------------------------+----------+----------------------------+---------------------+-----------------------+------------+--------+------------------+------------+-----------+------+-------+ > | 69622 | 0 | 1510444289 | [email protected] > <mailto:[email protected]> | sip:[email protected]:5061 > <http://sip:[email protected]:5061> | 341 | sip:[email protected]:5060 > <http://sip:[email protected]:5060> | 0000-00-00 00:00:00 | > udp:1.2.3.4:5060 <http://1.2.3.4:5060> | 1239854732 | 4 | > udp:1.2.3.4 | 1239897933 | 0 | 1 | 1 | > +-------+--------+------------+-------------------------+----------------------------+----------+----------------------------+---------------------+-----------------------+------------+--------+------------------+------------+-----------+------+-------+ > 1 row in set (0.00 sec) > > The data is all in the wrong fields!! This happened on exactly ONE record. yeap....it looks messy... > > In addition, when I watch "SHOW PROCESSLIST" in mysql, i normally > (even at 100CPS) just see like 4-6 "acc" inserts do not fully follow you here - 100CPS should produce (INVITE+BYE)*100 acc records per sec -> 200 acc per sec. > .. when my rating script runs, I see my screen fill up (completely) > with "acc" inserts. So I'm about to test this with the max connections > in mysql raised up to.. say... 1000. Maybe the cause is running out of > mysql connections for acc transactions under high load.. opensips does not dynamically create more DB connection - whatever the load is, the number of DB connection is the same - their number depends only of the number of processes in opensips. Regards, Bogdan > > -Brett > > > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
