Jump to content


Photo

Increase Wait Time When Establishing A New Sql Connection

connection wait time

  • Please log in to reply
3 replies to this topic

#1 pasi

pasi

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 24 October 2016 - 06:48 PM

I have a DB that take a few second to establish connection.
SQLyog terminate the connection attempt faster than then DB can respond; therefore, it's keep giving me the error Error No. 2013 Lost connection to MySQL server at 'handshake: wating for initial communication packet', system error: 138.
Is there a way I can extend the wait time for respond on the MySQLyog?
I am having the MySQLyog version 12.2.6.
 
Attachment show the error message.
 
 
Thank you,

Attached Files



#2 Sibin A S

Sibin A S

    Advanced Member

  • Admin
  • PipPipPip
  • 105 posts
  • Gender:Male

Posted 27 October 2016 - 05:35 AM

Hi,

 

We have replied to you in the ticket that you have created. 

 

Regards,

Sibin



#3 pasi

pasi

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 28 October 2016 - 01:15 PM

The SQLyog and the MySQL server I am connecting to are on 2 separate machines over the network.
I already tried to extend the connect_timeout global variable to 60 seconds. However, the SQLyog version 12 is still generating the same connection fail message after the same amount of time.
Interestingly, the connection could be establish successfully if I use an older version of SQLyog (version 8).



#4 Sibin A S

Sibin A S

    Advanced Member

  • Admin
  • PipPipPip
  • 105 posts
  • Gender:Male

Posted 07 November 2016 - 06:50 AM

Hi,

 

We have replied to you in the ticket that you have created. 

 

Regards,

Sibin






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users