[nithin]

Hello,

Regarding this issue I have made a post to Wine forum

http://forum.winehq.org/viewtopic.php?p=40954#40954

We will proceed as soon as we get a reply for this.

Regards

Nithin

[nithin]

Hello,

The issue has got reproduced at our end.

We will look into this in detail and update you the progress.

Thank you

Nithin

[nithin]

Hello

Please reply with following details

– What is the SQLyog version you are using?

– How are you connecting to servers (direct, ssh or Http)?

– Are these 3 tables always failing? and what is the error you get (you can check the sja.log)

– Ok your target server's 'max_packet is 64mb', what about source server (if that is less than the target server's it can fail)?

– Please tell do you have any blob, text columns for tables those are failed? and what is the maximum size of that column.

You can execute this query to find that:

SELECT MAX(LENGTH(blob_column)) FROM table_name

Quote:

With bulk inserts it fails. I checked the output of a synchronization script and it seems to be using bulk inserts. I cannot find an option to change this, is there anything I can do

If target table is empty Data-sync use bulk insert, and currently there's no option to change this.

One workaround is add a row manually to target table and do Data sync(then it wont do bulk insert). Can you verify this?

Thank you

Nithin

[nithin]

We have released SQLyog 8.22 with this fix, which is available publicly.

Please refer to:

http://www.webyog.com/blog/2010/01/29/sqlyog-mysql-gui-8-22-has-been-released/

Please try it and let us know the status..

[nithin]

Hello,

We had simlar bug reports and we fixed this issue internally. We may probably release binaries with this fix on this Friday.

Thank you

Nithin

[nithin]

Hello,

We are providing you a special build with this issue got fixed.

Your assumptions were correct that the scroll bar were able to handle 16 bits values only.

It was documented this:

“Note that the WM_VSCROLL message carries only 16 bits of scroll box position data. Thus, applications that rely solely on WM_VSCROLL (and WM_HSCROLL) for scroll position data have a practical maximum position value of 65,535.”

The fix is that now it can be processed 32 bit values, so your issue would be solved.

Please download, try it in your environment and lets know the status, so that we can include this fix into next public release

http://www.webyog.com/downloads/betas/not_released/SQLyog822.2Trial.exe

Thank you

Nithin

[nithin]

Hello,

We are providing you a special trial binary where we do some additional logging (in sja.log itself) during Tunneling error. Please try this and attach the sja.log file.

http://webyog.com//downloads/betas/not_released/SQLyog822.1Trial.exe

Thank you

Nithin

[nithin]

Also you can see the screen shot attached, Its case insensitive in version 8.21

Please explain the issue in detail.

[nithin]

We have released SQLyog 8.21 GA with this fix, which is available publicly!

Please refer to:

http://www.webyog.com/blog/2010/01/11/sqlyog-mysql-gui-8-21-has-been-released/

[nithin]

Hello,

We haven't reproduced yet

Inbtw please tell,

Have you tried this case other OS than Win7?

What type of connection used (Direct/ssh/http)?

MySQL version?

Also can you try with latest stable version 8.2?

Thank you

Nithin

[nithin]

Quote:

The delay occurs after calling upon a saved schema file and answering the second dialog (i.e. during synchronization to the tables).

Can you confirm the 2nd dialog you mentioned is same as attached image?

[nithin]

Hello,

Can you explain the issue in detail?

You did 'Add tables' to canvas or Load a saved 'schema design' file?

It will be appreciated if you provide a test case.

Also tell Is it direct or HTTP/SSH connection.

Also tell MySQL Server version.

Thank you

Nithin

[nithin]

Hello,

Thanks for the information.

The issue is fixed and we are providing a special binary. Please download, try your case and let's know the status?

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

Note:

This is v 8.21 special build. Since v 8.2 we have changed the registration key, you can get it from webyog portal.

Thank you

Nithin

[nithin]

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.

[nithin]

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

[Author]

Posts