st execute failed: Lost connection to MySQL server during qu

All installation and configuration problems and questions

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

st execute failed: Lost connection to MySQL server during qu

Postby akmayuga » Mon Mar 24, 2014 2:38 am

Hi,


I got this message on "/var/mail/root".

DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/share/astguiclient/AST_CRON_audio_3_ftp.pl line 398.
executing: select recording_id,start_time from recording_log where filename='20140314-xxxxxxx_dicho_xxxxxxxxx' order by recording_id desc LIMIT 1; Lost connection to MySQL server during query at /usr/share/astguiclient/AST_CRON_audio_3_ftp.pl line 398.


we are using FTP on our recordings, yesterday we got a high load average, and agents cant login, what can we do to prevent this issue.

best regards
Vicibox 64-bit
Asterisk v.1.4.39.2-vici
ViciBox Redux v.5.0.2-130807
preload iso installation
No Digium/Sangoma Hardware
No Extra Software After Installation
single server
akmayuga
 
Posts: 56
Joined: Thu Apr 19, 2012 1:53 pm

Re: st execute failed: Lost connection to MySQL server durin

Postby geoff3dmg » Mon Mar 24, 2014 4:54 am

Something went wrong with your database server. I'd start looking there first.
Vicibox 5.03 from .iso | VERSION: 2.10-451a BUILD: 140902-0816 | Asterisk 1.8.28.2-vici | Multi-Server | Amfeltec H/W Timing Cards | No Extra Software After Installation | Dell PowerEdge 1850 | Pentium 4 'Prescott' Xenon Quad @ 3.40GHz
geoff3dmg
 
Posts: 403
Joined: Tue Jan 29, 2013 4:35 am
Location: Lancashire, UK

Re: st execute failed: Lost connection to MySQL server durin

Postby williamconley » Wed Mar 26, 2014 1:39 pm

check the time. likely a reboot.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 86 guests