How to fix SQLITE_IOERR: Some kind of disk I/O error occurred in SQLite

# Check permissions on database file
ls -l /path/to/database.db

# Check directory permissions
ls -ld /path/to/

# Ensure write access to directory (needed for journal files)
chmod 755 /path/to/
chmod 644 /path/to/database.db

# If using WAL mode, check for -wal and -shm files
ls -l /path/to/database.db-wal
ls -l /path/to/database.db-shm

// C API
sqlite3_extended_result_codes(db, 1);
int extended_code = sqlite3_extended_errcode(db);

# Python sqlite3
import sqlite3
conn = sqlite3.connect('database.db')
# Extended codes are enabled by default in Python
try:
    conn.execute("...")
except sqlite3.OperationalError as e:
    print(f"Error: {e}")

// Node.js better-sqlite3
const Database = require('better-sqlite3');
const db = new Database('database.db');
// Check error.code property for extended codes

# Linux: Check filesystem (unmount first if possible)
sudo fsck /dev/sdX1

# Check disk health with SMART
sudo smartctl -a /dev/sdX

# For mounted filesystems, check dmesg for I/O errors
dmesg | grep -i "i/o error"
dmesg | grep -i "sector"

# Check database file integrity
sqlite3 database.db "PRAGMA integrity_check;"

# Check filesystem type
df -T /path/to/database.db

# Avoid SQLite on network filesystems when possible
# NFS/CIFS have locking and caching issues

# Linux: Find processes with file open
lsof /path/to/database.db

# Check for stuck lock files
ls -la /path/to/database.db-journal
rm /path/to/database.db-journal  # Only if no other process is using it

# For WAL mode
ls -la /path/to/database.db-wal
ls -la /path/to/database.db-shm

# Temporarily disable antivirus to test (Linux with ClamAV)
sudo systemctl stop clamav-daemon

# Check SELinux denials
sudo ausearch -m avc -ts recent

# Check AppArmor denials
sudo journalctl | grep DENIED

# Create test database in /tmp
sqlite3 /tmp/test.db "CREATE TABLE test(id INTEGER PRIMARY KEY, data TEXT);"
sqlite3 /tmp/test.db "INSERT INTO test(data) VALUES('test');"
sqlite3 /tmp/test.db "SELECT * FROM test;"