[SJet]

Unfortunately I did not post the follow-up.

After some investigation we found the evil. It is Kaspersky antivirus. Anyhow when we turn it off the problem does not come up.

Still we did not found which exactly setting causes the reconnect.

So for the time being one turns Kaspersky off. Other learn to live with reconnections.

[SJet]

'nithin' wrote on '22:

Can you check whether the server got restarted or not when it show 'Reconnected' for a query? You can confirm it from the 'Info tab', select the Server(root) node in Object browser(left pane) and select the Info tab in HTML mode. It gives the server Up-time information.

see the image attached.

MySQL Server: 5.0.32-Debian_7etch8-log, Running for: 7 days 23 hrs 50 mins 15 secs

MySQL Server: 5.0.51a-24+lenny2, Running for: 83 days 14 hrs 22 mins 22 secs

[SJet]

'SJet' wrote on '21:

It began still with the older version ( I guess 6.5.4 )

And remained after upgrade to 8.18.

About Mysql version. As I said the same problem we have with different servers.

These are the versions:

5.0.32-Debian_7etch8-log

5.0.51a-24+lenny2

[SJet]

'peterlaursen' wrote on '21:

We need to analyze the issue. Since 8.13 this error will only rarely come in HISTORY if SSH-tunnelling is not used.

We will provide you a special build that logs details like which error of MySQL caused this reconnection, query executed. Since you are getting this issue without SSH, we will provide you a Community build. Download from: 

http://www.webyog.com/downloads/betas/not_released/SQLyog821.3Community.exe

(note that you do not need overwrite existing installation.  You can install to a seperate folder)

Please reproduce the case and attach the log file created.

The log file name is (for unknown reason) 'slow_log.log' and it is stored in users 'AppData' folder (where also the sqlyog.ini file is).

You may create a ticket for privacy, of course.

So far the content of the file is:

______________ select 1 Error code = 2013 querycount = 0 SQLyog reconnected

______________ select 1 Error code = 2013 querycount = 0 SQLyog reconnected

______________ select 1 Error code = 2013 querycount = 0 SQLyog reconnected

While history is

/*[15:38:49][ 16 ms]*/ SET NAMES 'utf8';

/*[15:38:49][ 0 ms]*/ SET sql_mode='';

/*[15:38:49][ 0 ms]*/ SHOW DATABASES;

/*[15:38:52][ 0 ms]*/ USE `SIS`;

/*[15:38:57][ 0 ms]*/ SELECT 1;

/*[15:45:40][ 0 ms]*/ SELECT 1;

/*[15:45:43][ 16 ms]*/ SELECT 1;

/*[15:57:58][76503 ms] SQLyog reconnected */

/*[15:57:58][ 0 ms]*/ SELECT 1;

/*[16:10:15][76503 ms] SQLyog reconnected */

/*[16:10:15][ 0 ms]*/ SELECT 1;

/*[16:50:44][76519 ms] SQLyog reconnected */

/*[16:50:44][ 0 ms]*/ SELECT 1;

[SJet]

'peterlaursen' wrote on '21:

We need to analyze the issue. Since 8.13 this error will only rarely come in HISTORY if SSH-tunnelling is not used.

We will provide you a special build that logs details like which error of MySQL caused this reconnection, query executed. Since you are getting this issue without SSH, we will provide you a Community build. Download from: 

http://www.webyog.com/downloads/betas/not_released/SQLyog821.3Community.exe

(note that you do not need overwrite existing installation.  You can install to a seperate folder)

Please reproduce the case and attach the log file created.

The log file name is (for unknown reason) 'slow_log.log' and it is stored in users 'AppData' folder (where also the sqlyog.ini file is).

You may create a ticket for privacy, of course.

Thank you.

I've insatalled it and will inform you further.

[SJet]

'SJet' wrote on '21:

Hello,

Even with SELECT 1;

I get reconnect

/*[9:51:50][81417 ms] SQLyog reconnected */

/*[9:51:50][ 15 ms]*/ SELECT 1;

So probably there is no need to test other queries.

It began still with the older version ( I guess 6.5.4 )

And remained after upgrade to 8.18.

About Mysql version. As I said the same problem we have with different servers.

These are the versions:

5.0.32-Debian_7etch8-log

5.0.51a-24+lenny2

One of the servers is on intranet , that exclude that it is a firewall issue.

I will try to use SSH tunnel now and will report the result.

SSH tunneling did not help.

Same:

/*[11:00:18][77142 ms] SQLyog reconnected */

[SJet]

'nithin' wrote on '21:

Also

After some time of inactivity SqLyog always got reconnected for any query?

If so can you try these queries and confirm the freezing happens all these.

(make sure while connecting in connection dialog you set the 'Session Idle Timeout is 28000')

i. SELECT 1;

ii. SELECT * from ;

iii. SELECT * from .;

Please check the 'History' whether 'Reconnected' is added for all these queries

Thank you

Nithin

Hello,

Even with SELECT 1;

I get reconnect

/*[9:51:50][81417 ms] SQLyog reconnected */

/*[9:51:50][ 15 ms]*/ SELECT 1;

So probably there is no need to test other queries.

It began still with the older version ( I guess 6.5.4 )

And remained after upgrade to 8.18.

About Mysql version. As I said the same problem we have with different servers.

These are the versions:

5.0.32-Debian_7etch8-log

5.0.51a-24+lenny2

One of the servers is on intranet , that exclude that it is a firewall issue.

I will try to use SSH tunnel now and will report the result.

[SJet]

'peterlaursen' wrote on '20:

Are you using SSH-tunnel?

Not for the servers in question.

And my colleague does not use it at all.

[SJet]

'peterlaursen' wrote on '19:

Please execute “SHOW GLOBAL VARIABLES LIKE 'wait_timeout'”.  What does it return? My guess is that 'wait_timeout' setting on the server is low.  But it can of course also simply be connectivity issue.

However it seems you are using a rather old SQLyog version. If 'wait_timeout' is the reason you can work around it. Please read release notes for 8.13:

http://www.webyog.com/blog/2009/08/14/sqlyog-813-has-been-released/

“Added an option for user to specify the timeout setting for the session (note: it will work with MySQL 4.1 and up only as earlier versions do not support SESSION variables). Please see detailed note below.”

… and also this Blog:

http://www.webyog.com/blog/2009/09/02/“mysql-server-has-gone-away”-part-2-session-timeout/

Thank you for your reply.

SHOW GLOBAL VARIABLES LIKE 'wait_timeout' returns 28800

Also I'm using recent version 8.18.

[Author]

Posts