I'll have to wait and see if the t_newtran fixes the issue. The error message I was getting didn't happen a lot (maybe once every two or three days)<span></span><br><br>On Tuesday, April 30, 2013, Bogdan-Andrei Iancu wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div bgcolor="#ffffff" text="#000000">
<tt>Hi Duane,<br>
<br>
I'm glad it help - is now your problem solved (with the REGISTERs)
?<br>
<br>
Regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<br>
On 04/29/2013 11:41 PM, Duane Larson wrote:
<blockquote type="cite">
<div dir="ltr">Wow those thresholds give you a good amount of
info. I'll have to see how I can make my MySQL service quicker.
<div><br>
</div>
<div>
<div>Apr 29 15:31:37 SIPProxy02
/usr/local/sbin/opensips[3104]: WARNING:db_mysql:log_expiry:
threshold exceeded : mysql query took too long - 512355
us.Source : insert into location
(username,contact,expires,q,ca</div>
<div>llid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,sip_instance,domain
) values
('9*12*1$%$%','<a>sip:9*12*1$%$%@172.*.*.33:57369;line=mtj8kl6c','2013-04-29</a>
16:31:37',1.00 ,'26</div>
<div>000000cbed-7lfki4ifz7hz',1260,0,0,'snom720/<a href="http://8.7.3.19" target="_blank">8.7.3.19</a>','<a>sip:172.*.*.33:57369',NULL,'udp:</a><a href="http://50.57.54.156:5060" target="_blank">50.57.54.156:5060</a>',7999,'2013-04-29
15:31:37',NULL,'<a href="http://all.com" target="_blank">all.com</a>') on duplicate key
update username='9*12*1$%$%',co</div>
<div>ntact='<a>sip:9*12*1$%$%@172.*.*.33:57369;line=mtj8kl6c',expires='2013-04-29</a>
16:31:37',q=1.00
,callid='26000000cbed-7lfki4ifz7hz',cseq=1260,flags=0,cflags=0,user_agent='snom720/<a href="http://8.7.3.19" target="_blank">8.7.3.19</a>',received='<a>sip:1</a></div>
<div><a href="http://72.12.199.33:57369" target="_blank">72.12.199.33:57369</a>',path=NULL,socket='udp:<a href="http://50.57.54.156:5060" target="_blank">50.57.54.156:5060</a>',methods=7999,last_modified='2013-04-29
15:31:37',sip_instance=NULL,domain='<a href="http://all.com" target="_blank">all.com</a>'</div>
<div>Apr 29 15:31:37 SIPProxy02
/usr/local/sbin/opensips[3104]: WARNING:core:log_expiry:
threshold exceeded : msg processing took too long - 519804
us.Source : REGISTER sip:<a href="http://all.com" target="_blank">all.com</a> SIP/2.0#015#012Via: SIP</div>
<div>/2.0/UDP
172.*.*.33:57369;branch=z9hG4bK-clxrqnw5iv48;rport#015#012From:
"901-201-5656" <<a>sip:9*12*1$%$%@</a><a href="http://all.com" target="_blank">all.com</a>>;tag=bs72h6ifw5#015#012To:
"901-201-5656" <<a>sip:9*12*1$%$%@</a><a href="http://all.com" target="_blank">all.com</a>>#015#012Ca</div>
<div>ll-ID: 26000000cbed-7lfki4ifz7hz#015#012CSeq: 1260
REGISTER#015#012Max-Forwards: 69#015#012Contact:
<a><sip:9*12*1$%$%@172.*.*.33:57369;line=mtj8kl6c></a>;reg-id=1;q=1.0;audio;mobility="fixed";duplex="full";desc</div>
<div>ription="snom720";actor="principal";events="dialog";methods="INVITE,ACK,CANCEL,BYE,REFER,OPTIONS,NOTIFY,SUBSCRIBE,PRACK,MESSAGE,INFO"#015#012User-Agent:
snom720/<a href="http://8.7.3.19#015%23012Allow-Events" target="_blank">8.7.3.19#015#012Allow-Events</a>:
dialog#015#012X-</div>
<div>Real-IP: 192.168.1.71#015#012Supported:
path#015#012Authorization: Digest
username="9*12*1$%$%",realm="<a href="http://all.com" target="_blank">all.com</a>",nonce="517ed8c7f0973e1dd14a403ead3ffb092efd04c3",uri="sip:<a href="http://all.com" target="_blank">all.com</a>",qop=auth,nc=</div>
<div>00000001,cnonce="649029e8",response="c1cdca29ccd998e22b8caed1454719d2",algorithm=MD5#015#012Expires:
3600#015#012Content-Length: 0#015#012#015#012</div>
<div>Apr 29 15:31:37 SIPProxy02
/usr/local/sbin/opensips[3104]: WARNING:core:log_expiry: #1
is a core action : 6 - 519586us - line 553</div>
<div>Apr 29 15:31:37 SIPProxy02
/usr/local/sbin/opensips[3104]: WARNING:core:log_expiry: #2
is a core action : 14 - 519573us - line 595</div>
<div>Apr 29 15:31:37 SIPProxy02
/usr/local/sbin/opensips[3104]: WARNING:core:log_expiry: #3
is a core action : 6 - 519567us - line 594</div>
<div>Apr 29 15:31:37 SIPProxy02
/usr/local/sbin/opensips[3104]: WARNING:core:log_expiry: #4
is a core action : 14 - 519564us - line 967</div>
<div>Apr 29 15:31:37 SIPProxy02
/usr/local/sbin/opensips[3104]: WARNING:core:log_expiry: #5
is a module action : save - 516033us - line 956</div>
<div>Apr 29 15:31:38 SIPProxy02
/usr/local/sbin/opensips[3106]: WARNING:db_mysql:log_expiry:
</div></div></div></blockquote></div>
</blockquote>
<br><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>