项目场景:
Hangfire使用了MySQL作为持久化在后台执行任务
问题描述
在启动项目时发生报错
MySqlConnector.MySqlException (0x80004005): The Command Timeout expired before the operation completed.
---> MySqlConnector.MySqlException (0x80004005): Query execution was interrupted
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 44
at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 120
at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 450
at MySqlConnector.Core.CommandExecutor.
本文介绍了在使用Hangfire配合MySQL时遇到的启动报错问题,问题源于Sql执行超时和可能的死锁。通过检查MySQL状态发现存在未完成的事务。通过查看XA事务信息并手动清理,成功解决了程序启动错误,确保了Hangfire后台任务的正常运行。
最低0.47元/天 解锁文章
8161

被折叠的 条评论
为什么被折叠?



