<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1649" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2>Hi All</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2>This sounds just like a problem I have had and still
investigating having moved to 16.9 using chan_sip. </FONT></SPAN><SPAN
class=379045619-01042020><FONT face=Arial color=#0000ff size=2>I am still trying
to repeat the problem it looks from debug that the issue is either voicemail of
call transfer but I cant consistently repeat it. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2>Voicemail is using ODBC and I just imported the data from
the old system into the new database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2>Nick - if you have any more info I would be grateful
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2>TIA</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020><FONT face=Arial
color=#0000ff size=2>Paddy</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=379045619-01042020></SPAN> </DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr align=left><FONT face=Tahoma size=2><B>From:</B> asterisk-users
[mailto:asterisk-users-bounces@lists.digium.com] <B>On Behalf Of </B>Nick
Olsen<BR><B>Sent:</B> 01 April 2020 18:54<BR><B>To:</B> Asterisk Users Mailing
List - Non-Commercial Discussion<BR><B>Subject:</B> Re: [asterisk-users] PJSIP
Lockup<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>We ultimately found this to be a voicemail issue. The voicemail is
held in MYSQL as well (via ODBC). And we found when attempting to playback a
customers voicemail unavail greeting is when the deadlock would occur
(Immediately, every time. Throwing the same "task processors" errors, And
making pjsip completely unresponsive). We had imported a number of greetings
from a legacy asterisk system and the vast majority of them worked. When we
deleted the row containing the customers unavail greeting (making asterisk
revert to read the mailbox number) all issues went away. If we re-record the
customers unavail greeting it works fine and the problem doesn't reoccur. This
was one out of ~250 voicemails imported.
<DIV><BR></DIV>
<DIV>Since then we've done a few more migrations and they've all gone smooth
with the exception of the most recent one. ~50% of the imported greetings have
caused asterisk to deadlock. We've been checking them now at time of
migration.</DIV>
<DIV><BR></DIV>
<DIV>What I can't figure out is what it doesn't like about the greeting. It was
on a previous asterisk system working fine. The row looks identical to a working
one. The only thing I can guess is something about the blob for the recording
goes wrong. It would be nice if asterisk handled that more
gracefully. </DIV>
<DIV><BR></DIV>
<DIV>I post this mostly just for internet history. To hopefully help the next
guy out who has this same issue.</DIV>
<DIV><BR clear=all>
<DIV>
<DIV class=gmail_signature dir=ltr data-smartmail="gmail_signature">
<DIV dir=ltr><B>Nick Olsen</B>
<DIV>Network Engineer</DIV>
<DIV>Office: 321-408-5000 x103</DIV>
<DIV>Mobile: 321-794-0763</DIV>
<DIV><IMG src="http://dl.floridavirtualsolutions.com/emaillogo/logo.png"
NOSEND="1"><BR></DIV></DIV></DIV></DIV><BR></DIV></DIV><BR>
<DIV class=gmail_quote>
<DIV class=gmail_attr dir=ltr>On Mon, Mar 2, 2020 at 8:29 PM Joshua C. Colp
<<A href="mailto:jcolp@sangoma.com">jcolp@sangoma.com</A>>
wrote:<BR></DIV>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV dir=ltr>
<DIV dir=ltr>On Mon, Mar 2, 2020 at 4:24 PM Nick Olsen <<A
href="mailto:nick@floridavirtualsolutions.com"
target=_blank>nick@floridavirtualsolutions.com</A>> wrote:<BR></DIV>
<DIV class=gmail_quote>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV dir=ltr>Thanks for the info, Joshua.
<DIV><BR></DIV>
<DIV>Does PJSIP handle database access the same way Chan_sip did? We had a
number of boxes running chan_sip referencing the same mysql server without
issue.</DIV>
<DIV><BR></DIV>
<DIV>We're going to attempt to get a backtrace on the next occurance. We're
also going to run a local copy of the database on the same physical asterisk
instance and have the system reference it. Just to "throw everything at the
wall".</DIV></DIV></BLOCKQUOTE>
<DIV><BR></DIV>
<DIV>It uses the same underlying API and layer. It can do more frequent
database access though due to queries and because PJSIP is
multithreaded.</DIV></DIV>
<DIV><BR></DIV>-- <BR>
<DIV dir=ltr>
<DIV dir=ltr>
<DIV>
<DIV dir=ltr>
<DIV>
<DIV dir=ltr>
<DIV dir=ltr>
<DIV dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: tahoma,sans-serif"><FONT color=#073763>Joshua C.
Colp</FONT></DIV>
<DIV style="FONT-FAMILY: tahoma,sans-serif"><FONT color=#073763>Asterisk
Technical Lead</FONT></DIV>
<DIV style="FONT-FAMILY: tahoma,sans-serif"><FONT color=#073763>Sangoma
Technologies</FONT></DIV>
<DIV style="FONT-FAMILY: tahoma,sans-serif"><FONT color=#073763>Check us out
at <A href="http://www.sangoma.com" target=_blank>www.sangoma.com</A> and <A
href="http://www.asterisk.org"
target=_blank>www.asterisk.org</A></FONT><BR></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV>--
<BR>_____________________________________________________________________<BR>--
Bandwidth and Colocation Provided by <A href="http://www.api-digital.com"
target=_blank rel=noreferrer>http://www.api-digital.com</A> --<BR><BR>Check
out the new Asterisk community forum at: <A
href="https://community.asterisk.org/" target=_blank
rel=noreferrer>https://community.asterisk.org/</A><BR><BR>New to Asterisk?
Start here:<BR> <A
href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started"
target=_blank
rel=noreferrer>https://wiki.asterisk.org/wiki/display/AST/Getting+Started</A><BR><BR>asterisk-users
mailing list<BR>To UNSUBSCRIBE or update options visit:<BR> <A
href="http://lists.digium.com/mailman/listinfo/asterisk-users" target=_blank
rel=noreferrer>http://lists.digium.com/mailman/listinfo/asterisk-users</A></BLOCKQUOTE></DIV></BODY></HTML>