KNOWLEDGE BASE

Error: "Lost connection to MySQL server during query" When Refreshing a Data Source on Tableau Online


Published: 26 Jul 2017
Last Modified Date: 27 Nov 2017

Issue

When attempting to refresh a data source on Tableau Online, the following message occurs:

"[MySQL][ODBC 5.3(w) Driver][mysqld-5.6.27]Lost connection to MySQL server during query."

Environment

  • Tableau Online
  • MySQL

Resolution

While our team is currently investigating this issue, please try the following workaround: 
  1. Download the data source.
  2. Open the extract in Tableau Desktop
  3. Go to the Edit data source tab.
  4. Click the arrow next to the data source name.
  5. Select Initial SQL.
  6. Enter the following: set net_write_timeout=7200
  7. Click OK.
  8. Republish the data source.

Cause

Our team is currently investigating this issue (ID: 674773). 
Did this article resolve the issue?