webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.16k stars 318 forks source link

SQLyog returns an error “unknown thread id” on stopping the query execution #2319

Open sibwy opened 1 year ago

sibwy commented 1 year ago

Issue description: The issue is that Azure DB returns a wrong thread id after connecting to the server. In SQLyog, we are checking whether it is an Azure DB or not. If the MySQL hostname contains "database.azure.com" then we are considering it as an Azure DB and then we are executing another query (select connection_id()) to fetch the thread id if it is an Azure DB.

The user report can be found in SF: 00946340, 00965619, 00965658