Troubleshooting Guide

Error: ENOENT: no such file or directory, open '/path/to/data/serverId.db'

Error: SQLITE_BUSY: database is locked

// Always close databases
try {
    // Database operations
} finally {
    db.close();
}

# Find running node processes
ps aux | grep node

# Kill if needed
pkill -f "node src/client.js"

# Stop bot first
rm data/*.db-journal
rm data/*.db-wal

Error: file is not a database
Error: database disk image is malformed

cp data/serverId.db data/serverId.db.backup

sqlite3 data/serverId.db ".recover" | sqlite3 data/serverId_recovered.db

# Remove corrupted database
rm data/serverId.db

# Bot will create new database on next start
npm start

module.exports = {
    data: new SlashCommandBuilder()
        .setName('slowcommand')
        .setDescription('A slow command'),
    async execute(interaction) {
        // Defer immediately for long operations
        await interaction.deferReply();
        
        try {
            // Long operation here
            const result = await longDatabaseQuery();
            
            // Edit the deferred reply
            await interaction.editReply({
                content: 'Operation complete!'
            });
        } catch (error) {
            await interaction.editReply({
                content: 'Error: ' + error.message
            });
        }
    }
};

const used = process.memoryUsage();
console.log(`Memory: ${Math.round(used.heapUsed / 1024 / 1024)} MB`);

// Always close databases
db.close();

// Remove listeners when done
client.removeListener('messageCreate', listener);

// Clear caches periodically
client.sweepMessages();

CREATE INDEX idx_userid ON current(userID);
CREATE INDEX idx_channelid ON replyChannels(id);

const stmt = db.prepare('SELECT * FROM phrases WHERE id = ?');
stmt.get([id], callback);
stmt.finalize();

const cache = new Map();

if (cache.has(serverId)) {
    return cache.get(serverId);
}

const settings = await getSettings(serverId);
cache.set(serverId, settings);