sqlite3 disk I/O error on cli

Question

sqlite version 3.6.20, running through VNC.

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.

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?

.log stderr does not work in version 3.6.20. I cannot upgrade and cannot use new local version since it's linked against different glibc. — pusheax, Jun 29 '16 at 12:00

score 4 · Accepted Answer · edited Apr 13 '17 at 12:42

4

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

edited Apr 13 '17 at 12:42

Community

1
1

answered Jul 04 '16 at 12:10

pusheax

123
3
10

If I could give you more rep for this answer, I would. Thank you! – Rado Jun 05 '17 at 14:32

sqlite3 disk I/O error on cli

1 Answers1

Linked