Invalid connection between Matlab and Mysql

Hi, my team is working on a pilot test project which requires real-time sensor or feedback data, which we are receiving at Simulink via MySql database. Very often, all the functions to collect data from the database run for a few days but one of the functions (not a particular one) shows the above error after running successfully for a few days. What could be the reason and how can we fix it?

[Walter Roberson]

What operating system are you running on?

[Shreya Dutta]

Hi Walter, I'm using Windows 10.

Answer 1

[Dinesh]

Hi Shreya,

The error you're encountering in Simulink, which seems to arise from a MATLAB function block after a few days of runtime, may be due to several factors. These could include issues with the database connection, or unhandled edge cases in the data being received. Since it happens after a prolonged period, it's possible that the system is encountering a scenario not seen in the initial days, such as a specific type of data input, or there could be a growing resource allocation issue (memory leak error) that only becomes critical after a few days.

To resolve this, you'll want to implement error handling within your MATLAB functions to manage unexpected inputs or connection issues gracefully. Additionally, monitor system resources over time to check for leaks. You may also consider setting up a logging mechanism within your MATLAB code to record detailed error information when the issue occurs, which will be invaluable for troubleshooting.

The following link might help you:

https://www.mathworks.com/help/matlab/error-handling.html