Discord bot cannot write to SQLite despite 998 MB free — Errno 28 / SQLITE_IOERR_SHMSIZE
Posted by user_6tdmf6 in discord-bots.
Hello, I am having a storage/quota issue with my Python Discord bot server. The Wispbyte panel shows: Disk used: 25.6 MB Disk free: 998.4 MB Total disk: 1024 MB RAM usage: 43.8 MB of 588.8 MB However, Python and SQLite intermittently cannot write inside: /home/container/data A diagnostic executed inside the container reported: total=392.65 GiB free=20.01 GiB available=0.00 B A direct write test failed with: OSError: [Errno 28] No space left on device SQLite also returned: sqlite errorcode=4874 sqlite errorname=SQLITE IOERR SHMSIZE message=disk I/O error On a second execution, the effective available space changed to only: available=3.26 MiB During that second execution, the direct write, fsync and SQLite COMMIT worked correctly. The SQLite database is only around 28 KB and passed: PRAGMA quick check = ok The issue also happens during normal bot operation when SQLite executes connection.commit(): sqlite3.OperationalError: database or disk is full Could you please check the effective disk quota, project quota, container storage limit, or filesystem allocation applied to UID 988? The storage available inside the container does not appear to match the approximately 998 MB shown as free in the Wispbyte panel. Server files are located under: /home/container Database path: /home/container/data/temp channels.db Thank you.
Replies
astror
Hey there, seems like an issue on our own side. Can you provide your node name? Its located on the right side of your console. Thanks