Forum Discussion

TK12345's avatar
TK12345
Resolver II
3 years ago

MySQL: Fatal error encountered during data read

Hi community, I have an issue with a dataflow and a connection with a MySQL.  Since a few days the dataflow will not reload the data anymore and gives me the following error: MySQL: Fatal error...
Need Help
Show and Tell
Tips and Tricks
unicorns's avatar
unicorns
Helper II
3 years ago

Hello TK12345, 

 

Have you checked your query editor + checked all the steps in the query to see if any of the steps give you an error? (You might have to do a refresh on the query editor).

I think I've ran into this issue before when some changes were made in the original database (SQL) and I had to update my steps in the query editor (for my case, data type was changed in the SQL database that was causing the issue so had to update that step). 

 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, and Kudos ‌ are very much appreciated!

- YJ

TK12345's avatar
TK12345
Resolver II
3 years ago

Hi unicorns,

Thanks for reaction. In the dataflow I only have the navigation step, so no change type or something. Could it be possible that the MySQL has to low performance?

  • unicorns's avatar
    unicorns
    Helper II
    3 years ago

    Hello,

     

    I see, thanks for that information. It does seem like it's an issue with the MySQL server, especially if you were able to load everything succesfully before.