Re: [asterisk-users] Exceptionally long queue length queuing

2020-06-29 Thread Joshua C. Colp
On Sun, Jun 28, 2020 at 2:26 PM Dovid Bender  wrote:

> Hi,
>
> We have a box up and we are starting to see a lot of "Exceptionally long
> queue length queuing" in the logs. From all the research so far it seems
> like this leads to their systems crashing and being unreachable. In our
> case the box remains up and takes calls. We are running Asterisk 16.6.1. We
> are using MusicOnHold to play online music streams via ffmpeg. Any idea on
> how to troubleshoot this further to see why this is happening?
>

The message occurs when either a channel is deadlocked or the processing
time to handle what a channel is doing is substantial, and things build up.
Getting a backtrace[1] at the time it occurs will show what the system is
actually doing and can provide insight into what is causing it.

[1]
https://wiki.asterisk.org/wiki/display/AST/Getting+a+Backtrace#GettingaBacktrace-Runningast_coredumperfordeadlocks,taskprocessorbackups,etc
.

-- 
Joshua C. Colp
Asterisk Technical Lead
Sangoma Technologies
Check us out at www.sangoma.com and www.asterisk.org
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed

2020-06-29 Thread Markus

Hi,

Am 08.06.2020 um 12:25 schrieb Antony Stone:

On Monday 08 June 2020 at 12:15:56, Markus wrote:


Hi list!

I'm getting this error frequently:

ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to
database server localhost: (2026) SSL connection error:
SSL_CTX_set_default_verify_paths failed


Hmmm... talking to localhost over SSL... seems a bit computationally wasteful.


I switched to connecting via sock. My cdr_mysql.conf looks like this:

[global]
;hostname=localhost
dbname=asterisk
table=cdr
password=somepassword
user=someuser
;port=3306
sock=/var/lib/mysql/mysql.sock

However, I'm still frequently getting:

"[Jun 29 12:40:08] ERROR[12977][C-07cc]: cdr_mysql.c:203 mysql_log: 
Cannot connect to database server localhost: (2026) SSL connection 
error: SSL_CTX_set_default_verify_paths failed"


Which makes no sense because I'm no longer connecting via localhost. The 
error message still mentions localhost, though. Maybe the error message 
is not accurate enough?!


Strange?

As explained previously, the error comes and go. Right now I'm losing 
about 10% of my CDRs. But that means it's not a general problem with the 
SSL stuff.


Thanks!
Markus

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
 https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users