[peterlaursen]

Can you please check in the Windows EventViewer (Control Panel .. Administration .. Logs) if there is more information? 

[peterlaursen]

Well ..we have this FAQ: http://faq.webyog.com/content/27/114/en/introduction-to-the-_sqlyog-job-agent_-sja.html

 

But it is recommend to use the wizard from the ‘powertools’ menu to generate the jobfile.

 

Note that Data Sync is available (only) in Professional and Ultimate editios of SQLyog. Refer https://www.webyog.com/product/sqlyog (click the ‘Features’ button).

[peterlaursen]

Deleted.  But why?

[peterlaursen]

OK .. I think we will need to reproduce this on XP as first step (if we can). But it could be that code generated by our compiler (Visual Studio 2010 with all Servicepacks and updates) produces code that is not safe on XP. After all Microsoft stopped support for XP ~1 year ago.  And as an XP user you probably don’t have an option to try the 64 bit version of SQLyog (64 bit XP’s did exist, but were not commonly used).

 

MySQL documentaton has this http://dev.mysql.com/doc/refman/5.6/en/out-of-memory.html (but SQLyog does not support the -quick option like command line client does. I believe it always uses the mysql_store_result() and not the mysql_use_result() API function (refer http://dev.mysql.com/doc/refman/5.6/en/mysql-use-result.html) – so this is not a solution). It is very much a mystery to me how this error (if it is the same error) can occur as you didn’t even execute a query.

 

As a first step could you please attach a screenshot of the error dialog? This will help us to understand the context (if it is a Windows dialog or a SQLyog dialog returning this error for instance). 

 

Also please tell how much RAM you have in the machine and how much is typically used/free.

[peterlaursen]

Yes, of course it is. However this is not an upgrade option available online (in neither our webshop nor Customer Portal), so you cannot handle this on your own.

 

 

Just send a mail to [email protected] and our sales team will handle this.

[peterlaursen]

We have received your mail now.

[peterlaursen]

You shold login to our Customer Portal (http://www.webyog.com/customer) in order to access new versions.  But as it seems you purchased through a 3rd party reseller (with or withourt our knowledge), you may not have been informed about your login details for the Customer Portal.

 

 

Besides, we will not discuss your license details in public.  It is private for you and us. Please send a mail to [email protected] or [email protected] with a reference to this Forums post, and we do our best to help.

[peterlaursen]

We will check this.  it is not immediately reproducible for me.

 

(and one request: next time please attach images using a compressed image format (such as JPG or PNG).  BMP’s (and TIFF’s) are uncompressed and waste a lot of server space)

[peterlaursen]

“keep variants or parallel related work in different Tab”.  You can do that but you need parallel connection tabs.

“if you’re working only with simple/fast queries it’s ok [else it is not]”. Why? The new connection tab will open whlle the old tab is waiting. You can work completey in parallel.

 

 

This has been discussed several times before and we won’t change anything in this respect. Al tools allowed for working in parallel to same server in multiple tabs must – not matter the program GUI layout – necessarily have more connections open.  If not it is not possble to work in parallel.

 

 

We have tabs in 2 levels: connection tabs (on top) and for every connection tab an option for multiple query tabs . I cannot understand why it makes a big difference. 

[peterlaursen]

It is not an issue with the host address.  it is because the server sdo not allow for remote connections. MySQl does not as default. it is also not a problem with SQLyog. Any client would face the same issue.

 

I think the error you get is “1045”. If so please read this FAQ:

http://faq.webyog.com/content/23/18/en/error-no-1045-connection-denied.html

“User is not allowed to connect from the actual host. Note that MySQL by default only allows connection from ‘localhost’. To specify from where a user may connect SQL wildcards (% and _) can be used. Simply ‘someuser@%’ means that user ‘someuser’ may connect from everywhere.”

 

If you execute “SELECT host, user FROM mysql.user;” you will probably find that user is declared a a localhost-user.

 

Relevant MySQL documentaton page: http://dev.mysql.com/doc/refman/5.5/en/account-names.html

[peterlaursen]

You cannot open a new query tab in same connection, but you can open a new connection tab to the same server while a query is running (ctrl+n will do it). 

 

I am not sure about WB, but as far as I remember, Navicat will open a new connection for every query tab.  We don’t do this. One advantage of what we are doing is that we are able to use the same user variables and temporary tables in more query tabs (those that belong to the same connection). 

[peterlaursen]

Also please note that MySQL 5.1x is not actively supported anymore – refer http://www.mysql.com/support/eol-notice.html “December 4, 2013: MySQL 5.1 covered under Oracle Lifetime Sustaining Support”. Andhttp://www.mysql.com/support/ “No new releases, no new fixes (no error correction for new issues), no new updates. Only pre-existing updates, fixes and alerts are available.”

 

As this is the situation with MySQL 5.1 we will not change anything in SQLyog to handle this better. It works without explicit casting with server versions that are fully supported today.

[peterlaursen]

I think there may besome gateway/router setting on your server or network independent of SSHD settings interrupting inactive connections.

[peterlaursen]

To post images ‘click more reply options’, next select a file, ‘attach’ and finally ‘append to post’.

[peterlaursen]

From MySQL documentation:

 

http://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_concat “If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent nonbinary string form.”

 

http://dev.mysql.com/doc/refman/5.6/en/group-by-functions.html#function_group-concat “The return value is a nonbinary or binary string, depending on whether the arguments are nonbinary or binary strings. The result type is TEXT or BLOB unless group_concat_max_len is less than or equal to 512, in which case the result type is VARCHAR or VARBINARY.”

 

 

Do you see a different behavior? if so it should be reported to bugs.mysql.com. But what is your group_concat_max_len setting (“SHOW VARIABlES LIKE ‘group_concat_max_len’;”). According to http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_group_concat_max_len default is 1024.  Also note that you may SET if on a SESSION basis. If you “SET SESSION group_concat_max_len = 512;”  on top of your test case, does it change anything? 

[Author]

Posts