cli 上的 sqlite3 磁盘 I/O 错误 [英] sqlite3 disk I/O error on cli

问题描述

sqlite 版本 3.6.20，通过 VNC 运行.

sqlite version 3.6.20, running through VNC.

启动 sqlite3 cli 会话.尝试运行命令.tables"、.databases"、create table"时，我收到错误:磁盘 I/O 错误".我不知道如何获得更准确的描述.我想在我有权限的主目录中写入.

Starting sqlite3 cli session. When trying to run commands ".tables", ".databases", "create table" I get "Error: disk I/O error". I don't know how to get more accurate description. I want to write in my home directory where I have permissions.

我在 .sqliterc 中使用日志模式和临时存储尝试了一些建议的修复 - 它们没有帮助.一些命令，如PRAGMA synchronous = OFF;"也会导致磁盘io错误.

I tried some suggested fixes in .sqliterc with journal mode and temp storage - they do not help. Some commands like "PRAGMA synchronous = OFF;" also cause disk io error.

.output /dev/null
PRAGMA journal_mode = MEMORY;
PRAGMA locking_mode = EXCLUSIVE;
PRAGMA temp_store_directory = '/home/username/tmp';

如何找到更多关于错误的信息并解决这个问题?

How to find out more about error and solve this?

推荐答案

这是与 VMWARE 相关的错误.解决方案:将文件移动到/tmp.Sqlite 在那里工作.此处描述 https://dba.stackexchange.com/questions/93575/sqlite-disk-io-error-3850

It was VMWARE related error. Solution: move files to /tmp. Sqlite works there. It is described here https://dba.stackexchange.com/questions/93575/sqlite-disk-i-o-error-3850

这篇关于cli 上的 sqlite3 磁盘 I/O 错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！