sqlite整理数据库文件vacuum命令失败-“diskisfull/thedatabasediskimageismalformed”_拔剑-浆糊的传说_新浪博客

最新推荐文章于 2024-01-24 11:23:43 发布

拔剑_浆糊的传说

最新推荐文章于 2024-01-24 11:23:43 发布

阅读量987

点赞数

本文链接：https://blog.csdn.net/qq_40287292/article/details/90608940

版权

SQLite在执行VACUUM时因创建临时文件导致失败，该文件大小接近原始数据库。失败原因可能是临时目录磁盘空间不足。在Unix/Linux系统中，SQLite会按照SQLITE_TMPDIR、TMPDIR、/var/tmp等目录顺序寻找有权访问的临时目录。解决方法包括直接在SQLite中设置临时目录或通过环境变量指定。

摘要由CSDN通过智能技术生成

sqlite整理数据库文件vacuum命令失败 -“disk is full / the database disk image is malformed”

------------

root cause:

The OP noted that during a VACUUM, SQLite creates a temporary file that is approximately the same size as the original database. It does this in order to maintain the database ACID properties. SQLite uses a directory to hold the temporary files it needs while doing the VACUUM. In order to determine what directory to use, it descends a hierarchy looking for the first directory that has the proper access permissions. If it finds a directory that it doesn't have access to, it will ignore that directory and continue to descend the hierarchy looking for one that it does. I mention this in case anyone has specified an environment variable and SQLite seems to be ignoring it.

In his answer CL gives the hierarchy for Linux and in his comment mentions that the hierarchy is OS-dependent. For completeness, here is the hierarchies (in so far as I can determine them from the code).

For Unix (and