Invalid connection between Matlab and Mysql

Question

Shreya Dutta 2022-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1688724-invalid-connection-between-matlab-and-mysql

回答： Dinesh 2023-12-22

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?

2 个评论
显示无隐藏无

Walter Roberson 2022-4-5

What operating system are you running on?

Shreya Dutta 2022-4-5

Hi Walter, I'm using Windows 10.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Dinesh 2023-12-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1688724-invalid-connection-between-matlab-and-mysql#answer_1376172

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