愿所有的美好和期待都能如约而至

SQLite3 数据库或磁盘已满/数据库磁盘映像格式错误

发布时间:  来源:互联网  作者:匿名  标签:corruption error SQLite3 database or disk is full / the database disk image is m  热度:37.5℃

本文介绍了SQLite3 数据库或磁盘已满/数据库磁盘映像格式错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我的数据库大约有 25 MB,我已经验证访问它的用户名以及文件权限几个月没有改变.我遇到了一个问题,查询因数据库或磁盘已满”而失败,然后有时会出现数据库磁盘映像格式错误”的问题.

My database is about 25 MB, and I’ve verified that the username accessing it, as well as the file permissions haven’t changed in months. I’m having a problem where queries are failing due to a “database or disk is full” and then sometimes “database disk image is malformed” issue.

除非我读错了,否则我的磁盘不会接近满(这是一个 Ubuntu 服务器,9.10,如果有什么不同的话)

Unless I’m reading this wrong, my disk isn’t anywhere near full (this is an Ubuntu server, 9.10, if it makes any difference)

Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda1             19610300   2389596  16224560  13% /
udev                     10240       128     10112   2% /dev
none                    254136         0    254136   0% /dev/shm
none                    254136        36    254100   1% /var/run
none                    254136         0    254136   0% /var/lock
none                    254136         0    254136   0% /lib/init/rw

作为测试,我刚刚做了一个添加新记录的操作,没问题.我试图弄清楚是否有一组特定的操作失败.但是,在插入(并验证它在那里)之后,数据库磁盘上的字节数没有改变(既不增加也不减少).

As a test I just did an action that added a new record, and it’s fine. I’m trying to fiqure out if there’s a specific set of actions that are failing. However, after the insert (and verifying that it’s there) the number of bytes on disk for the database has not changed (neither up nor down).

使用命令行实用程序会导致类似以下内容的结果,这非常失败:)

Using the command line utility results in something like the following, which is failing spectacularly

勇敢去编程!

勇敢的热爱编程,未来的你一定会大放异彩,未来的生活一定会因编程更好!

TOP