Kuma SQLite error on Azure Web App #4031

Closed
opened 2026-02-28 03:48:48 -05:00 by deekerman · 2 comments
Owner

Originally created by @R8iKKo on GitHub (Mar 13, 2025).

⚠️ Please verify that this question has NOT been raised before.

  • I checked and didn't find similar issue

🛡️ Security Policy

📝 Describe your problem

After no manual action, I am not able to log into Kuma, from Azure Log Stream I see that there is a error with SQLite

📝 Error Message(s) or Log

Trace: [Error: SELECT * FROM heartbeat WHERE monitor_id = '1' ORDER BY time DESC LIMIT 100 - SQLITE_CORRUPT: database disk image is malformed] {errno: 11, code: 'SQLITE_CORRUPT'} at originalConsole. [as trace] (/agents/nodejs/node_modules/diagnostic-channel-publishers/dist/src/console.pub.js:43:39) at process.unexpectedErrorHandler (/app/server/server.js:1872:13) at process.emit (node:events:519:28) at emitUnhandledRejection (node:internal/process/promises:250:13) at throwUnhandledRejectionsMode (node:internal/process/promises:385:19) at processPromiseRejections (node:internal/process/promises:470:17) at process.processTicksAndRejections (node:internal/process/task_queues:96:32) If you keep encountering errors, please report to https://github.com/louislam/uptime-kuma/issues
Trace: [Error: select * from heartbeat where monitor_id = 1 ORDER BY time DESC limit 1 - SQLITE_CORRUPT: database disk image is malformed] {errno: 11, code: 'SQLITE_CORRUPT'}

🐻 Uptime-Kuma Version

beta:2.0.0

💻 Operating System and Arch

Linux Azure ASP

🌐 Browser

Safari/Chrome

🖥️ Deployment Environment

  • Runtime: Azure Web App - Docker Container
  • Database: Sqlite
  • Filesystem used to store the database on: /app/data on Azure SMB File Share
  • number of monitors: 11
Originally created by @R8iKKo on GitHub (Mar 13, 2025). ### ⚠️ Please verify that this question has NOT been raised before. - [x] I checked and didn't find similar issue ### 🛡️ Security Policy - [x] I agree to have read this project [Security Policy](https://github.com/louislam/uptime-kuma/security/policy) ### 📝 Describe your problem After no manual action, I am not able to log into Kuma, from Azure Log Stream I see that there is a error with SQLite ### 📝 Error Message(s) or Log Trace: [Error: SELECT * FROM heartbeat WHERE monitor_id = '1' ORDER BY time DESC LIMIT 100 - SQLITE_CORRUPT: database disk image is malformed] {errno: 11, code: 'SQLITE_CORRUPT'} at originalConsole.<computed> [as trace] (/agents/nodejs/node_modules/diagnostic-channel-publishers/dist/src/console.pub.js:43:39) at process.unexpectedErrorHandler (/app/server/server.js:1872:13) at process.emit (node:events:519:28) at emitUnhandledRejection (node:internal/process/promises:250:13) at throwUnhandledRejectionsMode (node:internal/process/promises:385:19) at processPromiseRejections (node:internal/process/promises:470:17) at process.processTicksAndRejections (node:internal/process/task_queues:96:32) If you keep encountering errors, please report to https://github.com/louislam/uptime-kuma/issues Trace: [Error: select * from `heartbeat` where monitor_id = 1 ORDER BY time DESC limit 1 - SQLITE_CORRUPT: database disk image is malformed] {errno: 11, code: 'SQLITE_CORRUPT'} ### 🐻 Uptime-Kuma Version beta:2.0.0 ### 💻 Operating System and Arch Linux Azure ASP ### 🌐 Browser Safari/Chrome ### 🖥️ Deployment Environment - Runtime: Azure Web App - Docker Container - Database: Sqlite - Filesystem used to store the database on: /app/data on Azure SMB File Share - number of monitors: 11
deekerman 2026-02-28 03:48:48 -05:00
  • closed this issue
  • added the
    help
    label
Author
Owner

@louislam commented on GitHub (Mar 13, 2025):

Azure SMB File Share

It has been mentioned it the README:

File Systems like NFS (Network File System) are NOT supported. Please map to a local directory or volume.

@louislam commented on GitHub (Mar 13, 2025): > Azure SMB File Share It has been mentioned it the README: > File Systems like NFS (Network File System) are NOT supported. Please map to a local directory or volume.
Author
Owner

@DavidDeSloovere commented on GitHub (Apr 23, 2025):

For future reference, I now use docker compose as deployment and have set the env variable WEBSITES_ENABLE_APP_SERVICE_STORAGE to true.

You can enable FTPS and upload your kuma files (like kuma.db) to start from an existing install.

services:
  uptime-kuma:
    image: louislam/uptime-kuma:1
    volumes:
      - ${WEBAPP_STORAGE_HOME}/site/app-data:/app/data
    ports:
      # <Host Port>:<Container Port>
      - 3001:3001
    restart: unless-stopped

Image

Found some info here: https://stackoverflow.com/a/64020044/292410

@DavidDeSloovere commented on GitHub (Apr 23, 2025): For future reference, I now use docker **compose** as deployment and have set the env variable `WEBSITES_ENABLE_APP_SERVICE_STORAGE` to `true`. You can enable FTPS and upload your kuma files (like kuma.db) to start from an existing install. ``` services: uptime-kuma: image: louislam/uptime-kuma:1 volumes: - ${WEBAPP_STORAGE_HOME}/site/app-data:/app/data ports: # <Host Port>:<Container Port> - 3001:3001 restart: unless-stopped ``` ![Image](https://github.com/user-attachments/assets/9f4a053c-db76-49c6-9fd3-5980d5b5c599) Found some info here: https://stackoverflow.com/a/64020044/292410
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/uptime-kuma#4031
No description provided.