Skip to main content

Hi.

I am using CData SQL Gateway to query PostgreSQL data in MySQL workbench. MySQL workbench has successfully connected to PostgreSQL data source, but no table can be fetched.

Here is my error:

 

This is my CData PostgreSQL ODBC configuration:

And this is my mysql remoting service configuration in CData SQL Gateway:

This is my MySQL WorkBench connection configuration to the above “mysql remoting service”:

 

How do I resolve this issue? Many thanks!

Hi ​@DuyNguyen 

The “Lost connection to MySQL server during query” error that you are encountering would typically indicate the connection between your MySQL client and database server has timed out. Essentially, this can occur in cases when it takes too long for the query to return data so the connection gets dropped.
You can avoid the error by changing some Timeout values. If you’re an administrator for your MySQL server, MySQL documentation suggests increasing the net_read_timeout or connect_timeout values on the server.
 
Alternatively you can also try this in MySQL Workbench, by editing the SQL Editor preferences:
In the application menu, select Edit > Preferences > SQL Editor. Look for the MySQL Session section and increase the DBMS connection read time out value.


The default value is 30 so try setting a higher value. Save the settings, quit MySQL Workbench and reopen the connection.

If issues persist even after the above suggestion, I would recommend you open a ticket with our support team here and send over the Gateway logs along with additional details so they can look further into the matter.

CData's Winter 2025 Release
Terms and ConditionsCookie settings