MySQL connect ERROR:

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

MySQL connect ERROR:

Postby ruben23 » Tue Mar 12, 2019 10:50 am

Version: 2.14b0.5
SVN Version: 3067
DB Schema Version: 1564
DB Schema Update Date: 2019-03-01 18:32:30
Password Encryption:DISABLED - S1 - C1
Auto User-add Value: 101
Recording Prompt Count: 0
Install Date: 2019-03-01
ASterisk 1.8
Scratch install Ubuntu Server


HI, i have a Database Server/Web Server and 2 VICIDIAL/asterisk Server load balance, running on production its 45 agents running on it Our database Server is hitting 1.58 load AVG no CPU core spike on it. same with the rest of the asterisk server

Database/WEB Server - Dell Server 4 cores Xeon, 16GB memory and 2 Terabytes SATAII HDD
Asterisk/Vicidial - Dell Server 4 cores Xeon, 4GB memory and 2 Terabytes SATAII HDD

now during full operation im getting random error like this few in a while : MySQL connect ERROR: Can't connect to MySQL server on '192.168.10.250' (99) --------> (192.168.10.250') DATABASE/WEB LOCAL IP ADDRESS
Agents are not logout it just appear a couple of time on the realtime screen and also on the AGENTS Interface then once it gone they proceed, but i see deadcalls on the realtime with agent not all few only

on my HTOP monitoring i get Average load @ 1.58 and tried monitoring also with MYTOP but no activity on mytop at all

and to add up just recently this was monitored that this happens during we load leads during the peak production(meaning everyone is dialing, but our biggest leads load is only 20K leads) Any idea guys.? Anyone.?
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1088
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: MySQL connect ERROR:

Postby mflorell » Tue Mar 12, 2019 5:24 pm

What is your "max_connections" set to in /etc/my.cnf?

Do you have slow query logging enabled in MySQL? If so, have you looked for long running queries when this is happening?
mflorell
Site Admin
 
Posts: 17156
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: MySQL connect ERROR:

Postby williamconley » Tue Mar 12, 2019 6:03 pm

mysql -e "show status like '%Aborted%'";

http://eflo.net/VICIDIALforum/viewtopic ... 73#p133462
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18177
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: MySQL connect ERROR:

Postby ruben23 » Thu Mar 14, 2019 1:23 pm

@Matt Florell

Thanks for reverting back, my max_connections = 1000 in my.cnf

and i enable slow log query i will check on it also, im suing MariaDB, ill make feedback about this, Thanks a lot
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1088
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines


Return to Support

Who is online

Users browsing this forum: No registered users and 18 guests