Doubt110 2022-05-26 10:41 采纳率: 0%
浏览 107

ib_16384_0.dblwr failed at offset 0如何解

问题遇到的现象和发生背景

C# 报错Too many connections

问题相关代码,请勿粘贴截图

2022-05-25T23:40:54.671870Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:40:54.672269Z 0 [ERROR] [MY-012639] [InnoDB] Write to file .\ib_16384_0.dblwr failed at offset 0, 16384 bytes should have been written, only 0 were written. Operating system error number 0. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2022-05-25T23:40:54.673241Z 0 [ERROR] [MY-012640] [InnoDB] Error number 0 means 'No error'
2022-05-25T23:40:54.673518Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:41:04.683786Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:41:04.684132Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:41:14.700761Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:41:14.701116Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:41:24.713814Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:41:24.714163Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:41:34.726883Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:41:34.727266Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:41:44.741978Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:41:44.742284Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:41:54.761575Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:41:54.762211Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:42:04.772059Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:42:04.772405Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:42:14.785355Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:42:14.785703Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:42:24.799589Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:42:24.799893Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:42:34.802759Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:42:34.803126Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:42:44.819207Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:42:44.819517Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:42:54.832239Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:42:54.832545Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:43:04.847068Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:43:04.847414Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:43:14.860182Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:43:14.860529Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:43:24.876193Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:43:24.876571Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:43:34.889049Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:43:34.889397Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:43:44.903644Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:43:44.904132Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:43:54.920635Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:43:54.920942Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:44:04.935257Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:44:04.935604Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:44:14.949632Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:44:14.950162Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:44:24.961362Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:44:24.961683Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:44:34.975043Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:44:34.975430Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:44:44.987013Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:44:44.987512Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:44:55.000161Z 0 [Warning] [MY-012638] [InnoDB] Retry attempts for writing partial data failed.
2022-05-25T23:44:55.000489Z 0 [ERROR] [MY-013676] [InnoDB] I/O error while writing to file: .\ib_16384_0.dblwr. Retrying ...
2022-05-25T23:44:57.516269Z 0 [Warning] [MY-012985] [InnoDB] A long semaphore wait:
--Thread 1144 has waited at trx0sys.ic line 80 for 241 seconds the semaphore:
X-lock on RW-latch at 000002760B9A05C0 created in file buf0buf.cc line 784
a writer (thread id 5032) has reserved it in mode SX
number of readers 0, waiters flag 1, lock_word: 10000000
Last time read locked in file not yet reserved line 0
Last time write locked in file C:\build\sb_1-1362124-1607674653.17\mysql-8.0.23\storage\innobase\buf\buf0flu.cc line 1345
InnoDB: Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0

运行结果及报错内容
我的解答思路和尝试过的方法
我想要达到的结果
  • 写回答

1条回答 默认 最新

  • Null_Reference 2022-05-26 10:59
    关注

    看下是不是磁盘满了

    还有就是可能你的insert 或者select语句 插入或者查询的数据量过大,超过了磁盘容量。

    评论 编辑记录

报告相同问题?

问题事件

  • 创建了问题 5月26日

悬赏问题

  • ¥20 怎么在stm32门禁成品上增加记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
  • ¥50 NT4.0系统 STOP:0X0000007B
  • ¥15 想问一下stata17中这段代码哪里有问题呀
  • ¥15 flink cdc无法实时同步mysql数据
  • ¥100 有人会搭建GPT-J-6B框架吗?有偿
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 解riccati方程组