刚开始收到发生AIR SQLite的错误3182磁盘I / O错误 [英] Just started getting AIR SQLite Error 3182 Disk I/O error occurred

问题描述

我们有我们的软件的新测试版有了一些变化，但不是在我们的数据库层。

We have a new beta version of our software with some changes, but not around our database layer.

我们刚刚开始收到错误报告3128在我们的服务器日志。似乎一旦发生，它发生，只要该应用是打开的。的code，其中这是最明显的部分是我们将数据记录每秒通过的SQLite。我们已经在我们的服务器仅这个月就产生47K的错误。

We've just started getting Error 3128 reported in our server logs. It seems that once it happens, it happens for as long as the app is open. The part of the code where it is most apparent is where we log data every second via SQLite. We've generated 47k errors on our server this month alone.

3128     Disk I/O error occurred.   Indicates that an operation could not be completed because of a disk I/O error. This can happen if the runtime is attempting to delete a temporary file and another program (such as a virus protection application) is holding a lock on the file. This can also happen if the runtime is attempting to write data to a file and the data can't be written.  

我不知道这可能是造成此错误。也许一个反病毒程序？也许我们的程序是越来越困惑和写入数据在彼此的顶部？我们使用异步连接。

I don't know what could be causing this error. Maybe an anti-virus program? Maybe our app is getting confused and writing data on top of each other? We're using async connections.

这是造成很多的问题，我们是处于亏损状态。它发生在我们的旧版本，但也许100次在一个月内，而47000多名倍。无论哪种方式，我想做到这一点0时代。

It's causing lots of issues and we're at a loss. It has happened in our older version, but maybe 100 times in a month rather than 47,000 times. Either way I'd like to make it happen "0" times.

推荐答案

解决的办法是，以确保数据库中删除，更新，插入只发生逐一在时间通过包装一个小包装。最重要的是，我们只好眼睁睁地看着错误3128和重试。我想这是因为我们有一个触发运行，可以锁定数据库后，我们插入的数据。

The solution was to make sure database delete, update, insert only happened one at at time by wrapping a little wrapper. On top of that, we had to watch for error 3128 and retry. I think this is because we have a trigger running that could lock the database after we inserted data.

这篇关于刚开始收到发生AIR SQLite的错误3182磁盘I / O错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！