MySQL 操作数据库数据报错：Fatal error encountered during command execution

最新推荐文章于 2023-02-28 16:14:22 发布
最新推荐文章于 2023-02-28 16:14:22 发布
阅读量2.4k 收藏
点赞数
分类专栏： mysql C# 文章标签： 数据库 mysql java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/tnb_ml/article/details/126040454
版权
C# 同时被 2 个专栏收录
11 篇文章 0 订阅
订阅专栏
mysql
1 篇文章 0 订阅
订阅专栏

MYSQL报Fatal error encountered during command execution.错误的解决方法

  1. 背景：今天在做数据同步到数据库mysql时候，做insert操作，insert方法是C#底层封装的，没改动，insert数据时候就一直不能写入，查看log：{MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. --->

  2. 百度方案：在连接字符串里加上：

Allow User Variables=True;

自己试了之后，还是不行！

  1. 尝试解决：手动写一条insert语句，在数据库的表插入一条数据，显然数据是成功插入的。清除了刚刚插入的测试数据，把正式环境服务job开启后，数据就写进来，感觉有点疑惑，记录一下，望各位大佬给予宝贵评语！
遥远的救世主○
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
mysql报错error during_MYSQL报Fatal error encountered during command execution.错误的解决方法...
weixin_42510453的博客
02-18 6734
{MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to...
mysql fatal_MYSQL报Fatal error encountered during command execution.错误的解决方法
weixin_31080131的博客
01-27 2639
{MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to...
JNA方式调用dll报错：A fatal error has been detected by the Java Runtime Environment:
04-06
NULL 博文链接：https://dingherry.iteye.com/blog/1545972
解决：系统重装后的pip报错:Fatal error in launcher: Unable to create process using
12-20
系统重装后的pip 原为win7旗舰版的系统，升级固态后换成win10系统，可以用pycharm2020. 第一次重装系统后，将环境变量纳入，Python成功，但是pip失败，使用pip更新命令 python -m pip install --upgrade pip 后成功。 第二次重装系统，一样的问题，更新命令无法解决，遇到 Fatal error in launcher: Unable to create process using '"e:\users\administrator\appdata\local\programs\python\python37\python.exe" "
解决PHP程序运行时：Fatal error: Maximum execution time of 30 seconds exceeded in的错误提示
10-21
最近做的程序中涉及到的循环比较多且处理的情况较复杂，在运行程序时出现执行超时提示如下：Fatal error: Maximum execution time of 30 seconds exceeded in D:phpAppServwwwsum3test.php on line 3通过在网上搜索，找到了解决方法和大家分享，下面来一起看看吧。
重装系统后python环境问题后续——scrapy生成spider报错：Fatal error in launcher: Unable to create process using
12-20
重装系统后python环境问题后续：scrapy报错：Fatal error in launcher: Unable to create process using'”c:\users\administrator\appdata\local\programs\python\python37\python.exe” “D:\Users\Administrator\AppData\Local\Programs\Python\Python37\Scripts\scrapy.exe” startproject spider’: ???????????解决路径 报错：Fatal error in lau
Fatal error encountered during command execution
热门推荐
邵鸿鑫
12-04 4万+
错误信息：Fatal error encountered during command execution.（命令执行过程中遇到的致命错误。）出现这种问题有可能是两种情况：1.查询结果包含海量数据。长时间检索无响应。这种情况，需要优化SQL，尽量减少数据输出量。2.表结构损坏。可以通过 CHECK TABLE REPAIR TABLE 语句进行检测或修复。初步判断是第一种情况，有两种解决方案：优化
SqlSugar 连接MySql 8.0.29报错
piao110liang的博客
08-26 7693
SqlSugar 连接MySql 8.0.29报错
NET连接mysql字符串
weixin_42170496的博客
07-28 1522
NET连接mysql字符串
C#开发问题2—链接数据库错误（引发的异常:“MySql.Data.MySqlClient.MySqlException）
Parallel_intersect的博客
09-25 4653
1.问题描述： 引发的异常:“MySql.Data.MySqlClient.MySqlException”(位于 MySql.Data.dll 中) Authentication method 'caching_sha2_password' not supported by any of the available plugins. 2.解决方案，使用8.0版本以上的MySql.Data.dl...
MYSQL报Fatal error encountered during command execution.错误的解决方法
weixin_30920091的博客
09-16 1974
{MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attemp...
mysql流已关闭,.net – 尝试读取MySQL中流错误的过去结束
weixin_39942488的博客
03-18 1183
我遇到 MySQL的问题,我有以下错误.MySqlClient.MySqlException: Fatal error encountered during command execution. --->MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset...
mysql超出流末尾,试图读取过去的MySQL流错误结束
weixin_28969555的博客
01-21 1260
I'm running into a problem with MySQL where I have the following error.MySqlClient.MySqlException: Fatal error encountered during command execution. --->MySql.Data.MySqlClient.MySqlException: Fatal...
MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution的解决方法
fuyun6363的博客
12-13 1万+
最近在用SSMS作业将MySQL中的数据迁移到SQL Server时作业报错，报错信息如下： 消息 已以用户 WORKGROUP\iZw30eykry8q1hZ$ 的身份执行。 Microsoft ® SQL Server 执行包实用工具 Version 10.50.6000.34 for 64-bit 版权所有 © Microsoft Corporation 2010。保留所有权利。 ...
【数据库-MySql】Fatal error encountered during command execution.
少莫千华
07-01 3721
一、问题描述 1.语句 SELECT AVG(jsjg) as '平均接收间隔', AVG(fyjg) as '平均发药间隔', AVG(jsfyjg) as '平均接收-发药间隔', AVG(fywcjg) as '平均发药-完成间隔', AVG(jswcjg) as '平均接收-完成间隔' FROM ( SELECT aa.ct1 as ct, aa.t1 as t, aa.ft1 as ft, TIMESTAMPDIFF(SECOND,bb.c
关于MYSQL报Fatal error encountered during command execution. （Parameter ‘@var‘ must be defined.）错误的解决方法
qq_37823627的博客
02-28 833
关于MYSQL报Fatal error encountered during command execution. （Parameter '@var' must be defined.）错误的解决方法
mysql报错error during_MySQL数据库之MYSQL报Fatal error encountered during command execution.错误的解决方法...
weixin_35261213的博客
01-19 3012
本文主要向大家介绍了MySQL数据库之MYSQL报Fatal error encountered during command execution.错误的解决方法 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。{MySql.Data.MySqlClient.MySqlException(0x80004005):Fatalerrorencounteredduring...
fatal error encountered attempting to read the resultset.
最新发布
05-23
This error message usually occurs when there is an issue with the result set returned from a database query. It could be caused by various reasons such as invalid column name, incorrect data type, or null values in the result set. To fix this error, you can try the following steps: 1. Check the SQL query and ensure that it is correct and returns the expected result set. 2. Verify that the column names in the result set match the expected names. 3. Make sure that the data types of the columns in the result set match the expected data types. 4. Check for any null values in the result set and handle them appropriately. If none of these steps work, you may need to consult with a database administrator or a software developer to further investigate the issue.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值