<span class="Apple-style-span" style="font-family: 'courier new', monospace;">All,<br>Ok, so I fixed my kernel panic issue.. 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.. <br>
<br>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. 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.<br>
<br>It's also worth mentioning that I hadn't increased the SHM in that config...<br><br><br>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. <br>
<br>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.. so I checked it out.. Look at this from my acc table:<br>
<br><br>+-------+--------+------------+-------------------------+----------------------------+----------+----------------------------+---------------------+-----------------------+------------+--------+------------------+------------+-----------+------+-------+<br>
| id | method | from_tag | to_tag | callid | sip_code | sip_reason | time | ua | from_did | to_did | srcip | gw | harvested | pdd | trace |<br>
+-------+--------+------------+-------------------------+----------------------------+----------+----------------------------+---------------------+-----------------------+------------+--------+------------------+------------+-----------+------+-------+<br>
| 69622 | 0 | 1510444289 | <a href="mailto:22645-3410@1.2.3.4">22645-3410@1.2.3.4</a> | <a href="http://sip:sipp@1.2.3.4:5061">sip:sipp@1.2.3.4:5061</a> | 341 | <a href="http://sip:9999@1.2.3.4:5060">sip:9999@1.2.3.4:5060</a> | 0000-00-00 00:00:00 | udp:<a href="http://1.2.3.4:5060">1.2.3.4:5060</a> | 1239854732 | 4 | udp:1.2.3.4 | 1239897933 | 0 | 1 | 1 | <br>
+-------+--------+------------+-------------------------+----------------------------+----------+----------------------------+---------------------+-----------------------+------------+--------+------------------+------------+-----------+------+-------+<br>
1 row in set (0.00 sec)</span><br><div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;"><br></span></div><div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;">The data is all in the wrong fields!! This happened on exactly ONE record.</span></div>
<div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;"><br></span></div><div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;">In addition, when I watch "SHOW PROCESSLIST" in mysql, i normally (even at 100CPS) just see like 4-6 "acc" inserts.. 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..</span></div>
<div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;"><br></span></div><div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;">-Brett</span></div>
<div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;"><br></span></div><div><span class="Apple-style-span" style="font-family: 'courier new'; font-size: 12px;"><br></span></div>