Invalid connection between Matlab and Mysql

3 次查看（过去 30 天）
Shreya Dutta
Shreya Dutta 2022-4-5
回答： 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?

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

回答（1 个）

Dinesh
Dinesh 2023-12-22
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

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by